Hey guys, I'm racking my brain on the one...
=INDEX(B109:B116,MODE(MATCH(B109:B116,B109:B116,0)))
I can't seem to get this formula to work on cells that were populated by Dropdowns. Anyone know the reason for this?
Hey guys, I'm racking my brain on the one...
=INDEX(B109:B116,MODE(MATCH(B109:B116,B109:B116,0)))
I can't seem to get this formula to work on cells that were populated by Dropdowns. Anyone know the reason for this?
What's in the cells?
What result do you get?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
It is a list of color combinations ("Red / Yellow", "Green / Blue", Yellow / Green" etc.) they are pulled from a table using VLOOKUP that were populated by a short dropdown list.
It's simply coming up blank.
I don't think I'm allowed to share the file yet, or I would.
Is there an entry in B109:B116 that appears more than once?
If there's not an entry that appears more than once then the formula will return the #N/A error.
Is the formula returning an error but there is conditional formatting applied to hide it?
Yes there is a duplicate. It's showing
Error
Did not find value '' in MATCH evaluation.
I'm not familiar with that error message.
OK, if there are dupes then try comparing them to each other.
If B109 and B112 are dupes then what result do you get from this formula:
=B109=B112
I just realized...
If the cells all contain drop down lists and the lists all use a common source then of course the duplicate entries will be exactly the same.
So:
=B109=B112 should return TRUE
I think I figured it out. It basically was counting the empty cells... I'm an idiot.
The error message only appeared as I tried to mess with it.
Good deal. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks