Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 13th 08, 06:40 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default lookup values vertically in a list and return the repeats

I have a huge table with account numbers and I need to find out all the ones
that are repeated in one column so that I can delete them and just keep one
value (one Row)..

Does anybody know how to do this with VLOokup or some other function?

Thank you

  #2   Report Post  
Old November 13th 08, 06:48 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 1,805
Default lookup values vertically in a list and return the repeats

If you have your account numbers in Col A then enter this in B1 and copy down
=IF(COUNTIF($A$1:A1,A1)1,"Duplicate",A1)
Filter on Duplicate and delete those rows..


"April_2004" wrote:

I have a huge table with account numbers and I need to find out all the ones
that are repeated in one column so that I can delete them and just keep one
value (one Row)..

Does anybody know how to do this with VLOokup or some other function?

Thank you



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
How do I use LOOKUP to return a range of values, then SUM values? irvine79 Excel Worksheet Functions 5 August 4th 06 01:33 PM
Lookup a value in a list & return multiple corresponding values medic Excel Worksheet Functions 2 May 30th 06 11:38 PM
msquery odbc -- excel repeats query on return [email protected] Excel Discussion (Misc queries) 0 April 3rd 06 06:22 PM
How do I lookup and return different values when the lookup value. kg Excel Discussion (Misc queries) 1 January 20th 05 12:53 AM
Lookup values in a list and return multiple rows of data Amanda L Excel Worksheet Functions 2 December 2nd 04 04:48 PM


All times are GMT +1. The time now is 12:32 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017