LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Matz
 
Posts: n/a
Default Sort function or macro for the first 4 letters

If i have several rows with product data is there a way to get it to search
for hits simular to the first 4 letters ? then of course sumit up to 1 result.

for exampel:
the data sheet:

21 units 200$ candyliqurish
50 units 200$ candyfudge
20 units 300$ candylollypop

the result sheet:

91 units 700$ candy*****

this forum i sthe best !!

thanks to all competent people !

best regards Matz
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How to enable the sort function for a protected sheet lkjing Excel Discussion (Misc queries) 1 June 30th 05 01:18 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
Using a MACRO to sort data BAM718 Excel Worksheet Functions 5 April 16th 05 01:40 PM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM
Data > Sort function amnesia? Dave D Excel Discussion (Misc queries) 1 November 29th 04 10:44 PM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"