Collating Payroll

Closed
snuffs - Aug 23, 2010 at 07:30 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Aug 24, 2010 at 08:28 AM
Hello,

I'm looking for a formula to analyse a payroll spreadsheet. On the spreadsheet there are a number of names and then it lists a breakdown of what their pay is being made up of (PAYE/NI/SSP etc).

Now these people make up 4 teams between them - so what I want to do is search the column with all the employees names in and if it finds a certain name - pull a value from that row. I would need the foruma to search for multiple names and then add up all the values from a set column.

The difficulty is that the same people will not be paid each month - so the payroll export could look different from month to month. This could possibly create a problem whereby if for example you seached for the name 'JANE' (which was found in row 6) is would pick up the value in H6 - the next month however is 'JANE' was found in row 5 - it would need to pick up the value H5. So the formula would not pick up set cells, but depending on the row the search value is found it would take a value a number of cells along - i.e be flexible.

As an Example (Very Basic)

--------A---------B
1------JANE ----10
2------DAVE----10
3------JOHN----10
4------TOM------5

Team 1 is made up of Jane and John - so the foruma needs to search from A1:A4 for those names, and if found add the values of 1 cell along together.

Thank you in advance for your help.










1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 24, 2010 at 08:28 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0