Excel – How to assign rows in multiples of a number (Excel/Google Docs)

google docsmicrosoft excelworksheet-function

For example, I want the first entry in Column B (B1) to show A5, then B2 shows A10, then B3 shows A15.

How would I go about doing this?

Best Answer

For excel you can put this in B1 and drag down


To start with A5 instead of A1, use this

Related Question