Hello There,
I would like to have a Function in VBA which can return the occurence of a given value for the below situation:
1. Data is filtered
2. Search for a value in a given range and count it's occurence (in the filtered area, visible rows only)
Parameters for the Function would be:
1. Range
2. Search value
I have attached a sample workbook for your reference.
Look forward to hearing from you.
Regards,
Don
I would like to have a Function in VBA which can return the occurence of a given value for the below situation:
1. Data is filtered
2. Search for a value in a given range and count it's occurence (in the filtered area, visible rows only)
Parameters for the Function would be:
1. Range
2. Search value
I have attached a sample workbook for your reference.
Look forward to hearing from you.
Regards,
Don