• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Array Formula

  • Thread starter Thread starter GB
  • Start date Start date
G

GB

Member
Hi,
in the attached file I have data in column B and C that I want to evaluate in columns D,E,F,G. I have manually entered four very simple formulas to evaluate the data but it is not a simple copy down to get the results I need, as you will see in the file if you F2 the formulas.

I want to turn these into an array formula so I don't have to evaluate each one individually.

Any help to get me going would be appreciated.
regards
GB
 

Attachments

Hi Somendra,
thank you, that gives me something to learn from. Appreciate your help.

regards
GB
 
You must log in or register to reply here.
Back
Top