Does anyone know a formula that will provide the same function as the one I have listed below? This formula works perfect in Google Spreadsheets but I cannot find anything similar for Excel 2013. I need this formula to automatically populate certain cells based on information entered into another sheet that basically has the criteria that if there is a value in this area then that information needs to be populated with "this".
=FILTER(' TPT Calculations'!A6:A101, ' TPT Calculations'!D6:D101 > 0)
I have also attached the spreadsheet.
Thanks!
Dawn
Working Copy.xlsx
Bookmarks