# Thread: Count if data in 1 cell not equal to another cell (MS Excel 2007)

1. ## Count if data in 1 cell not equal to another cell (MS Excel 2007)

Hello!
I'm going to try to explain is as clearly as possible. If customer in A23' is a identified as Sub Acct in D23 , if A23 <>C23, Find C3 in column A:A, when found is B2 = B23. If not count .. I want to be able to do the entire range of the sheet (50k rows) I hope this didn't confuse anyone. Please . Please say you can help.
Thank You So Much!

2. ## Re: Count if data in 1 cell not equal to another cell (MS Excel 2007)

Did you mean "Find C23 in column A:A" instead of "Find C3 in column A:A"?

3. ## Re: Count if data in 1 cell not equal to another cell (MS Excel 2007)

Yes Hans you are correct. Sorry about the typo find C23 in A:A

4. ## Re: Count if data in 1 cell not equal to another cell (MS Excel 2007)

What does "when found is B2 = B23. If not count .." mean?

5. ## Re: Count if data in 1 cell not equal to another cell (MS Excel 2007)

in the example we searched in AA and found the value of "C23 in A2(ADDS), is the value in B2= B23 if not count . Does that make sense?

6. ## Re: Count if data in 1 cell not equal to another cell (MS Excel 2007)

Sorry, none at all. What do you want if the value in B2 equals that in B23? And if not, count what? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

7. ## Re: Count if data in 1 cell not equal to another cell (MS Excel 2007)

I'm so sorry I have you scratching your head.. let's try this again.

Customer A23 is a subaccount, so I look at C23 to determine what the master account# is. Next I look in AA for the account # found in C23, I found it in A2. Now I look at B2, is B2 = C23 no. That tells me the warehouses are not equal. So I have to count that as 1 of the Sub Accounts not equal to the Master Count.

8. ## Re: Count if data in 1 cell not equal to another cell (MS Excel 2007)

Ok, but I still don't have the slightest idea what you want and where. Do you want a formula? If so, in which cell(s)? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

9. ## Re: Count if data in 1 cell not equal to another cell (MS Excel 2007)

yes a formula or a macro to run that will give me the total of the entire sheet.

10. ## Re: Count if data in 1 cell not equal to another cell (MS Excel 2007)

Does the formula in E1 in the attached version do what you want? The formulas in E2 and below are auxiliary formulas.

11. ## Re: Count if data in 1 cell not equal to another c

HANS!
YES! YES! It is! YOU ARE A ROCK STAR! Thank you so much and I again I apologize for getting you all confused! :-)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•