Change an Array formula to a normal formula
Hi All,
I need to change the formula below from an array to a normal formula. The formula basically looking through a list and finding the next larger match.the formula i need to change is;
Thanks for any help.
Please Login or Register to view this content.
Hi jolpool!
Welcome tot he forum..
Did you tried DMAX formula.. its best in this scenario..
=DMAX(Data!$A$1:$E$9999,"HeaderInE1",Sheet1!T1:U2)
Where T1:U2 is helper column.. and like below..
Capture.JPG
If you are facing any challenges to adapt.. please upload a sample file.. for proper Fromula..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
use helper column. for instance column AA. In AA2 write:
Formula:
Please Login or Register to view this content.
copy down to row 36351 and your main formula can be now:
Formula:Please Login or Register to view this content.
which is exactly the same as
Formula:Please Login or Register to view this content.
Note that a benefit of array formula was, that you could easily copy it down. with non-array equivalent - you cannot do so.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks