G
Guest
Hi,
I have an array formula that gives me the results I am looking for...with
the exception of one type. Anytime the result has only 1 value, it duplicates
that same value infinitely to the end of my array. As I said, 2 or more
values populate perfectly, without duplication...but I can't seem to figure
out why a result of 1 repeats.
I thought perhaps I had actually been trimming the resultant row values off
by 1 initially, and thus whenever the result was 1 it was actually using 0,
which would default me to the "UDP" range length I have...but every other
value results perfectly. Any help or advice would be appreciated, as I'm lost
on this one.
Here is my array formula...naturally it does have the {} when it is entered.
Also...the range UDP is quite long, contains duplicate values, but the OFFSET
cell range does not contain duplicates.
=OFFSET(UDP,MATCH(U41,UDP,0)-1,-51,COUNTIF(UDP,U41),1)
Let me know if any other info would be helpful.
Thanks,
Steve
I have an array formula that gives me the results I am looking for...with
the exception of one type. Anytime the result has only 1 value, it duplicates
that same value infinitely to the end of my array. As I said, 2 or more
values populate perfectly, without duplication...but I can't seem to figure
out why a result of 1 repeats.
I thought perhaps I had actually been trimming the resultant row values off
by 1 initially, and thus whenever the result was 1 it was actually using 0,
which would default me to the "UDP" range length I have...but every other
value results perfectly. Any help or advice would be appreciated, as I'm lost
on this one.
Here is my array formula...naturally it does have the {} when it is entered.
Also...the range UDP is quite long, contains duplicate values, but the OFFSET
cell range does not contain duplicates.
=OFFSET(UDP,MATCH(U41,UDP,0)-1,-51,COUNTIF(UDP,U41),1)
Let me know if any other info would be helpful.
Thanks,
Steve