LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Sort and Match like Items in 2 Columns

The purpose of my project is to reconcile financial information. I have 2
colums of numbers...while most numbers in column A will match those in column
B, I do have some that do not match or are missing...must be out of balance :
) My objective is to sort the two columns in a manner with the data in both
columns match up. If there are mismatched numbers or missing numbers in one
column/row, then I want the alternating column/row to be left blank.
 
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
match and sort columns Shamus Excel Worksheet Functions 0 May 27th 06 02:01 AM
MATCH UP DATA IN COLUMNS jickes Excel Worksheet Functions 2 March 2nd 06 01:14 AM
Using AutoFilter to Sort Data Pulled in by INDEX / MATCH A Romeo Jr Excel Worksheet Functions 7 January 30th 06 11:43 PM
Match and sort vijaya Excel Worksheet Functions 1 November 18th 05 09:23 PM
How do I match identical values in 2 columns and then sort? Godswatch Excel Discussion (Misc queries) 1 November 9th 05 06:55 PM


All times are GMT +1. The time now is 01:29 PM.

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"