Howdy folks. Here is the problem.
Three columns of data labeled Tract, Block and Lot.
What the Data to display as follows:
T#B#L# when each column has data
B#L# when there is only data in columns the Block and Lot columns
L# when there data only in the Lot Column
As you can see below, I have an IF statement that does this fine.
Where I would like some help is the next step where the combined output will only put information for the columns that apply such as:
T#L# when there is just data in the Tract and Lot columns, or
T#B# when there is only data in the Tract and Block Columns
I figure it is one more IF statement but I'm getting lost
As a bonus I'd love to know how to do it in VBA as well.
Three columns of data labeled Tract, Block and Lot.
What the Data to display as follows:
T#B#L# when each column has data
B#L# when there is only data in columns the Block and Lot columns
L# when there data only in the Lot Column
As you can see below, I have an IF statement that does this fine.
Where I would like some help is the next step where the combined output will only put information for the columns that apply such as:
T#L# when there is just data in the Tract and Lot columns, or
T#B# when there is only data in the Tract and Block Columns
I figure it is one more IF statement but I'm getting lost
As a bonus I'd love to know how to do it in VBA as well.
