B
bimmerman
I have a date that manually gets changed every day in C1.
This day matches up with a cell with the exact same value in H6:L
where there is a cell for each of the 5 days.
In A7 I need to do a rank based on the values underneath the matchin
date in column H:L.
Each day I need to go into my Rank formula and change the cel
reference to reflect the matching date.
What I ultimatly want is to change the date in C1. Then in cell A7:A2
have a rank formula that will use the ROW of data underneath th
matching date.
Thanks for any help
This day matches up with a cell with the exact same value in H6:L
where there is a cell for each of the 5 days.
In A7 I need to do a rank based on the values underneath the matchin
date in column H:L.
Each day I need to go into my Rank formula and change the cel
reference to reflect the matching date.
What I ultimatly want is to change the date in C1. Then in cell A7:A2
have a rank formula that will use the ROW of data underneath th
matching date.
Thanks for any help