Hello,
I'm running into an interesting problem when I go to make a nested formula with 2 UDF's. I get a #VALUE error even though it seems like everything is evaluating correctly.
Quick Description:
Zcut: removes 0's from array
test: grabs max
For example:
=test(zcut(TRANSPOSE((IF($A5=lkup,clicks,0)))))
When I evaluate with F9:
=test(zcut(TRANSPOSE((IF($A5=lkup,clicks,0)))))
=test({735,691,688,778,651,644,609,704,708,612,616,509,620})
=test(zcut(TRANSPOSE((IF($A5=lkup,clicks,0)))))
=778
I'm not sure what's going on. Is it possible that the "test" is trying to run before the "zcut"? I'm confused, and would really appreciate any help.
Thanks!
Ghrain22
I'm running into an interesting problem when I go to make a nested formula with 2 UDF's. I get a #VALUE error even though it seems like everything is evaluating correctly.
Quick Description:
Zcut: removes 0's from array
test: grabs max
For example:
=test(zcut(TRANSPOSE((IF($A5=lkup,clicks,0)))))
When I evaluate with F9:
=test(zcut(TRANSPOSE((IF($A5=lkup,clicks,0)))))
=test({735,691,688,778,651,644,609,704,708,612,616,509,620})
=test(zcut(TRANSPOSE((IF($A5=lkup,clicks,0)))))
=778
I'm not sure what's going on. Is it possible that the "test" is trying to run before the "zcut"? I'm confused, and would really appreciate any help.
Thanks!
Ghrain22
Last edited: