Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 21st 05, 11:15 PM
Novaglory
 
Posts: n/a
Default Delete Rows based on criteria in excel

Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks



  #2   Report Post  
Old April 21st 05, 11:52 PM
Michael
 
Posts: n/a
Default

Hi Novaglory. Try Chip Pearson's site:
http://www.cpearson.com/excel/duplicat.htm. Scroll to the bottom and he has
link for deleting duplicates. HTH

"Novaglory" wrote:

Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks


  #4   Report Post  
Old April 22nd 05, 05:41 PM
Novaglory
 
Posts: n/a
Default

Hi Michael
thanks for the link- I'm working through one solution involving on VBA Code,
which i'm a newbie at, and my computer keeps hanging, but i'll keep trying.
Any other suggestions anyone?


"Michael" wrote:

Hi Novaglory. Try Chip Pearson's site:
http://www.cpearson.com/excel/duplicat.htm. Scroll to the bottom and he has
link for deleting duplicates. HTH

"Novaglory" wrote:

Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks


  #5   Report Post  
Old July 10th 07, 04:40 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 75
Default Delete Rows based on criteria in excel

Hi. I have the same problem and that link doesn't work.

"Michael" wrote:

Hi Novaglory. Try Chip Pearson's site:
http://www.cpearson.com/excel/duplicat.htm. Scroll to the bottom and he has
link for deleting duplicates. HTH

"Novaglory" wrote:

Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks




  #6   Report Post  
Old July 10th 07, 08:29 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 2,819
Default Delete Rows based on criteria in excel

Try the link again now.

Heidi wrote:

Hi. I have the same problem and that link doesn't work.

"Michael" wrote:


Hi Novaglory. Try Chip Pearson's site:
http://www.cpearson.com/excel/duplicat.htm. Scroll to the bottom and he has
link for deleting duplicates. HTH

"Novaglory" wrote:


Hello everyone,

I'm looking to delete every rows where one cell (not all cells) has a
duplicate value of another cell within the same column, but in a different
row.
Best case scenario, the formula would select which row to delete based on
whether or not another field in the row displayed a specified value.
I sincerely appreciate any help, Thanks





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert rows based on specific value bob Excel Worksheet Functions 6 February 29th 08 07:11 PM
how can you add more rows in excel 2000? Khody Excel Discussion (Misc queries) 3 February 16th 06 11:30 AM
counting cells (COUNTIF) based on two or more criteria Tricia S. Excel Worksheet Functions 10 March 17th 05 02:17 PM
How to delete duplicate rows in Excel 2000? [email protected] Excel Discussion (Misc queries) 1 January 28th 05 03:08 PM
How do I remove blank rows in Excel? m28leics Excel Discussion (Misc queries) 2 November 29th 04 11:56 PM


All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017