Automatically delete duplicates of cells?

[Tinwelende]

If I have one column with a little bit over 13 000 rows of data and some of them might be duplicates - is there a way to only get one of each different cell into a new column?

[oeldere]

Excel 2007 => data => remove duplicates.

P.s. this seems to me also a duplicated post

[Tinwelende]

That command seem to look at capital letters and lower case letters as the same. I need them so separate these, too. Is that possible?

A duplicate post of what? A post that already exists, or a duplicate of the post I just created a couple of hours ago? (In the latter case, it's not. This is another question).

[oeldere]

I translate the formula, please post back if the formula is different in Englisch

b3=TEXT(CODE(LEFT($A3,1)),"000")&A3

See the attached file.

Use this helpcolumn in column B

After that you can do remove duplicates (on column B) (as added in earlier respond).

After that just delete column B and you get the desired result.

[Tinwelende]

Thank you! Though, I'm not sure I understand completely what to do now? If I add the code that you posted in column C, it still gives me an error...

[oeldere]

And which formula do you use in column C ?

Otherwise post an example of your excel sheet, without confidentional information.

[Tinwelende]

I used the formula you posted: b3=TEXT(CODE(LEFT($A3,1)),"000")&A3

[oeldere]

in cel b3 you need to add this formula.

and then try again.


=TEXT(CODE(LEFT($A3,1)),"000")&A3

[Tinwelende]

That didn't work, either. I'm probably doing something wrong. Here's a workbook of some of my data that I need sorted. It needs to be a formula that sorts them, regardless of what letters are in the cells.

Is that possible?

Workbook sorting.xlsx

[Tinwelende]

My program is in Swedish, by the way? Maybe I should try and translate the words in the formulas you give me?

[oeldere]

The letters are all in the same order?

First letter A and then letter B, or they are just random?

And the endresult needs to be merged (or that's not neccesary)?

Where you gonna use it for.

[Tinwelende]

Oh, sorry. I've created two forum posts lately, wanting two different things. It seems like I threw both tasks onto you in this post now! That was not my intent. I'm sorry.

No, the end result doesn't need to be merged. I can merge it as the next step, into new cells later on.

All the letters will be random. They come in pairs, though, so if there's an "A" in the first cell, there will be an "a" or an "A" in the next. It's just that they can show up in capital letters, or in lower care letters and I want these two pairs sorted. So basically, I want the cell in column A to be compared to the cell in column B and have the two cells sorted.

AFTER THIS, I need all the duplicate rows to be deleted automatically (remember that this in on my sheet 4, or something, and depending on what letters I write on sheet 1, the content of the cells will change, so I need the rows to delete duplicate rows every time new data is put into them, so that they only show one copy of each different row, independent of what's been in them before.

I'm trying to do an automised inheritance pattern for the known genes of hamsters. Using all the possible kodes that can be transferred by the male and all the possible kodes that can be transferred by the female, crossing them, and now I've got the result, but I've got 13 000 different outcomes. I need to delete all the outcomes that are duplicates and later on I need to sort it even more (so there will probably be more forum posts after this). I've come a long way already, though! I'm able to get the results. Now I just need to refine the results.