rajeshn_in
01-09-2017, 01:01 AM
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 comming
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)), "")
17970
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 comming
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)), "")
17970