how to return multiple values vertically
Hi guys,
I am stuck and confused at the moment.
Hope you guys could lend me some brightness.
I have attached my working sample book, and I want to return multiple values vertically on my result tab which conditions match
should I use SMALL or ROW function? or not?
and how should it be applied? please kindly help out gracias
Last edited by blackhound; 07-12-2021 at 01:49 AM. Reason: title change
IN B3 copied down
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Dhanyadagalu kvsrinivasamurthy
one more question to ask, is it essential to lock the range field $A$2:$A$30 ? or could I extend to whole field A:A ?
You can extend the range to A:A but it will slow down calculation. It’s better to use fixed range like A2:A400000 with sufficient margin.
Thanks for feedback and rep.
worksheet name : RESULTS
Cell B3 array formula , Drag down
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks