Nov 19 2019 12:27 PM
Hi,
I am looking to create a graph in a 2nd tab, populated from information from tab 1.
Please see attached sheet. I need the 2nd tab to only bring across 5% mark-up figures of the figures in column I of Tab 1, only when Gateway is in Column D.
The figures should land in their prospective months, taken from tab 1, column P.
Can anyone help.
At the moment, it is taking across 5% mark-up of all figures.
Regards,
John
Nov 20 2019 12:48 AM
@johnjamescassidy I would advise to use a pivot table rather than formulas, see attached. I'm not sure what the 5% is about so I just summarized the amounts.