Hi,
Can anyone help me please?
I've attached an example sheet which I hope explains my problem, and I'll attempt to explain it in words...
I have a sheet with multiple sets of data (highlighted by colours) and I want to calculate, per set of data, based on the highest value of one column (G), but only if a 1 or 2 exists in another column (F)
Amber/Green colours...
So if Col G has the highest value per set of data, plus there is a 1 or 2 in column F then multiply Value1 (Col E) by whatever parameter I set, in this case 10 (J1)
All other results for that set of data are zero
On the other hand, (blue highlighted data) if we've identified the highest value per set of data but if the matching 'select' value (F) is zero, then the result should be a minus of my set parameter (J1), and again all other results for that set of data are zero
I've just read that back and I think I've made it sound awful, but I think with the example it might make sense.
As always, any help or advice is much appreciated.
Thank you
Bookmarks