none
Power Query with data from excel cells? RRS feed

  • Question

  • I have a power query table and I want to multiply all the numbers in the last column by a number a have in a excel cell. Is that possible?
    Friday, December 26, 2014 12:23 PM

Answers

  • Yes. If you make the Excel cell a named range, you can select it and click "From Table" to get it into PQ-land. You should then be able to reference it in your other query in order to multiply all the numbers in the last column by the value in the Excel cell.

    Ehren

    Wednesday, October 28, 2015 10:26 PM
    Owner