Hi Excel Experts,
As per available readings data for different machines (Mch Code) , it consist of duplicates (more than 2 readings records per machines) for some machines. However, for analysis or efficiency calculation purpose, we want to keep it a single reading line per machine (Mch Code) basis following criteria...
1. Firstly , 1st Reading is to be matched
2. Secondly,
a. In case of similar 1st Reading in multiple rows for similar machine (Mch Code) with IDENTICAL 1st Date (date & time), it should be considered ANY one row.
b. In case of similar 1st Reading in multiple rows for similar machine (Mch Code) with DIFFERENT 1st Date (date & time), it should be considered a row with SMALLEST 1st Date (date & time)
c. In case of similar 1st Reading in single row for similar machine, same row is to be considered.
d. In case of 1st Reading is NOT MATCHING for specific machine, error message is to be appeared i.e. 1st Reading not appearing in (not matching with) available data.
Please ref. to attached file for details
At present we do this exercise manually (remembering above criterion), How to get this working with automatic formulas or VBA in Excel, help in this issue would be great! THANKS IN ADVANCE.
Ravi
Bookmarks