Spreeding
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 76 articles for 0.303 sec
select the area that you want in the excel spreadsheet, hold down the shift key and click on Edit. Select copy picture>as Printed, then go to the word doc and copy from the clipboard to the document. Rob L "allend27" <allend27@discussions.microsoft.com> wrote in message news:B6B55BEC-9C55-4192-B5ED-AAF9A7CBEB52@microsoft.com... > My wife is in school and must put a spreed sheet into a     

Group: microsoft.public.excel.misc · Group Profile · Search for Spreeding in microsoft.public.excel.misc
Author: Rob L
Date: Jul 29, 2008 04:44

You could use Autofilter and select "is greater than" Data Filter Autofilter Click on the filter arrow on the Quantity Column and select: Custom and select "is greater then" and zero from the arrow dropdowns. You can then copy and paste the data without the zeros. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator
Show full article (0.59Kb) · Show article thread
I need help which is probably basis to most of you, thanks in advance I have a spreed sheet with this type of data Item Quantity Price Total xxx 23 $64 xxxx xxx 0 $74 xxxx xxx 14 $222 xxxx What I would like to do is be able to create a seperate spreed sheet that only counts the items that total over 0. Is this     

Group: microsoft.public.excel.misc · Group Profile · Search for Spreeding in microsoft.public.excel.misc
Author: allend27
Date: Jul 28, 2008 17:31

"psalm91jim" wrote: How do I collect a sum with the following conditions(?): If found in column A:A = all cells containing "AAA" If found in column D:D = all cells containing "XXX" then sum of all "XXX" that also are "AAA" (i.e., appear in the same row as "AAA") Along the same lines consider also: If found in column A:A = all cells containing "AAA" and, If found
Show full article (0.24Kb)
"psalm91jim" wrote: > > How do I collect a sum with the following conditions(?): > If found in column A:A = all cells containing "AAA" > If found in column D:D = all cells containing "XXX" > then sum of all "XXX" that also are "AAA" (i.e., appear in the same row as > "AAA") > > Along the same lines consider also: > If found in column A:A = all cells containing "AAA" and, > If found     

Group: microsoft.public.excel.misc · Group Profile · Search for Spreeding in microsoft.public.excel.misc
Author: Sandy Mann
Date: Aug 13, 2008 12:33

How do I collect a sum with the following conditions(?): If found in column A:A = all cells containing "AAA" If found in column D:D = all cells containing "XXX" then sum of all "XXX" that also are "AAA" (i.e., appear in the same row as "AAA") Along the same lines consider also: If found in column A:A = all cells containing "AAA" and, If found in column C:C = all cells containing "BBB" and
Show full article (1.03Kb) · Show article thread
"Roger Govier" wrote: > Hi Jim > > =SUMPRODUCT(--(A1:A1000)="AAA"),--(C1:C1000="BBB"),--(D1:D1000="XXX")) > > -- > Regards > Roger Govier > > "psalm91jim" <psalm91jim@discussions.microsoft.com> wrote in message > news:E943E5A5-6178-4CDE-9119-4DC37E6C5470@microsoft.com... > > How do I collect a sum with the following conditions(?): > > If A:A = "AAA" > > If D:D = "XXX" > > then     

Group: microsoft.public.excel.misc · Group Profile · Search for Spreeding in microsoft.public.excel.misc
Author: Lost in excel
Date: Aug 13, 2008 11:43

Hi Chris, It is not a 100%% clear what you are really up to, but here's a first tip: Create a key-table with all the numbers in one coloumn and the names in the next coloumn and then you can use the vlookup function. If you have a non-neat sheet where the mentioned numbers are spread across with no pattern then I would suggest a macro, for which please post a sample file so that I can understand
Show full article (0.42Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for Spreeding in microsoft.public.excel.misc
Author: psalm91jim
Date: Aug 6, 2008 07:10

Show full article (2.76Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Spreeding in microsoft.public.excel.misc
Author: psalm91jim
Date: Aug 5, 2008 14:17

Show full article (2.78Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Spreeding in microsoft.public.excel.misc
Author: psalm91jim
Date: Aug 5, 2008 12:48

Show full article (2.50Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for Spreeding in microsoft.public.excel.misc
Author: psalm91jim
Date: Aug 5, 2008 12:31

Show full article (2.85Kb) · Show article thread
    

Group: microsoft.public.excel.charting · Group Profile · Search for Spreeding in microsoft.public.excel.charting
Author: eNJay
Date: Aug 1, 2008 08:38

Show full article (0.67Kb) · Show article thread
    

Group: microsoft.public.excel.charting · Group Profile · Search for Spreeding in microsoft.public.excel.charting
Author: Chris
Date: Jul 31, 2008 12:56

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