Basically I wanted to know if there was a way to filter some data into two column. I have uploaded a document that has different prices of some items and wanted to make a filter them to have two columns where one is date and the other will give the corresponding price. I greatly appreciate your help.
Last edited by Kdot; 07-28-2017 at 05:58 PM.
How should the result look like. You did not add that in your example.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Something like the highlighted columns. Basically wants the date is chosen, only the prices of that date shows up
With data-validation in the column P.
After that index / match.
See the attached file.
Thank you
Thanks for the rep.
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
If you have questions on the result feel free to ask.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks