Forum Discussion
Which excel formula?
mathetes I can do everything I need to do with the filter function I am just trying to have a formula to do the majority for me. I have 4000 customers spread out over 30 area codes. I have heavy busy time in spring and winter. I ame trying to break up the customers by area codes to keep my techs in close areas. When it comes that time I can look at my sheet and see who is in what area I need to call.
I can do everything I need to do with the filter function I am just trying to have a formula to do the majority for me.
Did you click on the link I gave to the FILTER function? It is not the filter capability from the tool bar, but is a function that is incorporated into formulas. That was the whole point. Much more effective than the IF function that you referred to. But it requires Excel 2021 or newer.
- Did not notice that and I will have to see what year it is when I get back to my shop
Here too is a YouTube video that served as my own introduction to the FILTER function, along with several others. It may give you a visual clue as to why it could be useful in your situation.
- And yes my excel is way out of date but I do thank you for the videos I will still watch them