LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default comparing side-by-side lists


I have two lists only containing numbers in columns A and B. How can I
see which cells are not in Column B that are in Column A? For
Example:

Cloumn A Column B
1 1
2 2
3 4
4 6
5 7
6 8
7 9
8
9
10

Is there a way that I can have excel return the missing values from
column B (3,5,10)

Thanks


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=530926

 
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
Cannot see both spreadsheets when comparing side by side SSantellan Excel Discussion (Misc queries) 0 January 17th 08 05:28 PM
How2 setup one page distribution report side by side results sailorgirl Charts and Charting in Excel 0 August 20th 07 09:14 PM
Comparing 2 lists side by side petevang Excel Discussion (Misc queries) 2 April 7th 06 02:44 PM
excel should cut & paste lists side by side to save paper Richierich Excel Worksheet Functions 1 March 10th 06 12:42 AM
Converting grid data to side-by-side lists The Chad Excel Discussion (Misc queries) 6 July 27th 05 03:47 PM


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

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

About Us

"It's about Microsoft Excel"