Ok firstly in your responses (assuming there are any!) please consider
me a retard at least that way I'll be more familiar with the terminlogy
and formulae used. This is going to be a pain to explain as I cant use
tables on this forum it seems so forgive the formatting :P

Also bear in mind im operating off a very locked system and I have no
net access there and a very cut down version of excel so I dont have
access to plugins or some of the more advanced functions only available
on custom installs.

In excel how can I count a specific set of values and have it return
them:

so there would be a user entry box, enter a name and it looks up all
the data associated with that name (which would be amount of accounts
opened in this case and accounts w/c opened both of which are simple
numbers which would add up across a few worksheets representing days of
the week.)

The spreadsheet setup is currently this

Worksheets:

Sunday, monday, etc etc, saturday

on each worksheet is this topline below which a few 100 odd spaces
ready for the data that I input.

Accounts

WW LIN CW HOM F&B ACC MEN COS CS NAME

Accs w/c

WW LIN CW HOM F&B ACC MEN COS CS

All of this is in the same line on the sheet and the only useful
information under each is a simple "1" this is the only value that
appears in these columns apart from obviously the name of the person.
There is always a "1" in one of the columns if a name is also entered,
these are entered by me from the data im working off, it nice and
simply means NAME has opened 1 account the next box along is acc w/c
and doesnt always have a value in, but if it does then that value will
always match the same header in "accounts" and will also be a "1"

So what I'd want is nice and simply say I want to look up name "blah"
then it will list

account acc w/c
blah 2 1

for example and it would list that if it found 2 accounts opened as
well as 1 acc w/c for that name.

More ideally I'd like a permanant output based of all the worksheets
which lists EVERYONE found and exactly how many accounts and acc w/c
are attributed to them.

sorry thats all a bit of longwinded way of explaining, this is all
probably laughably easy to do but I would be very grateful if someone
could help as this would save me soooooo much time.

thanks!


--
dave99
------------------------------------------------------------------------
dave99's Profile: http://www.excelforum.com/member.php...o&userid=30221
View this thread: http://www.excelforum.com/showthread...hreadid=498989