M
Mercian
Hello all,
I have a spreadsheet project I need to complete for a spreadsheet with
multiple worksheets (13 in total, 1 per month and a results page). Each of
the monthly worksheets will contain the same type of data but this data will
vary in quantity. it is for an IT support desk to calculate the number of
times a certain field is populated for each person. Column's A, B & C are
the same data in both worksheets.
Worksheet 1
Column A Column B Column C
Person 1 Field 1 Trigger
Worksheet 2
Column A Column B Column C
Person 1 Field 1 Trigger
Using the data from Worksheet 2 how can I work out in Worksheet 1 how many
'Field 1' and 'Trigger' entries there were for 'Person 1'? Worksheet may
contain tens of thousands of rows with thousands of entries per person but
there should only be one entry for each person on Worksheet 1.
Thanks in advance,
A.
I have a spreadsheet project I need to complete for a spreadsheet with
multiple worksheets (13 in total, 1 per month and a results page). Each of
the monthly worksheets will contain the same type of data but this data will
vary in quantity. it is for an IT support desk to calculate the number of
times a certain field is populated for each person. Column's A, B & C are
the same data in both worksheets.
Worksheet 1
Column A Column B Column C
Person 1 Field 1 Trigger
Worksheet 2
Column A Column B Column C
Person 1 Field 1 Trigger
Using the data from Worksheet 2 how can I work out in Worksheet 1 how many
'Field 1' and 'Trigger' entries there were for 'Person 1'? Worksheet may
contain tens of thousands of rows with thousands of entries per person but
there should only be one entry for each person on Worksheet 1.
Thanks in advance,
A.