it does, thanks.
On Tue, Feb 19, 2013 at 10:06 PM, Brian Barker <[email protected]>wrote: > At 20:04 19/02/2013 -0700, John Meyer wrote: > >> I'm doing QA in my office and I have a sheet filled with Employee IDs and >> a simple pass/fail score, like so: >> >> EmpID Pass/Fail >> 111111 Pass >> 111112 Pass >> 111111 Fail >> 111113 Fail >> >> What I want to do, is in a separate area of the sheet, have the following: >> >> EmpID % >> 111111 50 >> 111112 100 >> 111113 0 >> >> Where percentage is a ratio of the number of passes vs the number of all >> scored results. >> >> I have a column of all possible IDs. My question is would it be easier >> to do this via a VLOOKUP or a Data Pilot. Either way is okay as long as I >> can get the results. >> > > I'd use neither, I think. Suppose your data above is in columns A, B, and > C. In D2, enter: > =SUMPRODUCT(A$2:A$5=C2;B$2:B$**5="Pass")/COUNTIF(A$2:A$5;C2) > and fill this down the column. > > With this version, you will need to format column D as Percent. If you > preferred, you could add *100 to the formula and format the column as > Number. > > I trust this helps. > > Brian Barker > > > -- > For unsubscribe instructions e-mail to: [email protected].** > org <users%[email protected]> > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
