| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort by even and odd digits and copy to separate worksheet
This is a second function to a prior question wherein we removed an alpha
character from the end of a number down the full length of a column. Now they want me to sort these data into even and odd numbers and copy them and their correspondending data to another worksheet. Is there a way to add these two functions to the following formula? =LEFT(A1,LEN(A1)-1)+0 You all are wonderful... I've been away from Excel for years and have forgotton even the basics of writing forumlas and macros. Back to the books ! Thanks so much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy each row from 1 Worksheet to separate Worksheets? | Excel Discussion (Misc queries) | |||
| Copy data automatically onto a separate worksheet | Excel Discussion (Misc queries) | |||
| Trying to truncate or separate the first 3 characters/digits of co | Excel Discussion (Misc queries) | |||
| What formula will sort data in a separate worksheet%3f | Excel Worksheet Functions | |||
| Sort by last 2 digits | Excel Worksheet Functions | |||
![K Drier[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
