Isabel asks how to use Ctrl+F to find a row where three criteria are true. Rather than use Ctrl+F, Episode 1044 suggests using a Filter.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
hey welcome back to the MrExcel netcast.
i'm Bill Jelen.
You start out with massive amount of data so how we're going to analyze as well plus fire up a pivot table.
and see how you can solve this problem.
All right welcome back to the MrExcel netcast. i'm Bill Jelen.
Today's question send by Isabel.
Isabel is trying to use CtrlF define feature.
but she's trying to do it to look for things that occur in three different columns on the same row so what isabel says is hey I need to look to find a certain branch a certain "From street" and a certain "To street" and "Find and Replace" doesn't seem to do that it just lets me look for one value and I need to limit it down.
going to suggest that Isabel uses something that in Excel 2003 was called the auto filter but now in Excel 2007 it's just called a filter.
In 2003 you go to data and choose filter, auto filter.
In Excel 2007 just come here and choose data filter and what we get is a drop-down now on each column heading and you're going to have to do this in three steps unfortunately, let's say that you're looking for Laurel Street come here to the "From" and uncheck "Select All" Scroll down and select just Laurel.
Click "OK" and now what you'll see is already we have just the records visible that are Laurel.
if you're also an looking for from Laurel to view we can come here and choose just view click OK and already you're down to the branch you need it but if you would need to limit it down to a certain branch you could come here and select that sort of branch and then find those records.
Now if we want to go back in Excel 2003 you could use data filter show all here we can just click clear and it goes back to show us all the records so a bit more tedious but definitely much more powerful than what you have using the find dialog box.
All right want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
i'm Bill Jelen.
You start out with massive amount of data so how we're going to analyze as well plus fire up a pivot table.
and see how you can solve this problem.
All right welcome back to the MrExcel netcast. i'm Bill Jelen.
Today's question send by Isabel.
Isabel is trying to use CtrlF define feature.
but she's trying to do it to look for things that occur in three different columns on the same row so what isabel says is hey I need to look to find a certain branch a certain "From street" and a certain "To street" and "Find and Replace" doesn't seem to do that it just lets me look for one value and I need to limit it down.
going to suggest that Isabel uses something that in Excel 2003 was called the auto filter but now in Excel 2007 it's just called a filter.
In 2003 you go to data and choose filter, auto filter.
In Excel 2007 just come here and choose data filter and what we get is a drop-down now on each column heading and you're going to have to do this in three steps unfortunately, let's say that you're looking for Laurel Street come here to the "From" and uncheck "Select All" Scroll down and select just Laurel.
Click "OK" and now what you'll see is already we have just the records visible that are Laurel.
if you're also an looking for from Laurel to view we can come here and choose just view click OK and already you're down to the branch you need it but if you would need to limit it down to a certain branch you could come here and select that sort of branch and then find those records.
Now if we want to go back in Excel 2003 you could use data filter show all here we can just click clear and it goes back to show us all the records so a bit more tedious but definitely much more powerful than what you have using the find dialog box.
All right want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
