Link to home
Start Free TrialLog in
Avatar of Flora Edwards
Flora EdwardsFlag for Sweden

asked on

How to remove the requirement of CSE in this formula

How do I change this formula, so that it does not require array-entry (the keystroke of CSE).

=LOOKUP(2,1/(MIN(IF((MONTH(Sheet1!$C$3:$C$1002)=Sheet1!$G3)*Sheet1!$C$3:$C$1002>0,(MONTH(Sheet1!$C$3:$C$1002)=Sheet1!$G3)*Sheet1!$C$3:$C$1002))=Sheet1!$C$3:$C$1002),Sheet1!$D$3:$D$1002)
Avatar of Alan
Alan
Flag of New Zealand image

Hi,

I cannot see the string CSE anywhere in there.

Maybe copy / paste again from a cell that does contain that?

Thanks,

Alan.
Are you trying to ask how to convert it from an array formula?

If so, what are you actually trying to achieve?  What is the problem with it?

Alan.
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Flora Edwards

ASKER

byundt,  you are truly a genius!  I almost believed that it is impossible but you really surprised me.

Thanks a Million.  You did it even without the actual sample workbook. thanks again.
Flora,
Thanks for the kind words!

It took me a while to figure out what the original formula was trying to do. You might have gotten an answer sooner (before I got involved) had you offered an explanation.

Brad
Thanks byundt.

Wish you a very good weekend!