Thread: Excel Experts
View Single Post
Old 11-15-2007, 03:09 AM  
BlueDesignStudios
Confirmed User
 
Industry Role:
Join Date: Feb 2003
Location: Australia
Posts: 9,492
that's not easy to code up in just one column C without use of a macro

I suggest you split a,b,c,c,d,e into separate columns, then use the COUNT() and FIND() functions to produce the output you need
__________________

Blue Design Studios - Adult Design Specialists!
Email me for a free quote: [email protected]
BlueDesignStudios is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote