Change an Array formula to a normal formula

**jolpool** · 12-12-2014, 12:41 PM

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;

Please Login or Register  to view this content.

Thanks for any help.

**Debraj Roy** · 12-12-2014, 12:55 PM

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..

**Kaper** · 12-12-2014, 01:09 PM

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.

Change an Array formula to a normal formula

LinkBack

Thread Tools

Rate This Thread

Display

Change an Array formula to a normal formula

Re: Change an Array formula to a normal formula

Re: Change an Array formula to a normal formula

Thread Information

Users Browsing this Thread

Similar Threads

VBA Code to Change Portion of Array Formula

[SOLVED] Array Formula Vs Normal Formula

[SOLVED] Variable Formula - both normal and array

[SOLVED] How can I change a # in an array formula for a whole column?

[SOLVED] Convert Normal formula to array formula

Bookmarks

Bookmarks

Posting Permissions