shili12
Member
Posted under here, but nevertheless, power query, formula or conditional formatting solutions, or LET are acceptable as well.
i have a 36MB file with over 171000 rows. Am using office 365.
My expected result is the last column narration or coloured, the final column is not part of original database:-
i have a 36MB file with over 171000 rows. Am using office 365.
My expected result is the last column narration or coloured, the final column is not part of original database:-
Unit manager | Agency | policy nos(unique) | Date | Type | amount | Action needed on row |
EVANS smithson | SUN-Asean INSURANCE AGENCY | 200/070/1/763154/2023/ | 4-Aug | DRN | 11880.8 | keep as its august transaction |
EVANS smithson | SUN-Asean INSURANCE AGENCY | 200/070/1/763154/2023/ | 4-Aug | REC | -11881.7 | keep as its august transaction |
EVANS smithson | SUN-Asean INSURANCE AGENCY | 200/070/1/763817/2023/ | 17-Jul | DRN | 3881 | delete as its july transaction |
EVANS smithson | SUN-Asean INSURANCE AGENCY | 200/070/1/763817/2023/ | 17-Jul | REC | -3881 | delete as its july transaction |
MONICAH jones | MONICAH jones | 050/088/1/002610/2023/ | 11-Jul | DRN | 7366.5 | delete as its july transaction |
MONICAH jones | MONICAH jones | 050/088/1/002610/2023/ | 11-Jul | REC | -9790 | delete as its july transaction |
MONICAH jones | PENA INSURANCE AGENCY | 120/070/1/500188/2022/ | 31-Jul | DRN | 2341 | keep as it has july aug |
MONICAH jones | PENA INSURANCE AGENCY | 120/070/1/500188/2022/ | 7-Aug | REC | -2381 | keep as it has july aug |
MONICAH jones | PENA INSURANCE AGENCY | 120/070/1/747345/2023/ | 11-Aug | REC | -181 | delete as it is solo transaction |
MONICAH jones | PENA INSURANCE AGENCY | 120/080/1/189302/2023/ | 1-Aug | DRN | 899 | delete as it is solo transaction |
EVERLYN cookson MAINA | PAC INSURANCE AGENCY | 040/070/1/758959/2023/ | 8-Jul | DRN | 1370.6 | delete as its solo transaction |
EMMAH nightingale | PHELP INSURANCE AGENCY | 140/070/1/780879/2023/ | 11-Aug | DRN | 9999.9 | delete as it has credit note |
EMMAH nightingale | PHELP INSURANCE AGENCY | 140/070/1/780879/2023/ | 11-Aug | REC | -10000 | delete as it has credit note |
EMMAH nightingale | PHELP INSURANCE AGENCY | 140/070/1/780879/2023/ | 21-Aug | CRN | -9959.9 | delete as it has credit note |
EVANS smithson | SPRINT INSURANCE AGENCY LTD | 010/070/1/674210/2023/ | 13-Jul | CRN | -19292.4 | delete as its july transaction |
EVERLYN cookson MAINA | NERITA INSURANCE AGENCY | 050/070/1/750194/2023/ | 25-Jul | CRN | -2380.7 | delete as its july transaction |
EVERLYN cookson MAINA | NERITA INSURANCE AGENCY | 050/070/1/750194/2023/ | 25-Jul | DRN | 2380.7 | delete as its july transaction |
VIRGINIA NJOROGE | EBC INSURANCE AGENCY | 050/084/1/026101/2023/ | 19-Aug | CRN | -33492.6 | delete as it has solo credit note |