Hello all,
My list array is in C6#.
I want to enter a dynamic array formula into D6 that would list the occurrence of the value in the adjacent cell in column C.
here is the desired result.
Screenshot 2022-02-08 092146.png
Hello all,
My list array is in C6#.
I want to enter a dynamic array formula into D6 that would list the occurrence of the value in the adjacent cell in column C.
here is the desired result.
Screenshot 2022-02-08 092146.png
Last edited by Coley356; 02-11-2022 at 11:59 AM.
if sequential order, as inferred, one option might be:
D6:
=1+SEQUENCE(COUNT(C6#))-MATCH(C6#,C6#,0)
try this in cell D6:
Please Login or Register to view this content.
Thank you janmorris, but I needed to keep my list range dynamic as C6#.
Perfect! thank you XLent, this is exactly what i needed!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks