LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Identify Differences Between four columns of data

I have 4 columns of data. The first two columns have 500 rows and the second
two have 700 rows. I need to identify the differences between the columns.
The data is representative of the following:
Invoice # INV Amount Invoice # INV Amount
530878 0 530878 47.6
530878 0 530878 144
530878 127.2 530878 38.4
530878 31.2 530878 26.4
530878 47.6 530878 104
530878 30 530878 192
517605 55.2 517605 104
517605 68.8 517605 120
517605 0 517605 0
517605 0 517605 72
517605 72 517605 95.2
517605 95.2 517605 55.2
517605 104 517605 68.8
517605 120 517605 0

What is the best way to do this?
--
Tickfarmer
 
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
Data in columns. Which formula will identify last completed colu. Piet Excel Worksheet Functions 2 June 15th 09 09:35 AM
Conditional Formating CF (to identify case/strikethro differences) Ron@Buy Excel Worksheet Functions 3 October 26th 07 06:11 PM
identify missing data b/t columns and then paste in anthoer column Little pete Excel Discussion (Misc queries) 0 January 31st 07 12:36 PM
Differences between two columns. Mr. Smiley Excel Discussion (Misc queries) 4 September 20th 05 12:32 AM
identify different data in two columns fitzy Excel Discussion (Misc queries) 2 July 20th 05 11:13 AM


All times are GMT +1. The time now is 05:10 AM.

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

About Us

"It's about Microsoft Excel"