Forum Discussion
Pulling in data from a separate spreadsheet
Hi!I’m trying to determine how to pull in data from another spreadsheet and am stumped. One the spreadsheet I’m working on I have a field I need to populate with number of employees ny dept I’d and j...
If you have the most current version of Excel, you should be able to use the FILTER function. I use that to get data from a separate sheet, and you can use multiple criteria to screen (i.e. FILTER) which rows. Then just nest it in a COUNT or COUNTA function.
You do need the most current version of Excel, however.
Here are some helper resources for that function: https://exceljet.net/excel-functions/excel-filter-function
https://www.youtube.com/watch?v=9I9DtFOVPIg