Forum Discussion
sivasrao
3 years agoHelper III
Assigned 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
3 years agoSolution Sage
In 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.
sivasrao
3 years agoHelper III
If 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.