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)
RavenTimAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rspahitzConnect With a Mentor Commented:
Do you want to actually clear the data, or hide it?

What I suggest is a simple formula in the next adjacent column: (starting in C2)
=if(A1=A2, "", B2)

Copy this down to the last row with data in A and you can then hide column B and column C should show what you want.

and in C1 put:
=B1
to wrap it up
0
 
RavenTimAuthor Commented:
This solutions led me in the right directions.  Thanks for your help.
0
 
rspahitzCommented:
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 :)
0
 
RavenTimAuthor Commented:
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.
0
 
rspahitzCommented:
OK thx :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.