see the link for the best way to get the most out of the forums Getting Started in the Forums
without more information in the form of your TWBX workbook I can only point you toward a couple of calcualtions
first look into Contains
you would use that in a conditional If ... Then ... end statement to get you rcount
then consider a table calculation like Percent of total
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Any Data, because without that we may prepare some other dish which would be of no use to you. Please attach something fake.
Apologies, getting used to the forum here.
Here's a list of sample data. I'm going for the "% of CustID with Home"
CustId InvId Item 1 1 Home 1 2 Home # of Home Counts 5 2 3 Life # of Unique CustID for Home 4 3 4 Auto # of Unique CustID 6 3 5 Home % of CustID with Home 67% 4 6 Home 4 7 Auto 5 8 Auto 5 9 Life 5 10 Home 6 11 Life
This is beautiful! You are a saint.
Quick question, what could I change if I wanted it to contain "home" and not be a strict match to "home?"
Can you post some example data again
CustId InvId Item 1 1 Home 1 2 Home # of Home Counts 5 2 3 Life # of Unique CustID for Home 4 3 4 Auto # of Unique CustID 6 3 5 Home % of CustID with Home 67% 4 6 Homeowner 4 7 Auto 5 8 Auto 5 9 Life 5 10 Homeowners 6 11 Life
Just using the above data but changing the name to Home, Homeowner, and Homeowners. I would like it to count in item that contains the word "Home"
Same Formula will work for this. Try it and once you get the Result Please Close The Thread by Marking my Reply as Helpful and CORRECT to Close Thread.