Jump to content
xisto Community
WeaponX

Excel - Verifying Data...

Recommended Posts

Hi, I have an Excel spreadsheet here that has 4 columns in it. The Date, some number, and whether it was received or not.

 

I have the Not Received column highlighted in blue color. But what I want to do is that if there is an X marked in the column for Received, and the number matches to the one that's not received, I want the blue color to be changed to the default black again. As of now, I'm doing a lot of this manually.

 

So, for example:

 

Date Number Received Not Received

10/1/05 123 X

10/4/05 456 X

10/8/05 123 X

 

So I want that blue X to be marked back to black once the entry for 10/8/05 (with the same number but marked Received this time).

 

I tried doing an IF statement, but I don't know how to loop it through the whole list checking each Number in the column and also verifying that it's received.

 

Thanks in advance.

Share this post


Link to post
Share on other sites

Forgotto preview before I sent this one out.  The above example should have the data aligned properly...my bad.  You get the idea :mellow:

1064324496[/snapback]


I have a complete spreadsheet tools e-book somewhere.. will hunt it down. Check your PM's for my private mail ID - send me your mailing ID so that I can e-mail you the spreadsheet e-book. you'll need to do a search through the e-book, but if what you're asking for is possible - then I do believe the e-book will be able to sort out your problems. Lemme start digging...

 

Rashid

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.