Moiz Saifuddin
asked on
Filter count
I want a function in Excel that would filter according to the bold text content and another function to calculate the count of bold cells.
ASKER
formula is better
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
how do I get a count of those bolded cells, could u send me a sample excel sheet
have a look at attached, regards.
Book121.xls
Book121.xls
junholee
whyse !!! didn't know about GET.Cell function and assume that the 20 is for testing bold ?
one think you need to whatchout for is that this function is not volatile and if the format changes on any cell to bold it will not automatically trigger a true in your formula unless you press F9 enter in edit in any of the other cells in the workbook.
gowflow
whyse !!! didn't know about GET.Cell function and assume that the 20 is for testing bold ?
one think you need to whatchout for is that this function is not volatile and if the format changes on any cell to bold it will not automatically trigger a true in your formula unless you press F9 enter in edit in any of the other cells in the workbook.
gowflow
gowflow