Count the times a name appears in a range and on a particular day

DezB · Apr 11th 2023

Hi

I need to count the number of times a name appears in a range and also on either the Tur or Fri. Also how many times in each month the name appears.

I've attached a sample workbook if that helps and would really appreciate any help please..

Kind regards.

DezB

name-test.xlsx

**alansidman** · Apr 11th 2023

If you normalize your data into rows instead of columns this can be easily achieved with a Pivot Table. With the current layout of data (non-normalized), it will take a bit of machinations.

**Carim** · Apr 12th 2023

Hi,

You can use Range Names ...

DezB · Apr 12th 2023

Hi Both

Thank you so much for the advice, very much appreciated as usual...

Kind regards

DezB

**Carim** · Apr 12th 2023

Thanks for the feedback !!!

Glad to hear the Forum could help you out

DezB · Apr 17th 2023

Hi Carim

This forum always helps me out, as it does countless others, it really is an amazing place to turn to thank you... Long may it continue...

Kind regards

DezB

Count the times a name appears in a range and on a particular day

Participate now!

Share

Similar Threads

Select Odd Rows from Named Range

VBA to add rows between dates and populate other columns

VBA Code that records previous value of changed cells in other cells impacts more cells at once than intended

Unique names in list of names

If dupplicate values found in column A - copy/paste range B:D of the dupplicates on the same row of the original value

Copy Area To Rows Using VBA

Users Viewing This Thread