Hi guys,
Can you help me understand why its not working as i wanted to?
Hi guys,
Can you help me understand why its not working as i wanted to?
Try this instead...
=IF(ISNUMBER(MATCH(E6,C5:C7,0)),TRUE,FALSE)
Also, please update your thread title to describe what you are asking.
HTH
Regards, Jeff
Use this instead in F6:
=COUNTIF($C$5:$C$7,E6)>0
if you want to see if E6 is present anywhere in the range C5:C7.
Hope this helps.
Pete
Jeff,
slightly shorter version of yours:
=ISNUMBER(MATCH(E6,C5:C7,0))
Hope this helps.
Pete
Thanks Pete
Thanks guys but unfortunately it wont help my purposes.. i ll post another thread and i ll try to explain it better
No, please do not post another thread as that would be a duplicate. Please explain your requirements here.
What do you mean it won't help? What Pete and I suggested answer's your question.Thanks guys but unfortunately it wont help my purposes
I thought that i could handle this with only slight help but it wouldnt be enough... i need to divide database on 5 parts (20% x5) and then apply ifs=true
Okay.
If the requirement have changed, by all means start a new thread.
In the new thread, attach a sample workbook with a clear before and after sample. Also, please craft a better title than "Array Formula".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks