ExcelBanter - Groups of numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Groups of numbers (https://www.excelbanter.com/excel-worksheet-functions/69197-groups-numbers.html)

evanr

Groups of numbers

I want take a column of numbers and split them equally into two other
columns that are as equal in value as possible.

Elkar

Groups of numbers

Maybe I'm not understanding your question, but would dividing by 2 work?

If your original value is in cell A1, then enter this formula in both B1 and
C1.

=A1/2

HTH,
Elkar

"evanr" wrote:

I want take a column of numbers and split them equally into two other
columns that are as equal in value as possible.

All times are GMT +1. The time now is 11:15 PM.