Hi.
Hopefully there is an example attached.
I am after the data from Sheet1 under the relevant date which is selected on Sheet2 C1
Sheet2 C1 - has a validation list so date is changeable.
Example: Sheet2 C1 07/07/07 date is selected - in Sheet1 under the selected date the names Bob and Barry are what I would like to be shown in Sheet2 B5 (downwards)
Is this possilble? and if so how?
Many thanks.
Try this array formula in B5:
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Please Login or Register to view this content.
Quang PT
Great. Thank you.
Without Arry
B5Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hi There,
Is there a way to do that with the results in the same cell?
Thank you!
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Ok, sorry for this!
Will comply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks