In each application (Workbook) I need to get the customer from the customer workbook.

I have tested:

On opening a Workbook app I copy the most recent customer list from CUSTOMERS.XLSX to the workbook and use DGET to retrieve the correct record from the copied customer list. However, DGET loses the connection to the customer range/table name every time I update the list. The DGET function looks like

=DGET(tCUSTOMERS[ALL#];B1;$A1:$R2),

where tCUSTOMERS is the table I have just copied.

Can I use SQL instead to retrieve one specific record from the customer list in the closed CUSTOMERS.xlsx?

Probably easily, but I haven’t so far found any example on the net. Thankful for any advice.

/Håkan

]]>

Please forward me the paper titled "The Role of Household-Level Characteristics in Predicting the Unbanked in Rural India: A Comparison of Eastern and Western Regions"

]]>

Thanks for the help! ]]>

I have been stuck trying to create a formula for my spreadsheet and was praying that someone could help me. I have spent hours on google searches trying to come up with this formula and I've had no luck.

Cell A11 = Maximum Commission

Cell A13 = Minimum Commission

Cell A9 = Commission Amount (%)

Cell I2 = Loan Amount

I am a lender and I am trying to create a formula that calculates the amount of commission I'll receive on a loan. I have a minimum and maximum commission that I receive as well.

I have tried the IF functions for maximum and minimum but I am having difficulty combining those functions into the same field.

I wanted a function that stated;

Loan amount * Commission Amount = Commission with a Max commission amount and minimum commission amount.

Can someone please help me out with this!?

THANK YOU SO MUCH!!!! ]]>

In Excel 2007 using a Font called 3 of 9 Barcode, we have for years been using this successfully for part numbers or employee numbers which have only ever had single string of characters, i.e. ="*"&B5&"*". My problem is with our location labels. They have 3 levels of characters, i.e., WHSE B01 A05..

On our RF guns, we can type in by hand the location code we want (WHSE B01 A05) and our old Zebra 105SL printer prints the labels, no problem. The bar code which is printed by the Zebra, does not have any gaps (which I can tell) in the RF label, and the guns have no problems reading it.

I have tried various methods of separating the various components into separate cells, i.e., WHSE in E2, B01 into F2, A05 into G2 and then concatenating them back together but, our RF Guns won't read it.

But since we have 168 to do, I was hoping someone may have solved this in the past.

]]>

New user to this forum so hope I'm in right place..

I am trying to set up an excel spreadsheet when I can calculate the odds for a number of combinations. I am using upto 4 columns. As an example. Imagine a horse meeting with 4 races. In each race I select 4 horses. I have worked out how to present all 256 combinations for the 4 races. However, what I really want now is to be able to multiply the odds for each horse in each combination. This will give me the odds for each combination happening.

I hope this makes sense....

Can anyone help?????

Cheers ]]>

=IF(X4="",IF(ISNA(L4),"",IF(G4<>"",L4*(1-G4),IF(LEFT(H4,5)="1M0ER",L4*0.

4,IF(OR(LEFT(H4,5)="1C050",LEFT(H4,5)="1H00E",H4=" 1HACCH1MEL000H000E",H4

="1HACCH2CNT000H000E",H4="1HACCH5CNV000H000E",H4=" 1HACCH6SBI000H000E",H4

="1HACCHIMELH0003",H4="1HACCH2CNTH0003",H4="1HACCH 5CNVH0003",H4="1HACCH6

SBIH0003"),L4*0.38*0.95,IF(OR(LEFT(H4,5)="1F0VE",L EFT(H4,5)="1FACC",LEFT

(H4,5)="1F0VT",LEFT(H4,5)="1FRMP",LEFT(H4,5)="1F0F V",LEFT(H4,5)="1FRIC")

,L4*0.45*0.95,IF(OR(E4=1,E4=3),L4*0.4*0.9,"")))))) )

If I insert something more in line No. 8, Excel complains. See the

"IF(E4=2)L4*0.4*0.95" shown below on line No. 8. Excel keeps on

telling me that it found a problem with this formula and to click the

Insert Function on the Formula tab to fix it. I cannot figure out what

the problem is... Have I perhaps reached the max number of characters

in a formula?

=IF(X4="",IF(ISNA(L4),"",IF(G4<>"",L4*(1-G4),IF(LEFT(H4,5)="1M0ER",L4*0.

4,IF(OR(LEFT(H4,5)="1C050",LEFT(H4,5)="1H00E",H4=" 1HACCH1MEL000H000E",H4

="1HACCH2CNT000H000E",H4="1HACCH5CNV000H000E",H4=" 1HACCH6SBI000H000E",H4

="1HACCHIMELH0003",H4="1HACCH2CNTH0003",H4="1HACCH 5CNVH0003",H4="1HACCH6

SBIH0003"),L4*0.38*0.95,IF(OR(LEFT(H4,5)="1F0VE",L EFT(H4,5)="1FACC",LEFT

(H4,5)="1F0VT",LEFT(H4,5)="1FRMP",LEFT(H4,5)="1F0F V",LEFT(H4,5)="1FRIC")

,L4*0.45*0.95,IF(OR(E4=1,E4=3),L4*0.4*0.9,IF(E4=2) ,L4*0.4*0.95,"")))))))

--

tb

]]>

> or Monday Wednesday...

>

> if i enter a date in one cell and then drag the cell it

> will want to enter dates sequentially...but there must be

> some easy way to enter a different pattern...

>

> help! thanks in advance!

>

> :)

This was incredibly helpful! Thank you so much!!

]]>