Taking Next Highest Number

Muppley · May 31st 2007

Hi

I have a dilemma. What I want to do is: If I input a date in a cell I want the adjacent cell to take the next highest number from a list on another worksheet. My example attached will explain a little better I hope.

Thanks

JimFuller1 · May 31st 2007

Re: Taking Next Highest Number

Muppley,

Hard to say how to go on this one. Are you saying that the "next highest number" is based on all dates in the first column of all sheets in the workbook - sort the dates and use up the numbers in the list - change the number returned when a date in between the dates already entered is entered? Does that last sentence even make sense? See why it's going to be hard to help you?

Maybe we should start with why you want to do this???

Jim

Brian Walters · May 31st 2007

Re: Taking Next Highest Number

In C1 of Sheet1 and Sheet2 enter this and copy down =SMALL(Data!A:A,COUNTA(Sheet1:Sheet2!A:A)-RANK(A1,Sheet1:Sheet2!A:A)+1)

Muppley · May 31st 2007

Re: Taking Next Highest Number

Thanks for both your replies.

Brian, I have tried your formula and it seems to work as I wanted. Many thanks for prompt reply and help.

Taking Next Highest Number

Participate now!

Share