Good afternoon,
I am struggling trying to compare 4 Cells that should contain either 4*1 or 4*2 or 4*3.
The target is, to find in Cell A1:A4, either only 1s or either only 2s or either only 3s and if so, then it is True and if not, it is False.
If I use the formula:
=AND(EXACT(A1:A4,B2))
it works but I have no clue, how to extend it, so I also can check for value 2 or 3? Or maybe with match but here also stuck.
Can you please help?
Thank you,
Mike
There are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you Ali,
Excel is uploaded.
Please try
=STDEV(A1:A4)=0
Sorry - this means absolutely nothing to me. The sample file needs manually mocked up data, not a formula that is not doing what you want. Please annotate the workbook to show exactly what you are referring to. There shall be only 1s, 2s and 3s where?Target is, that when Column A Row1-4 is checked, that there shall be only 1s, 2s or 3rs, then it that would be good and shall show True and if not, it shall be False.
Not at all clear (to me).
WOW, that did the trick, thank you very much Bo_Ry (so simple!)
Thank you Ali,
Bo_Ry did solve the issue... and sorry for the complicated explanation...good that Bo_Ry was able to understand my cryptic message
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks