If/Then formula to copy down a row of data

[misshelby]

Hi,

I'm trying to create a formula that will copy all data in a row down to a new row, only if a certain criteria is met (as in win/lose, yes/no etc), else a new line is created with no copied data.

The rows also need to be numbered. For example, if the certain criteria is met, then a new row is created, all data copied down and the first cell of the row is now row "2". However, if the criteria is not met, the new row has no copied data and the new row is now row "1" again (back to the start of the pattern, so to speak).

If anyone can provide help on this I'd really appreciate it!.

 

[ravishankar]

Hi
A little more info. would have been helpful
Assuming row 6 has data
slno, result, Amount
6, Win , $100
A7 = if(B6="win", A6+1,"") ie if b6 has win, 1 will be added to A6
C7 = "if(A6<> "", C6,"") ie if A6 is not blank it will copy C6
Try it
Ravi

6

 

[misshelby]

Thanks Ravi,

Will give it a go. I tried to give as much info as possible. Will try be more descriptive in future!

Thanks for the tip. Appreciate your help.

Shell.