Search : in
By :

Repeating formula in a specific number of row

Last answer on Jul 13, 2009 1:02:46 pm BST CP007, on Jul 9, 2009 3:28:58 pm BST 
 Report this message to moderators

Hello,
I'm trying to develop a formula that will repeat a result in a specific number of rows. For example, if there was a number "2" in A2 and a "45" in H2, I would like the number 45 to populate twice in the same column in two different rows (for example column J, rows 3 and 4). How can that be done with excel formulas?

Configuration: Windows XP
Firefox 3.0.11

Best answers for « Repeating formula in a specific number of row » in :
Re-adjusting the size of an image in pixels ShowRe-adjusting the size of an image in pixels IF you want to adjust an image, according to a specific number of pixels. You can use the Paint.NET software to achieve this manipulation. Link: http://www.getpaint.net/ After installing the...
How to change XP Serial/License number ShowHow to change XP Serial/License number Go to / Start Menu/ Run/ Type regedit and click OK. Before any operation in the registry, he should make a backup of the registry as a precaution In the Registry Editor, click File...
SERIAL NUMBER- Trend Micro PC CILLIN ShowSERIAL NUMBER- Trend Micro PC CILLIN Explanation How to replace your old serial number by the new one? Explanation Go to registry by Menu Start > Run and type REGEDIT and click on “OK”. In the open window under « My computer...
Download Random Number Generator Pro ShowRandom Number Generator Pro is a tool that generates a list of random numbers based on customizable criteria. You can choose the minimum and maximum limits and incrementing numbers. Limits can be positive or negative values. Advantage The...
Download A-PDF Number ShowDescription The application is designed by A-PDF.com. Simple and easy to use, the application is completely FREE! A-PDF Number is tool that allows you to add or create the page numbers in PDF files. The application allows you to create documents...
Download Random Number Generator Pro ShowRandom Number Generator Pro is a very simple tool to generate a random number list. There are several combinations and you can define the randomization criteria. You simply select the lower and upper limits as well as the number increments and the...
Specifications ShowInterest of specifications "Specifications" refer to a contractual document describing what is expectd of the contractor by the client. It is a document that describes, as precisely as possible, in simple terms, the needs that the contractor must...
Ask your question Reply

1

 Trowa, on Jul 13, 2009 1:02:46 pm BST

Hi CP007,

If you are going to put the result in J3 and below use this formula in J3:
=ALS($A$2>=1;$H$2;"")
Now copy the formula down depending on how big your number in A2 can become.
If A2 cannot be bigger then 10; copy the formula down till J12.
Add 1 to the 1 in the formula for each cell you go down.
So In J4 the formula will be:
=ALS($A$2>=2;$H$2;"")
In J5:
=ALS($A$2>=3;$H$2;"")

If the number in A2 is something like 100, this way can be a lot of work.
Use a free column and type 1 in the top cell and 2 in the cell below,
select the two cells and drag them down till you have 100.
If your free column is L, change the formula into this:
=ALS($A$2>=L1;$H$2;"")
Drag the formula down 100 cells and you are done.
You can hide column L for a clean look.


Let me know if this solution works for you.

Best regards,
Trowa

   
Reply to Trowa
Ask your question Reply
They need your help