Excel Data Consolidation and Organization
Budget: $30 – $250 USD
I have a spreadsheet that requires data consolidation from 2 other ones. The spreadsheet called "All Credentialed CPP and Guidestone" has a tab called "required only". Columns AK, AL, AM, AQ, and AR need data from the "Life and Health Census" and "Census Data" spreadsheets.
Column AL should populate "Yes" if the individual in question is found on the "Census Data" sheet.
Column AM should populate years of service data from the "Census Data" sheet
Column AQ should populate "Yes" if the individual is on the "Life and Health Census" sheet with "MED" in the Medical plan column.
Column AR should populate "Yes" if the individual is on the "Life and Health Census" sheet with "LTD" in the LTD plan column.
Column AL should populate "Yes" if the individual in question is found on the "Census Data" sheet.
Column AM should populate years of service data from the "Census Data" sheet
Column AQ should populate "Yes" if the individual is on the "Life and Health Census" sheet with "MED" in the Medical plan column.
Column AR should populate "Yes" if the individual is on the "Life and Health Census" sheet with "LTD" in the LTD plan column.