Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I filter by term digits
I could really use some help with an excel function. Within my office, we work with several hundred files. Each employee is assigned files based on the last two digits of the file number. What I need is a way to identify what file is assigned to which employee based on the term digits of the file.
So for example, I have the following list of files: 1002856101 22781721 1044863815 1008799064 1044779765 1006511115 1007641804 0729939256 5303486020 8364709 0014094759 0019921519 8172717 Employee A works all files ending 00 - 49, and employee B works all files ending 50 - 99. Is there a formula that I can run that would identify which files belong to which employee? Btw, most of our file numbers are 10 digits long. But that's not always the case. I don't know if that makes a difference, but I wanted to mention it. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
Filter 3 digits | Excel Discussion (Misc queries) | |||
Filtering by Term Digits | Excel Discussion (Misc queries) | |||
how can I set up a custom filter to ignore the last few digits | Excel Discussion (Misc queries) | |||
Filter/find/isolate one specific term? | Excel Worksheet Functions |