![]() |
#1
|
|||
|
|||
![]()
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)), "") |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
bendmc | Excel | 2 | 11-17-2016 11:31 AM |
![]() |
SebastianG | Word | 3 | 01-01-2016 12:25 AM |
![]() |
babs1234 | Excel | 3 | 03-04-2015 06:08 AM |
![]() |
bobsone1 | Excel | 2 | 08-19-2014 12:12 AM |
IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |