Example : Fruits sold at the same time in four stores "ORANGE"
Can someone please help me ? It would be much appreciated. Thanks in advance
Example : Fruits sold at the same time in four stores "ORANGE"
Can someone please help me ? It would be much appreciated. Thanks in advance
Last edited by choletseng; 10-19-2021 at 07:38 AM.
If your data was store, fruit, a simple pivot would give you
fruit, count
the list in the order you seek. to get the anwer form the datai n the shape it currently is is will be a complex formula or vba, or possibly power pivot which I know very little about!
Try the attached.
Regards
Cell G2 Array formula , Drag down and across
Try this !r0c00, if can not try r0c00
Formula:=IFERROR(INDIRECT(TEXT(MIN(IF((COUNTIF($B$2:$E$8,$B$2:$E$8)=5-COLUMN(A1))*($B$2:$E$8<>"")*(COUNTIF(G$1:G1,$B$2:$E$8)=0),ROW($2:$8)/1%+COLUMN($B:$E))),"!r0c00"),),"")
Problem solved, You all are awesome
wk9128,RaulSerg .Thanks you very much
@choletseng You're Welcome. Glad to help . Thank You for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks