Solved

Clear Duplicate values (Not Delete) in Excel 07

Posted on 2011-02-15
5
285 Views
Last Modified: 2012-05-11
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)
0
Comment
Question by:RavenTim
  • 3
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
rspahitz earned 125 total points
ID: 34898386
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
 

Author Closing Comment

by:RavenTim
ID: 34898770
This solutions led me in the right directions.  Thanks for your help.
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 34898816
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
 

Author Comment

by:RavenTim
ID: 34898890
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
 
LVL 22

Expert Comment

by:rspahitz
ID: 34898910
OK thx :)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
After updating data my Excel graphs are showing too many dates 8 32
ADD New Entries 7 16
Update As Well As Add 6 37
Excel 2016 formulas 5 26
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now