Swap by Excel lists - I need help tips

4 posts
Tobse
Joined: 23 Feb 2010
Posts: 26
Posted: 21 Aug 2013, 16:43 #
Posted: #
Hello - sometimes it happens that swappers ask for a swap, send their Excel list with
doubles per mail, and ask that I should send mine.

I know for Numista it´s not needed but sometimes I have this.

Now my question:

How do you all go with this swaps with Excel lists

- is there a senseful search idea which helps with this horny job

- and is there a possibility with Excel to compare two lists??
sujit_kumar Catalogue referee
Joined: 11 Jan 2013
Posts: 2360
Posted: 21 Aug 2013, 18:11 #
Posted: #
Yes, Use "LOOKUP" function in Excel to compare lists.
“A man without a hobby is only half alive.”
Franklin Delano Roosevelt
Tobse
Joined: 23 Feb 2010
Posts: 26
Posted: 21 Aug 2013, 19:11 #
Posted: #
what is lookup??

can you explain in more detsils
sujit_kumar Catalogue referee
Joined: 11 Jan 2013
Posts: 2360
Posted: 22 Aug 2013, 04:32 #
Posted: #
Quote: Tobsewhat is lookup??

can you explain in more detsils
Try these links for Examples,

http://www.techonthenet.com/excel/formulas/lookup.php
http://support.microsoft.com/kb/324986
“A man without a hobby is only half alive.”
Franklin Delano Roosevelt
Topic locked (Numista Robot, 23 Jan 2019, 23:20)
Forum »

» Forum policy

Used time zone is UTC+2:00.
Current time is 02:35.