Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to run a query in Excel?

user-image
Question added by Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)
Date Posted: 2013/06/04
Samy Abd Allah
by Samy Abd Allah , Country Security Manager , Thales Egypt

Dear,mike The UEST function is not supported in Microsoft Office Excel2007 because the Excel2002 Add-in Open Database Connectivity () is only supported in Excel2002 ...
but you can make the same function by using all kinds of filters.

solomon Birhanu
by solomon Birhanu , Sales Manager , M. F. D. R. of Ethiopia Ministry of Defense Bishoft Automotiv Industry

I have a table with columns like city, state, population, average income, average house price.
This table is constantly being updated and amended, with the new info tacked on at the end.
So for example, I might have (all numbers completely pulled out of my ass): Addis , WI,600000,40000,150000 Awasa, MT,30000,25000,100000 Gonger, IL,2000000,60000,200000 Mekele, WI,100000,50000,125000 assosa, IL,100000,40000,100000 I need to group the cities by state and calculate stuff like total population, average income and house price by state.
So I want to end up with WI,700000,45000,137500 IL,2100000,50000,150000 I'm familiar with Access but I can't use that for this project because the end user only has access to Excel (2007).
I understand SQL (mostly), but I don't know if it can be used in Excel and if it can, I don't know where to put it.
I don't know any other code well enough.
Please, if you have some magic line of code that will work, tell me exactly where to put it, because I won't know.

Mike Emerson Pasaron
by Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)

Solomon, nice try but I know where you took it and it does not answer the question.
How to return values, for example when i enter the employee no.
it will show all transactions made by the employee.
it is easy to make a lookup to return a single row but to return multiple rows, this is the problem.
we can try to filter, but values are dynamic so filter is not the best option.
As much as possible if it can be done without macros, please leave a reply.
A link to a site answering the question is also welcome.

More Questions Like This