Flora Edwards
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$1 002>0,(MON TH(Sheet1! $C$3:$C$10 02)=Sheet1 !$G3)*Shee t1!$C$3:$C $1002))=Sh eet1!$C$3: $C$1002),S heet1!$D$3 :$D$1002)
=LOOKUP(2,1/(MIN(IF((MONTH
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.
If so, what are you actually trying to achieve? What is the problem with it?
Alan.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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 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
ASKER
Thanks byundt.
Wish you a very good weekend!
Wish you a very good weekend!
I cannot see the string CSE anywhere in there.
Maybe copy / paste again from a cell that does contain that?
Thanks,
Alan.