Functions

modifying T. Valko ws function
Howdee all. I received some help from T. Valko back in January on a complicated worksheet function. It's been working really great, and today I found that I wanted to make a modification to it. So, Biff, if you'd be so kind as to one again help me on this, I'd really...... appreciate it. Original discussion.... 1 Jun 2010 17:32

why is the feature "share workbook" unavailable to use
I am trying to share a work book but the feature is grayed out, not sure why - pls explain ... 1 Jun 2010 15:19

Drop Down Lists 2007
I have followed all the steps in creating a drop down list in Excel 2007: Created Named list on seperate sheet goto the sheet that the drop down will be on and select the appropriate cell Data > Data Validation > Allow:List > Source: =BlahList > Click "OK" ....And then, I get this message every time: "The l... 2 Jun 2010 08:44

Remove columns containing all zeros
How can I create a macro or conditional formula to remove columns containing all zeros ... 1 Jun 2010 18:39

How do I save a header?
I need to permanently save a header and it will never save once I open up a new file. Any suggestions? ... 1 Jun 2010 13:06

Finding identical rows in a list
I have a long list in columns A to I. In some cases, all the items in adjacent rows are identical, and I need to be able to find these as quickly as possible. This formula identifies the number of columns in row 8 which are identical to the corresponding items in row 7, and returns "9" when the rows in all t... 2 Jun 2010 07:39

V-Lookup variation query
Hi, I am having an issue with comparing columns of values. Basically I have a table similar to the below except with a couple of thousand lines. Either the first column will have a value that doesn't match with the second column or vice versa so basically I need Excel (2002) to begin at the top and compare... 1 Jun 2010 11:59

Multi-Condition Formula
I'm using this formula; =IF(OR('Source Sheet'!C10={“”,”C”, “B”}),'Source Sheet'!B10). This allows what I enter into the source sheet to also enter into the destination sheet unless, “C” or “B” are present and then nothing is entered into the destination sheet. This only leaves two conditions that would allow ... 2 Jun 2010 09:50

Sumproduct formula help (possible Index????)
Morning all I am stuck with a forumula that I hope someone will be able to help with. It's quite long winded the way I am doing it but am hoping that it may be able to be shortened. Column B Lines 42 - 58 has either "current" or "ex" in the cells Column G lines 42 - 58 has a date in them Column H lines ... 1 Jun 2010 08:39

If OR formula
I am trying to write a formula that will first look at the value in C3 which is identified by either 1 or 99. Then depending on either of these two numbers, use a specific vlookup to a certain table. The best way I can explain is to If cell c3="1", then vlookup(a3,named range, 7,0)*B3 or if cell c3="99" the... 31 May 2010 22:57