February 29, 2012
I had one query in using the IF as explained in the Blog. After loading the attached excel file comprising sales number using Power Query, if Column 1 has contents (Text and numbers both i.e. Store name at the beginning followed by numbers and again store name followed by numbers) and if we want to fill only text below it wherever the numbers are present until you reach a text. I tried using t[Image Can Not Be Found]he above guidelines, but could not. Could you please guide?
November 8, 2013
Try this formula in a new custom column:
if (try Number.From([Column3]) otherwise "Text") ="Text" then "Text Found" else null
You can replace "Text Found" with [Column3] if you want to return the text found.
(columns 1 and 2 are empty, I assume you are referring to column 3 instead of column 1 in your description)
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
John Ryan Kivela
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas