skip blank cells

as attachment...

Hi,

I hope this solution can help.

see attached amendment.

Cheers

Tony

thanks TonyB51,
it's really helpful.
this is what i want.

another problem...

Hi again,

I have amended the lookup by adding a second column for the counts.

See what you think.

Cheers

Tony

thanks again...

hello everybody,
this is another problem but same type...
sample is as attachment, tq.