ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how can we compare name and roll no lists (https://www.excelbanter.com/new-users-excel/93326-how-can-we-compare-name-roll-no-lists.html)

Iftikhar

how can we compare name and roll no lists
 
for a data set if the names and roll no are disordered how can we compare
with original list?


Bill Ridgeway

how can we compare name and roll no lists
 
There are a number of ways to answer your query dependent on what you're
wanting to do.

Are you wanting to compare and eliminate duplicates? Is data entered in
both in exactly the same way?

Regards.

Bill Ridgeway
Computer Solutions

"Iftikhar" wrote in message
...
for a data set if the names and roll no are disordered how can we compare
with original list?




Ragdyer

how can we compare name and roll no lists
 
Check out this link to Chip Pearson's web site.
Scroll down to the D's, and you'll find several pages that deal with
handling duplicates.

http://www.cpearson.com/excel/topic.htm

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Iftikhar" wrote in message
...
for a data set if the names and roll no are disordered how can we compare
with original list?




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com