Link to home
Start Free TrialLog in
Avatar of RavenTim
RavenTim

asked on

Clear Duplicate values (Not Delete) in Excel 07

I have a spreadsheet with two columns.  First column is a box # and the second column is a list of files.  So the box # is replicated down column A 10 X's if there are 10 unique records within the box(listed in column B).  I want to have excel search column A and find the first unique box # and then clear the cells beneath until it finds the next box # .  (Clear the data without moving the next # up in the column)
ASKER CERTIFIED SOLUTION
Avatar of rspahitz
rspahitz
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RavenTim
RavenTim

ASKER

This solutions led me in the right directions.  Thanks for your help.
Just curious about the B grade.  Was it inadequate for your question?
I strive to give the best possible answers so I'd appreciate some info on how to make this answer better.
thanks :)
The specific solution you gave was not what I needed, but it did lead me to the correct formula...  I had to use =IF(A2=A1,"",A1+1) .  Thanks Again.
OK thx :)