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 job code. I have this data on another spreadsheet, but it is calculated using a COUNTIF formula. I’m not sure how to pull this data in, as it has more dept I’d/job code then the sheet I’m working on. Any help is appreciated!
1 Reply
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
