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 ...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Hi Hans, yes here is a link to the drive , hopefully you can access it.
https://docs.google.com/spreadsheets/d/1FQzwYphLJoyJKlN-eWtEN1SFIMC625oY/edit?usp=sharing_eip_m&rtpof=true&sd=true&invite=CIaEsrIG&ts=6616f03d&sh=246TQy3ybM0tjNow&ca=1&exids=71471469,71471463
https://docs.google.com/spreadsheets/d/1FQzwYphLJoyJKlN-eWtEN1SFIMC625oY/edit?usp=sharing_eip_m&rtpof=true&sd=true&invite=CIaEsrIG&ts=6616f03d&sh=246TQy3ybM0tjNow&ca=1&exids=71471469,71471463
I can see the workbook, but downloading has been disabled, and copying as well, so I cannot do anything with it.
- 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.
