Hello,

I have a list of items as shown below:

A .5
B
B .25
B .25
C
C 1

If a given letter has a value assigned to it, all of the instances of that
letter will have the same value. For example, all of the B's that have
values assigned all share the same value of .25 But the first B doesn't have
a value. (The reason for this is that there is another variable column that
adds another dimension, but I just simplied the problem here.)

I would like to be able to return that shared value, but I am having
difficulty doing so. I tried the Match command to pick out the row number to
incorporate it into other functions, but it only picks out the first
instance. This won't work because in some cases, the first instance is a
blank which returns a zero. I want to return the non-zero value.

Any suggestions?