Hello friends,
How are you?
I am in great need of help.
I have to organize the order sheet and it has about 10,000 rows.
What needs to be done is to remove all the values except one based on the duplicated values on the other column.
Let me show an example.
Column A Column B
12345678 $10.00
12345678 $10.00
44448888 $15.00
44448888 $15.00
44448888 $15.00
00033344 $10.00
00033344 $10.00
This should organized into like the one below
Column A Column B
12345678 $10.00
12345678
44448888 $15.00
44448888
44448888
00033344 $10.00
00033344
all the values for the duplicated values on the column A were removed except for the first one.
(it can be last one or the first one, as long as one remains)
I was doing it manually for the past one hour but I have barely dont couple hundred and I have more than 10,000 left.
And this needs to be done by no later than 1am. Please help.
(I am not really familiar with the formula and the function so I would be really appreciated if you can also explain how the formula should be applied)
Thank you!
Sample.xlsx
Bookmarks