excelexcel-formulaworksheet-functionexcel-2011
Set Pass/fail based on 10 answers from each of many individuals
I'm trying to output a Pass/Fail indicator for each student. A new student is on every row and their 10 answers are logged from Column E to N.
I want to match their answers with the 10 correct answers in Column S to AB, count them, and then have the word Pass show in the results Column O if they have a 70% pass rate, and fail if they are under that 70%.
All help appreciated.
Solution
I'd suggest a separate row for the answers but in matching columns:
then something like:
=IF(SUMPRODUCT(--(E$1:N$1=E3:N3))>6,"Pass","fail")
As @Jeeped points out, the correct answers could be left where they are with only a small adjustment to the formula above but (apart from the lurid colours!) I think the layout shown is neater and possibly more useful.
- Partial value font color in red using vba
- VBA to manually position an Excel pivot when AutoSort is blocked
- Count the value of the current stock in excel
- Extract time from a date time string in excel
- Easy way to export multiple data.frame to multiple Excel worksheets
- Is it possible for HYPERLINK to spill friendly names?
- Loop inside loop. Stop second loop if condition is met
- Using TEXTJOIN to display table values of numbers within certain criteria
- How to Save DataFrame to Excel file using filedialog as SaveAs-Dialog in Python?
- Excel MS365: 2-D dynamic array creation problem
- Search the latest saved PDF file in a various folders and copy the latest one to a specific location
- How do I get all the different unique combinations of 3 columns using VBA in Excel?
- Worksheet names in VBE
- Excel macro to identify 0 crossing of the value
- Format Multienumeration Data for Pivot Table
- VBA Characters.Delete string over 255 characters
- Using Excel, return 1 for all values >0 WITHOUT using an IF
- How can I convert text in a cell to a sequence of ascii code values with a separator in Excel 2016 or LibreOffice?
- How do you copy and paste entire row of source sheet to destination when a date appears in specific column?
- Excel Chart title will not accept a date concatonated to a string
- Calculate average of both the columns and rows using VBA
- Automatically shows date and time in VBA on multiple columns
- filter out multiple criteria using excel vba
- Convert Excel Column Number to Column Name in Matlab
- Consolidate and sum values based on multiple conditions VBA
- Excel number format to only show decimals when necessary
- How to Merge Rows values into a Column on a prior Row?
- Sumif times (datetime format) are greater than 22:30
- Private Sub for hiding worksheets based on cell value "View" / "Hidden"
- Power Query Filtered Rows based on value