Thank you very much ... it really helped to learn ....
Hi, Me too here to enhance my skill and still learning & trying to solve other problems .... will you be kind enough to elaborate below formula which you send in above link ??? http://www.excelforum.com/excel-gene...onditions.html ={SUM(PF2*(MATCH(IF(PF2,ENAME),IF(PF2,ENAME),0)=(ROW(ENAME))-2))} Please define how it works exactly ...... especially Match & Row(ename)-2 .....
Hi, I want to special thanks as your formula really helped me and right now i had to make another list with multiple project in which projects were repeating and i have to count then only once. I created EPROJECT & PJ2 array just like your previous trick and succeeded. cheers
