|
|
#3
11-04-2021, 06:38 PM
|
||||
|
||||
See attached spreadsheet.
I made it a table and added a Reconciliation column to show where the daily total doesn't equal zero. Then the conditional formats applied to each column show the problem days in orange and problem transactions in red.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Merging all data between two sheets into a third one without duplicates or rows or columns | Ricko_uk | Excel | 4 | 08-27-2020 01:16 AM |
| Transpose multiple data form rows in columns matched with a key | Alex1s85 | Excel | 6 | 06-24-2020 07:08 AM |
 How to Loop through rows and Columns to Offset Data
|
Josh1012 | Excel Programming | 4 | 09-06-2018 03:20 AM |
| Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
| macro for comparing data from 3 columns and pasting into another worksheet | ashukla | Excel | 1 | 06-24-2009 05:01 PM |
Windows 10 
Office 2016
Threaded Mode