Functions

Data Validation List Names
I have Excel 2007 and am attempting to use the data validation tool. I have created several lists in a separate worksheet and named them (In the name box). My drop down and options have shown correctly. However, I now need to make a few changes to the lists. I added a few extra cells with data to one of th... 28 Feb 2010 11:06

Using validation to make data appear or not
I have an array of cells that all rely on a "Y" or "N" value in another cell, and an IF statement to either make the data appear or not appear. It works fine, except that when the data appears and fill, the borders pop up fine. Some of them, however refuse to disappear the same way the data does, yet other... 27 Feb 2010 21:00

Lookup
I have a work sheet with a column of numbers, that are always being added to. I want use a different worksheet to lookup the last number in the column in the first sheet. i.e. vlookup last number in sheet 1 and place in sheet 2 ... 27 Feb 2010 23:11

Count Wednesdays within a calendar month
How can i count how many let's say Wednesdays have each month of a year, each year? -- sato panago ... 27 Feb 2010 17:42

MULTIPLE COPYING OF ONE WORKSHEET
hello: i have a worksheet with labels and formulas, (call it worksheet 2) and i wouldlike to have multiple copies of it(worksheets 3-14). how do i accomplish this? excel 2007 -- thanx jmh ... 27 Feb 2010 15:29

Conditionally formatting a cell based on other cell values
I am trying to format a cell based upon the relationship of another cell to a reference value. For instance if the reference is 5 and the other cell is 4 I want to format the original cell green, if it is the same blue and if it is less than the reference red. Can someone help please! ... 27 Feb 2010 17:42

Insert Code
I am trying to insert a code in the combo box and do not understand what information is to be entered? Thanks ... 27 Feb 2010 13:16

Drop down list
When I "name" a range and put that name into the selection while creating the drop down list. Then go to the cell and click on the arrow all i see is the name of the range and it doesn't show the list to allow selection? -- rustyrunrite ... 27 Feb 2010 13:16

VLOOKUP
I have two sheets that I need to pull information from. I need to know what has been paid since 12-31-09. My first sheet is from 2009 is a list of invoice and amounts. Second sheet is a current list of invoice and amounts. I need to find what invoice and amounts between both sheets that have been paid and not p... 27 Feb 2010 13:16

Excel trace dependents functions broken
Trace dependents / precedents stopped working in large-ish model (15MB). However it works in other bigger models, so unlikely size-related. In addition, the model stopped recomputing values (and it is not set to "manual"). Any suggestions? Excel 2003 I think. ... 27 Feb 2010 02:22