What do you mean "Adam and Chris are together"? Do you mean if they are next to each other in the cells? Also, how should I know if I am looking for "Adam and Chris" and not "Ben and Dave" Is this information stored somewhere?
What do you mean "Adam and Chris are together"? Do you mean if they are next to each other in the cells? Also, how should I know if I am looking for "Adam and Chris" and not "Ben and Dave" Is this information stored somewhere?
By "Adam and Chris are together" I mean that they are in group 1, i.e. they share a common value in column A. The relative location in column B is not important.
"Adam and Chris" vs. "Ben and Dave" vs. any other combination of 2 would be done on an ad hoc basis, this could be typed into the formula as needed or referenced in another cell. I've attached a sample which should help (probably should have done this in the first place...)
Group_check.xlsx
Thank you!
Hi
One way to do this, is using IF & SUMPRODUCT formulae.
In first example, in L4, put this formula and copy down.=IF(SUMPRODUCT((K4=$G$5)*(J4=$G$4))+SUMPRODUCT((J4=$G$4)*(K4=$G$6))>=1;"X";"")
Is this, OK, for you?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
This is PERFECT, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks