Fill Cells based on 3 Criteria (2 that match and 1 that doesn't)

**freybe06** · 06-20-2013, 03:25 PM

Hello Everyone,

I haven't found anything like this question so hopefully someone can help me. I've attached an example spreadsheet containing how the data looks before the macro and how it should look afterwards.

What I'm trying to do (using the spreadsheet as reference) - between rows, if the data in column B and column E match but the data in column H does not, then an "X" should be place in column G. For example, in row 4, row 6, and row 17, you can see that column B says "January" and column E says "Sunday", however, only in row 4 and 6 does column H say "1" (Row 17 says "2"). Therefore, I'd like all three rows to have "X" in column G.

If Row 17 did not exist, then row 4 and row 6 wouldn't need anything done because all three columns would match.

Please let me know if I need to explain this a little better. Thank you in advance for all your help!

TestBook2.xlsx

**AlphaFrog** · 06-20-2013, 05:50 PM

Please Login or Register  to view this content.

**freybe06** · 06-21-2013, 09:40 AM

Thanks for the quick response AlphaFrog! I am having a little bit of an issue though - with my actual data, the headers are in the first row. I tried changing the "A3" and "G3" in the code to read "A1" and "G1" but it doesnt look like that solved it. When I run the macro, it is just taking the header from row 1 and putting it in row 3.

Could you please help me figure out what needs to be changed?

Thanks again!

Edit: Actually, I just reran the macro and changing A3 and G3 to A1 and G1 made it work! Thanks again for all your help!