I would appreciate some ideas on this one.
Our company has a massive database under Oracle, and I can dump to Excel a spreadsheet of about 5,000 lines, based on Job Numbers throughout the whole country.
In my area I have a set of Job Number I am particularly interested in.
How do I Sort; Filter; Match or WHAT the whole database dump to display only those I need?
Thanks in anticipation of a swell answer!!
Go to Data|Filter|Autofilter..
Your Row 1 should now have some drop down arrows. Select the one with the Job Ids and filter by the one of interest.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are probably 600 different Job Numbers in the 5,000 lines of data.
I am interested in maybe 60/70 of these Job Numbers.
I need to reduce the whole 5,000 lines to show only the lines which have my Job Numbers thereon.
When I have used filters I can see the whole list and am able to select one identity or in custom I have 2 choices.
I do not think this is a quick solution.
Thanks
How about creating a list on a separate sheet of the job numbers you are interested in....
Then you can add a formula in a new column in the data sheet.
Something to the effect:
=Isnumber(Match(A1,Sheet2!$A$1:$A$60,0)) copied down
where A1 contains a job id in your original sheet and Sheet2!A1:A60 contains the job ids of interest.
This formula results in TRUE if the job Id matches your list....
Then you can use Autofilter and filter for TRUE in your new column.
Does that work for you?
WOW
That works a treat - thanks!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks