•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating list of unused table values
Our take
In the quest to create a comprehensive report template for auditors, it's essential to identify which criteria have passed without instances of failure. By leveraging a formula to compare the full table of criteria against the dropdown selections on the results sheet, you can effectively list those criteria that remain unused. While COUNTIF is useful for counting occurrences, you’ll need a different approach to extract and display the criteria that did not appear in any of the results, ensuring a complete overview of performance.
I have a report template in which auditors report failures of a list of criteria. Each criteria may fail multiple times, but some may not fail at all. The template has a sheet with a table of criteria, and the results sheet uses dropdowns driven by that table. I've been tasked with adding a list of "passed criteria" to the report, and so I'm looking for a formula that would compare the criteria chosen in the dropdown with the full table, and would list those not appearing on the results sheet.
I know I can use COUNTIF to count instances of a value, but I need to list unused values.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#financial modeling with spreadsheets#Excel alternatives for data analysis#rows.com#natural language processing for spreadsheets#AI formula generation techniques#generative AI for data analysis#Excel compatibility#AI-driven spreadsheet solutions#formula generator#Excel alternatives#unused table values#criteria#list unused values#passed criteria#report template#auditors report#formula#results sheet#dropdowns#list of criteria