I have found a good explanation of formula by patrick
, but i have a problem, the data is too much more than 70000 rows .
now this example formula =IFERROR(INDEX($B$2:$B$8, SMALL(IF($A$11=$A$2:$A$8, ROW($A$2:$A$8)-ROW($A$2)+1
), ROW(1:1))),"" ) for small number of rows. works. but when it comes to 70K plus rows then it really becomes useless. i learned from Microsoft page that using Row functions that are extremely volatile make the workbook calculation and speed TOO SLOW.
i was wondering if there is any other formula or any other UDF or VBA that can help me reduce the number minutes i am waiting for the calculation to be done. sometimes the excel is frozen and it is really annoying.
also if someone could help with alternative not using ROWs functions in that referred formula.
thanks in advance for your help.