| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 column sort
I have a 2 column worksheet like below but having hundreds of line
instead of these few. Day 1 100.56 234.43- 405.43 6,506.00 1,304.00 Day 2 100.56 234.43- 405.43 6,506.00 1,304.00 What I need to do in Excel 2003: Find any discrepencies between the columns. 1. Identify any items in column one which are not in column two. 2. Identify any items in column two which are not in column one. Column 2 may arrive with several more items than it should, or severa less. I need a way to see what is extra or what is missing in column 2. It is a real puzzler to me. Any code to help -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort without including column headings in sort | Excel Discussion (Misc queries) | |||
| Auto-Sort Won't Sort All Column Cells | Excel Discussion (Misc queries) | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| my column is sorted in two sections. How do I sort entire column? | Excel Discussion (Misc queries) | |||
| How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions | |||
Threaded Mode
