Sorry sort of new to excel, but I'm looking for a way to input a formula into a column which multiply it by a sequence of numbers.Ex (column F) F8 Measurement*0 F9 Measurement*1 ......... all the way to 100. Hopefully there is a easier way to do this so I don't have to have a extra 2nd column. Sorry for any grammar issues, it's late at night.
F8:and drag down.Formula:
=Measurement * (ROW(A1)-1)
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks