Hi,
If I have a large table of data similar to this:
On a seperate tab I only want to list out those that have warnings in the 'over limit flag' & 'approaching limit' columns, please can someone help with a formula to do this?
Thank you
If I have a large table of data similar to this:
Customer | AoD Net Limit | Over Limit | Over Limit Flag | Approaching Limit | Approaching Limit |
Alpha | - | - 25,000.00 | Ok | 0.00% | Ok |
Beta | 21,957.00 | - 128,043.00 | Ok | 14.64% | Ok |
Charlie | 23,470.50 | - 9,529.50 | Ok | 71.12% | Warning |
Delta | - 16,666.67 | - 16,666.67 | Ok | 0.00% | Ok |
Echo | - | - | Ok | 0.00% | Ok |
Foxtrot | - | - | Ok | 0.00% | Ok |
Golf | 14,280.71 | 14,280.71 | Warning | 0.00% | Ok |
Hotel | 91,164.40 | 61,164.40 | Warning | 303.88% | Warning |
On a seperate tab I only want to list out those that have warnings in the 'over limit flag' & 'approaching limit' columns, please can someone help with a formula to do this?
Thank you