I'm struggling to come up with a filter-like action/calculation below:
Bascially, the null in C-land group should return 2 as shown under Land Group. However, only 2 was shown for the complex code as coded in the syntax below.
How can I change the syntax below to make C-Land group return all 2s? Thank you!!
Any sample workbook can be shared?