•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating list of unused table values
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]
Want to read more?
Check out the full article on the original site
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