*********URGENT**********I want like to add a decimal point to each number (or letter-number) in a way that it is the decimal is in the second place, e.g. 100 to 10.0 and 010 to 01.0 Attached is the column in question. http://wikisend.com/download/410642/srgcd.xlsx
yes, always after the first two numerical digits
problem has been resolved for now. thank you. will contact you if i need anything else....
actually, i do need a f/u here.....
how do i remove duplicates in a column while also removing the corresponding value in the next column (since they are for the same code)?
You did understand what I meant. This might be my mistake. I know how to remove duplicates. However, i am trying to remove duplicates in one column and the corresponding value in another column. That being said, the other column does not have any duplicates.
PLEASE ASAP!!!!!!!!!!!!absolutely. however, how do i remove the first duplicate not the second?
So you don't know how to do?
It might be easier than we think. the problem is that in column A there are duplicates, but column B there are no duplicates and i need the description in column B that corresponds to the duplicate in column A.