Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare values in a column
I need help with a macro that checks that cells values in column A are
increasing by one increment. In Column A i put receipts numbers. I want to be able to check if all receipts have been recorded. for example, if column A looks like this: A 1 100 2 101 3 103 4 104 5 105 All values are increasing by 1, except the value in cell A3 increased by 2. Which means that Receipt Number 102 hasn't been recorded. I want the macro to go through cells in column A, and once it detects a gap, the cell fill colour (cell A3 in the above example) turns red. I'm using Excel 2003. Many thanks Tendresse |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up values in one column and compare with another | New Users to Excel | |||
HOW TO COMPARE COLUMN VALUES IN EXCEL? | Excel Worksheet Functions | |||
How do I compare string values in one column to another column? | Excel Worksheet Functions | |||
Need code to compare cell values in a column | Excel Programming | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions |