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.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

I have added the link since you are a new member.

Just be patient, please - the query is now valid.

Whilst I understand that you may be in a bit of a panic, don't tell us that it is urgent, please. All your helpers here are volunteers giving freely of their own time: you haven't paid a penny for any assistance you get here, therefore expecting any form of speed response or preferential treatment, or seeming to, is inappropriate.

Thank you for your understanding. I have removed the urgency notice from your thread title.

Moderator