Functions

Working from oldest date
Hi there hope someone can help, here goes Date RM MR 05/08/1997 £13.64 £53.41 04/05/1998 £62.94 £246.44 i am looking for a formula to check which date is the oldest and put in the corresponding amounts ie as above 05/08/97 is oldest date therefore A10= £13.64 A11= £53.41 and... 15 Sep 2009 02:26

why does a sumproduct formula return a #div/0!
The sumproduct formula that I'm using is returning #div/0!. Here's the formula: =SUMPRODUCT((outlook!CV2:CV1931="XNOR OPC")*(outlook!CU2:CU1931="jpy")*outlook!CD2:CD1931) ... 9 Sep 2009 10:50

Synchronous scrolling in all sheets of a wokbook.
I have a need to scroll (up and down) in any sheet of a workbook of excel and then when I switch between sheets in the same workbook - I would like to find myself in the same place on the new sheet. Is this possible in anyones experience? ... 3 Sep 2009 19:36

Cell referncing
Is there a way to refernce the cell name, ie C3 instead of the contents in it, using formulas in another cell ... 2 Feb 2009 10:30

Already exists on the destination workbook
When I copy a worksheet into the same workbook I get a warning message that states "a formula or sheet you want to move or copy contains the name 'wrn.Retirement._.Bonus.', which already exists on the destination worksheet." I don't have any formulas or Names with this 'wrn.Retirement._.Bonus. Does anyone know ... 11 Jul 2008 16:08

Multiple condition countif for excel 2003
Hi, if I have 2 lines of data say, A and B. I need to count num of data that fulfill both X criteria in A row and Y criteria in B row. How do I do that? Thanks. ... 30 May 2008 03:39

Making a structured reference absolute?
Excel 2007 table is a forecast with product name in col A, unit price in Col B and forecast units by month in col's C:N. I want to show forecast dollars in each month's column. This formula outside the table (cell C102) works fine: =SUMPRODUCT($B2:$B100,C2:C100) Since I anchor the Unit price column refere... 13 Apr 2008 23:06

Using Bloomberg's BDP function in VBA
My question is: How can I use Bloomberg's BDP/BDH/BDS function inside vba? I would like to retrieve data inside vba rather than to do it via worksheet cell. regards, Marc ... 15 Feb 2008 04:20

Wonderware Active Factory Add In Problem
I am using a function from active factory called wwWideHistory2( ). It is an array formula that looks something like this: {=wwWideHistory2( ....)}. In order for this function to work i have to have the active factory excel add in installed. The function is working fine. The problem is that sometimes when ... 3 Oct 2007 17:40

working VAT in worksheet
Hi all I have a worksheet like below, It might be easy for some but i'm a bit rusty. F8 F9 F10 Net VAT Total What i need is a function that will allow me to enter a amount in either Net or Total and it would work out Vat and either Net or... 8 Aug 2007 15:46