LinkBack URL
About LinkBacks
Small correction to NBVC's post, I2 needs to be,
=IF(H2='Team Overview (Breakdown)'!$F$3,COUNTIF($H$2:H2,H2),"")
and this would be copied down.
The formula was missing the first person under the manager.
Small correction to NBVC's post, I2 needs to be,
=IF(H2='Team Overview (Breakdown)'!$F$3,COUNTIF($H$2:H2,H2),"")
and this would be copied down.
The formula was missing the first person under the manager.
Thanks for catching that Dulanic,
I just missed a +1...
so formula should be:
=IF(H2='Team Overview (Breakdown)'!$F$3,COUNT($I$1:I1)+1,"")
Note: COUNT() is I think more efficient then COUNTIF()
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That would make sense too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks