I am trying to transpose this formula into an Arrayformula but I am stucked.
=COUNTIF($C$3:C3;C3)
Can someone help me, please?
https://docs.google.com/spreadsheets/d/1gH1_8vnKUNDr0JtETjxJtD82cb5FWHQCAgMeebkebYU/edit#gid=0
1 Answers
use:
=ARRAYFORMULA(IF(TRIM(C3:C)="",,COUNTIFS(C3:C, C3:C, ROW(C3:C), "<="&ROW(C3:C))))
Related