Free Microsoft Excel 2013 Quick Reference

Using dget in a table Results

I am trying to use DGET in a table of information. Where column 'a' functions as the criteria and gets evaluated in another column for each row in the table. Can this be done.

It would probably make more sense just looking at the sample. The first two columns is the data table. The other little table tries to access the data table using DGET.

I want to add a reminder line to my excel workpage. I have a list of dates
that I have certain appointments, also I have a countdown of the number of
days until that appointment. All of this data is already in a table. What I
need it to do is to count the number of appointments I have in the next 7
days. When using the dget or the dsum, I get an error #VALUE

Database: SST (name of the range the database is in)
Field: 3
Criteria: <7

In the criteria line, it wants text, I dont understand why it wont take a
number when a number is what I am looking for.

Any help would be appreciated

Hi there,

I was wondering if anyone could give me some pointers as to where to
start with the following?

I have a spreadsheet of data in a table. One of the fields is date. I
would like the user to be able to enter a date range and have all the
records returned that fall within that range.

What function should I use for that? DGET can only return one record.
Could I use something like VLOOKUP in an array? The number of records
returned will obviously change depending on the date range entered.

Or, should I use something like a VBA loop?

I need to do this in Excel - it can't be in Access.

Any help would be much appreciated.

Many thanks - David

I want to add a reminder line to my excel workpage. I have a list of dates
that I have certain appointments, also I have a countdown of the number of
days until that appointment. All of this data is already in a table. What I
need it to do is to count the number of appointments I have in the next 7
days. When using the dget or the dsum, I get an error #VALUE

Database: SST (name of the range the database is in)
Field: 3
Criteria: <7

In the criteria line, it wants text, I dont understand why it wont take a
number when a number is what I am looking for.

Any help would be appreciated

I want to use the DGET function to populate a results table in an excel spreadsheet. Two of the "criteria" I'm using for the DGET function will be stored in the first row and first column of the output table. Unfortunately, it looks like DGET requires a contiguous array to be used as the "criteria" input. I have tried using an array constant (i.e. a hardcoded array using curly braces {}), but am getting errors. There seem to be two separate problems occurring:
1. The DGET function returns an error when I try to use an array constant
2. I don't think array constants can contain cell references; they literally have to be constants.

Any input will be greatly appreciated. I've attached a spreadsheet showing an example of the problem.

Thanks!

Hi,

I'm new to the forum although I'm a great fan of the news letter. Reading thro' it I learnt that using DGet instead of VLookup will speed up my spread sheets. The question is how to use DGet.
I have 2 big tables. In Table 1 I have the Customers details; for every register I have a unique Customer number. In the other, Table 2, I have only the Customer number and the VLookup formula fills in some of the data that is in Table 1.
Can I accomplish the same task with DGet?

Thanks in advance.

:P Okay, I'm sorry If this has been answered before, but, I'm really stuck with where I should begin. I have been tracking objects over time and I get the data in an excel spreadsheet in a format like:

[object] [time] [velocity]
1 35 5
1 61 2
1 95 55
1 123 8
3 211 47
3 243 32
3 275 5
4 61 27
4 93 17
4 126 59
4 151 6
4 172 23

i have hundreds of objects that i have tracked and i want to use excel to help me quickly analyze this data.

i would like to have a table with

[object] [lifetime of the object] [max velocity]
1 =123-35 =55
2
3 =275-211 =47
4 =172-61 =59

where the lifetime of the object is the time in the column of corresponding to the last data for the object-the time for the first data for the corresponding object.

i hope this is an accurate explanation of what i want to do, and i hope there is someone out there who can help me or can at least point me in the right direction!

thanks so much for taking the time to read this!

oh, and if it helps im using the mac osx version of excel.

I have a sheet within a workbook which has a summary of all employees current salaries. The first column is the employee name and the subsequent columns are salary by month. The difficulty is that the column will only have a value if there has been a raise applied. (In my case it never seems to appear). I need to find the highest value for and employee and a month. Below is the sample:
******** ******************** ************************************************************************>Microsoft Excel - nameswages.xls___Running: xl2000 : OS = Windows Windows 2000 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutB4=
ABCDEFGHIJKLM1*1234567891011122Alan$45$57***$84******3Bill$37*$49*$78*******4Celine************5Max$61**$59********names*
[HtmlMaker 2.20] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

I would like to know the value of Alan in month 3(Column D)His last raise was in month 2. I was trying to use max value but the range is going to vary as managers look up employees and change dates. This is further complicated by the fact that we may have values in months in the future, so I can't set the range to automatically look across the entire spectrum. I tried DGET but can't get past the blank cell value. Anyone have any ideas.

Dear Bernie:

I have the correct formula but for some reason it is pulling in a number
from the same row but a different month in column K. I have double and
triple checked my formula. Does it have something to do with the OFFSET or
MATCH portion of this formula? I can’t figure it out. Does It have
something to do with the last portion (i.e. !$1:$1,False)-1)) Thank you in
advance.

=SUMPRODUCT(('[Book Name.xls]Sheet Name'!$A$1:$A$1000=$A$2)*('[Book
Name.xls]Sheet Name'!$B$1:$B$1000=$B$2),OFFSET('[Book Name.xls]Sheet
Name'!$A$1:$A$1000,0,MATCH($C$1,'[Book Name.xls]Sheet Name'!$1:$1,FALSE)-1))

"Leslie" wrote:

> Sorry, did you see this part of my earlier question?
>
> Another question, The reason I need
> > this > formula is because I'm creating other workbooks which will each be various
> > subsets of this worksheet. How does the other worksheet know to pull for
> > company A, FY 2004 in July instead of company C, FY 2005 for July? I
> > can't tell from the formula
>
> "Bernie Deitrick" wrote:
>
> > > If the labels are in the first row, instead of A1,
> > > A2 and A3 don't you mean A1, B1, C1.
> >
> > No, not really. Those are the cells that contain the key values that you
> > want to extract from your database, and are on the same sheet as your
> > formula. They _could_ be in A1, B1, and C1, so you would change the formula
> > to
> >
> > =SUMPRODUCT(('[Book Name.xls]Sheet name'!A1:A1000=A1)*('[Book Name.xls]Sheet
> > name'!B1:B1000=B1),OFFSET('[Book Name.xls]Sheet
> > name'!A1:A1000,0,MATCH(C1,'[Book Name.xls]Sheet name'!1:1,FALSE)-1))
> >
> > This part ensures that only the correct company is pulled:
> >
> > ('[Book Name.xls]Sheet name'!A1:A1000=A1)
> >
> > This part ensure that only the correct FY is pulled
> >
> > ('[Book Name.xls]Sheet name'!B1:B1000=B1)
> >
> > and this part finds the correct month:
> >
> > MATCH(C1,'[Book Name.xls]Sheet name'!1:1,FALSE)
> >
> > and this part is pulls in the actual data:
> >
> > OFFSET('[Book Name.xls]Sheet name'!A1:A1000,0,MATCH(C1,'[Book Name.xls]Sheet
> > name'!1:1,FALSE)-1))
> >
> > It's a complex formula, but you have a complex problem.
> >
> > If you don't want to use a formula, you could use a pivot table, but then
> > you would need to use a database rather than a cross-tab table, which would
> > look like:
> >
> > Company FY Month Amt.
> > A FY 2005 Jly. $6,502.20
> > A FY 2005 Aug. $9,899.43
> > A FY 2005 Sep. $28,916.10
> > etc....
> >
> > HTH,
> > Bernie
> > MS Excel MVP
> >
> >
> > "Leslie" <Leslie@discussions.microsoft.com> wrote in message
> > news:39936A5E-B68B-4546-B993-141B267490C8@microsoft.com...
> > > Thank you for your reply. If the labels are in the first row, instead of
> > > A1,
> > > A2 and A3 don't you mean A1, B1, C1. I'm new using these functions so any
> > > further explanation is appreciated. Another question, The reason I need
> > > this
> > > formula is because I'm creating other workbooks which will each be various
> > > subsets of this worksheet. How does the other worksheet know to pull for
> > > company A, FY 2004 in July instead of company C, FY 2005 for July? I
> > > can't
> > > tell from the formula. Thanks again.
> >
> >
> >

I am wanting to replace some VLookup formulas with the DGet function but cannot get the DGet to work. The syntax seems simple enough but all I get is #N/A errors. The criteria exist in the database range, are not duplicated and I am trying to retrieve the value from the second column of the database range as such:

=DGET(E6:F500,2,I2:I500)

A possible complexity is that the database range is actually part of a pivot table and that I cannot use headings for the columns, or is it simply that you cannot use DGET when your criteria is a long list rather than just a heading and one criteria value?

Any suggestions would be appreciated.

Hi,
I have table which contents the detailed recept of matl.
Now, I have another summery sheet in the same file. I wish to pull the
latest purchased rate of specific items. I have tried this by using DGET /
DMAX function.
but it gives results for only on single items.
for, your ref. i am providing herewith the summery sheet
im_code (DESIRED OUTPUT)
ATM0093 =DGET(GIN!A:BV,"IM_INVRT",$A$1:$A$7)
ATM0094 =DGET(GIN!A:BV,"IM_INVRT",$A$1:$A$7)
PTM0748 =DGET(GIN!A:BV,"IM_INVRT",$A$1:$A$7)
ATM0576 =DGET(GIN!A:BV,"IM_INVRT",$A$1:$A$7)
ATM0577 =DGET(GIN!A:BV,"IM_INVRT",$A$1:$A$7)
ATM0579 =DGET(GIN!A:BV,"IM_INVRT",$A$1:$A$7)
but the value returns #NUM!
Is there any way to give condition in this like
=DGET(GIN!A:BV,"IM_INVRT",$A$1,$A$5)
that means the crietria would be col. heading & the specific row no.

--
Thanks,
Vikram P. Dhemare

Hey, I'm having trouble getting this to work right. I'm not tremendously experienced with Excel, nor have a wide knowledge of its functions. I do have some (pretty basic) programming background with Visual and MATLAB etc. (through my engineering studies). But here is my problem:

I'm trying to pull a "Role" from a table, using the criteria of "Name" and "Date", the table is set up something like this:

Table 1
Name	Role	         Start Date	End Date
Joe	Labourer 1	January-01-10	June-01-10
Joe	Labourer 2	June-02-10	December-01-10
Jim	Labourer 2	January-01-10	December-01-10
Jarrod	Labourer 3	January-01-10	December-01-10
Then I will try to pull the "Role" as the output of some function of "Name" and "Date" given Like this:

Table 2
Name	Date	         Role
Joe	February-01-10	*OUTPUT*
Where the Role is determined by where it falls on the table, like Start Date < Date < End Date, and of course by the name.

I've been tinkering around with INDEX, VLOOKUP, IF, MATCH, and arrays, but I can't seem to get it to works. My algorithm for doing this has kinda been all over the place too. Am I heading in the right direction at least?

EDIT:

I've also been looking into making table 1 contain only "Effective Date" or "Date" using only 1 number and using DGET with criteria being ">=Date" or something...

I am trying to return the winner name from a data set. I have a set of teams, a list of activities in which they earn points, a calculation for team total and personal totals and areas of summarizing the max number of any item (for example to highest total number accomplished by any one individual).

What I need, and can't seem to get to work, is an equation to look up the highest number accomplished by any one person (this will be set up as an equation in one cell using the MAX function), & compare it against the data table to see which row/person/value corresponds to that value (if for example, 8 is the highest anyone got, find the record with the 8 in it- oh, I should mention here that the table I am pulling these from is a reference to the original data values since those are set up to look nice, and the table is set up so there are no blank spaces in between them) and then to find the adjacent row that has the data label (in this case, the name of the person who got the 8- for example John Smith). This is the value I would like to be returned as the result. I am using Excel from Office 2007 if that helps, and I have tried DGET, LOOKUP, MATCH, OFFSET and many combinations of these- most return a #NA value or a 0 value.

If anyone can figure this out, I would really appreciate it!!!

I'm note sure what to use here.

******** ******************** ************************************************************************>Microsoft Excel - Book1___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=
ABCDEFGHI1DateQtyRun_NoStatusWeight  Run_NoDate21/31/0851x   21/1/0832/15/0863    3Open41/1/08152xR  12/28/0853/17/08182      62/28/08221wR    71/1/08993x     82/15/08751e     Sheet1 
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

I need a formula in I2 thru I4 that will find an "R" in the weight column and return the appropriate date for the certain run_no. If there is no ""R" then return Open

Thanks,

Ross

Got a head scratcher. I have a list of prices and dates. I'm using a
DMAX function to get the highest price for each month, which works just
fine.

But, I want to lookup the result of the DMAX function and return the
date. That way I have a list of months, the high price and the date
that price came from. Problem is, in the whole table there are multiple
prices that are the same, so I get a #NUM error if I use DGET, or
vlookup just returns the first one.

How can I set the lookup table to check the original date criteria and
only lookup in a part of the overall table?

--
Chiba
------------------------------------------------------------------------
Chiba's Profile: http://www.excelforum.com/member.php...o&userid=24998
View this thread: http://www.excelforum.com/showthread...hreadid=385264

Although I like a lot the way that Excel handles data analysis (and
especially the Pivot Tables) I think that there is still significant "room"
for improvement.

Here is what I suggest:

Regarding FILTERS we need the following improvements on functionality and
ergonomy:

1) to be able to formulate more than 2 conditions - probably 10 would be ok;
I know that this could be accomplished by using Advanced Filter but this is
very time-consuming
2) possibility to create conditions that relate current cell with the
coresponding cell from other column
3) to filter after more than one value and on multiple columns when we click
on "AutoFilter" icon - according to the cells we have selected while keeping
CTRL pressed
4) to obtain a "Show excluding" filter when we click on "AutoFilter" icon
while pressing Shift
5) a corresponding button to "Show All" which enables us to remove only the
filter of the current column (or selected columns) - a shortcut key like F6
would also be very useful - so if we have 5 active filters we could easily
cancel one and keep the other 4
6) to be able to see (and activate) each one of the last 10 different filter
conditions used when we click on the filter arrow attached to the header cell
of a filtered column - this could be shown either on the left or the right
side
7) to be able to save and load certain set of filters - this is very
important when you work with more than 3 custom filters and occasionally
press "Show All" or when you need to switch between different sets of filters
8) to view the current filter condition when we float the mouse pointer over
the column's header cell
9) enhanced visibility for the active filters - not only the small blue
arrow on the grey square

Regarding PIVOT TABLES:

1) to save the pivot table "settings" in order to be able to switch quickly
from one "look" to another - I often have to make at least 4 different copies
of the same pivot in order to quickly show the desired aspects of different
analysis (on the same data set) to my superiors
2) when we make a copy of one pivot table in the same workbook Excel should
base the new pivot, by default, on the "database" used by the original pivot;
3) when we double-click on one of the detail fields the new sheet that
appears should keep the same formatting as the "database" sheet; by
formatting I also refer to the settings like Group/Ungroup and Freeze Panes
4) it is extremely necessary to have a function that allows us to copy the
data from the TOTAL field in a pivot table to a special field in the pivot's
"database"; this would help us when we need to group the data we analyse in
different categories according to the sum in that speciffic field - one usage
is when we need to separate the products that were sold above a minimum
value (or quantity); at this time we can only run a very slow SUMIF on all
data or a VLOOKUP over the pivot
5) there are many situations when our pivot table is based on an enormous
database but we only need to study just a part of it at a time - it would
help us a lot to be able to automatically generate a pivot table with the
same design as the main pivot but based on our specific selection from it
6) each pivot table should be able to auto-freeze its header according to
the changes we brought to its page, column, row and data fields

Other issues:

1) the status bar should be able to display simultaneously at least 3
informations chosen by user: SUM, COUNT and NO DUPLICATES (something like
MODE function) would be a good default option
2) we need an enhanced VLOOKUP function that would be able to search in a
database by more that one single criteria (example: NAME + SURNAME) and to
return more than one field (example: AGE, COUNTRY, SALARY, JOB); I know that
multi-criterial search could be accomplished through DGET but this works only
for one record at a time
3) we need to have an option that would automatically re-order the columns
on a second table based on the columns in the master table. This is extremely
useful when you have to append periodically some data to an existing table or
to merge two tables in order to run an agregated pivot. Please note that this
can't be achieved through horizontal sort since the header of a table isn't
usually sorted alphabetically.

Above is what I consider that would help me, my colleagues and a lot of
power users that I know to use Excel more efficiently. Please let me know
what do you think about my suggestions.

Thank you very much for your attention.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Sorry, did you see this part of my earlier question?

Another question, The reason I need
> this > formula is because I'm creating other workbooks which will each be various
> subsets of this worksheet. How does the other worksheet know to pull for
> company A, FY 2004 in July instead of company C, FY 2005 for July? I
> can't tell from the formula

"Bernie Deitrick" wrote:

> > If the labels are in the first row, instead of A1,
> > A2 and A3 don't you mean A1, B1, C1.
>
> No, not really. Those are the cells that contain the key values that you
> want to extract from your database, and are on the same sheet as your
> formula. They _could_ be in A1, B1, and C1, so you would change the formula
> to
>
> =SUMPRODUCT(('[Book Name.xls]Sheet name'!A1:A1000=A1)*('[Book Name.xls]Sheet
> name'!B1:B1000=B1),OFFSET('[Book Name.xls]Sheet
> name'!A1:A1000,0,MATCH(C1,'[Book Name.xls]Sheet name'!1:1,FALSE)-1))
>
> This part ensures that only the correct company is pulled:
>
> ('[Book Name.xls]Sheet name'!A1:A1000=A1)
>
> This part ensure that only the correct FY is pulled
>
> ('[Book Name.xls]Sheet name'!B1:B1000=B1)
>
> and this part finds the correct month:
>
> MATCH(C1,'[Book Name.xls]Sheet name'!1:1,FALSE)
>
> and this part is pulls in the actual data:
>
> OFFSET('[Book Name.xls]Sheet name'!A1:A1000,0,MATCH(C1,'[Book Name.xls]Sheet
> name'!1:1,FALSE)-1))
>
> It's a complex formula, but you have a complex problem.
>
> If you don't want to use a formula, you could use a pivot table, but then
> you would need to use a database rather than a cross-tab table, which would
> look like:
>
> Company FY Month Amt.
> A FY 2005 Jly. $6,502.20
> A FY 2005 Aug. $9,899.43
> A FY 2005 Sep. $28,916.10
> etc....
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "Leslie" <Leslie@discussions.microsoft.com> wrote in message
> news:39936A5E-B68B-4546-B993-141B267490C8@microsoft.com...
> > Thank you for your reply. If the labels are in the first row, instead of
> > A1,
> > A2 and A3 don't you mean A1, B1, C1. I'm new using these functions so any
> > further explanation is appreciated. Another question, The reason I need
> > this
> > formula is because I'm creating other workbooks which will each be various
> > subsets of this worksheet. How does the other worksheet know to pull for
> > company A, FY 2004 in July instead of company C, FY 2005 for July? I
> > can't
> > tell from the formula. Thanks again.
>
>
>

I am using DGET to look through a table. First there is a dropdown box that has the values of column B to choose from. Once you choose... It plugs in the rest of the information from that row to the cells scattered around the sheet where they belong. The problem comes up when there are items in column B that are identicle. Since the rest of the data on the row is unique to the other cells in the row with the identicle data in column B. The easiest way I can think of to bypass this problem would be to find a way to search all of column B of the worksheet "Data2" and on the first instacce of duplicate text, add a character such as "*". on the next duplicate add "**" Im not sure if this is even possible so Im open to any ideas or suggestions.

for example

column B column C
test one
test two
test three
real one

so I would need B1 to stay test
B2 to become test *
B3 to become test**

thanks in advance to anyone taking the time to try this

I have racked my brain with this one although im sure its easy for many of you. I am using DGET to look through a tables. First there is a dropdown box that has the values of column B to choose from. Once you choose... It plugs in the rest of the information from that row to the cells scattered around the sheet where they belong. The problem came up when there are items in column B that are identicle. Since the rest of the data on the row is unique to the other cells in the row with the identicle data in column B. The easiest way I can think of to bypass this problem would be to find a way to search all of column B of the worksheet "Data2" and onthe first duplicate cell add a character such as "*". on the next duplicate add "**"

for example

column B coulmn C
test one
test two
test three
real one

so I would need row 1 coulmn B to stay test
row 2 column B to become test *
row 3 coulmn B to become test**

thanks in advance to anyone taking the time to try this

Although I like a lot the way that Excel handles data analysis (and
especially the Pivot Tables) I think that there is still significant "room"
for improvement.

Here is what I suggest:

Regarding FILTERS we need the following improvements on functionality and
ergonomy:

1) to be able to formulate more than 2 conditions - probably 10 would be ok;
I know that this could be accomplished by using Advanced Filter but this is
very time-consuming
2) possibility to create conditions that relate current cell with the
coresponding cell from other column
3) to filter after more than one value and on multiple columns when we click
on "AutoFilter" icon - according to the cells we have selected while keeping
CTRL pressed
4) to obtain a "Show excluding" filter when we click on "AutoFilter" icon
while pressing Shift
5) a corresponding button to "Show All" which enables us to remove only the
filter of the current column (or selected columns) - a shortcut key like F6
would also be very useful - so if we have 5 active filters we could easily
cancel one and keep the other 4
6) to be able to see (and activate) each one of the last 10 different filter
conditions used when we click on the filter arrow attached to the header cell
of a filtered column - this could be shown either on the left or the right
side
7) to be able to save and load certain set of filters - this is very
important when you work with more than 3 custom filters and occasionally
press "Show All" or when you need to switch between different sets of filters
8) to view the current filter condition when we float the mouse pointer over
the column's header cell
9) enhanced visibility for the active filters - not only the small blue
arrow on the grey square

Regarding PIVOT TABLES:

1) to save the pivot table "settings" in order to be able to switch quickly
from one "look" to another - I often have to make at least 4 different copies
of the same pivot in order to quickly show the desired aspects of different
analysis (on the same data set) to my superiors
2) when we make a copy of one pivot table in the same workbook Excel should
base the new pivot, by default, on the "database" used by the original pivot;
3) when we double-click on one of the detail fields the new sheet that
appears should keep the same formatting as the "database" sheet; by
formatting I also refer to the settings like Group/Ungroup and Freeze Panes
4) it is extremely necessary to have a function that allows us to copy the
data from the TOTAL field in a pivot table to a special field in the pivot's
"database"; this would help us when we need to group the data we analyse in
different categories according to the sum in that speciffic field - one usage
is when we need to separate the products that were sold above a minimum
value (or quantity); at this time we can only run a very slow SUMIF on all
data or a VLOOKUP over the pivot
5) there are many situations when our pivot table is based on an enormous
database but we only need to study just a part of it at a time - it would
help us a lot to be able to automatically generate a pivot table with the
same design as the main pivot but based on our specific selection from it
6) each pivot table should be able to auto-freeze its header according to
the changes we brought to its page, column, row and data fields

Other issues:

1) the status bar should be able to display simultaneously at least 3
informations chosen by user: SUM, COUNT and NO DUPLICATES (something like
MODE function) would be a good default option
2) we need an enhanced VLOOKUP function that would be able to search in a
database by more that one single criteria (example: NAME + SURNAME) and to
return more than one field (example: AGE, COUNTRY, SALARY, JOB); I know that
multi-criterial search could be accomplished through DGET but this works only
for one record at a time
3) we need to have an option that would automatically re-order the columns
on a second table based on the columns in the master table. This is extremely
useful when you have to append periodically some data to an existing table or
to merge two tables in order to run an agregated pivot. Please note that this
can't be achieved through horizontal sort since the header of a table isn't
usually sorted alphabetically.

Above is what I consider that would help me, my colleagues and a lot of
power users that I know to use Excel more efficiently. Please let me know
what do you think about my suggestions.

Thank you very much for your attention.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc


No luck finding an answer? You could always try Google.