I have column A and B filled with:
A B
1 aa
2 bb
2 bb
1 aa
3 cc
3 cc
.....
i need to loop the column A do until the last cell is blank and fill a dictniory object with distinct value...
in this case
myDict contain:
1 aa
2 bb
3 cc
key are values in column A and items are values of column B
How to?
A B
1 aa
2 bb
2 bb
1 aa
3 cc
3 cc
.....
i need to loop the column A do until the last cell is blank and fill a dictniory object with distinct value...
in this case
myDict contain:
1 aa
2 bb
3 cc
key are values in column A and items are values of column B
How to?
Last edited:
