+ Reply to Thread
Results 1 to 3 of 3

I need to multiply the contents of a cell, in the same column for a fixed number of times.

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    4

    I need to multiply the contents of a cell, in the same column for a fixed number of times.

    Hi Guys!

    I am working now at a school project and I got a bit stuck. I was wondering if it is an easy way of doing this. Below you have an example of my data:

    Column A
    A
    A
    A
    A
    A
    A
    B
    B
    B
    C
    C
    C
    D
    D

    I want to multiply each value (these are names of companies) for exactly 24 times. I tried a few times myself and used a decreasing number and every time it hit 1 the function would have got the next value from the left and multiply it again 24 times. The only problem is that after some time the countdown missed some companies which obviously I do not want to happen. I am already trying to do this for about 4hr now and I do not know how what else should I try.

    I would really appreciate your time!
    Thank you!

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: I need to multiply the contents of a cell, in the same column for a fixed number of ti

    depending on which column they are in you can try this (assumes Col A) =INDEX($A$1:$A$1000,ROUNDUP(ROW(A1)/24,0)) then drag down (put in col B)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: I need to multiply the contents of a cell, in the same column for a fixed number of ti

    you can also do it this way if you don't want to use the limits in the other formula and they begin in row 1=INDEX(A:A,ROUNDUP(ROW(A1)/24,0))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Repeating a Text String a Fixed Number of Times
    By andrewc in forum Excel General
    Replies: 2
    Last Post: 10-21-2013, 09:51 AM
  2. [SOLVED] Fixed Cell Reference Minus a Fixed Number
    By juddykong in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2013, 03:25 PM
  3. [VBA] Multiply each cell of a column 5 times
    By Eldexoly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2011, 12:26 PM
  4. fixed column, row number from another cell
    By atabdd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-25-2007, 06:56 PM
  5. Multiply One Column Times Another Summed by Row
    By Mkren911 in forum Excel General
    Replies: 1
    Last Post: 03-03-2005, 08:24 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1