Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Using Query In Excel Formula
Name: danmeier Date: March 20, 2009 at 11:58:47 Pacific OS: Windows Vista Subcategory: Microsoft Office
Comment:
I have created an Excel query in Office 2007 to return a specific set of values from within a named range in my spreadsheet (for example, the 6PM temperature from all days in March from a range containing 6PM temperatures over many years). I want to use the Percentile function to return 80th percentile 6PM temperature for March using the Excel query I created as the Range argument in the Percentile formula. However, the Percentile formula doesn't seem to recognize the query (although it does recognize named ranges within my worksheet...). Can I use the output of an Excel query as an Excel formula argument?
Summary: This formula will return the Tab Name of the sheet it is used in. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1))) Modifying the A1 refe...
Summary: unfortunately I don't know how to use VBA so I couldn't solve the problem, I tried writing down the function found in the web site in the VBA software of excel but afterwards I wasn't able to use it i...
Summary: Many thanks, Bryco. I never used macro in Excell, so it's totaly new for me, but as soon as I understand (and read carefuly your explanations) I will try it. I downloaded the file so you can delete it...
