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