Grouping data with VB script or function?

Z

Zakynthos

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Sendkeys be used to send a selected no. of characters in a sin 2
Converting time-formatted to text-based data 2
IF function 4
Calculate Count of Days & Average WHERE Amount <>0 1
Word Error Message: This file is corrupt and cannot be opened 1
UDF: Roots of 1D Polynomials of Degree N and Real or Complex Coeff 10
Function for week number 5
ArrayFunctions: How do I... ? 3

Top