Guys can anyone tell me how I adjust the formula to get the second smallest value, instead of the smallest?
thanks guys![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Code:
=MIN(query20044964!$D$7, query20044964!$D$10, query20044964!$D$13, query20044964!$D$16)
thanks guys