Forum Discussion
Split Dataset
Hello Tech Community, I want to be able to split a data set that I have. I want to split it evenly 50/50 but want a particular column to contain equal distributions in the splits. For instance thi...
Filter the first column and indclude the values less or equal to median. The second column imclude the values greater than or equal to median. Should split the lits into two simila columns.
=FILTER(D4:D7;C4:C7<=MEDIAN(C4:C7))
Where C4:C7 is your list 1 to 4.
- Geir