hello
here my formula:
{=SMALL(IF('SE 2011 Status'!$S$14:$S$304='Raw data 1'!$E$77,IF('SE 2011 Status'!$O$14:$O$304=Summary!$D$11,IF('SE 2011 Status'!$F$14:$F$304=$D$12,'SE 2011 Status'!$W$14:$W$304,""),""),""),K11)}
basically, im searching by three criteria
1) revenue bucket ($0-$10.99; $11-$24.99 etc)
2) tenure
3) region
issue:
it should list 4 ppl...but bc they are in the first bucket $0-$10.99 and all four are $0, it is only using the first person's name that appears and show it four times
$0 John Doe
$0 John Doe
$0 John Doe
$0 John Doe
how can i make it so it only shows the person's name once? pls help!! ive been stuck at this for a day now :S
pls see attached file *i have highlighted row in red**
i was struggling to attach the file on here (not a big fan of the new change to the site)...so i have it on a shared drive..pls help!!!
https://skydrive.live.com/redir.aspx...108&parid=root
Bookmarks