| View previous topic :: View next topic |
| Author |
Message |
fivefootnine
Power User
Joined: 09 Apr 2012
Posts: 60
|
 Posted: Fri Jul 20, 2012 9:03 am Post subject: [SOLVED]Formula for Removing duplicates from 1 row |
 |
|
Hi, I´m trying to figure out this myself, but I´m stuck.
I have one row A1-Z1 with numbers, some of them are duplicates. I need to automatically copy the list to another row and skip the duplicates.
I need a formula to to this,, I´m sure this has been asked before, so there might be an answer somewhere on the web, a link to a solution would be helpful.
Thank you for any help!
Have a nice day
Last edited by fivefootnine on Fri Jul 20, 2012 10:27 pm; edited 1 time in total |
|
| Back to top |
|
 |
karolus
OOo Advocate
Joined: 22 Jun 2011
Posts: 208
|
| Posted: Fri Jul 20, 2012 9:51 am Post subject: |
|
|
Hallo
Mark A1:Z1
Strg+x
go to A1
Strg+shift+v
[x]all & [x]Transpose
→Data→Filter→Standardfilter....[x]without Duplicates
Karo |
|
| Back to top |
|
|
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 316
Location: victoria
|
| Posted: Fri Jul 20, 2012 2:22 pm Post subject: |
|
|
Your question is unclear on your wants so I have listed two formula either one to be put A2 and dragged across to Z2.
If you have 3 - 13's this will get 1 - 13 and skip the 2 duplicates
| Code: | | =IF(COUNTIF($A$1:A1;A1)>1;"";A1) |
If you have 3 - 13's this will get no 13,s as they are all duplicates.
| Code: | | =IF(COUNTIF($A$1:$Z$1;A1)>1;"";A1) |
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
fivefootnine
Power User
Joined: 09 Apr 2012
Posts: 60
|
| Posted: Fri Jul 20, 2012 10:27 pm Post subject: |
|
|
Thank you Guys for your your replys!
Since i wanted an automatic way the formula was just what I wanted, sorry for the unclear question, I uses the first formula, works like a charm! Problem Solved!
Have a nice Weekend both of you! |
|
| Back to top |
|
|
|
