In the attached called msofficeforums50445 there are single-celled formulae in cells A1 of sheets a,b,& c.
In the attached file called msofficeforums50445pq theres a power query solution on each of those sheets, they need refreshing (like a pivot table) by clicking on Refresh All in the Queries & Connections section of the Data tab of the ribbon.
|