counta if not strikethrough
I don't know if I need VBA for this solution and that's why I posted here first.
I've got a simple spreadsheet. Two of the columns containing text require counting but not if the text is strikethrough.
How can I exclude the strikethrough text from the cell count?
Thanks.
Mike
Strikethrough, bold, color, and any other kind of formatting is not data to Excel.
Add a column that controls the strikethrough formatting, and use that to control sums.
Entia non sunt multiplicanda sine necessitate
Or
Try this UDF
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
In Excel use the UDF like this…
Please Login or Register to view this content.
=NonStriked(A1:A9)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
That function, like any other, will not update when a cell is formatted to add or remove strikethrough.
You're swimming upstream with that approach.
With a bit of alteration that worked perfectly.
Thank youSixthsense
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks