Forum Discussion
fcbda
Jun 02, 2021Copper Contributor
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...
Hogstad_Raadgivning
Jun 02, 2021Steel Contributor
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