Combining Match and Rank and possibly others?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Weighted ranking of a series 3
How can I use both RANK and MATCH 2
Match/Index/Sum function with date range 2
Excel formula question... 8
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
VLookup IF word in string exists within cell, use the word. 0
Match issue 3

Top