Hi, i need help in formula or VBA code any thing, i am using =COUNTIF($A$2:$A2,A2) formula, it is giving me count of my duplicate lease no which are in column A, i need to replace highest number with word "Last". |
eg: |
LEASE NO IS IN "A" COLOUMN = 10005 ( total lease for 10005 duplicates are 5 ) |
TOTAL LEASE VERSION = 5 (=COUNTIF($A$2:$A$13,A2) |
LAST AND HIGHEST LEASE VERSION = 5 (Need to Replace 5 with "LAST" ) =COUNTIF($A$2:$A2,A2) |
see the attached file pic and excle .Thanks |