Hi Seniors/Gurus,
I am matching 6 column data at row level. I want to ignore blank cells keeping the formula consistent.
Please find attached file.
Regards
Hi Seniors/Gurus,
I am matching 6 column data at row level. I want to ignore blank cells keeping the formula consistent.
Please find attached file.
Regards
anyone please
I tried this and it seemed to work...
=OR(IF(A3="","TRUE"),IF(AND(A3=B3,A3=C3,A3=D3,A3=E3,A3=F3),"TRUE","FALSE"))
EDIT, hold the horses, it didn't work for your values in row 4, will have to tinker with it more.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
OK, now it did work in all instances, go ahead and give that formula a try and let me know.
not sure why it didn't work for row 4 at first but now it does.
hi pareshvm. maybe:
=COUNTIF(A2:F2,LOOKUP(2,1/(A2:F2<>""),A2:F2))=COUNTA(A2:F2)
@Sambo kid:
TRUE and FALSE are recognized in formulas, so you don't need double quotes.
=OR(IF(A3="",TRUE),IF(AND(A3=B3,A3=C3,A3=D3,A3=E3,A3=F3),TRUE,FALSE))
logical tests returns TRUE or FALSE, so you don't need IFs to do that. if A3 is "", it returns TRUE without needing the IF. you can try typing that somewhere
=A3=""
so just:
=OR(A2="",AND(A2=B2,A2=C2,A2=D2,A2=E2,A2=F2))
but i think the blanks may not be in Column A only. so if column A is filled with xyz, column B is empty, and the rest are also filled with xyz, then the formula wouldn't work
wishing you both a happy new year~
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks Benishiryo, its working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks