I need to loop thru €œB1:B100€� to place a number in each cell in that range
following this criterion: in €œA1:A100€�, every time the value changes, I need
to count the total occurrences of that value and divide 1 by that number (of
occurrences) then place that result in each correspondent cell in column B
then move to the next unique value and do the same. Obviously the data in
column A is sorted in order to avoid duplicates.


Thanks in advance