Lacan
Active Member
- Joined
- Oct 5, 2016
- Messages
- 281
- Office Version
- 365
- Platform
- Windows
Hello Guys,
🖐
Accordingly with customer name using let function would like to compare 2 Columns ("Average" Vs "Month") and return the highest value?
All the help is welcome!
Thank you very much.



Accordingly with customer name using let function would like to compare 2 Columns ("Average" Vs "Month") and return the highest value?
All the help is welcome!
Thank you very much.



2025.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | |||||||||||||
2 | |||||||||||||
3 | CUSTOMER | DEAL | ENE. 2025 | FEB. 2025 | MAR. 2025 | TOTAL | AVERAGE | MONTH | Compare between AVERAGE and MONTH return the highest value | ||||
4 | ABC | 8 000 | 15 | 1000 | 5 | 1020 | 1 000 | 727 | |||||
5 | XPTO | 5 000 | 100 | 50 | 10 | 160 | 100 | 455 | |||||
6 | ZBD | 5 000 | 1200 | 25 | 20 | 1245 | 1 200 | 455 | |||||
7 | TEST2 | 4 000 | 15 | 1 | 20 | 36 | 18 | 364 | |||||
8 | |||||||||||||
9 | |||||||||||||
10 | |||||||||||||
Jan.25 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D3:F3 | D3 | =TRANSPOSE(UPPER(TEXT(EDATE("01-01-2025",SEQUENCE(3,1,0)),"[$-es-ES]mmm aaa"))) |
G4:G7 | G4 | =SUM(D4:F4) |
H4:H7 | H4 | =AVERAGEIFS(D4:F4,D4:F4,">="&AVERAGE(D4:F4)) |
I4:I7 | I4 | =C4/11 |
Dynamic array formulas. |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
I10 | Other Type | Icon set | NO | |
I10 | Other Type | Icon set | NO |