Thank you I have figured out that issue now! but I encountered another issue that you could help me with? if I am entering a bunch of ID numbers with the a sort of pattern, cant I just copy them? but excel doesn't pick up the pattern.
AA101 E
AA101 F
AA101 G
AA101 H
.. and so on
How can I get excel to detect that pattern? I did some experimenting and it detects patterns with number at the end of the ID numbers
Bookmarks