Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 19th 06, 09:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default Duplicate entries

I have a large spreadsheet consisting of about 16,000 rows and 8 columns.
The first columns are longitude and latitude coordinates. Is there a way to
sort and display the rows where both the values in columns A and B are the
same? I have sorted on A then B but sometimes places have exactly the same
longitude but very different latitudes. I'm just trying to eliminate the
necessity of going through all 16000 entries to eliminate duplicates.

Thanks,

Rick Morrison




  #2   Report Post  
Old September 19th 06, 10:15 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,047
Default Duplicate entries

Hi Radiorick

try to use an auxiliar column and concatenate A and B figures =a2&b2 and
sort for this one

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Radiorick" escreveu:

I have a large spreadsheet consisting of about 16,000 rows and 8 columns.
The first columns are longitude and latitude coordinates. Is there a way to
sort and display the rows where both the values in columns A and B are the
same? I have sorted on A then B but sometimes places have exactly the same
longitude but very different latitudes. I'm just trying to eliminate the
necessity of going through all 16000 entries to eliminate duplicates.

Thanks,

Rick Morrison




  #3   Report Post  
Old September 19th 06, 11:01 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 213
Default Duplicate entries

try to use an auxiliar column and concatenate A and B figures =a2&b2
and sort for this one


For the extra picky, maybe something like
=a2&"x"&b2
would work better.

After all, "1" &"12" is the same as "11"&"2".

Never mind if there's enough punctuation in the columns to avoid the
ambiguity.
  #4   Report Post  
Old September 20th 06, 10:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default Duplicate entries

Thanks . . . I used your idea and got found all the duplicates, Rick

MyVeryOwnSelf" wrote in message
...
try to use an auxiliar column and concatenate A and B figures =a2&b2
and sort for this one


For the extra picky, maybe something like
=a2&"x"&b2
would work better.

After all, "1" &"12" is the same as "11"&"2".

Never mind if there's enough punctuation in the columns to avoid the
ambiguity.



  #5   Report Post  
Old March 23rd 19, 05:20 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2019
Posts: 1
Default Duplicate entries

Excellent. Thanks.


  #6   Report Post  
Old March 23rd 19, 12:39 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2019
Posts: 2
Default Duplicate entries

You could have an extra column with “=a1=b1” this would give a true or false


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
Duplicate Entries Phxlatinoboi® Excel Discussion (Misc queries) 2 August 24th 06 01:17 AM
removing duplicate entries armagan Excel Discussion (Misc queries) 1 June 12th 06 05:42 PM
Duplicate Entries ConfusedNHouston Excel Discussion (Misc queries) 1 November 1st 05 01:50 PM
problem tagging duplicate entries julz Excel Worksheet Functions 5 June 30th 05 01:59 AM
count duplicate (or, inversely, unique) entries, but based on a condition markx Excel Worksheet Functions 3 March 8th 05 07:57 PM


All times are GMT +1. The time now is 08:18 PM.

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