Given the below table, the challenge before you is to – Work out a formula for Customer spending Maximum amount and his Spend (Cells H4 and H5) for a given Month (H2) and starting alphabet (H3).
Cell H2 has the month in numbers 1 to 12 and H3 has starting alphabet.
If H2 is blank, then it should search irrespective of the month.
If H3 is blank, it should search irrespective of the starting alphabet.
Example – For the month of Mar and starting Alphabet M, Maddy has spent the highest amount and his spend is 345.
The relevant Excel file can be downloaded from here Customer Max Spend.
Note – If you wish, you may post your answer in Comments.
