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
|