Ok, in other words you want to know what the *last* C number entered is?

1
2
C1
C2
22
4
C3
7
26

=LOOKUP(2,1/(LEFT(F10:F100)="C"),F10:F100)

Result = C3

--
Biff
Microsoft Excel MVP


"bvasquez" wrote in message
...
They are random. The C numbers I manually enter. For my application I am
using these C numbers to indicate change orders on a contract. It is
imperative that the go in a consecutive order without skipping any
numbers.
They will be entered in a random order but always within the F column
starting with the range of (F10:F100). As the range (F10:F100) begins to
fill
up and I expand the range to (F10:F500) and so on, I am using cell F9 to
tell
me what my next consecutive C number will be. This way I ensure the C
count
climbs consecutively without having to physically look through the range
for
the next highest C number and possibly missing a number in between.

"T. Valko" wrote:

Are these alpha-numerics in sequential order? Like this:

1
2
C1
C2
3
4
C3
5
C4

Or, are they random:

C4
2
C1
1
3
C3

--
Biff
Microsoft Excel MVP


"bvasquez" wrote in message
...
Just cant seem to get it. I am working with data in F10:F100 that
contains
numbers like (1,2,3,4) as well as lettered numbers like (C1,C2,C3,C4).
I
can
not come up with a formula that will index this column and return the
next
highest C number. F9 needs to display the next highest C number. I can
get
this to work with the standard numbers only (1,2,3,4). Any suggestions