Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
=FILTER(A2:E1000,COUNTIF(G2:G200,D2:D1000))
Filter a list base on another list.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Hello
I have a list of truck loads with names. This list contains loads that belong to me and some that do not. I want to use a list that contains the names of my loads, to filter out the rows from those that do not belong to me.
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
{count} votes
Answer accepted by question author
-
Anonymous
2024-06-12T13:21:48+00:00
5 additional answers
Sort by: Most helpful
-
Ashish Mathur 101K Reputation points Volunteer Moderator2024-06-11T22:58:23+00:00 Hi,
Share some data to work with and show the expected result.
-
Anonymous
2024-06-12T13:02:58+00:00 Good Day Ashish, thank you for your message. I have attached an example.
The daily truck unload list (In short form) My customer list EXAMPLE OF WHAT I WOULD LIKE TO SEE Type Appointment # Contract # Name Product Name Type Appointment # Contract # Name Product Truck 100 2000 Bob L Bob Truck 100 2000 Bob L Truck 123 8999 James L Pete Truck 156 2000 Bob L Truck 156 2000 Bob L Lani Truck 456 3200 Yuan L Truck 456 3200 Yuan L Yuan Truck 365 4512 Pete L Truck 842 3100 Mike L Truck 265 4512 Pete L Truck 365 4512 Pete L Truck 477 9665 Lani L Truck 265 4512 Pete L Truck 712 4223 Bob L Truck 855 8456 Cecil L Truck 444 7531 Jimmy L Truck 985 9465 Thommy L Truck 465 1225 Owen L Truck 477 9665 Lani L Truck 712 4223 Bob L Truck 991 1225 Owen L This list is usually the length of 400 lines This list is about 70 people long -
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
-
Anonymous
2024-06-12T13:42:32+00:00 Amazing! Thank you!!! 😁😁😁