Hi guys, I need some help with coding please. I've attached the file here for ease of reference.
A few steps are involved and I'm trying to get it all in 1 step:
1. I want to establish, the highest value in column F1, rows 4-12.
2. Thereafter I want to identify the corresponding colour of row 12 (mentioned in column G1).
3. If the colour is Red, I want 2 separate values:
i) (Row 12, Column E) minus the value obtained in step 1 = "Red Sale"
ii) (Row 12, Column B) plus the value obtained in step 1 = "Red Buy"
4. If the colour is Green, I want 2 separate values:
i) (Row 12, Column B) minus the value obtained in step 1 = "Green Sale"
ii) (Row 12, Column E) plus the value obtained in step 1 = "Green Buy"
I'm computing these tables for work and there's hundreds of them! I've done one example of the intended output (just manually coding each step) but any help getting it in 1 step (yellow box) would be most appreciated!
Bookmarks