Hi Peo,

When I posted and said your Formula worked, it does Fill Down but as soon as
my file is re-calculated it does not keep the sorted data together, it
reverts to its original position before I sorted. Whereas, my original
Formula did keep all the cells of data that belonged to a certain Row
together when sorted (but I manually changed the Row references on each Row
when I used INDIRECT in the Formula).

Further assistance appreciated.

Cheers,
Sam

Peo Sjoblom wrote:
This will increment if filled down while staying the same if you insert rows
above, assume you want to put it in row 4 and want 1 and copied down to row
5 it will return 2 and so on,

=ROW()-ROW($C$4)+1

assume your formula is in B2 then you can replace the indirect part with

=TEXT(ROW()-ROW($B$2)+1,"00 ")&TEXT(ROW()-ROW($B$2)+2," 00")

Hi All,

[quoted text clipped - 12 lines]
Thanks
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200511/1