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
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