Filter one data set by a column on another data set

Anonymous ,

---

Anonymous wrote:

Hi all,

 

I am very new at this, so here's hoping my question is easy and I can understand the answer...

 

I have one Excel sheet with about 2000 lines that I have sorted and chosen, now I want to use only the data in other sheets (multiple columns) which matches a number value present in the first column in my first sheet. In fact, this is sales data for an entire year (number in first column are store ID numbers) and I want to follow same-store sales only, so no new lines allowed. How can I make that happen?

 

Also, how do I set data type if my entire sheet is the "Date" value?

 

Any and all help appreciated!

 

Thank you,

 

JC

---

Please share some sample data and clarify the expected result.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.