Posted to microsoft.public.excel.programming

external usenet poster

Posts: 11

Filtering from multiples and writing to new page

Hi,

I'm looking to filter a column which has multiples of the same string and
creating a definitive list on another worksheet. i.e.

Column A "data" sheet
bed
cog
dog
bed
dog
cog

So what I am looking to do is filter column A from row 2 to get a result of

Column A "summary" sheet
bed
cog
dog

The list isn't a set length long on "data" sheet so it needs to keep going
till it reaches a blank cell.

Regards

Ric

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DISPLAY IN MULTIPLES	Faraz A. Qureshi	Excel Discussion (Misc queries)	1	August 7th 09 09:47 AM
create overview page; lookup results from multiples worksheet	van0710	Excel Worksheet Functions	5	January 4th 09 06:05 PM
Pivot table page field filtering	murkaboris	Excel Discussion (Misc queries)	2	December 19th 08 01:47 AM
Pivot Table - Filtering Page Field	R. G. Ingersoll	Excel Discussion (Misc queries)	1	January 29th 05 07:29 PM
Multiples	[email protected]	Excel Programming	6	September 1st 03 12:23 AM

All times are GMT +1. The time now is 08:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us