Forum Discussion
sivasrao
Helper III
Helper IIIAssigned to Previous column
The below table has two columns. Event Target C 0 C 0 C 3 R 0 R 0 R 0 C 0 C 2 R 0 R 0 My requirement is Target Column. Target: The count of...
johnyip
Solution Sage
Solution SageIn this case, just merge the logic and B2 and C2 into E2. This will make the formula hard to read though, although it will create fewer columns.
And yes, you can get column D as easy as that, my mind's screwed up when dealing with the logics.
sivasraoHelper III
Helper IIIIf we have only two columns as I mentioned in the above reply,then what logic we can put to get the Target Column.
Please give that logic.