Good Morning,
I'm trying to create a spreadsheet that is a bit difficult for me.
The first sheet titled db is a database of all the information to pull from. Columns D-F will have keywords that if on the main report you type one in, I need it to list the first 3 columns associated with it.
I've attached a sample of spreadsheet. Is this possible to do in excel?
In A2, enter:
Copy across / down.Formula:
Please Login or Register to view this content.
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...
Olly, this worked perfect! You are a GENIUS! Thank you very much as I cannot begin to explain to you how much time this will save me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks