365 values & 365 dates. What is best way to pull the top 10 of each?

[aedctalk]

Hi. Ok i have a situation that is stumping me quite a bit.

I'm trying to get top 10 values and top dates those values were on.

I have my values and dates set up like below:


ROW 1 date 1/2/11 1/3/11 1/4/11 1/5/11 1/6/11 1/7/11 1/8/11 A1:A8

ROW 2 value 4.31 2.24 3.35 7.27. 323.2 3431.3 23.8 B1:B8
ROW 3 date (and so on for 7 days of the week) C1:C8
ROW 4 value (and so on for 7 days of the week) D1:D8
ROW 5 date (and so on for 7 days of the week) E1:E8
ROW 6 value (and so on for 7 days of the week) F1:F8

and it goes so on for 50 weeks.

how can i get top 10 numbers from this? and the dates of those numbers?

I am so so so lost.

i mean i get how i can get 1 weeks top nummbers and dates. just not how i can do it for so many weeks :/

Also somewhat related if i use =LARGE for A1:A8 is there a method by which i can make it not count the dates as values? those end up being my top values).. i only want the value rows counted though.

 

[jc.021286]

Personally,
I'd suggest you get something to quickly and easily put all the data into 2 continuous columns. As it is, your data is broken out across 7. Thus, every other row with dates would be put into column A (on another sheet if you wanted). And the value contents into column B and you would get an easy set of data to do your other work with.

jc

 

[aedctalk]

yeah. thank you. that looks like what im going to have to do. seems like it'll take a while . eek. wish there was a faster way :/


Thanks again!