E. J.
asked on
Creating a custom sequence based on another cell
What formula or function can I use to populate a number based on how often a number appears in another column. I want it to say 1, 2, or 3 and keep that order. If it is the 5th time a number appears in column B, I want the number to show 2.
Subodh Tiwari (Neeraj)
Why not upload a sample workbook with the desired output mocked up manually to visualize your requirement?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Without confirmatio from author but does as requested