Help using the LARGE function "WITHOUT" using an array

Can someone show me how to accomplish the following by using the LARGE
function "WITHOUT" using an array ?

I'm trying to rank each product (most, second most, etc.) by weight.

   Data worksheet

     A		B		C
   1 Product	Type		Pounds
   2 Orange	Fruit		600
   3 Tomato	Vegetable		500
   4 Apple		Fruit		700
   5 Potato		Vegetable		1,000


Using the LARGE function, the goal is to get the following result on
another worksheet:

   Order worksheet

     A		B		C
   1 Product	1		2
   2 Fruit		Apple		Orange
   3 Vegetable	Potato		Tomato


On the Order worksheet, the following formula is the one I'm using
with an array:

   {=IFERROR(INDEX(Data!$A$1:$C$5,MATCH(LARGE(IF(Data!$B$1:$B$5=
$A2,Data!$C$1:$C$5,""),B$1),Data!$C$1:$C$5,0),1),"")}


Does anyone know how to get the same result without using an array -
even if it uses another function ?
0
exceluser
6/3/2010 1:40:06 AM
excel.worksheet.functions 4936 articles. 2 followers. Follow

6 Replies
726 Views

Similar Articles

[PageSpeed] 55

Hi, this does not have to be array-entered, if that's what you mean.

=IFERROR(INDEX(Data!$A$1:$A$5,MATCH(LARGE(INDEX(
(Data!$B$2:$B$5=$A2)*Data!$C$2:$C$5,),B$1),Data!$C$1:$C$5,0)),"")

BTW, this (and your original) would fail if you had two products of the same 
weight and type.

HTH
Steve D.


"exceluser" <ifmcqy7aiasefw@yahoo.com> wrote in message 
news:4ed0be3e-3a9b-44eb-9b72-3561cfe9a088@u7g2000vbq.googlegroups.com...
> Can someone show me how to accomplish the following by using the LARGE
> function "WITHOUT" using an array ?
>
> I'm trying to rank each product (most, second most, etc.) by weight.
>
>   Data worksheet
>
>     A B C
>   1 Product Type Pounds
>   2 Orange Fruit 600
>   3 Tomato Vegetable 500
>   4 Apple Fruit 700
>   5 Potato Vegetable 1,000
>
>
> Using the LARGE function, the goal is to get the following result on
> another worksheet:
>
>   Order worksheet
>
>     A B C
>   1 Product 1 2
>   2 Fruit Apple Orange
>   3 Vegetable Potato Tomato
>
>
> On the Order worksheet, the following formula is the one I'm using
> with an array:
>
>   {=IFERROR(INDEX(Data!$A$1:$C$5,MATCH(LARGE(IF(Data!$B$1:$B$5=
> $A2,Data!$C$1:$C$5,""),B$1),Data!$C$1:$C$5,0),1),"")}
>
>
> Does anyone know how to get the same result without using an array -
> even if it uses another function ? 

0
Steve
6/3/2010 10:33:47 AM
If you need to allow for two products of the same weight and type, try this:

=IFERROR(INDEX(Data!$A$1:$A$10,MATCH(LARGE(INDEX(
(Data!$B$2:$B$10=$A2)*Data!$C$2:$C$10+
ROW(Data!$C$2:$C$10),),B$1),INDEX(Data!$C$2:$C$10+
ROW(Data!$C$2:$C$10),),0)+1),"")



"Steve Dunn" <stunn@sky.com> wrote in message 
news:9F7E0B2D-7169-4572-8CE6-4E20C74D7864@microsoft.com...
> Hi, this does not have to be array-entered, if that's what you mean.
>
> =IFERROR(INDEX(Data!$A$1:$A$5,MATCH(LARGE(INDEX(
> (Data!$B$2:$B$5=$A2)*Data!$C$2:$C$5,),B$1),Data!$C$1:$C$5,0)),"")
>
> BTW, this (and your original) would fail if you had two products of the 
> same weight and type.
>
> HTH
> Steve D.
>
>
> "exceluser" <ifmcqy7aiasefw@yahoo.com> wrote in message 
> news:4ed0be3e-3a9b-44eb-9b72-3561cfe9a088@u7g2000vbq.googlegroups.com...
>> Can someone show me how to accomplish the following by using the LARGE
>> function "WITHOUT" using an array ?
>>
>> I'm trying to rank each product (most, second most, etc.) by weight.
>>
>>   Data worksheet
>>
>>     A B C
>>   1 Product Type Pounds
>>   2 Orange Fruit 600
>>   3 Tomato Vegetable 500
>>   4 Apple Fruit 700
>>   5 Potato Vegetable 1,000
>>
>>
>> Using the LARGE function, the goal is to get the following result on
>> another worksheet:
>>
>>   Order worksheet
>>
>>     A B C
>>   1 Product 1 2
>>   2 Fruit Apple Orange
>>   3 Vegetable Potato Tomato
>>
>>
>> On the Order worksheet, the following formula is the one I'm using
>> with an array:
>>
>>   {=IFERROR(INDEX(Data!$A$1:$C$5,MATCH(LARGE(IF(Data!$B$1:$B$5=
>> $A2,Data!$C$1:$C$5,""),B$1),Data!$C$1:$C$5,0),1),"")}
>>
>>
>> Does anyone know how to get the same result without using an array -
>> even if it uses another function ?
> 

0
Steve
6/3/2010 12:52:24 PM
On 3 Jun., 02:40, exceluser <ifmcqy7aias...@yahoo.com> wrote:
> Can someone show me how to accomplish the following by using the LARGE
> function "WITHOUT" using an array ?
>
> I'm trying to rank each product (most, second most, etc.) by weight.
>
> =A0 =A0Data worksheet
>
> =A0 =A0 =A0A =A0 =A0 =A0 =A0 =A0B =A0 =A0 =A0 =A0 =A0 =A0 =A0 C
> =A0 =A01 Product =A0 =A0Type =A0 =A0 =A0 =A0 =A0 =A0Pounds
> =A0 =A02 Orange =A0 =A0 Fruit =A0 =A0 =A0 =A0 =A0 600
> =A0 =A03 Tomato =A0 =A0 Vegetable =A0 =A0 =A0 =A0 =A0 =A0 =A0 500
> =A0 =A04 Apple =A0 =A0 =A0 =A0 =A0 =A0 =A0Fruit =A0 =A0 =A0 =A0 =A0 700
> =A0 =A05 Potato =A0 =A0 =A0 =A0 =A0 =A0 Vegetable =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 1,000
>
> Using the LARGE function, the goal is to get the following result on
> another worksheet:
>
> =A0 =A0Order worksheet
>
> =A0 =A0 =A0A =A0 =A0 =A0 =A0 =A0B =A0 =A0 =A0 =A0 =A0 =A0 =A0 C
> =A0 =A01 Product =A0 =A01 =A0 =A0 =A0 =A0 =A0 =A0 =A0 2
> =A0 =A02 Fruit =A0 =A0 =A0 =A0 =A0 =A0 =A0Apple =A0 =A0 =A0 =A0 =A0 Orang=
e
> =A0 =A03 Vegetable =A0Potato =A0 =A0 =A0 =A0 =A0Tomato
>
> On the Order worksheet, the following formula is the one I'm using
> with an array:
>
> =A0 =A0{=3DIFERROR(INDEX(Data!$A$1:$C$5,MATCH(LARGE(IF(Data!$B$1:$B$5=3D
> $A2,Data!$C$1:$C$5,""),B$1),Data!$C$1:$C$5,0),1),"")}
>
> Does anyone know how to get the same result without using an array -
> even if it uses another function ?

Hello,

I suggest to use array functions to get your result right:
In sheet Data, enter into D1 "Type Rank" and into D2
=3DSUMPRODUCT(--($B2=3D$B$2:$B$999),--($C2<$C$2:$C$999))+SUMPRODUCT(--($B2=
=3D
$B$2:$B2),--($C2=3D$C$2:$C2))
and copy down.

Then you can array-enter in sheet Order into B2:
=3DINDEX(Data!$A$2:$A$999,MATCH($A2&"|"&B$1,Data!$B$2:$B$999&"|"&Data!$D
$2:$D$999,0))
and copy down and across.

If you like to compare with other approaches, test with Pounds data
like 1,1,1,1 or 0,0,0,0, for example.

Further examples you can find at
http://sulprobil.com/html/sorting.html

Regards,
Bernd
0
Bernd
6/3/2010 1:54:08 PM
On Jun 3, 9:54=A0am, Bernd P <bplumh...@gmail.com> wrote:
> On 3 Jun., 02:40, exceluser <ifmcqy7aias...@yahoo.com> wrote:
>
>
>
>
>
> > Can someone show me how to accomplish the following by using the LARGE
> > function "WITHOUT" using an array ?
>
> > I'm trying to rank each product (most, second most, etc.) by weight.
>
> > =A0 =A0Data worksheet
>
> > =A0 =A0 =A0A =A0 =A0 =A0 =A0 =A0B =A0 =A0 =A0 =A0 =A0 =A0 =A0 C
> > =A0 =A01 Product =A0 =A0Type =A0 =A0 =A0 =A0 =A0 =A0Pounds
> > =A0 =A02 Orange =A0 =A0 Fruit =A0 =A0 =A0 =A0 =A0 600
> > =A0 =A03 Tomato =A0 =A0 Vegetable =A0 =A0 =A0 =A0 =A0 =A0 =A0 500
> > =A0 =A04 Apple =A0 =A0 =A0 =A0 =A0 =A0 =A0Fruit =A0 =A0 =A0 =A0 =A0 700
> > =A0 =A05 Potato =A0 =A0 =A0 =A0 =A0 =A0 Vegetable =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 1,000
>
> > Using the LARGE function, the goal is to get the following result on
> > another worksheet:
>
> > =A0 =A0Order worksheet
>
> > =A0 =A0 =A0A =A0 =A0 =A0 =A0 =A0B =A0 =A0 =A0 =A0 =A0 =A0 =A0 C
> > =A0 =A01 Product =A0 =A01 =A0 =A0 =A0 =A0 =A0 =A0 =A0 2
> > =A0 =A02 Fruit =A0 =A0 =A0 =A0 =A0 =A0 =A0Apple =A0 =A0 =A0 =A0 =A0 Ora=
nge
> > =A0 =A03 Vegetable =A0Potato =A0 =A0 =A0 =A0 =A0Tomato
>
> > On the Order worksheet, the following formula is the one I'm using
> > with an array:
>
> > =A0 =A0{=3DIFERROR(INDEX(Data!$A$1:$C$5,MATCH(LARGE(IF(Data!$B$1:$B$5=
=3D
> > $A2,Data!$C$1:$C$5,""),B$1),Data!$C$1:$C$5,0),1),"")}
>
> > Does anyone know how to get the same result without using an array -
> > even if it uses another function ?
>
> Hello,
>
> I suggest to use array functions to get your result right:
> In sheet Data, enter into D1 "Type Rank" and into D2
> =3DSUMPRODUCT(--($B2=3D$B$2:$B$999),--($C2<$C$2:$C$999))+SUMPRODUCT(--($B=
2=3D
> $B$2:$B2),--($C2=3D$C$2:$C2))
> and copy down.
>
> Then you can array-enter in sheet Order into B2:
> =3DINDEX(Data!$A$2:$A$999,MATCH($A2&"|"&B$1,Data!$B$2:$B$999&"|"&Data!$D
> $2:$D$999,0))
> and copy down and across.
>
> If you like to compare with other approaches, test with Pounds data
> like 1,1,1,1 or 0,0,0,0, for example.
>
> Further examples you can find athttp://sulprobil.com/html/sorting.html
>
> Regards,
> Bernd- Hide quoted text -
>
> - Show quoted text -

Bernd,

   Thank you very much for that fast and very detailed response.

   The reason that I'm trying to avoid using an array is that the
sheer number of cells that would contain this formula (15,000+) would
cause my computer to lockup for over an hour and a half while it
recalculates.

   I recently replaced an array with a formula using the SUMIF
function and that rewrite alone reduced the calculation time from 2.5
hours to 1.5 hours.

   Now I'm just trying to eliminate that last 1.5 hours which is the
reason for my original post.

   It looks like I'll be able to avoid the array with the formula that
Steve suggested above.

   I also checked out your website and it was very helpful.

   Again, I appreciate the time you spent creating the solution above.




Exceluser

0
exceluser
6/4/2010 12:47:59 AM
On Jun 3, 8:52=A0am, "Steve Dunn" <st...@sky.com> wrote:
> If you need to allow for two products of the same weight and type, try th=
is:
>
> =3DIFERROR(INDEX(Data!$A$1:$A$10,MATCH(LARGE(INDEX(
> (Data!$B$2:$B$10=3D$A2)*Data!$C$2:$C$10+
> ROW(Data!$C$2:$C$10),),B$1),INDEX(Data!$C$2:$C$10+
> ROW(Data!$C$2:$C$10),),0)+1),"")
>
> "Steve Dunn" <st...@sky.com> wrote in message
>
> news:9F7E0B2D-7169-4572-8CE6-4E20C74D7864@microsoft.com...
>
>
>
> > Hi, this does not have to be array-entered, if that's what you mean.
>
> > =3DIFERROR(INDEX(Data!$A$1:$A$5,MATCH(LARGE(INDEX(
> > (Data!$B$2:$B$5=3D$A2)*Data!$C$2:$C$5,),B$1),Data!$C$1:$C$5,0)),"")
>
> > BTW, this (and your original) would fail if you had two products of the
> > same weight and type.
>
> > HTH
> > Steve D.
>
> > "exceluser" <ifmcqy7aias...@yahoo.com> wrote in message
> >news:4ed0be3e-3a9b-44eb-9b72-3561cfe9a088@u7g2000vbq.googlegroups.com...
> >> Can someone show me how to accomplish the following by using the LARGE
> >> function "WITHOUT" using an array ?
>
> >> I'm trying to rank each product (most, second most, etc.) by weight.
>
> >> =A0 Data worksheet
>
> >> =A0 =A0 A B C
> >> =A0 1 Product Type Pounds
> >> =A0 2 Orange Fruit 600
> >> =A0 3 Tomato Vegetable 500
> >> =A0 4 Apple Fruit 700
> >> =A0 5 Potato Vegetable 1,000
>
> >> Using the LARGE function, the goal is to get the following result on
> >> another worksheet:
>
> >> =A0 Order worksheet
>
> >> =A0 =A0 A B C
> >> =A0 1 Product 1 2
> >> =A0 2 Fruit Apple Orange
> >> =A0 3 Vegetable Potato Tomato
>
> >> On the Order worksheet, the following formula is the one I'm using
> >> with an array:
>
> >> =A0 {=3DIFERROR(INDEX(Data!$A$1:$C$5,MATCH(LARGE(IF(Data!$B$1:$B$5=3D
> >> $A2,Data!$C$1:$C$5,""),B$1),Data!$C$1:$C$5,0),1),"")}
>
> >> Does anyone know how to get the same result without using an array -
> >> even if it uses another function ?- Hide quoted text -
>
> - Show quoted text -

Steve,

   You are so THE MAN !

   It makes me almost forget that whole BP thing ... for a few hours
anyway.

   The reason why I wanted to avoid using an array was because the
original formula I was using with an array (in over 15,000 cells) was
using %100 of the CPU for approximately

90 minutes on an Intel 3.4 GHz processor with 2 GB of RAM.

   To make matters worse, new data is imported daily and making any
change effecting those cells would cause a 90 minute recalculation.

   This new formula has reduced the calculation from 90 minutes to
under 30 seconds.

   Could you explain why ... ?

	1) The second INDEX function skips the first row for 'Data!$B$2:$B$5
and 'Data!$C$2:$C$5 rather than using the whole column

	2) The second INDEX function multiplies those two ranges

   Thanks again for that super fast formula.



Exceluser
0
exceluser
6/4/2010 10:34:55 PM
On Jun 3, 8:52=A0am, "Steve Dunn" <st...@sky.com> wrote:
> If you need to allow for two products of the same weight and type, try th=
is:
>
> =3DIFERROR(INDEX(Data!$A$1:$A$10,MATCH(LARGE(INDEX(
> (Data!$B$2:$B$10=3D$A2)*Data!$C$2:$C$10+
> ROW(Data!$C$2:$C$10),),B$1),INDEX(Data!$C$2:$C$10+
> ROW(Data!$C$2:$C$10),),0)+1),"")
>
> "Steve Dunn" <st...@sky.com> wrote in message
>
> news:9F7E0B2D-7169-4572-8CE6-4E20C74D7864@microsoft.com...
>
>
>
> > Hi, this does not have to be array-entered, if that's what you mean.
>
> > =3DIFERROR(INDEX(Data!$A$1:$A$5,MATCH(LARGE(INDEX(
> > (Data!$B$2:$B$5=3D$A2)*Data!$C$2:$C$5,),B$1),Data!$C$1:$C$5,0)),"")
>
> > BTW, this (and your original) would fail if you had two products of the
> > same weight and type.
>
> > HTH
> > Steve D.
>
> > "exceluser" <ifmcqy7aias...@yahoo.com> wrote in message
> >news:4ed0be3e-3a9b-44eb-9b72-3561cfe9a088@u7g2000vbq.googlegroups.com...
> >> Can someone show me how to accomplish the following by using the LARGE
> >> function "WITHOUT" using an array ?
>
> >> I'm trying to rank each product (most, second most, etc.) by weight.
>
> >> =A0 Data worksheet
>
> >> =A0 =A0 A B C
> >> =A0 1 Product Type Pounds
> >> =A0 2 Orange Fruit 600
> >> =A0 3 Tomato Vegetable 500
> >> =A0 4 Apple Fruit 700
> >> =A0 5 Potato Vegetable 1,000
>
> >> Using the LARGE function, the goal is to get the following result on
> >> another worksheet:
>
> >> =A0 Order worksheet
>
> >> =A0 =A0 A B C
> >> =A0 1 Product 1 2
> >> =A0 2 Fruit Apple Orange
> >> =A0 3 Vegetable Potato Tomato
>
> >> On the Order worksheet, the following formula is the one I'm using
> >> with an array:
>
> >> =A0 {=3DIFERROR(INDEX(Data!$A$1:$C$5,MATCH(LARGE(IF(Data!$B$1:$B$5=3D
> >> $A2,Data!$C$1:$C$5,""),B$1),Data!$C$1:$C$5,0),1),"")}
>
> >> Does anyone know how to get the same result without using an array -
> >> even if it uses another function ?- Hide quoted text -
>
> - Show quoted text -

Steve,

   Is there a way to use the second formula when sorting with a mix of
positive and negative numbers ?




Exceluser
0
exceluser
6/5/2010 10:17:11 PM
Reply:

Similar Artilces:

How do I represent data in a cell as hexadecimal without converti.
I have a worksheet with hexadecimal data. I am trying to create a chart but the chart will not interpret hex numbers correctly. I know I can convert to decimal and do it that way. Is there a way I can tell Excel that the numbers in the cells are hex and have it plot it correctly? Hi AFAIK you have to convert them first to numerics before plotting them -- Regards Frank Kabel Frankfurt, Germany trosier wrote: > I have a worksheet with hexadecimal data. I am trying to create a > chart but the chart will not interpret hex numbers correctly. I know > I can convert to decimal and do ...

cancel parameter without error?
I cannot suppress the 2501 error message when cancelling the parameter input. Please help! Here is my code: Private Sub Command88_Click() On Error GoTo Err_Command88_Click Dim stDocName As String stDocName = "rptPrint_F_RecRpt_TransCksSingleCk" DoCmd.OpenReport stDocName, acViewPreview, , , acWindowNormal Exit_Command88_Click: Exit Sub Err_Command88_Click: If Err.Number = 2501 Then 'do nothing Else: MsgBox Err.Description Resume Exit_Command88_Click End If End Sub Hi, What is the recordsouce for the report? Is it a sav...

Excel Line Feed Character
imported Text in cells are formatted with 3 line feed characters. If you use clean it deletes the characters and puts the text into one line. I need to be able to delete the Chr(10) and keep the formatting by a macro if possible. This file is needed to be uploaded into SAP which doesn't like CHR(10). Presently the only way to do this is to go to the end of each line and manually delete the three CHR(10) and all works well as the formatting stays the same. I have tried Substitute and Find and replace but it always ends up in single line.... Hope someone can help.... Thanks Rob ...

Document library without top link bar and quick launch menu: how?
Hi All, is it possible to create a link to a document library that is going to show just the document library without the "master page" border??? I mean without quick launch menu and top link bar..... I'm working with MOSS 2007 and 2010 beta... any suggestion will be good ;) thanks Vit Using SharePoint Designer you can attach a specific master page to it and disable the navigation elements you don't want. Be advised, however, that you now will be taking your users to a place they can't navigate out of. Would you be better served placing a list v...

Can I automatically resize all controls in a Dialog without adding user codes
Dear All, Can I design a Dialog that automatically resizes all controls when the Dialog is being resized? Many thanks, Yes. You can resize or move them as you wish by handling OnSize of the dialog. SetWindowPos can be used to change the size and/or position. Here is a helpful link: http://www.codeproject.com/dialog/resizabledialog.asp --- Ajay No. You must explicitly take action on the OnSize handler to resize them. Sometimes, there are packages called "geometry managers" that make this fairly straightforward (check www.codeproject.com and www.codeguru.com for examples)...

Help with tracking user without enforcing security
I know that the best way to track who is in the db is to enforce security. However, I am in a situation where the client does not want the security to be enforced at least right now. since we will have to keep another file (.mdw) on the network. Is there a way to track few users (5 max) in access through code? I have a login form that has 2 text boxes, one for the user ID and the other for the password. I have a table called tblUserLog that every time a user logsin, a new record is created in that table keeping the login ID and date/time. The login form fires the code in the after updat...

Can we use ReportServerCredentials without passing domain name
Hi, I am using ReportingService2005 web service through my asp.net application. It is running fine at my machine but when using this web service through remote server it is giving error "An error has occurred during report processing. The data source 'Live_DB_VAR' cannot be found. ". However, I am passing credentials only user name and password but the problem is that remote machine does not come under any domain. So any body could help me that how can I pass ReportServerCredentials without domain. Thanks, Anurag Report Data Sources can be configured with ...

Changing User Information without SA
Hello All, We're currently using GP 9.0 where I work (I'm the DBA) and we want to migrate these databases to a SQL 2005 cluster (these databases currently sit on a SQL 2000 stand-alone). These databases will be moving to cluster nodes that have other databases that are critical to our environment and we would like to limit the use of SA to strictly IT internally. My question: In PDK is there any way to allow GP users (employees) to modify other user information within the System -> User screen. For example: Someone logs in with their own GP account and wants to change tha...

sum doesn't update total without double-click of cell
In a spreadsheet, using formula like "A1 + B1" to get the sum of values in cells A1 and B1 to show in a third cell. The total in the third cell does not update automatically after changing the value in one of the two cells (e.g., A1). Only after double-clicking the third cell, is the proper total displayed. Any ideas why this is happening? Set your calculations to automatic under tools>options>calculations -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "David E. Gross" <David E. Gro...

putting a picture onto a userform without using the vba window.
I have userforms which I activate to show text information. I would like to be able to paste a picture from the clipboard onto an opened userform so that there is a picture as well as text. The picture would be a copied picture from the web or a copied wmf from another application Traditionally the way to do this is through the vba window by using the image control and navigating it to a saved image or alternatively pasting the image into the picture line of the Image Properties box. This is too complicated for a user of my spreadsheet to do so I am looking for alternativ...

Pivot Table update without opening the Excel file.
Hi, I have a spreadsheet saved as an xlt. It has three pivot tables which connect to CSV data files using Microsoft Text Driver. The CSV files are updated overnight by an external application. The Excel file is in \\Server\Viewers The Data files are in \\Server\Data Local users use a shortcut to open the Excel file on \\Server\Viewers which the does an auto-update from the CSV files. The pivot table data is updated. All that has been working perfectly for years, internally. Now I need to send the same excel file to another company by email. I have succeeded in writing a vbscript that creates...

Compress excel without using additional software
Hi, Is it possible to compress Excel without installing any additional software or writing any programs? Thanks for your help! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ "nylecaj" <nylecaj.v2iyi@excelforum-nospam.com> wrote... >Is it possible to compress Excel without installing any additional >software or writing any programs? The compression capabilities built into NTFS file systems are adequate for your needs? Direct answer: no. ...

DPM 2010 RC grows disk allocation without 'auto grow'
I backup a Hyper-V (R2) VM with 65GB fixed size hard disk in a protection group without 'auto grow'; i reserved 75GB for Replica Volume and 5GB for Recovery point; after synchronisation DPM automatically grows the reservered space to 99,75GB for replica and 48,12B for recovery points. How can i prevent the growth? You can modify the protection to group to achieve, in the modification flow you will be given option to select/un select the auto grow feature. Thanks, Praveen D [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights. &...

How do I convert works file to excel without works software?
I received a copy of information needed in microsoft works file. Microsoft works is not in my computer and I'd like to open in excel rather than having to manually put data into my system. Under excel help it seems you have to open in works and then save as excel file. Since works is not on my computer, I can't open the file. You need to get a hold of someone who has works and can save it in the correct format or get a commercial converter Regards, Peo Sjoblom "CatMB" wrote: > I received a copy of information needed in microsoft works file. Microsoft > wo...

Sending an email from another mailbox WITHOUT the "sent on behalf
Our Library has a mailbox and the administrators in the library have their own mailbox. I have Outlook 2003 on their PCs setup to access the Library mailbox with owner rights from their mailboxes. When the send email from the Library mailbox, the email header says 'username ON BEHALF OF LIBRARY." They do not want that. They just want it to say LIBRARY. How can I get this result? We have Exchange 2003. Thanks. they also need to have the "Send as" permission...on the security tab... -- Susan Conkey [MVP] "Saucer Man" <SaucerMan@discussions.micros...

How do I add 12 out of 18 numbers without using sort to get them .
The list are scores that need to be kept in order. I need to be able to add the best 12 numbers to provide a score at the end of the year. Can anyone help? Hi Tas Checkout =LARGE in help. That may give you a clue. John North Yorkshire UK "Tas" <Tas@discussions.microsoft.com> wrote in message news:4E76B260-9F57-4BCB-93BF-051C1B6207EE@microsoft.com... > The list are scores that need to be kept in order. I need to be able to > add > the best 12 numbers to provide a score at the end of the year. > > Can anyone help? On Fri, 17 Sep 2004 02:25:07 -0700, Ta...

filter a form without opeing it
is it possible to edit a record with the event procedure of a control on a form that is completely seperate from the source of the record if the source of the record is not open? for example, I have a form with only a textbox where I scan a barcode (Tracking number). On enter it should filter another form, which is not open, for that tracking number. I was thinking about making the form a subform in the form where I scan the barcode, but if I can do it without having to open the form I would rather do that. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.asp...

How to not see "on behalf of" in Outlook 2002 without Exchange
I have multiple email accounts in my Outlook 2002 setup. When I send email from an account that is not the default account the From field shows "From me@myisp.com on behalf of notme@notmy.isp.com". I there a way that all email accounts send using their own name and not the name of the default account? I do not use MS Exchange. Thanks You shouldn't see that behavior if you use the Accounts button on the toolbar to choose the sending mail account instead of the From field on the new message form. -- Jocelyn Fiorello MVP - Outlook *** Messages sent to my e-mail address wil...

Change Header on Multiple Sheets without Changing Other Formatting
Hello I have a file with sheets that have the same header. Each tab has specific page setup formatting that I need to keep intact. I tried highlighting all tabs and changing the header via page setup but the other page setup formatting changed to the formatting of the first sheet. Is there a way to add the header I would like to put on all tabs to the header drop down menu on header/footer tab in page setup. Thanks Only through VBA. Sub Text_In_AllFooters() Dim WS As Worksheet For Each WS In ActiveWorkbook.Sheets WS.PageSetup.CenterHeader = "Some te...

Scatter chart without connecting lines?
Could someone please help me out with my XY (Scatter) Chart? I've use the wizard (want to get it right then make a macro) and chosen the dat points connected by a smoothed line type. Using the data below with the Perc on the Y axis and the Dates acros the bottom, I can plot the data points correctly for each series bu they do not show the connecting line. Can someone please tell me ho to make these lines connected? Or even how I go about using a lin graph to display the data below? Thanks greatly in advance :) Batty Perc Series1 Series2 0 1/11/2004 11/11/2004 5 1...

How to Save Email, without extra folder being created
Whenever I try to save an email in Outlook 2007 to a customer file, an additional folder gets created. Is there a way around this. It looks like saving it as an .mht file, but is there a way to have outlook 2007 automatically default to this save as type? No, you cant pick a default save as type, but you might be able to use VBA to automate it. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Outlook Tips by email: mailto:dailytips-subscribe-request@lists.outlooktips.net EMO - a weekly newsle...

Inbound Email Tracking without Token?
This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C7335B.02B40060 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is this possible? Have a client who is very sensitive about the = appearance of the e-mails and does not like the token. All clients have = an e-mail and they only send to clients so there is always a e-mail on = record for inbound e-mails to resolve against. Alan ------=_NextPart_000_0019_01C7335B.02B40060 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-pri...

Reporting on Custom Fields without Crystal Enterprise
I would like to know if it is possible to report on custom MSCRM fields without Crystal Enterprise? Reading the Microsoft Reports FAQ says to log onto Crystal Enterprise and update the available fields by verifying the database. I do not have Crystal Enterprise on my computer so verifying the database throws errors. I have been modifying the standard MSCRM Crystal reports and then importing them using MSCRM Report Manager. This has worked fine but doesn’t allow me to report on custom fields. Is there a work around for reporting custom fields if you do not have Crystal Enterprise? ...

How get to end of document without scrolling?
How get to end of document without scrolling quickly? Ctrl + End -- Regards, Peo Sjoblom "cb" <cb@discussions.microsoft.com> wrote in message news:71E71871-C5BD-4100-8B34-39D6A81ED8F6@microsoft.com... > How get to end of document without scrolling quickly? THANKS IT TAKES ME TO THE RIGHT i NEED TO GO TO THE BOTTOM OF LIKE 600 ROWS "Peo Sjoblom" wrote: > Ctrl + End > > > -- > > > Regards, > > > Peo Sjoblom > > > "cb" <cb@discussions.microsoft.com> wrote in message > news:71E71871-C...

Logon to OWA without domain name
Is there a way to setup my OWA so that I can type just the username, instead of domain\username? "Tim Kowal" <tim@nospam.com> wrote in message news:gz2Dc.2397$pT3.482@newssvr27.news.prodigy.com... > Is there a way to setup my OWA so that I can type just the username, instead > of domain\username? You need to set the Default Authentication Domain (click the button next to 'Basic Authentication') for the 'Exchange' Virtual Directory in IIS Manager. Lee. -- _______________________________________ Outlook Web Access For PDA , OWA For WAP: www.leederby...