C
chris.howes
each week i get a report that contains site id,site name, failure wha
i need to do is create a spreadsheet that looks at all the previou
weeks data and compares the siteid, and then looks at the failure fo
all the previous weeks and highlights any differences.
at present i use vlookup to get a list of the failures for each sit
id for each week but can not get it to compare the current week wit
previous weeks eg 1 & 2 to give me any differences
this is going to be a rolling report so in he end will have upto 5
weeks of data to compare
thnx in advanc
i need to do is create a spreadsheet that looks at all the previou
weeks data and compares the siteid, and then looks at the failure fo
all the previous weeks and highlights any differences.
at present i use vlookup to get a list of the failures for each sit
id for each week but can not get it to compare the current week wit
previous weeks eg 1 & 2 to give me any differences
this is going to be a rolling report so in he end will have upto 5
weeks of data to compare
thnx in advanc