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