Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting and Filtering by font
Microsoft should create a sort feature that allows you to filter out certain
fonts or sort fonts in a certain order. A filter would be much better, It could be seperate from the filter that they have now. It should be a completely seperate function that way you can still filter the column info and also filter out other info in the same column, like font. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting and Filtering by font
Hi ____.
The word you are trying to use is separate. Actually I'm rather curious why you would want to sort on the font name. You could use a User Defined Function to obtain the font name. I don't think you are going to have much luck with your question as worded even over a number of years because that is a user defined function or as subroutine kind of thing. Font http://www.mvps.org/dmcritchie/excel/font.htm Show FORMULA or FORMAT of another cell http://www.mvps.org/dmcritchie/excel...tm#getfontname Function getFontName(cell As Range) As String getFontName = cell.Font.Name 'D.McR formula.htm End Function Instructions to install a macro or a user defined function in http://www.mvps.org/dmcritchie/excel/getstarted.htm To use if in same workbook =GetFontName(A1) To use if if your personal.xls workbook for use in other workbooks =personal.xls!GetFontName(A1) Use of your actual name in a technical newsgroup would be appreciated by people taking the time to answer your question. We are a friendly group. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "drob77777" wrote... Microsoft should create a sort feature that allows you to filter out certain fonts or sort fonts in a certain order. A filter would be much better, It could be seperate from the filter that they have now. It should be a completely seperate function that way you can still filter the column info and also filter out other info in the same column, like font. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting & Filtering in Shared Workbook mixing up data | Excel Worksheet Functions | |||
sorting and filtering | Excel Worksheet Functions | |||
Excel should allow sorting and filtering based on cell color. | Excel Worksheet Functions | |||
HELP! Filtering and sorting lists. | Excel Worksheet Functions | |||
Sorting and filtering | Excel Worksheet Functions |