Exclude Duplicate/Repeating Values via Lookup or R...

[Dereck_Hoekstra]

I’m trying to roll up the smallest value from Table A into Table B that’s at least “1” or greater with MIN(values) rollup formula. The problem right now is some is table A has values of “0”, and I don’t want to return that number. Example below:

TABLE A
record #: 4
record #: 2
record #: 15
record #: 21
record #: 0

My formula returns the smallest number in table A, which technically is “0”, but I don’t want that number, and I’m trying to figure out a formula to exclude any value of 0 or less.