Hello Everyone,
I need some help with the data below. So, I'm trying to assign numbers to the Values in Column B. For example ,if Column B has Apple in it and I assign it 22, I want the next item on the list to be 23 and so on. Same items should have same value, as you can see in Column A.
How can I achieve this using VBA? Any help would be much appreciated! Thanks!
I need some help with the data below. So, I'm trying to assign numbers to the Values in Column B. For example ,if Column B has Apple in it and I assign it 22, I want the next item on the list to be 23 and so on. Same items should have same value, as you can see in Column A.
How can I achieve this using VBA? Any help would be much appreciated! Thanks!
Column A | Column B |
22 | Apple |
22 | Apple |
22 | Apple |
23 | Banana |
23 | Banana |
22 | Apple |
23 | Banana |
24 | Orange |
24 | Orange |
23 | Banana |
22 | Apple |