Hi,
I Have VBA Code : Range("C2").Formula = "=INDEX(WEB!W:W,AGGREGATE(15,6,ROW(WEB!W$2:W$50000)/(WEB!W$2:W$50000=B2),COUNTIF(B$2:B2,B2)))"
But sometimes less 50,000 Rows and sometimes more 50,000 Rows. How to count rows in VBA Code used in this code.
Thank You Very much.
I Have VBA Code : Range("C2").Formula = "=INDEX(WEB!W:W,AGGREGATE(15,6,ROW(WEB!W$2:W$50000)/(WEB!W$2:W$50000=B2),COUNTIF(B$2:B2,B2)))"
But sometimes less 50,000 Rows and sometimes more 50,000 Rows. How to count rows in VBA Code used in this code.
Thank You Very much.