Forum Discussion
VLOOKUP WITH COUNTIF AND RANGE
I have an excel sheet that has several employee names for a 90 day period, it will show how many minutes late they were each day for 90 days. on another sheet i have their names pre filled and need ...
try now, i updated the settings
Like HansVogelaar I can see it, but not download or copy. Seeing it, though, makes me think that a formula using COUNT and FILTER would work, assuming you have a current enough version of Excel so that FILTER works. This video should be sufficient to show you how to write the FILTER function to get the rows that meet your criteria.