The information gathered is for Communitic International to ensure the sending of the newsletter.
The information will be used subject to terms and conditions, for advertising purposes.
You reserve the right to access and change your personal data, aswell as the right to request its deletion within the limits permitted by law.
You can also review your targeting options. For more information, click this privacy policy
.
Thks for ur response.....i hv mentioned below the problem in more detail....
DATE DAY Apple Orange Grape
14/6 Mon 1 6 3
15/6 Tue 3 9 4
16/6 Wed 4 2 5
17/6 Thu 5 8 6
18/6 Fri 8 6 9
21/6 Mon 5 3 8
I'm trying to create a excel worksheet that highlights by changing the background colour of the maximum value in the apple, Orange & Grape column . The max value changes based on the input in another column.
I had come across this formula =MAX(IF(NOT(ISNA(C2:C7)),C2:C7)) but I dont seem to be getting the desired answer.
Secondly, I need to get the date that corresponds with the maximum value that is located in the column to the left.
Date Price
High 8 =MAX(C2:C7)
Low 1 =MIN(C2:C7)
I was trying VLOOKUP but again not getting the desired answer.
I look forward to your reply...
Could you add an EXCEL file at any share site and post back the link, Please show in that book how the data is NOW AND how would you like that the final product to look like.
https://authentification.site/files/23162922/rate_ref.xls
Look forward to your solutions