Hi,
I have also been using google spreadsheet for a while.I am pretty impressed by Query function for e.g-
=Query (Range,"select B,D,K sum (E) where M='Power' order by B",1)
Is such type available in Power Query or somewhere in MS Excel.
Hi,
I have also been using google spreadsheet for a while.I am pretty impressed by Query function for e.g-
=Query (Range,"select B,D,K sum (E) where M='Power' order by B",1)
Is such type available in Power Query or somewhere in MS Excel.
Please clarify: is this a Google Sheets query?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please answer my question.
Yes, Mam.I don't know whether similar is available in ms excel or not.
Google Sheets questions belong in the Other Platforms section. Thread moved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks