Excel 2007 : User defined search and calculate

[PunterHunter]

Hi All,

Please forgive me if this is the wrong forum but I need some help from some Guru's..

I want to add a search box/ cell on a spreadsheet that the user can define the variable in. The function would then be to check a range of cells (which I would designate) for the varriable the user has entered, calculate the number of times the variable is found within the cell range and then present the answer. To make this a little more easier to understand.. I have a spreadsheet setup based on an audit tool I use at work. Part of the data is the initials of staff involved in aspects of the audit data - I would like to be able to search for a set of initials e.g. PT, across a cell range and then be told how many times PT has been found.

I have some understanding of how functions work but no VBA or MACRO expereince.. Any help or advice greatly appreciated.

Thanks.

[arthurbr]

Hi and welcome to the board

Without seeing your data, at first glance a COUNTIF function might suffice where the user enters is value in a cell somewhere

Maybe post a sample sheet of your data

[PunterHunter]

Hi Arthurbr, have attached sheet with similar data to that which I'm susing -

hope this helps..

[arthurbr]

Is this what you want? (see attached)

I created a list of staff members on sheet 2 and a validation in A12

[PunterHunter]

Arthurbr,

Thank you!!

So simple now I see it - thats why you're a Guru and I'm a pleb. Greatly appreciated.