LinkBack URL
About LinkBacks
What are you trying to achieve with this part:
Formula:
IF(ISERROR(SUBSTITUTE(F16," ","")*SEARCH("@JT",G67))
Do you want to return "@SUBCON" if G67 contains "@JT" and F16 is a number? As that is how it is currently evaluating...
What are you trying to achieve with this part:
Formula:IF(ISERROR(SUBSTITUTE(F16," ","")*SEARCH("@JT",G67))
Do you want to return "@SUBCON" if G67 contains "@JT" and F16 is a number? As that is how it is currently evaluating...
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks