PrashanthGM12345
Member
Hi..
I have 2 columns in the excel sheet (Column A and Column B)
Column A will contain 4 data (Major NC, Minor NC, Observation/Finding, OFI).
Column B will contain 2 Data (Current Previous).
I want a formula to calculate the number of
Number of:
* Current Major NC
* Current Minor NC
* Current Observation/Finding
* Current OFI
* Previous Major NC
* Previous Minor NC
* Previous Observation/Finding
* Previous OFI
How to do this? Please Guide me.
I have attached the file for Reference
I have 2 columns in the excel sheet (Column A and Column B)
Column A will contain 4 data (Major NC, Minor NC, Observation/Finding, OFI).
Column B will contain 2 Data (Current Previous).
I want a formula to calculate the number of
Number of:
* Current Major NC
* Current Minor NC
* Current Observation/Finding
* Current OFI
* Previous Major NC
* Previous Minor NC
* Previous Observation/Finding
* Previous OFI
How to do this? Please Guide me.
I have attached the file for Reference