Hi friends,

I have below excel file, in this file I have USD statement of account table. But cumming all details. Please check and advice me formula changes.

Please check Row 24, 25. I want 24 only, I mention it in formula, but 25th row coming,

Main thing is H OR I columns have any values then cell value come other wise no need. Have some date (B) and company name(C) conditions.

IFERROR(INDEX($A$5:$N$7, SMALL(IF(AND(OR(($I$5:$I$7)<>0, ($H$5:$H$7)<>0), ($B$5:$B$7>=$G$15), ($B$5:$B$7<=$G$16), ($C$5:$C$7=$A$15)), ROW($A$5:$A$7)-ROW($A$5)+1, ROW($A$5:$A$7)-ROW($A$5)+1), ROWS($A$23:$A24)), MATCH(D$19, $A$2:$N$2, 0)), "")

Attached Files

Book2.xlsx (62.9 KB, 11 views)