Fill series - very urgent

[thiag.siva]

Hi

I want to fill series in this format in excel 2007

<table style="border-collapse: collapse; width: 48pt;" border="0" cellpadding="0" cellspacing="0" width="64"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" align="right" width="64" height="20">1</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">1</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">2</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">2</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">2</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">3</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">3</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">3</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">4</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">4</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">4


</td> </tr> </tbody></table>How do I do this?

 

[Joe4]

Welcome to the Board!

I don't know if you can use FILL to do this, but you can use a formula to do it:, i.e.

=INT((ROW()-current row number)/3)+1

So if you are starting on row 1, it would look like:
=INT((ROW()-1)/3)+1

If you are starting on row 6, it would look like:
=INT((ROW()-6)/3)+1

Then just copy down for all your rows.

 

[thiag.siva]

Thanks for the reply.

I tried the formula. It just gives me 'FALSE' as the output.. can you show it with an example?

 

[Joe4]

Can you tell me which row you have entered your formula in, and post the exact formula, as you have it entered in that cell?

 

[lenze]

You must have copied it wrong. Joe's formula works quite well!!
lenze

 

[thiag.siva]

Sorry Joe.. I entered that formula in the wrong cell. It works fine. Thank you very much

 

[thiag.siva]

But what if I want to start from some other number instead of 1.

say for example.. i want it this way

45
45
45
46
46
46
47
47
47

 

[thiag.siva]

sorry again. I figured that out. changed '1'to '45'

 

[Joe4]

The last number is the number you want to start counting from:
=INT((ROW()-current row number)/3)+starting number

So, just use:
=INT((ROW()-current row number)/3)+45

If you still need help adapting it to work, I need you to provide the specifics, namely:
1. what row you are starting this fill series in;
2. what number you want to start counting from

 

[Joe4]

I see you figured it out and posted while I was typing (what can I say, I am a slow typist!). I'll leave the detailed explanation out there for others who might encounter the same question.