Numbering problem

mzspazchick

New Member
Joined
Nov 10, 2005
Messages
39
Hi All,
I have a new problem and you all have been soooo great in solving my old problems, so here I am again.
I have some data brought into a worksheet by a formula. So the data might be a list of names or it might have an error message depending on whether or not the data meets the requirements of the formula.
So I have:
Joe
Sue
Sally
#NUM!
#NUM!

and on another list I have:
Jesse
Jane
#NUM!
#NUM!
How can I put a sequential number in the box to the left of the names? For example I would like to see:
1 Joe
2 Sue
3 Sally
#NUM!
#NUM!

then on the other list
4 Jesse
5 Jane
#NUM!
#NUM!

and so on. I have tried an IF statement, but no luck. I have searched this board for days and I can find numbering but not like mine.
Can this even be done? And if so, any ideas on where I should start?
Thank you,
Michelle
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Book2
ABCD
103
2AutoNumberList1AutoNumberList2
31Joe4Jesse
42Sue5Jane
53Sally #NUM!
6 #NUM! #NUM!
7 #NUM!
8
Sheet1


A1 must house a 0.

A3, copied down:

=IF(ISTEXT(B3),LOOKUP(9.99999999999999E+307,$A$1:A2)+1,"")

C1:

=LOOKUP(9.99999999999999E+307,A1:A7)

C3, copied down:

=IF(ISTEXT(D3),LOOKUP(9.99999999999999E+307,$C$1:C2)+1,"")
 

mzspazchick

New Member
Joined
Nov 10, 2005
Messages
39
Many thanks again Aladin Akyurek. I greatly appreciate all your help. I think that formula was similar to another you helped me with before. Just a quick question, whats up with the "9.99999999999999E+307" part? How does that work? If you have a moment...
Thanks,
Michelle
:biggrin:
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
mzspazchick said:
Many thanks again Aladin Akyurek. I greatly appreciate all your help. I think that formula was similar to another you helped me with before. Just a quick question, whats up with the "9.99999999999999E+307" part? How does that work? If you have a moment...
Thanks,
Michelle
:biggrin:

See if this helps: http://tinyurl.com/83b2x
 

Watch MrExcel Video

Forum statistics

Threads
1,119,139
Messages
5,576,306
Members
412,716
Latest member
thviid
Top