Hi all,
Hope all are doing good and ready for the Christmas
Just some help in attached sheet.
1. In sheet Confirmation Form, cell E17 shows count of values entered from cell E19. However, since E19 onwards there's a formula entered and E17 also counts it where as it shouldn't. So cell E17 should show count as 14 instead of 37.
2. Cell E15 should contain a formula such that if all "present" values in column E starting from cell E19 matches exactly with that of values either in column B or column E of sheet " Decommissioning Request Form" starting from cell B59 or E59, then this cell should show "SERIAL NUMBERS MATCH", else "SERIAL NUMBERS MIS-MATCH".
The reason for either column B or E is that if values in column B are in below form
01003669937919751725043010CJ9U2119753447591903
then formula =IF(B59="","",RIGHT(B59,LEN(B59)-22)) will be applied in cell E59 onwards.
If values in column B are in below form
19753447591903
then there is no requirement of formula in column E.
Hence comparison with either B or E.
3. Cell C13 in sheet "Confirmation Form" contains a formula which should shows as FORM COMPLETE if below conditions are fulfilled.
a> If cells C5, C6, C8, C9. C11, C12 are not blank.
b> If cell C14 in sheet " Decommissioning Request Form" is "Partial Batch Decommissioning", then ,cell C15 in sheet "Confirmation Form" should be "QUANTITY MATCH"
c> If cell C14 in sheet " Decommissioning Request Form" is "Full Batch Decommissioning with Rework", then cell D17 in sheet "Confirmation Form" should not be 0.
I have entered the conditions from cell G4 to G7 but it somehow doesn't work.
Can someone please help?
Bookmarks