Register
Log In
Unanswered
Home
New Member
February 29, 2012
Offline
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?
Thank you,
November 8, 2013
Offline
Hi Arvind,
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)
Cheers,
Catalin
Most Users Ever Online: 57
Currently Online: Mynda Treacy
18 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
