Forum Discussion
Solved
Second to last non blank value in an array?
I have a chart with employees and reporting relationships and am trying to do some analysis by the VP of each department. My data looks like this: Department Employee First Manager Seco...
Could try a big nested if, something like:
if([fourth manager]=null,(similar logic checking the third manager),third manager)
It'll look at each column in turn, and when it finds one that isn't blank, returns the previous column
jthomson
Solution Sage
Solution SageCould try a big nested if, something like:
if([fourth manager]=null,(similar logic checking the third manager),third manager)
It'll look at each column in turn, and when it finds one that isn't blank, returns the previous column