Originally Posted by
InnoGuide
Thanks Soledad - I've got a large data set and it looks like there may be a few that violate this - Thanks for your help and clarification
Hi Soledad - the problem ended up being that there were blank rows at the bottom of the data set that could not be eliminated.
Just used Cell X1=SUMPRODUCT(MAX((A$2:A$13<>"")*ROW(A$1:A$13))) to find the last row and then used the indirect function. So your formula became:
Formula:
=IF(C2="","",MAX((A$2:INDIRECT("A"&X$1)=A2)*IFERROR((FIND(" "&B$2:INDIRECT("B"&X$1)&","," "&C2&",")>0),0)*D$2:INDIRECT("D"&X$1))+1)
Thanks again for all your help
Bookmarks