Microsoft Excel 2002 Tutorial
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 308 articles for 1.032 sec
Hello Jon, Thanks for your formulas and detail explanation. Kind Regards Low -- A36B58K641 "Jon Peltier" wrote: > With the original data in A1:E5, create a pivot table. Drag the Code field > into the Rows area, and one by one drag the fields 1, 2, 3, 4 into the data > area. Copy the pivot table, paste it in another range as values, replace > "Sum of " with "". Select the blank     

Group: microsoft.public.excel.misc · Group Profile · Search for Microsoft Excel 2002 Tutorial in microsoft.public.excel.misc
Author: Mr. Low
Date: Feb 21, 2008 06:20

With the original data in A1:E5, create a pivot table. Drag the Code field into the Rows area, and one by one drag the fields 1, 2, 3, 4 into the data area. Copy the pivot table, paste it in another range as values, replace "Sum of " with "". Select the blank cells in the first pasted column (use Ctrl+G, Special, Blanks), type = in the formula bar, press the up arrow, and Press enter, to
Show full article (2.09Kb) · Show article thread
Hi Gaj - I took what you said as cordial, and was just trying to indicate that while such features as notches in a box plot might be useful and common in some disciplines, my experience did not include such features. I must need to adjust my medications, however, as a few times in the past month or so I've been accused of being defensive or offensive, and that is never my intention. I     

Group: microsoft.public.excel.misc · Group Profile · Search for Microsoft Excel 2002 Tutorial in microsoft.public.excel.misc
Author: Jon Peltier
Date: Feb 20, 2008 08:50

Duh, duh, exhibits ignored, personal defensive stance taken, while my aim was quite the opposite (I thought it was obvious, but apparently ...). Anyway, my point was and is that notched boxplots *ARE* used in "real display of information", "heat of the battle" or whatever one calls that -- at least every now and then. To add to the ignored exhibits (deliberately as diverse as I could find
Show full article (1.80Kb) · Show article thread
Gaj - I'm not an entomologist, nor have I read much on the anthropology of monkeys. I've worked in scientific research as a metallurgist (for my doctorate and a dozen years of employment following that), and as an engineer in manufacturing. Maybe not the widest mathematical background, and I'm not degreed in statistics (though I've taken a graduate level course or three). I've encountered     

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel 2002 Tutorial in microsoft.public.excel.charting
Author: Jon Peltier
Date: Jun 20, 2007 12:00

Duh, every now and then even proved experts (even with a degree in statistics) say something that leaves me deeply perplexed. Less than five minutes of googling reveals these five fine examples: - Exhibit 1 (electronics / mobile phone manufacturing, 1996) http://ieeexplore.ieee.org/iel3/4031/12221/00561268.pdf?arnumber=561268 - Exhibit 2 (experimental / cognitive psychology, 1996) http
Show full article (12.54Kb)
Hello Jon, Many thanks for your formula. It works perfectly well. Kind Regards Low -- A36B58K641 "Jon Peltier" wrote: > Enter this in A2 and drag it down: > > =IF(D2="TOTAL :",MAX(A$1:A1)+1,"") > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Tutorials and Custom Solutions > http://PeltierTech.com > _______ > > > "Mr. Low" <lsk2141@discussions.microsoft     

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel 2002 Tutorial in microsoft.public.excel.charting
Author: Gaj Vidmar
Date: Jun 19, 2007 11:12

Enter this in A2 and drag it down: =IF(D2="TOTAL :",MAX(A$1:A1)+1,"") - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Mr. Low" <lsk2141@discussions.microsoft.com> wrote in message news:A6557AF8-9401-4010-9057-6503917EFB50@microsoft.com... Dear Sir, I have the following worksheet : A B C D
Show full article (10.36Kb)
Jon, Thanks for the response. Actually, I saw for even less a couple of places. I guess what I'm hoping for is someone who upgraded and kept the old legal version and is willing to part with it for a good price. Gotta be legal. -- Don Guillett SalesAid Software dguillett1@austin.rr.com "Jon Peltier" <jonxlmvpNO@SPAMpeltiertech.com> wrote in message news:%%23qPEATWeHHA.3996@TK2MSFTNGP06     

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel 2002 Tutorial in microsoft.public.excel.charting
Author: Jon Peltier
Date: Jun 19, 2007 09:36

When I saw your first thread, I did a quick search, and places like Amazon and eBay have it for around $150-200. Don't know if that's what you consider reasonable, for a two-version-old release. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Don Guillett" <dguillett1@austin.rr.com> wrote in message news:uY86hcUeHHA.3648@TK2MSFTNGP05
Show full article (5.82Kb)
    

Group: microsoft.public.excel.charting · Group Profile · Search for Microsoft Excel 2002 Tutorial in microsoft.public.excel.charting
Author: Gaj Vidmar
Date: Jun 19, 2007 07:17

Show full article (4.85Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Microsoft Excel 2002 Tutorial in microsoft.public.excel.misc
Author: Mr. Low
Date: May 12, 2007 05:19

Show full article (1.51Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for Microsoft Excel 2002 Tutorial in microsoft.public.excel.misc
Author: Jon Peltier
Date: May 11, 2007 06:23

Show full article (1.28Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Microsoft Excel 2002 Tutorial in microsoft.public.excel.misc
Author: Don Guillett
Date: Apr 7, 2007 15:38

Show full article (1.02Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for Microsoft Excel 2002 Tutorial in microsoft.public.excel.misc
Author: Jon Peltier
Date: Apr 7, 2007 15:32

Show full article (0.57Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next