Find 1st unique Value on Column and Insert certain Word on cell on left Column

Hello Im trying to create a Macro that will help me sort some data. I have an excel sheet and this what I want the finish product to be... that once I sort based on Column B.... I need the system to look for the first #1 and whereever the value of #1 is to Put a V on the same Row but in Column A.... for #2 for it to put a D on the same Row as the first #2 on the list but in column A...and so forth...
Im tried Lookup but it restricts me to a certain cell value...i need for the system to place the letter values on column A no matter on what row it falls..? thanks for your help everyone.

V 1 6,541.65
1 6,615.38
1 7,144.76
1 7,273.08
D 2 7,453.50
2 7,518.93
2 7,857.54
2 8,140.91
DDO 3 9,128.54
3 9,196.97
3 9,871.90
3 9,901.72
L 4 10,121.98
4 10,439.17
4 10,605.04
4 11,085.75
X 5 11,569.58
5 11,676.52
5 11,903.91
5 12,168.60
5 12,259.26
P 91 12,331.43
91 12,519.89
91 12,625.17
91 12,713.76
91 12,826.40

Colomn A is where I need the values to be added after the macro finds the first line item in Column B... the thing is the number of line items (1's) will vary daily as will the number of #2,#3 etc... so i need to find a way to tell excel that no matter where it falls, for it to find the first #2 in column B and put a "D" on the Column A next to it. In column B, the #1 might vary between 1 thru 400 or so a day .... thanks


Column A Column B
V 1
1
1
1
1
D 2
2
2
DDO 3
3
3
Etc 4
4

SAMPLE.jpg

hopefully it will work