Functions

Drop list and redirect
I have two workbooks W1 and W2, they both contain the same columns with the same type of data. I know how to have W2 display the changed cell when W1 is updated, however I would also like to add a validation list for W2 in the same cell. The list contains the same values as those entered in W1. Is there any w... 30 Apr 2010 18:34

Sharing workbook
I tried to install this patch and it stated that it was already installed, yet I am getting the same error, though the file is shared. "Squeaky" wrote: Hi Olivier, Have you recently patched your excel with KB978522? Look in your add/remove programs, check the "show updates" box and look for it. If ... 30 Apr 2010 17:27

Sumif Function
I successfully wrote a formula to give me the sum of one column (F) based on whether or not column D has an "x" in it. It works fine in one spreadsheet, but when I copied and pasted it to another spreadsheet, which was virtually identical to the first, only it had less information entered into it, I got a "#na... 30 Apr 2010 17:27

YES or NO formulas
Hi, I have a column that has a series of numbers it will always be either 10000 or 10100 , I want it to return a No for 10000 or Yes for 10100 in the field next to it, I have tried and I can't seem to make it work, I can do one or the other, any assistance would be greatly appreciated. The cells I am ... 30 Apr 2010 17:27

Finding most recent date for each customer - XL 2007
Excel 2007 PivotTable Consolidate and filter by most recent date. No formulas needed. http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_30_10.xlsx Pdf preview: http://www.mediafire.com/file/yo4dqi5cnzj/04_30_10.pdf ... 30 Apr 2010 11:44

determine a range using a formula
I have a spreadsheet with budgeted financial data in columns, the heading for each column is a 3 letter monthly abbreviation. Each month actual financial data is entered in a corresponding table. I want to build an automated array for the YTD budgeted data based on one cell in the spreadsheet, the currrent mo... 30 Apr 2010 12:51

VBA to autofill from relative location
If I need to autofill column B from the last cell that has data in it to the same row as the last cell of column A that has data in it, how do I set the destination for the autofill correctly? I have tried a lot of ways that seemed obvious and all of them return errors. Here is where I am stuck: Se... 30 Apr 2010 12:51

SAMPLE EXCEL DATA
How do I sample data in a EXCEL spreadsheet? Say I have 50.000 records and I want to sample say 0.1% or 50, what function do I use? ... 30 Apr 2010 11:44

Multiple AND OR functions
Is it possible to make this function work? =IF(AND(AND($B9="Z",AE9=35),OR(J9=1,J9="M",J9="C")),1000,IF(AND(AND($B9="A+",AE9=35),OR(J9=1,J9="M",J9="C")),750)) I need to find out if Cell B9 = Z and if Cell AE9 = 35, if this true then check cell J9 and check if it equals 1, M or C then return the value as 1000. ... 30 Apr 2010 09:29

IF formula help
Hi Again everyone. Ok another problem I am now having. I have the following formula in column H =IF(ISNA(VLOOKUP(TRIM(A135),'Current running April 2010'!$1:$65536,1,FALSE)),"",VLOOKUP(TRIM(A135),'Current running April 2010'!$1:$65536,1,FALSE)) In Column I simply want to say =IF(ISBLANK(h9),"","yes")... 30 Apr 2010 08:23