Survey analysis

Moderator's note: Cross-posted at https://www.mrexcel.com/board/thread...lysis.1237864/

Hi,

Requirement for column "D":

Check for the same "Area code" in column "A"

If only single area code in the "A" Column then result in column "D" should come "No records for comparison"

If there are 2 same area codes then in column "D" against 1st area code result should come as "1st Visit" then for 2nd area code result should come as difference of population for 2nd survey compared to 1st survey date.

If more than 2 surveys for same area code then for 1st area code result should come as "1st visit", against 2nd no. of area code difference of population as compared to last survey date, against 3rd no. of area code difference of population as compared to 2nd survey date.

Same above process should get replicated for multiple entries.

Requirement for column "E":

Check for the same "Area code" in column "A"

If only single area code in the "A" Column then result in column "E" should come "No records for comparison"

If there are 2 same area codes then in column "E" against 1st area code result should come as "1st Visit" then for 2nd area code result should come as difference of days in dates of surveys subtracting no. of holidays during that period referring holiday list.

If more than 2 surveys for same area code then for 1st area code result should come as "1st visit", against 2nd no. of area code difference of days in dates of surveys subtracting no. of holidays during that period referring holiday list, against 3rd no. of area code difference of days in dates of surveys subtracting no. of holidays during that period referring holiday list as compared to last survey date.

Same above process should get replicated for multiple entries.