Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Filter
Is there any way that in Data Filter to have only the alphabet? So when you
click on the arrow and the little screen pops up and shows everything, is there any way that it only shows A to Z. That way if you click on A only the company's that start with A will show up and so forth? |
#2
|
|||
|
|||
Data Filter
Maybe you could add another column:
=left(a2,1) and drag down. then filter by that column. Jenn wrote: Is there any way that in Data Filter to have only the alphabet? So when you click on the arrow and the little screen pops up and shows everything, is there any way that it only shows A to Z. That way if you click on A only the company's that start with A will show up and so forth? -- Dave Peterson |
#3
|
|||
|
|||
Data Filter
Thank you, now is there an easier way then doing it one by one. I have the
whole alphabet, and say 20 per letter, now is there a faster way to input the example: =left(b8) or do i have to do it one by one "Dave Peterson" wrote: Maybe you could add another column: =left(a2,1) and drag down. then filter by that column. Jenn wrote: Is there any way that in Data Filter to have only the alphabet? So when you click on the arrow and the little screen pops up and shows everything, is there any way that it only shows A to Z. That way if you click on A only the company's that start with A will show up and so forth? -- Dave Peterson |
#4
|
|||
|
|||
Data Filter
You can use the little autofill button on the selected cell outline (bottom
right corner) and drag it as far down the column as you need. Debra Dalgleish has some instructions with pictures at: http://contextures.com/xlDataEntry01.html#Mouse Jenn wrote: Thank you, now is there an easier way then doing it one by one. I have the whole alphabet, and say 20 per letter, now is there a faster way to input the example: =left(b8) or do i have to do it one by one "Dave Peterson" wrote: Maybe you could add another column: =left(a2,1) and drag down. then filter by that column. Jenn wrote: Is there any way that in Data Filter to have only the alphabet? So when you click on the arrow and the little screen pops up and shows everything, is there any way that it only shows A to Z. That way if you click on A only the company's that start with A will show up and so forth? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Pull data - Advance Filter | Excel Worksheet Functions | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) | |||
Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions |