The array formula I have will give me the smallest date from a Service table, based on the following criteria:
1) The value in the item column matches the item # in cell A1
2) The value in the amount column > 0
Adding "z" was the only way I could get it to exclude 0/FALSE, which would always claim itself as the smallest value. Is there a cleaner way to calculate this? It will be part of a more complex formula.