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:[TABLE="width: 144"]
<colgroup><col></colgroup><tbody>[TR]
[TD]048 - 909[/TD]
[/TR]
[TR]
[TD]048 - 841[/TD]
[/TR]
[TR]
[TD]153[/TD]
[/TR]
[TR]
[TD]*014 - 022[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]879 - 719 - 102

On Sheet 2 I need it to read:
A B
[TABLE="width: 50"]
<tbody>[TR]
[TD]909[/TD]
[TD].5[/TD]
[/TR]
[TR]
[TD]153[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]048[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]841[/TD]
[TD].5[/TD]
[/TR]
[TR]
[TD]879[/TD]
[TD].33[/TD]
[/TR]
[TR]
[TD]719[/TD]
[TD].33[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD].33[/TD]
[/TR]
</tbody>[/TABLE]

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.​

[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]
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).