Forum Discussion
Need help with a formula
Hello, I am building a dynamic worksheet in which when I put the data in the master sheet (say Sheet1), then all the data in the sheet3 automatically populates and calculates the desired results. Si...
Two methods that spring to mind...
1) Add a new column which looks at the cell to the left under "Error Type" and put in a formula...
=If(cell to the left ="","",1)
Supervisor-3 total =COUNTIFS(supervisor column,"Supervisor-3",New column,1))
2) Create a Pivot Table, takes about 5 seconds.
N
1) Add a new column which looks at the cell to the left under "Error Type" and put in a formula...
=If(cell to the left ="","",1)
Supervisor-3 total =COUNTIFS(supervisor column,"Supervisor-3",New column,1))
2) Create a Pivot Table, takes about 5 seconds.
N