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.
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.
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.