Digita
12-03-2007, 10:51 PM
Hi guys,
I'm a bit stuck in writing an array formula to return multiple values for unique entries (A, B & C) from a dynamic list in columns A & B :banghead: . I couldn't find an answer in this forum so I need someone's help.
I attach an example file for your viewing. I have manually input the answer for A in range E3:E7. It would be good if we can make the formula dynamic as well.
Thanks in advance.
Kind regards
kp
I'm a bit stuck in writing an array formula to return multiple values for unique entries (A, B & C) from a dynamic list in columns A & B :banghead: . I couldn't find an answer in this forum so I need someone's help.
I attach an example file for your viewing. I have manually input the answer for A in range E3:E7. It would be good if we can make the formula dynamic as well.
Thanks in advance.
Kind regards
kp