Hi,
Here is my spreadsheet:
In the yellow P&L current column Q I have the formula:
=SUMPRODUCT(--($I$2:$I$14=I31),$Q$2:$Q$14)
I would like a formula in the yellow cells Nominal code column I, where it takes the nominal codes from above but removes duplicates automatically without having to use the Excel command "Remove duplicates" each time.
is this possible?
Thank you
Here is my spreadsheet:
In the yellow P&L current column Q I have the formula:
=SUMPRODUCT(--($I$2:$I$14=I31),$Q$2:$Q$14)
I would like a formula in the yellow cells Nominal code column I, where it takes the nominal codes from above but removes duplicates automatically without having to use the Excel command "Remove duplicates" each time.
is this possible?
Thank you