Counting number of Times a number appears and depending on how many other numbers in the cell it receives a value.

[daltendavis]

For Example I would paste a list of values in A1 reading:

048 - 909
048 - 841
153
*014 - 022
879 - 719 - 102 On Sheet 2 I need it to read: A B 909 .5 153 1 048 1 841 .5 879 .33 719 .33 102 .33 <tbody> </tbody> Each Cell represents a Truck and the values a store. So if there are 3 values in a cell they would receive .33 or a third of said Truck. If 2 values .5 or a half if a single value 1 and so on. There will never be over 5 values in a single cell.​

<colgroup><col></colgroup><tbody>
</tbody>

This has drove me nuts and I have tried everything I can think of

Thank you for any and all help

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...tiple-numbers-them-using-vba.html#post5094451

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).