Excel experts?
Excel experts?
15-01-2017, 12:52 PM
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?
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
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?
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
15-01-2017, 01:05 PM
Or X + Y = Z
Lexus IS200 Mods--TTE Supercharger, Tein Superstreet Coilovers & EDFC, 6000K HID Lights, HKS Silent High Power Exhaust, DBA Front Discs, Kenwood DNX9240 Head Unit, 19" Rims, TRD Kit, FIGS Bonnet Struts, Greddy Pillar Pod & Defi Gauges, TTE Red ARBS . And Been To WIM twice
What about plums and grapes matey :tongue_smilie:
Or X + Y = Z
Lexus IS200 Mods--TTE Supercharger, Tein Superstreet Coilovers & EDFC, 6000K HID Lights, HKS Silent High Power Exhaust, DBA Front Discs, Kenwood DNX9240 Head Unit, 19" Rims, TRD Kit, FIGS Bonnet Struts, Greddy Pillar Pod & Defi Gauges, TTE Red ARBS . And Been To WIM twice
15-01-2017, 01:14 PM
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
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
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
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
15-01-2017, 02:02 PM
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
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
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
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
15-01-2017, 02:17 PM
Tinted Glass-Sports Grill-Debadged-TTE Spoiler-TTE Lowering Springs-PLUK Kazama Exhaust-18" Aero Alloys-K&N Air Filter-Denso Iridium Power Spark Plugs-Quad Tail Light Conversion-6000K HID-X-White High Beam-6 LED Sidelights-Quad LED Boot Light-JDM OEM Smoked Front Fogs-JDM Blue Reverse Bulbs-LS430 Smoked Side Repeaters-6 LED Side Repeaters-Chrome Indicator Bulbs-Alpine HU-Rear Headrest Monitors-PIAA Super Sporza-Fan Washer Jets-Lex Tax Disc Holder-Chrome Gear Knob-2003 Cup Holder-Toyo Proxes T1-R
are you wanting to copy the list to another location removing any duplicates and just end up with a unique list?
Tinted Glass-Sports Grill-Debadged-TTE Spoiler-TTE Lowering Springs-PLUK Kazama Exhaust-18" Aero Alloys-K&N Air Filter-Denso Iridium Power Spark Plugs-Quad Tail Light Conversion-6000K HID-X-White High Beam-6 LED Sidelights-Quad LED Boot Light-JDM OEM Smoked Front Fogs-JDM Blue Reverse Bulbs-LS430 Smoked Side Repeaters-6 LED Side Repeaters-Chrome Indicator Bulbs-Alpine HU-Rear Headrest Monitors-PIAA Super Sporza-Fan Washer Jets-Lex Tax Disc Holder-Chrome Gear Knob-2003 Cup Holder-Toyo Proxes T1-R
15-01-2017, 02:19 PM
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
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
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
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
15-01-2017, 02:38 PM
Tinted Glass-Sports Grill-Debadged-TTE Spoiler-TTE Lowering Springs-PLUK Kazama Exhaust-18" Aero Alloys-K&N Air Filter-Denso Iridium Power Spark Plugs-Quad Tail Light Conversion-6000K HID-X-White High Beam-6 LED Sidelights-Quad LED Boot Light-JDM OEM Smoked Front Fogs-JDM Blue Reverse Bulbs-LS430 Smoked Side Repeaters-6 LED Side Repeaters-Chrome Indicator Bulbs-Alpine HU-Rear Headrest Monitors-PIAA Super Sporza-Fan Washer Jets-Lex Tax Disc Holder-Chrome Gear Knob-2003 Cup Holder-Toyo Proxes T1-R
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.
Tinted Glass-Sports Grill-Debadged-TTE Spoiler-TTE Lowering Springs-PLUK Kazama Exhaust-18" Aero Alloys-K&N Air Filter-Denso Iridium Power Spark Plugs-Quad Tail Light Conversion-6000K HID-X-White High Beam-6 LED Sidelights-Quad LED Boot Light-JDM OEM Smoked Front Fogs-JDM Blue Reverse Bulbs-LS430 Smoked Side Repeaters-6 LED Side Repeaters-Chrome Indicator Bulbs-Alpine HU-Rear Headrest Monitors-PIAA Super Sporza-Fan Washer Jets-Lex Tax Disc Holder-Chrome Gear Knob-2003 Cup Holder-Toyo Proxes T1-R
15-01-2017, 02:42 PM
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?
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
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?
[COLOR="Gray"]December 2008: Crashed Lexus IS200 - Cat B Write Off
August 2009: Crashed Vauxhall Astra - Minor Damage DIY Repair
November 2009: Crashed Vauxhall Astra - Scratches To Bumper No Repair Required
February 2010: Other Party Crashed Into Astra - Extensive Damage To Rear -Settled With Third Party's Insurance
Anyone dare To Predict The Future?[/COLOR]
Recently Browsing
5 Guest(s)
5 Guest(s)
Recently Browsing
5 Guest(s)
5 Guest(s)