Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
SELECT Query
Hi
I am looking for a way of simulates a Access SELECT query in Excel. I have a worksheet that contains multiple instances of different peoples names. This worksheet is generated on a weekly basis and the names change, new ones added, other not appearing etc. What I am looking for is something along the lines of "SELECT DISTINCT name FROM worksheet" and add these name to a seperate work sheet. I have not got access to MS Access which would have made this easier to do. I would like to try and do this if possible without the need to use Excel VBA, but if it is the only way so be it. Any help appreciated. Thanks TJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel MS Query multiple select statements | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) |