I have a sheet see enclosed.
What i want is two cols for the output.
Lotid and Percentage
So, for a given lotid i want to count =>
(number of No Errors)/ (number_of_errors + number_of_No_Errors)
Notice that in the file there are multiple entries for a given lotid. But what i want is as i said above
For a single lotid (so need to generate a unique list of lotids) count
(number of No Errors)/ (number_of_errors + number_of_No_Errors)
Last edited by welchs101; 06-02-2011 at 06:19 AM.
i used a technique from an earlier post that someone gave me and it works as well. see enclosed file.
One question i did have is how to get the unique list of lotids. What i did was use the advanced filter option to create a unique list. Is this the best most efficient way? This way is "manual".....is there a more "automatic method". If not thats ok.
here is the table with the percentages
If you want unique values then...
The sum is not necessary with the Countifs in this scenario
Last edited by jeffreybrown; 06-01-2011 at 11:05 PM.
HTH
Regards, Jeff
thanks!
Just curious how you came up with the unique list .........did you use the advanced filter option?
You're welcome and yes I used the advance filter.If you trun on the macro recorder and record those actions the recording gives some good code you can repeat over and over.
Here are a couple of options.
Please Login or Register to view this content.Please Login or Register to view this content.
thanks for the info! very helpful.
On another issue related to this post:
Why did I not have to use the "SUM" on this one and I do have to use the "SUM" on the other one? I am not sure when i would need it and when i would not.
Instead of me searching for it, could you post the formula you are referring too. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks