How to extract names from a list

ArviLaanemets · #2 06-05-2018, 10:52 AM

1. Copy the column with names into separate worksheet. Use Remove Duplicates on copied list.

2. Create a Pivot table to count names. Copy names from Pivot table to another location. Or simply use this Pivot whenever you need the Vendor count (you can set filters for Pivot too - e.g. by dates)

3. On another worksheet, create an ODBC query like

Code:

SELECT DISTINCT VendorNames From YourTable

where YourTable is your Excel table, and VendorNames the column with names in it.
or

Code:

SELECT VendorNames, Count VendorNames From YourTable GROUP BY VendorNames

You can set the query to be refreshed on Open, and you can refresh it manually whenever you want (right-click on query table, and select Refresh from dropdown menu).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
List bookmark names in word doc	Hdata	Word VBA	2	04-11-2015 05:03 AM
Need to extract two word domains from a list (BULK)	Maxwell314	Excel	3	12-08-2014 06:17 PM
Need to extract domain names containing only specific words (MAJOR BULK)	Maxwell314	Excel	4	12-08-2014 05:10 PM
Right Click menu list names	jimbassett	Word	0	02-25-2013 02:39 PM
Random names from a given list	professor snape	Excel	1	06-06-2009 09:39 AM