RE: find last number in a string?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try:

N1 contains your search number e.g 12

=MAX(--(A1:C2>=N1)*(A1:C2<N1+1)*(A1:C2))

Enter with ctrl+shift+enter

Will only work on numbers (Not 1234/1 which is general/text)

HTH

"Steve" wrote:

Thx for that MIke, but my numbers are in a table aranged over say 7 columns.

i want to do a ctrl f on the array/table and it to tell me the highest
number in a range of number...as an example...i have say the number 12.02 &
12.03 and number 22.05 & 22.06....i want to be able to say...

"tell me the highest number in the array, not necessarily in same
column....for any number beginning with 22 and then do the same action on any
number beginning say 12"...
so in the first answer i would expect to see 22.06 and in the second i would
expect to see 12.03.
or even better still, for it to return the next in the sequence.

cheers





"Mike H" wrote:

Assuming the last number in your list is in A1, put this in B1 and drag down:-

=LEFT(A10,5)&MID(A10,FIND("/",A10,1)+1,99999999)+1

it will increment the numbers after the / by 1 up to 99999999

Mike

"Steve" wrote:

If i have a table of numbers in an array and want to find a number starting
with say first 4 digits and want it to tell me the next number in the
sequence, then how do i do it in excel if at all?

i.e.

if a list of numbers such as 1234/1, 1234/2, 1234/3....i want it to tell me
the next in the sequence is 1234/4..

any ideas?

its a pity you cant just think these thoughts in "help"...:)
.

Relevant Pages

  • Re: Combining Data from multiple fields
    ... Steve, your example got the ball rolling and I was able to successfully ... I can certainly understand you want the LSR to be *displayed* in the ... there may be occasional gaps in the sequence of the numbers. ... the form or report is based on, or in the Control Source of an unbound ...
    (microsoft.public.access.forms)
  • Re: How are date links identified?
    ... > Hello Steve, hello Siggy, ... >>> For hammock tasks I don't even bother. ... >>> data table, and also something called the Unique ID, a sequence number ... >>> MS Project Trainer & Consultant ...
    (microsoft.public.project)
  • Re: Adding auto-numbered field screws up Table order
    ... Steve Schapel, Microsoft Access MVP ... > if you use a Query joining this table to some other table, ... > Grouping property of a Report to control the sequence. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: coding text editor
    ... recommended from steve is old and makes a lot of features impossible ... Quoting from the linked paper (I have not read it entirely, ... The more sophisticated sequence data structures keep the ... span method keeps each line together and keeps an array or a ...
    (comp.os.linux.development.apps)