Hi,
I want to calculate headcounts in the file and the problem is where there is same employee name more than once which will give me wrong nr of heads.
I want a formula which puts an "1" in the cell which has the highest rate of FTE and "0" on other duplicate ones with lower FTE rate. I have written it worn in the file.
Thanks for all help !
Bookmarks