View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tickfarmer Tickfarmer is offline
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