Thread: Linking Rows?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jambun@bigpond.com is offline
external usenet poster
 
Posts: 28
Default Linking Rows?

Martin. Not sure what you mean, how or where do I number the rows or
change the numbers that are already there
ps I can overcome my problem by transposing the information from each
row to another sheet by using the formular =IF(A1=0,A2,A1) and then
doing the countback sequence in this new sheet,and will do this if
necessary
Thanks EPJ

On Tue, 13 May 2008 03:38:09 -0700, Martin Fishlock
wrote:

Hello Jambun:

One method is to number the rows as pairs for example
T1 Fred 10 10 2 3
T1 Tom 5 2 3 1
T2 Sally
T2 June....

or use

1.1 Fred 10 10 2 3
1.2 Tom 5 2 3 1
2.1 Sally
2.2 June....

May work and is the easiest method. That is unless any one else knows
otherwise.