I have a workbook ( actually several) with multiple, similar worksheets. I need to give a total row count (for each sheet) based on values found in two columns.
The values in Column F will either be 'Yes' or 'No'. The values in Column K will either be 'Absent' or 'Changed'.
I need to find the total rows where:
Col F = 'Yes' and Col K = 'Absent'
Col F = 'Yes' and Col K = 'Changed'
Col F = 'No' and Col K = 'Absent'
Col F = 'No' and Col K = 'Changed'
The number of rows in each sheet will vary.
Any assistance in pointing me in the right direction will be appreciated.
Ed Judge
The values in Column F will either be 'Yes' or 'No'. The values in Column K will either be 'Absent' or 'Changed'.
I need to find the total rows where:
Col F = 'Yes' and Col K = 'Absent'
Col F = 'Yes' and Col K = 'Changed'
Col F = 'No' and Col K = 'Absent'
Col F = 'No' and Col K = 'Changed'
The number of rows in each sheet will vary.
Any assistance in pointing me in the right direction will be appreciated.
Ed Judge