hello
im having some trouble with my formula...for some odd reason it is now showing the next line item.
basically i have a list of names in the master sheet (column I), and on the worksheet named "andrew L"...i have the following formula that list his corresponding metrics
formula in column J:
{=IF($H10="","",INDEX(MASTER!$C$9:$I$25,SMALL(IF(MASTER!$G$9:$G$25=$H$10,ROW(MASTER!$G$9:$G$25)-ROW($H$10)+1),COUNTIF($H$10:$H10,$H10)),J$8))}
it is listing the names on the metrics, but if you go the master sheet, u will notice it is not showing the correct names...it's making a duplicate for some odd reason....ur thoughts? what am i doing wrong?....in column J...it show a company called "national"....and its not :S
pls help!!
Bookmarks