Duplicate values

**Kikelinsky** · 01-09-2013, 04:16 PM

Hi all, my concern comes to this:

I work with excell tables to manage a Dynamic datebase system for accounts. I run a report from this system wich gives me an up to date list of certain accounts, I work with it and annotate it. I have to run periodical reports in the system in order order to get new accounts that have been entered. However I can't eliminate the accounts that all ready reported in the first report. In result I have duplicate values.

I would like to know if there is a way I could eliminte mi excell work list of duplicate values and have only the new accounts enter this list I curently work on.

PLease help.

**FDibbins** · 01-09-2013, 04:20 PM

Hi Kikelinsky and welcome to the forum

we would love to help you, but 1st, according to forum rule 1, please rename your thread to something more meaningful, that actually describes your problem. lots of contributors will look at a thread title, and if it of interest to them, or falls within their area of expertise, and will only open those threads. also, searching for """"help"""" will not turn up too many results that will benefit you, sorry

when you name a thread, think """"google"""". what kind of returns would you expect if you typed that into google?""

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you."

**oeldere** · 01-09-2013, 04:22 PM

You only want to see the new (duplicated) values?

Or you want to add these to the (old) list => so you get an list of unique values?

You get better help if you add an excel file, without confidentional information.

Please also add the desired result.

**Kikelinsky** · 01-09-2013, 04:39 PM

Hi here is a table as an example.

What I would like is to use the annotated rows ( the rows that I write on column g) to remain as they are and be able to see the new records that I add to this list sorted istead of having them duplicated as they are in the example. Let mne know