CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Thu, 17 Jul 2025 10:43:22 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20100330114057 location: https://web.archive.org/web/20100330114057/https://answers.oreilly.com/tag/excel/ server-timing: captures_list;dur=0.551697, exclusion.robots;dur=0.018148, exclusion.robots.policy;dur=0.008026, esindex;dur=0.011032, cdx.remote;dur=41.452959, LoadShardBlock;dur=295.047751, PetaboxLoader3.datanode;dur=142.104357, PetaboxLoader3.resolve;dur=136.653565 x-app-server: wwwb-app220 x-ts: 302 x-tr: 362 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: SERVER=wwwb-app220; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Thu, 17 Jul 2025 10:43:23 GMT content-type: text/html;charset=UTF-8 x-archive-orig-date: Tue, 30 Mar 2010 11:40:58 GMT x-archive-orig-server: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.8 x-archive-orig-x-powered-by: PHP/5.2.8 x-archive-orig-set-cookie: answers_session_id=deleted; expires=Mon, 30-Mar-2009 11:40:57 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_session_id=deleted; expires=Mon, 30-Mar-2009 11:40:57 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-cache-control: ,no-cachemust-revalidate, max-age=0 x-archive-orig-expires: 0 x-archive-orig-pragma: no-cache x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Tue, 30 Mar 2010 11:40:57 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Thu, 15 Oct 2009 13:10:42 GMT", ; rel="prev memento"; datetime="Mon, 15 Mar 2010 12:42:45 GMT", ; rel="memento"; datetime="Tue, 30 Mar 2010 11:40:57 GMT", ; rel="next memento"; datetime="Sat, 15 May 2010 06:18:02 GMT", ; rel="last memento"; datetime="Sun, 03 Aug 2014 14:41:27 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 52_15_20100330101149_crawl103-c/52_15_20100330113839_crawl100.arc.gz server-timing: captures_list;dur=0.607394, exclusion.robots;dur=0.021184, exclusion.robots.policy;dur=0.009703, esindex;dur=0.012401, cdx.remote;dur=13.085481, LoadShardBlock;dur=206.973899, PetaboxLoader3.datanode;dur=194.865694, PetaboxLoader3.resolve;dur=110.371128, load_resource;dur=126.268635 x-app-server: wwwb-app220 x-ts: 200 x-tr: 467 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip excel Questions and Answers - O'Reilly Answers

Jump to content

O'Reilly Answers

Clever Hacks. Creative Ideas. Innovative Solutions.

Share your knowledge

Welcome

Help

O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »

Send us feedback
Feed icon

O'Reilly Answers Feed
Twitter icon

@oreillyanswers

Topics: excel

excel Feed Subscription Feed subscription {tag} Email Subscription Email subscription Questions Only Feed Questions Only Email

Begining mySQL for every day work and linking in and out of MS Excel

Asked by komMWM : 11 March 2010 - 07:40 AM

Answered by KBenson : Mar 17 2010 11:30 AM
(Skip to the bottom if you are ONLY interesting in the MySQL portion of the question) There's a few basic questions that need to be answered before you can really decide where to start. These ar... full answer >
Tags:
1Answer

0Comments
Perl and Python manipulation of Excel files ( and Numbers too)

Asked by donfox : 31 January 2010 - 06:03 PM

Answered by adfm : Feb 05 2010 10:50 AM
If you are interested in comparing how others have accomplished manipulating an Excel spreadsheet using each language, then I would refer you to this article about reading and writing Excel files with... full answer >
Tags:
1Answer

0Comments
How to use R inside Microsoft Excel

By adfm : 20 January 2010 - 11:25 AM
Excel can be a safe comfort zone for some users, but sometimes you need access to more robust tools like R. Thankfully there's RExcel to bridge the gap. In this excerpt from Joseph Adler's R in a N...
Tags:
0Votes

0Comments
Can XML, XSLT and XSD do the following:

Asked by Boubou : 06 January 2010 - 08:52 AM

Answered by simonstl : Jan 08 2010 12:15 PM
I'm not completely clear on what the capabilities of your database extraction system are, or how complex your data is. If the data is strictly a table, then exporting as XML (with an XML Schema) ... full answer >
Tags:
- XML
- XSLT
- XSD
- Excel
1Answer

0Comments
Sorting an Excel worksheet using VBScript

Asked by LawrenceMW : 12 December 2009 - 11:53 PM

Answered by CurtFrye : Dec 19 2009 05:06 PM
Hi Lawrence, If you can't get your VBA to work, I recommend recording a macro, sorting the range in descending order, and using that code. I put data in the range A1:A5 and recorded this macro: ... full answer >
Tags:
- vbscript
- excel
1Answer

0Comments
How to use Excel to compare two versions of a legal contract

By michaelmilton : 03 December 2009 - 09:50 AM
I had a chance to use Excel for this purpose and thought you might want to see the technique. Be sure to watch it on full screen HD! Michael Milton is the author of Head First Data Analysis and...
Tags:
- legal
- excel
4Votes

1Comment
What are the benefits of SparkLines and Slicers in Excel 2010 (beta)?

Asked by kbnotes : 30 November 2009 - 01:15 PM

Answered by CurtFrye : Dec 04 2009 04:44 PM
Sparklines, which are small charts that have little or no additional formatting, summarize data in a compact space. They're often used in dashboards to provide context for another measure, such as... full answer >
Tags:
1Answer

1Comment
To sum satisfying two conditions in excel

Asked by Kicchagee : 24 November 2009 - 04:54 AM

Answered by odewahn1 : Nov 24 2009 09:05 AM
This is a bit of a hack solution, but it will always work: Create a cell for each condition you want to test. It should return a "1" if the condition is met, and "0" otherwise.... full answer >
Tags:
- sum
- excel
1Answer

0Comments
How to make data more digestible for presentations

By odewahn1 : 20 November 2009 - 12:30 PM
Presenting data is hard, particularly now that most people's attention span has shrunk to 140 characters. (Or less.) If you have to present some complex findings, it's a good idea to focus o...
Tags:
3Votes

0Comments
Excel 2003 Programming Book issues

Asked by c1802362 : 06 November 2009 - 04:11 PM

Answered by Util : Nov 09 2009 09:19 PM
Here are a few links to resolve your first issue: Snapshots of the original website, taken between 2003 and 2004, can be found in the WayBack Machine: https://web.archive.org/web/*/https://www.mstraini... full answer >
Tags:
- excel
1Answer

0Comments