Login Page - Create Account

Support Board


Date/Time: Sat, 30 Nov 2024 04:44:29 +0000



Post From: SMALL() function example usage

[2022-12-23 21:53:58]
User562383 - Posts: 10
I appreciate the response, but that does not answer my question. How do I input an array of 4 cells into the first argument of the small command without using the ":" syntax. The cells I want to select are not next to each other.

This works "=small(B3:B6,2)" But how would I rewrite it inputting each cell separately eg "=small([B3,B4,B5,B6],2)"