Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering by Term Digits
I'm a TL at an attorneys office and our vendor file numbers are in the
following format: VEN-0111223 I deal with large spreadsheets that I was manually splitting up and delegating to associates by filtering and giving myself major headaches (not to mention taking up most of my morning just giving them work. Thank you Tech department from hell). I'm in the process of trying to macro it out to where I come in and refresh the data with all of the new files for the day and have a macro split up their work into their specific portfolio assignments. The problem I'm running into is that I have associates assigned by client then by ODD and EVEN VEN numbers then further split by client. The client split is easy but identifying odd and even text/numeric fields is proving to be difficult. All of the formulas I found on the forum are for number fields only. I need to be able to take a spreadsheet full of VEN-0111223 and split them out by odd's and even's. I've used the =ISODD(C11) function but it only works on the loan number fields and their work is driven by the VEN numbers. Can anybody here help me out with this lovely task? I would be a very happy camper. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of digits in a cell | Excel Worksheet Functions | |||
data filtering based on last two digits of large number | Excel Worksheet Functions | |||
Mistery digits on excel | Excel Discussion (Misc queries) | |||
Filtering by digits | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |