Related:
- How to insert specific number of rows at fixed intervals in excel
- Number to words in excel - Guide
- Insert gif in excel - Guide
- How to insert photo in word for resume - Guide
- How to insert check mark in word - Guide
- How to insert watermark in word - Guide
1 response
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
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