Forum Discussion
Which excel formula?
I have a customer list. name, address, state, area code. all those on sheet 1. I am trying to spread my customer list across other sheets I have created separated by area code. I feel like the if for...
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.