Count Unique Values With Multiple Creteria.

I am looking for simple macros with an be amend in future to count unique values based on multiple criteria. I have other tables also. If anyone helps me I will get the idea and will manage to do other tables.

I have a list in worksheet named Data and a table in Calculation Result. Here are the details what I am requesting.

The scrip should look for Staff in column E and age below 65 years in column D for worksheet Data and count the values for match criteria and return the values in worksheet Calculation Result in cell B4. If the age is above then return the values in Cell E65. That’s how it goes.

Sample worksheet is attached with the result is attached for your reference.

have a review to attached workbook

u need Macro for this output , what happen that formula did not work ?

i will update macro for u dont wory just i need small clarifcation is it u will have only 6 relation only or it will increase

Mr. Naveed,

Please check this SCREENSHOT.

I have these tables which i need macros but if you do for 1 I will manage for others.

The classes will be fixed.

Hi,

ok i will get back to u with solution now i hv to go institute please don't mine anything.

Thanks - Naveed.

Thanks mike7952.

This is what i am looking. I have to work for other tables also if i have any problem i will get back to you or PM the new topic. Thanks for your valuable time.