Finding values considering multiple conditions

Occasional Contributor

Hi! I need a formula for this situation. I extracted a small fragment here and uploaded the excel Thank you!!!

There are Ids repeated according to other columns, so I need the STD value that considers the first 3 columns.



3 Replies


In E2 as an array formula confirmed with Ctrl+Shift+Enter:




If your data have more than 1000 rows, adjust the number 1000 in the formula.

Fill down.

@Hans Vogelaar Thank you! Unfortunately its not working. Did you try it and worked? It looks perfect, but it does not work in my case


Most probably formula was entered without CSE. I modified a bit what @Hans Vogelaar suggested to use as regular formula