Forum Discussion
Solved
OFFICE 365 - Return last entered value based on multiple conditions
Greetings to the Forum! I kindly need your help with a formula in the attached spreadsheet. I'm using Office 365. In the "raw data" tab I have a data set with various types of information relat...
=IFERROR(INDEX('RAW DATA'!$G$1:$G$100,LARGE(IF((SUMMARY!A3='RAW DATA'!$C$1:$C$100)*('RAW DATA'!$E$1:$E$100="SERVICE")*('RAW DATA'!$F$1:$F$100="ENGINE"),ROW('RAW DATA'!$A$1:$A$100)),1)),"")You can try this formula if column A in sheet "RAW DATA" is always sorted in ascending order. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Guys, thank you so so much for your responses!
Solution was found, much appreciated
Solution was found, much appreciated