How to repeat cell value x times in Excel?

Hi,

I am looking to copy multiple cells by a specific number. In the formula found below it finds A1 and copies it by B1. I am looking for it to look at A1,B1,C1 and copy the amount in D1. Could anyone please assist in this?(I know it is probably simple and I am not see it).

I have found this link which helped with the formula. Linkl

Formula used:

Please Login or Register  to view this content.

Thank you in advance for your help.

Hi there... and welcome to the Excel Forum. I don't quite understand what you want.... Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon

Oh dear. I'm still baffled. Have you shown us the "before" or the "after" picture??? We need to see what you HAVE and a sample (manually calculated) of what you WANT to see.

Is something like this what you're looking for...

https://www.excelforum.com/showthread.php?t=926616