Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Arranging columns
Suppose my excel sheet looks like this:
A 1 10 2 9 3 8 4 7 5 6 6 5 7 4 8 3 9 2 10 1 Now in B1 i want A10A9A8A7A6, i.e. 12345 then in B2 i want A5A4A3A2A1, i.e.678910. This is a simplified version of my problem. I have a column of 1000 numbers: - i want to take the first 5 numbers and arrange them in reverse order, - keep doing this for all the 1000 numbers in the column. How can i do this without manually performing the work? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |