When I try to detect a grade that is followed by a * e.g. A* it sees this as a wild card and counts all values that contain A. In the example I have worked around this but I wondered if there is an actual way of detecting * grades directly without resorting to manipulation?
I have included a spreadsheet with data.
Many thanks if you are able to help.
If you want to do a search for text that includes wildcard characters, and you want to find the literal character, instead of using the action of the wildcard, then place a tilde "~" in front of the character.
e.g., to find "A*", search for "A~*"
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
This worked for me....
=COUNTIFS($AC$4:$AC$86,B$3,$AB$4:$AB$86,$A4)
in B4, copied down and across
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
should do it. It can be dragged to include cells that don't contain the * as it will return the cell value as it is if it doesn't contain a *.Formula:
Please Login or Register to view this content.
Victoria
Many thanks - this has sorted my problem.
Paul
Gak67
thanks for your reply. I will try this tomorrow.
Paul
FDibbins
Thanks for your reply. I will try this tomorrow.
Paul
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks