Hi Max,

Here is the link: http://www.flypicture.com?display=updone&id=r9jxm6zZ

The "1101-6156" is the master sheet and the "PCA" and "KAB" are the
individual employee sheets. This is only a sample of the actual spreadsheet,
due to confidentiality, I couldn't post the full spreadsheet. The master
sheet will probably not look like that because I don't think the formula will
work with the current view.

I would still love to know how you came up with the formula so I can explain
it to my department and to know for future use.

Thanks in advance for all your help!!!




"Max" wrote:

Perhaps a better way, Victoria ..

Could you upload a small, sanitized sample of your actual file,
and paste the link to it in reply here ?

Just provide 2 key sheets in the sample will do:
The "master"** sheet and a typical "individual" sheet
**what is named as sheet: Z in my sample

I'll help to set it up to suit and provide the link back to it here.
(the detailed explanations can come later, if still required)

You could use either of these 2 free n easy-to-use filehosts
to upload your sample:

http://www.flypicture.com/
http://cjoint.com/index.php

For cjoint.com (it's in French), just click "Browse" button,
navigate to your folder select the sample file Open,
then click the button centred in the page below
(labelled "Creer le lien Cjoint") and it'll generate the link.
Then just copy & paste the generated link as part
and parcel of your response here.

Kindly note that no attachments should be
posted *directly* to the newsgroup
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik