Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data in columns. Which formula will identify last completed colu. | Excel Worksheet Functions | |||
Conditional Formating CF (to identify case/strikethro differences) | Excel Worksheet Functions | |||
identify missing data b/t columns and then paste in anthoer column | Excel Discussion (Misc queries) | |||
Differences between two columns. | Excel Discussion (Misc queries) | |||
identify different data in two columns | Excel Discussion (Misc queries) |