I have a column (Column A) of work order numbers that vary in the number of times they repeat. Is there a formula I can use in another column to assign a number (1, 2, 3, etc.) based on the number of times a number is repeated in Column A?
Please see attached. I'd prefer a formula vs. VBA if possible. Thanks for your help!