Hi all, I have data in column A (see below)

ROW A---------Column
1 Heading
2 BTC
3 BTC
4 BTC
5 GIS
6 GIS
7 VXZ
8 VXZ
9 BTC
10 BTC

I want macro on button which should produce result in column B
something like (see below)

ROW A B---------Columns
1 Heading Heading
2 BTC 1
3 BTC 1
4 BTC 1
5 GIS 2
6 GIS 2
7 VXZ 3
8 VXZ 3
9 BTC 4
10 BTC 4

In other words I want macro to check in column A cells and put numbers
in column B cells and when where value become different in column A
cells then it should also change the value in column B cells. Please
can any friend can help.