how to find last column with value?

[wzhu717]

so i have data that runs till column 5 but that can be change every month, so sometimes can be in column 3 or column 4. i want it to capture the last column with any values.i need help. so i try to use the multi field formula and then do "iif (isempty([name]),1,0)" and find the last column however it returns everything false. i want it to know before F5 is true.i need help.

.

[CharlieS · Accepted solution]

In this case, I recommend Transposing your data so the last record can be identified in the records. The attached workflow provides an example of this.