Need to look up values per X and Y axis. I'm thinking an index formula would work, but I'm not sure.
I've attached an example. Any help would be greatly appreciate!
Need to look up values per X and Y axis. I'm thinking an index formula would work, but I'm not sure.
I've attached an example. Any help would be greatly appreciate!
Can't see your example, but it would help if you attached a sample Excel workbook.
To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Don't try to use the Paperclip icon, as it doesn't work on this forum.
Hope this helps.
Pete
UseFormula: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...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks