• 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.

Something Wrong with Array Formula

sachar

Member
Dear All,

With reference to the attached sample file, May I know what is the wrong with following an array formula, it doesn’t change the cell address automatically which highlighted with red colour.

upload_2017-4-20_16-27-45.png

Please help me?
 

Attachments

  • Complimentary Summary_wrong in array formula.xlsx
    19.6 KB · Views: 4
Hi,

(Most likely) That is because you selected the entire range when inputting the formula... instead, input the formula into "A3" and complete with Ctrl+Shift+Enter... then drag down and across.

See attached
 

Attachments

  • Complimentary Summary_wrong in array formula.xlsx
    20.5 KB · Views: 12
Back
Top