I have a project that i'm working on at work but i cant seem to get it working right.
I'v got 9 values (BLUE) that will be filled by the "program user", it will contain 1 to 3 unique values.
I want these 1 to 3 unique values to be called up in 3 new cells (RED) in order (smaller to bigger).
What is the equation to write in these 3 cells??
I'v got 9 values (BLUE) that will be filled by the "program user", it will contain 1 to 3 unique values.
I want these 1 to 3 unique values to be called up in 3 new cells (RED) in order (smaller to bigger).
What is the equation to write in these 3 cells??
V1 | V2 | V3 | V4 | V5 | V6 | V7 | V8 | V9 | Unique 1 | Unique 2 | Unique 3 |
a | b | c | c | a | b | b | a | a | a | b | c |