CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Thu, 24 Jul 2025 17:37:38 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20091216181354 location: https://web.archive.org/web/20091216181354/https://answers.oreilly.com/tag/excel server-timing: captures_list;dur=0.792433, exclusion.robots;dur=0.026845, exclusion.robots.policy;dur=0.013084, esindex;dur=0.016702, cdx.remote;dur=283.799703, LoadShardBlock;dur=489.244945, PetaboxLoader3.datanode;dur=219.068301, PetaboxLoader3.resolve;dur=169.923532 x-app-server: wwwb-app212 x-ts: 302 x-tr: 825 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: SERVER=wwwb-app212; 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, 24 Jul 2025 17:37:39 GMT content-type: text/html;charset=UTF-8 x-archive-orig-date: Wed, 16 Dec 2009 18:13:56 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=Tue, 16-Dec-2008 18:13:55 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_session_id=deleted; expires=Tue, 16-Dec-2008 18:13:55 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: Wed, 16 Dec 2009 18:13:54 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, 07 Dec 2009 14:30:58 GMT", ; rel="memento"; datetime="Wed, 16 Dec 2009 18:13:54 GMT", ; rel="next memento"; datetime="Sat, 06 Feb 2010 06:40:35 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_13_20091216163416_crawl101_IndexOnly-c/52_13_20091216181344_crawl100.arc.gz server-timing: captures_list;dur=13.071638, exclusion.robots;dur=0.026555, exclusion.robots.policy;dur=0.013380, esindex;dur=0.018871, cdx.remote;dur=29.453491, LoadShardBlock;dur=458.837345, PetaboxLoader3.datanode;dur=261.926389, PetaboxLoader3.resolve;dur=205.765391, load_resource;dur=149.318012 x-app-server: wwwb-app212 x-ts: 200 x-tr: 801 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

Feed Subscription Email Subscription

Sorting an Excel worksheet using VBScript

Asked by LawrenceMW : 12 December 2009 - 11:53 PM
Tags:
- vbscript
- excel
0Answers

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
Using Microsoft Excel for Statistics

By SarahBoslaugh : 30 October 2009 - 01:03 PM
Microsoft Excel is, properly speaking, not a statistical package at all, although it is sometimes used as one. Excel is a spreadsheet application produced by Microsoft Corporation that is frequently u...
Tags:
0Votes

0Comments
How to Plot Histograms in Excel

By BruceFrey : 27 October 2009 - 11:08 PM
There is some truth to the cliché "a picture is worth a thousand words." A picture is often the best way to understand 1,000 numbers. People are visually oriented. We're good at looking at...
Tags:
1Vote

0Comments
Highlight Invalid Worksheet Data in Excel

By CurtFrye : 13 October 2009 - 02:59 PM
I provide IT support for a building supply company, and one of my prime responsibilities is maintaining a spreadsheet with lots of customer information, including credit limits. Over the last six mont...
Tags:
- excel
- validation
1Vote

0Comments
How to Avoid Duplicate Entries in a Column with Excel

By CurtFrye : 12 October 2009 - 12:15 PM
I take inbound calls at a tech-support center, and we track the various callers by recording their phone number in a spreadsheet. The number of different callers is supposedly vital information, and m...
Tags:
0Votes

0Comments

Pages:

Original Source | Taken Source