|
|
|
|
3 |
71 |
|
|
Data Validation using a table by
JBranter
I am trying to set up data validation using multiple columns, but not sure
how. Example - trying to limit choices of items sold as tiles, tools,
plants. ...
|
|
3 |
119 |
|
|
|
|
3 |
123 |
|
|
IF(AND(OR function returns #VALUE! error by
Linda
Hi,
The following formula in a cell retuns the #VALUE! error message. I have
tried using the formula auditing-evaluate formula. It shows the #VALUE!...
|
April 15th, 2009 06:00 PM
by Linda
|
3 |
73 |
|
|
Concatenate unique values among duplicates by
Toby
Hi. I'm trying to create a formula that, based on the results of a vlookup,
will combine any number of unique cell values into one.
In spreadsheet 1, I have...
|
|
6 |
93 |
|
|
|
April 15th, 2009 05:27 PM
by Luke M
|
1 |
67 |
|
|
I cannot use DIAS.LAB in my Excel (Spanish) by
User VB Excel[_2_]
In my office computer I cannot use DIAS.LAB (Excel said to me that #¿NOMBRE?)
I think I haven't this function in my implementation.
How I do for using...
|
|
0 |
105 |
|
|
Weekending Function by
Tracey
Hello
I have a worksheet with 15000 lines and we have a date field. I now need to
work out the weekending date (Fridays)
so if the date is 07 Apr 09 the...
|
April 15th, 2009 04:54 PM
by Tracey
|
5 |
80 |
|
|
count formula question by
mcook
I am working in a spreadsheet with two worksheets in it. On worksheet 1 I
want to enter a formula that tells me how many cells in column h5:h622 on the...
|
April 15th, 2009 04:36 PM
by mcook
|
2 |
108 |
|
|
excel function help by
[email protected]
I have two ranges named PReq and QOutput.
I have this procedu
Sub test_dependency()
Call dependency(Worksheets("PP"), , , "testtitle")
End Sub
And I have:
|
|
4 |
181 |
|
|
Advanced Filter by
dicko1
Is there a way to filter for more than two values?
Example:
If column A's values are 1, 2, 3, 1, 4, 5, 6
I would like to filter for 2, 3, and 6?
When a...
|
|
2 |
119 |
|
|
Date Range by
msguirt
I'm new to Excel (2003), so . . .
I'm trying to make a column to show every Sunday of the year for 2009. How
do I do that without having to type in each...
|
|
2 |
48 |
|
|
|
|
3 |
225 |
|
|
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 by
David Ryan[_3_]
Hi Folks the function below works in excel 2007 but not in 2003.
=IFERROR(LOOKUP('HDU Roster'!$C$9,{7,8,11,1330,1430,2245},{8,8,8,8,8,8}),0)
The file is saved...
|
April 15th, 2009 03:25 PM
by Steve
|
4 |
103 |
|
|
Lookup Problem with Index and Match by
Mike B
Hi,
I am trying to get the following working using the lookup function. it works
fine as it is shown however I have tried entering the lookup function...
|
April 15th, 2009 02:50 PM
by Mike B
|
3 |
56 |
|
|
Time Calculations by
jacsdad
In Excel 2007, I am attempting to calculate the difference between two times.
I have read the instructions in Help and found what I need to do, but cannot...
|
|
2 |
106 |
|
|
style sheets vs cell formatting by
Exceluser1
I am trying to choose between having a stylesheet that can be applied over a
score of worksheets vs doing cell formating when required. What is the better...
|
|
0 |
68 |
|
|
|
April 15th, 2009 02:09 PM
by PatPatt
|
2 |
96 |
|
|
Vlookup Error by
Farooqi
Hi,
I am getting a #N/A error when i try to use the formula,
=VLOOKUP(G20,'Protection Details'!$A$2:$D$112,2,FALSE)
In turn Cell "G20"in the above has this...
|
|
2 |
114 |
|
|
mean of range of dates by
leot
I have a column with a range of dates.
4/2/2006
4/4/2006
4/4/2007
4/7/2008
4/9/2006
5/1/2007
5/2/2006
5/2/2007
5/3/2008
|
|
3 |
51 |