| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| How to sum top 5 numbers from the column of numbers | Excel Discussion (Misc queries) | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
| formatting numbers | Excel Worksheet Functions | |||
Linear Mode
