Results 1 to 3 of 3

Trick to multiply an array without an array formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2005
    Posts
    81

    Trick to multiply an array without an array formula

    Hi, back again asking for help. I need to lean a worksheet of all array formulas and I don't know how to "translate" this one.

    {PRODUCT(alfa+a1:z1)}
    where alfa is a cell. This formula appears everywhere and alfa is always different so I cannot simply create a row with the argument of the PRODUCT formula for I would have to create a lot of rows. Of course the array formula works beautifully but as I said I need to remove them all (if it is manageble)

    Is there any trick which would do the job ?

    thanks a lot for any suggestion

    Paolo
    Last edited by kayard; 12-16-2010 at 05:08 AM.

Thread Information

Users Browsing this Thread

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

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