Rhon Alvarez
Member
Hi Team,
may i seek an assistance with regards to the attached file;
I need to tag each row as "rolled over", "new case" or "handled" accordingly.
these were 2 sets of data; comparison of data produced every two hours
the latest hour contains columns B to E while the previous hour contains only column B to properly segregate each sets
categories for tagging were:
1.) Duplicate Entries on Column B are to be tagged as "rolled over" only on the Latest Hour
2.) Remaining Data (not duplicate) from latest hour are to be tagged "new case"
3.) Remaining Data (not duplicate) from previous hour are to be tagged "handled"
please find attached file and should there a need for clarification, i am more than willing to cooperate.
Thanks in advance,
Rhon
may i seek an assistance with regards to the attached file;
I need to tag each row as "rolled over", "new case" or "handled" accordingly.
these were 2 sets of data; comparison of data produced every two hours
the latest hour contains columns B to E while the previous hour contains only column B to properly segregate each sets
categories for tagging were:
1.) Duplicate Entries on Column B are to be tagged as "rolled over" only on the Latest Hour
2.) Remaining Data (not duplicate) from latest hour are to be tagged "new case"
3.) Remaining Data (not duplicate) from previous hour are to be tagged "handled"
please find attached file and should there a need for clarification, i am more than willing to cooperate.
Thanks in advance,
Rhon