I am looking for a UDF or macro to number a list of numbers or words, so that they can be grouped together. The list would be sorted either alphabetically or numerically and when the alphabetic or numeric sequence "restarts", it will begin a new group number.
Attached is an example workbook with two sheets - one for the alphabetic example and the other numeric. Column A contain the data, column B is where the UDF would be used.
In both examples, the first character would determine the group number, as if it is "lower" than the cell preceding it, it would start a new sequence number.
I am not sure if a normal Excel formula would even work, but regardless, to simply things, I would like a UDF. Thanks.
SequenceExample.xlsx
Bookmarks