I am using excel 2016.
I have two files.
One just has a list of serial numbers. (serial list)
The second has many columns, but colmun E is the serial number list. (all computers2)
In the second sheet , I want to only display the rows that have the same serial numbers as the first sheet does.
Thank you
Last edited by ghurty; 05-14-2024 at 12:21 PM.
Post samples of both files.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you. I updated the original post
Try:
Formula:
Please Login or Register to view this content.
I just tried it and I got an error that the function is not valid. Please note that I am on a computer that uses excel 2016. TY
Your profile says 365, hence you got a formula that reflects your profile.
Please update your profile, or state within your OP what version of Excel the formula needs to work with.
You can still use the COUNTIF to check whether a record is present but you'll need different functions to return the data.
I appoligize, because of my profile, I wrote in my original post that I was using excel 2016.
What function would it be?
Thank you
For the 2016 version of Excel I would suggest:
1. Converting the data on the Report (31) sheet into an Excel table
2. Add a column E populated using: =ISNUMBER(MATCH(C4,MyProductList!C$2:C$7,0))
3. Filter the table by selecting the sort/filter button in cell E1 and choosing TRUE
Note that when the data on the MyProductList sheet is moved to another workbook the formula will automatically update.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks