Add a number sequence based on criteria in another column
 

My problem is probably very simple, but I CANNOT figure this out!
I have a spreadsheet where in column F is a list of values. What I need to
do is at each change in col F numerically sequence the groups in F with a
number in column A. The list is variable in length, the the groups can be 2
or more each. Below is an example of the finished product. I've attempted IF
stmts (I'm terrible at those), would like a macro or formula. Does this make
sense? Any help would be appreciated. Sometimes these journals run several
thousand lines, hundreds of groups.
A B C D E
F
Batch# Account Store RL Doc Value Line description
1 127100 1431000 (3,102.26) DO60858
1 127100 1431000 3,550.30 DO60858
1 (448.04) DO60858
2 127100 1431000 (2,871.34) DO60932
2 127100 1431000 2,869.20 DO60932
2 2.14 DO60932
3 127100 1431000 (919.45) DO60982
3 127100 1431000 908.37 DO60982
3 11.08 DO60982
4 127100 1431000 (1,741.78) DO61039
4 127100 1431000 1,720.78 DO61039
4 21.00 DO61039
5 127100 1431000 (240.39) DO61337
5 127100 1431000 238.16 DO61337
5 2.23 DO61337






--
DanaK

Add a number sequence based on criteria in another column
 

Try this...

Assuming data starts in F2.

Enter 1 in A2

Enter this formula in A3 and copy down as needed:

=(F3<F2)+A2

--
Biff
Microsoft Excel MVP


"DanaK" wrote in message
...
My problem is probably very simple, but I CANNOT figure this out!
I have a spreadsheet where in column F is a list of values. What I need to
do is at each change in col F numerically sequence the groups in F with a
number in column A. The list is variable in length, the the groups can be
2
or more each. Below is an example of the finished product. I've attempted
IF
stmts (I'm terrible at those), would like a macro or formula. Does this
make
sense? Any help would be appreciated. Sometimes these journals run several
thousand lines, hundreds of groups.
A B C D E
F
Batch# Account Store RL Doc Value Line description
1 127100 1431000 (3,102.26) DO60858
1 127100 1431000 3,550.30 DO60858
1 (448.04) DO60858
2 127100 1431000 (2,871.34) DO60932
2 127100 1431000 2,869.20 DO60932
2 2.14 DO60932
3 127100 1431000 (919.45) DO60982
3 127100 1431000 908.37 DO60982
3 11.08 DO60982
4 127100 1431000 (1,741.78) DO61039
4 127100 1431000 1,720.78 DO61039
4 21.00 DO61039
5 127100 1431000 (240.39) DO61337
5 127100 1431000 238.16 DO61337
5 2.23 DO61337






--
DanaK

Add a number sequence based on criteria in another column
 

Ahhh....Worked perfectly! Thank you so much!
You guys make stumbling though this stuff so much easier!

--
DanaK


"T. Valko" wrote:

Try this...

Assuming data starts in F2.

Enter 1 in A2

Enter this formula in A3 and copy down as needed:

=(F3<F2)+A2

--
Biff
Microsoft Excel MVP


"DanaK" wrote in message
...
My problem is probably very simple, but I CANNOT figure this out!
I have a spreadsheet where in column F is a list of values. What I need to
do is at each change in col F numerically sequence the groups in F with a
number in column A. The list is variable in length, the the groups can be
2
or more each. Below is an example of the finished product. I've attempted
IF
stmts (I'm terrible at those), would like a macro or formula. Does this
make
sense? Any help would be appreciated. Sometimes these journals run several
thousand lines, hundreds of groups.
A B C D E
F
Batch# Account Store RL Doc Value Line description
1 127100 1431000 (3,102.26) DO60858
1 127100 1431000 3,550.30 DO60858
1 (448.04) DO60858
2 127100 1431000 (2,871.34) DO60932
2 127100 1431000 2,869.20 DO60932
2 2.14 DO60932
3 127100 1431000 (919.45) DO60982
3 127100 1431000 908.37 DO60982
3 11.08 DO60982
4 127100 1431000 (1,741.78) DO61039
4 127100 1431000 1,720.78 DO61039
4 21.00 DO61039
5 127100 1431000 (240.39) DO61337
5 127100 1431000 238.16 DO61337
5 2.23 DO61337






--
DanaK

Add a number sequence based on criteria in another column
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"DanaK" wrote in message
...
Ahhh....Worked perfectly! Thank you so much!
You guys make stumbling though this stuff so much easier!

--
DanaK


"T. Valko" wrote:

Try this...

Assuming data starts in F2.

Enter 1 in A2

Enter this formula in A3 and copy down as needed:

=(F3<F2)+A2

--
Biff
Microsoft Excel MVP


"DanaK" wrote in message
...
My problem is probably very simple, but I CANNOT figure this out!
I have a spreadsheet where in column F is a list of values. What I need
to
do is at each change in col F numerically sequence the groups in F with
a
number in column A. The list is variable in length, the the groups can
be
2
or more each. Below is an example of the finished product. I've
attempted
IF
stmts (I'm terrible at those), would like a macro or formula. Does this
make
sense? Any help would be appreciated. Sometimes these journals run
several
thousand lines, hundreds of groups.
A B C D E
F
Batch# Account Store RL Doc Value Line description
1 127100 1431000 (3,102.26) DO60858
1 127100 1431000 3,550.30 DO60858
1 (448.04) DO60858
2 127100 1431000 (2,871.34) DO60932
2 127100 1431000 2,869.20 DO60932
2 2.14 DO60932
3 127100 1431000 (919.45) DO60982
3 127100 1431000 908.37 DO60982
3 11.08 DO60982
4 127100 1431000 (1,741.78) DO61039
4 127100 1431000 1,720.78 DO61039
4 21.00 DO61039
5 127100 1431000 (240.39) DO61337
5 127100 1431000 238.16 DO61337
5 2.23 DO61337






--
DanaK