+- JapCarForum (https://www.japcarforum.com)
+-- Forum: General Discussions (https://www.japcarforum.com/forumdisplay.php?fid=3)
+--- Forum: The JCF Lounge (https://www.japcarforum.com/forumdisplay.php?fid=17)
+--- Thread: Excel experts? (/showthread.php?tid=3148)
Excel experts? - Saraj - 15-01-2018
Need some help, google is doing my head in now !
Column A:
Apple
Banana
Pear
Orange
Lemon
Apple
Orange
Pear
Want I want to do in a new sheet, all the ones which are duplicate above and move them to a new sheet (or copy across rather then move) so then I know which ones have more then 1 result?
Anyone help with the formule?
Excel experts? - Moley - 15-01-2018
What about plums and grapes matey :tongue_smilie:
Or X + Y = Z
Excel experts? - Saraj - 15-01-2018
Moley What about plums and grapes matey :tongue_smilie:
Or X + Y = Z
looool, ive just a microsoft excel forum and posted for help there ! lool
Excel experts? - Lexusboy - 15-01-2018
Saraj i am really not understanding what you want to do.
Can you try to explain again
Excel experts? - Saraj - 15-01-2018
Sorry Ian, in column A is a list of numbers,
but within those number/text there are many duplicates, instead of going through them one by one, I need a formulae which would do this for me and move/copy all duplicates to a new sheet? hope that makes more sense
Excel experts? - SHAHZ - 15-01-2018
are you wanting to copy the list to another location removing any duplicates and just end up with a unique list?
Excel experts? - Saraj - 15-01-2018
SHAHZ are you wanting to copy the list to another location removing any duplicates and just end up with a unique list?
im hoping to move the duplicates to a new sheet, its the duplicates which matter to me the unique data is fine and i dont need.
for example:
1
2
3
1
4
2
3
5
I would like the 1's, 2's, and 3's to move to a completly new sheet as there appear more then once
Excel experts? - SHAHZ - 15-01-2018
not quite what you want, but it will help you identify the duplicates (not much use if youve got 1000's of lines.......Conditional format, choose 'formula' from the drop down and enter =COUNTIF($A$Z:$A$50,A1)>1 (change accordingly to the correct range.
Excel experts? - Saraj - 15-01-2018
SHAHZ not quite what you want, but it will help you identify the duplicates (not much use if youve got 1000's of lines.......Conditional format, choose 'formula' from the drop down and enter =COUNTIF($A$Z:$A$50,A1)>1 (change accordingly to the correct range.
yh managed to do that and it highlights the duplicates.
i think i have got around it.
Do you have any ideas, how I can get a row of data from one sheet to another if one of the cells in the row contains a number equal to 3 or greater?
Excel experts? - Lexusboy - 15-01-2018
You could use a macro