Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the next higher number in a sequence?
This should be easy, but I'm stumped (relatively new user). I have a column
of sequential numbers (except that the last numbers are 0) and I want to select the next highest number in that range. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the next higher number in a sequence?
If I understand what you're asking, does this work for you:
=MAX(A:A)+1 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CasaJay" wrote in message ... This should be easy, but I'm stumped (relatively new user). I have a column of sequential numbers (except that the last numbers are 0) and I want to select the next highest number in that range. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the next higher number in a sequence?
Not really, but thank you for the response. That returns the highest value
in the range +1, but not the NEXT highest value, which is what I need. In other words, if A1=1, A2=5, and A3=7 I'm looking for the value in A2. "Ragdyer" wrote: If I understand what you're asking, does this work for you: =MAX(A:A)+1 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CasaJay" wrote in message ... This should be easy, but I'm stumped (relatively new user). I have a column of sequential numbers (except that the last numbers are 0) and I want to select the next highest number in that range. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the next higher number in a sequence?
And also, I agree that I posed my question incorrectly... more specifically,
if forinstance B1=A1, then I want to return the next highest value, meaning the value in A2, since my numbers are sequential (with the exception being that the last numbers can be 0). "Ragdyer" wrote: If I understand what you're asking, does this work for you: =MAX(A:A)+1 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CasaJay" wrote in message ... This should be easy, but I'm stumped (relatively new user). I have a column of sequential numbers (except that the last numbers are 0) and I want to select the next highest number in that range. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the next higher number in a sequence?
Try:
=IF(B1=A1,LARGE(A:A,2),"") -Simon "CasaJay" wrote: And also, I agree that I posed my question incorrectly... more specifically, if forinstance B1=A1, then I want to return the next highest value, meaning the value in A2, since my numbers are sequential (with the exception being that the last numbers can be 0). "Ragdyer" wrote: If I understand what you're asking, does this work for you: =MAX(A:A)+1 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CasaJay" wrote in message ... This should be easy, but I'm stumped (relatively new user). I have a column of sequential numbers (except that the last numbers are 0) and I want to select the next highest number in that range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find by row number | Excel Discussion (Misc queries) | |||
HOW DO I FORMAT WORKSHEETS IN A WORKBOOK TO NUMBER IN A SEQUENCE? | Excel Worksheet Functions | |||
Find the missing number? | Excel Discussion (Misc queries) | |||
Indicate missing number in a sequence (Part II) | Excel Discussion (Misc queries) | |||
find next number in list | Excel Discussion (Misc queries) |