Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-09-2017, 01:17 AM
rajeshn_in rajeshn_in is offline Formula working wrong, I can't identify why. Windows 10 Formula working wrong, I can't identify why. Office 2016
Novice
Formula working wrong, I can't identify why.
 
Join Date: Nov 2016
Posts: 3
rajeshn_in is on a distinguished road
Default Formula working wrong, I can't identify why.

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
File Type: xlsx Book2.xlsx (62.9 KB, 11 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula working wrong, I can't identify why. Conditional formatting not working with simple formula bendmc Excel 2 11-17-2016 11:31 AM
Formula working wrong, I can't identify why. Word does not show wrong words (but spelling checker is actually working) SebastianG Word 3 01-01-2016 12:25 AM
Formula working wrong, I can't identify why. VLOOKUP Formula is not working babs1234 Excel 3 03-04-2015 06:08 AM
Formula working wrong, I can't identify why. Formula returns wrong value bobsone1 Excel 2 08-19-2014 12:12 AM
IF formula returns wrong result mashley Excel 3 09-07-2012 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft