Topic: Excel Hardware Spreadsheets, How do you customize by year & options?

[67gtasanjose]

Jim's spreadsheets are an excellent resource, no doubt about that. I printed off 28 pages of microscopic font that encompasses both the 67 and 68 model years, with EVERY option for both years.

I admit, I know VERY LITTLE of how Microft Excel works.

Perhaps a little tutorial of how I can thin the sheets, first by removing everything "68 ONLY" (for my specific needs), then perhaps a line by line deletion for engine or transmission options my example doesn't have and so on..


Any "Excel Wizards" who know a good way for me to customize a spreadsheet for my particular project?

Richard

[Bossbill]

Copy spreadsheet so that you have the original.
Open your copy and select the tab called Data and select the square box Sort.
Sort on Column J.

Result will have 67 first, then 68, then 67 and 68.
Remove the 68 section.

Next sort on column G, get result and remove stuff relate to "Trans" or whatever.

Selecting on the number row (before column A) and then shift selecting further down will allow multirow selecting. Right click for getting to the delete option.

That's as simple as I can make it.

[67gtasanjose]

Copy spreadsheet so that you have the original.
Open your copy and select the tab called Data and select the square box Sort.
Sort on Column J.

Result will have 67 first, then 68, then 67 and 68.
Remove the 68 section.

Next sort on column G, get result and remove stuff relate to "Trans" or whatever.

Selecting on the number row (before column A) and then shift selecting further down will allow multirow selecting. Right click for getting to the delete option.

That's as simple as I can make it.

ALMOST as clear as mud

I have downloaded a few copies of the spreadsheets and Jim has also PM'd me so it looks like I will be trying to learn more about using Excel.

[jwc66k]

Two "custom" 67 only files created and sent to Richard.
Jim

[67gta289]

Here's a shot at some instructions on Excel filtering using examples from one of the actual spreadsheets.  Let me know if I missed anything or if there are questions.

[67gtasanjose]

Here's a shot at some instructions on Excel filtering using examples from one of the actual spreadsheets.  Let me know if I missed anything or if there are questions.

I think my High school forgot this lesson. Oh wait, back in the stone age, we didn't Excel in all these fancy 'puter skills (hick-hick!)

That lesson was great John! I figured there were easier ways to use the program far beyond my comprehension level and patience...I think you have just proved it! lol!

I might dabble some in that to thin the herd of hardware closer to my build. What's the worse thing that could happen, I learn something NEW! (like, OMG!)