Posted to microsoft.public.excel.programming

Zakynthos

external usenet poster

Posts: 115

Grouping data with VB script or function?

I have this data in cell b3: S,M etc representing days of week:

FT NR 36 S (8h-16h), M (8h-16h),Tu (8h-16h30),W (8h-16h30),Th (8h-16h),F
(8h-16h) Sa (8h-16h30)

I would like a script/function that will group the identical time values in
the following way:

FT NR 36 S,M,Th,F (8h-16h),Tu,W,Sa (8h-16h30)

Thanks for any advice

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Need a Function for Grouping	Ingus Smith	New Users to Excel	3	February 16th 09 08:15 PM
DATE SCRIPT / add function col A,	Nastech	Excel Discussion (Misc queries)	2	September 24th 08 04:56 AM
Function for grouping range of data	supersonikk	Excel Worksheet Functions	1	July 16th 08 02:49 AM
VB Script Code needed for Grouping Rows	Abhi_Rise	Excel Discussion (Misc queries)	0	February 19th 08 02:01 PM
VBA to VBA Script Function	Danny Young[_2_]	Excel Programming	7	October 22nd 06 03:12 PM

All times are GMT +1. The time now is 05:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us