Hello everyone,
I have a question...it seems like it might be kinda tricky.
Here are my field names:
LastName, FirstName, Company, True/False
So, I have a list of contacts at various companies, and under the T/F field I have FALSE if the person NO LONGER works there and TRUE if the person DOES work there. I'm trying to delete contacts in my database according to the percentage of people that no longer work there.
So, what I want to calculate is for each UNIQUE company name, whether ALL the contacts return FALSE in the T/F field (i.e. none of my contacts are correct), 50% or less return FALSE or more than 50% return FALSE.
How can this be achieved???
The formula =COUNTIF($B$2:$B$844,B2)
will say how many contacts I have for each company, and it works SO LONG AS 2 adjacent companies do not have the SAME number of contacts.
once I have the # of contacts for each company, I need to sum up the TRUE/FALSE values and divide by the total in order to obtain a % of people still there. But how do I take the number of contacts for the company, perhaps obtained by the COUNTIF function, and then search THAT NUMBER of places down in the T/F field in order to get the correct number to divide into the total?
Thanks for your help!!!!
I have a question...it seems like it might be kinda tricky.
Here are my field names:
LastName, FirstName, Company, True/False
So, I have a list of contacts at various companies, and under the T/F field I have FALSE if the person NO LONGER works there and TRUE if the person DOES work there. I'm trying to delete contacts in my database according to the percentage of people that no longer work there.
So, what I want to calculate is for each UNIQUE company name, whether ALL the contacts return FALSE in the T/F field (i.e. none of my contacts are correct), 50% or less return FALSE or more than 50% return FALSE.
How can this be achieved???
The formula =COUNTIF($B$2:$B$844,B2)
will say how many contacts I have for each company, and it works SO LONG AS 2 adjacent companies do not have the SAME number of contacts.
once I have the # of contacts for each company, I need to sum up the TRUE/FALSE values and divide by the total in order to obtain a % of people still there. But how do I take the number of contacts for the company, perhaps obtained by the COUNTIF function, and then search THAT NUMBER of places down in the T/F field in order to get the correct number to divide into the total?
Thanks for your help!!!!
Last edited: