LOOKUP and Filter Based on Combined Condition

2019-12-11 14_32_32-LOOKUP and FILTER BASED ON COMBINED CONDITION - Reply to Topic.png

i dont know why i cannot attach excel sheet. its not going to pop out window to upload.

please help

2019-12-11 14_32_32-LOOKUP and FILTER BASED ON COMBINED CONDITION - Reply to Topic.png

pop out window is not opening when i click the attachment.

can any one help.

Hello friends,

Please find excel sheet in which i need formula and function to filter the data as mentioned in the tags. repeating once again my requirments.

1. filter date & time, active and radiation data which are between radiation 200 to 1000
2. filter date &time, active and radiation data which are below ambient temperature 40 Deg C
3. filter date & time, active and radiation data which are not having negative active power data(Ex. -35)