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
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
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
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)
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.
Don’t have an account yet? Register yourself now and be a part of our community!