I have this attached spread sheet and I am trying to finish it off.
The results come back with 2012 results but for some reason it misses the top result out.
Also I am looking to be able to change cell B2 so that it search from the appropriate worksheet and returns the results from that sheet.
Can any one help solve these last two problems?
Thanks
Last edited by trumpetman; 09-13-2013 at 11:17 AM.
I can't see any formulae or source data in your attachment. Not clear what your issue is.
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...
Sorry wrong sheet.
Attached to this post is the correct one.
In A6
Ctrl+Shift+Enter
Please Login or Register to view this content.
Copy down and across
Use INDIRECT instead of sheet reference to achieve your second task
Life's a spreadsheet, Excel!
Say thanks, Click *
Ace for that. I have tried that and it doesn't seem to work. I take it I should be pasting the code in the first work book?
did you enter that as an array?
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
FDibbins, Thanks for that. You were right about the just hitting enter.
When you say use INDIRECT for the second task, I don't fully understand, sorry.
FDibbins. The array works for all the item out of the drop box from Douglas Ward. However from Bryn and above for some reason it does return the top result from that section.
for the INDIRECT, change the formula to this...
Formula:
Please Login or Register to view this content.
and the file seems to work fine when I tested for bryn?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks