Creating a list from data in multiple cells

How would I create a list of all data in Column A that has specific matching data next to it in Column B? For example in the attached image, I have 6 names in Column A. Adjacent cells in Column B have either the Letter M or F. In Column D I manually entered all the names with an M to their right, but I would like some sort of fucntion to do it for me instead.

Hi

You could eventually sort your data based on the second column - Data - Sort - And sort by Col B ( fi)

EDIT : if you only want those with M - Data - Filter - AutoFilter - Select F in Ddown box and delete the rows - Unselect Autofilter

That would work, but this is just a simple example of what I'm trying to do. I don't want to hide all the other information on the sheet. I want to put the list somewhere else. I started reading about arrays and it seems like that might be what I want. I haven't been able to completely figure them out yet though.

bump, still stumped

bump, still stumped

Bump. Is this not something simple? It seems like it would be a pretty standard thing to be able to do.

What exactly are you trying to do...are you just trying to replicate the data from columns A and B into columns D and E?

In the attached sample of my workbook, you'll see separate sections for different dogs that my business takes care of. Column AA for each dog is true (1) when the dog is being shuttled on the date in H5. A dog is marked for shuttle by putting the tag "a" in one of the calendar cells (d stands for daycare, a stands for am shuttle, p stands for pm shuttle if you are curious. Try it out1). What I'm trying to accomplish is a list of the dogs that need to be shuttled that day so that I can print it out and give it to the driver. Yes I could filter by column AA, but that would hide all the calendars, charges, payments, etc. I don't want a user messing with the look of the sheet. I would rather have a separate sheet for this.