|
|
|
|
1 |
128 |
|
|
Help with INDIRECT by
GoBucks
I have a column in one worksheet (Col A) with a list of names:
Col A
Jones
Smith
Williams
James
In another worksheet I am looking for a formula that will...
|
|
7 |
118 |
|
|
Sum or Average with #N/A cells by
PaulinaDi
I'm using a formula to bring results from another worksheet but in some cases
I get the #N/A result as I donĀ“t have data on the original worksheet. To get...
|
|
5 |
106 |
|
|
|
|
1 |
97 |
|
|
Bolean Logic with the Advanced Filter by
leimst
I would like to use a Bolean formula to identify cells with a red background
when performing filtering using the Advanced Filter. I recorded a macro
where I...
|
April 14th, 2009 12:59 AM
by leimst
|
0 |
112 |
|
|
Drop Down Starting Position by
veggies27
I have a drop down list in a data validated cell with blank items at the
bottom of the list (to allow for addition user-entered choices). Is there any
way,...
|
|
2 |
119 |
|
|
|
|
1 |
146 |
|
|
Auto Sum by
NRH
my coulum wont sum how do i turn it on
|
|
3 |
73 |
|
|
Count IF by
Adam
Hey Guys, i Want to use COUNTIF function liek this..
(Range, Criteria,
when you use count if, it will just let you do one if statement, (range,...
|
|
1 |
64 |
|
|
|
|
11 |
142 |
|
|
|
April 13th, 2009 07:49 PM
by Syd
|
4 |
120 |
|
|
Using multiple IF conditions by
Jayceejay
I am having a difficult time with an IF statement.
I have a value in cell A1 that triggers a response in cell A5.
If cell A1 = 0, Cell A5 should =0
If cell A1...
|
|
3 |
101 |
|
|
|
April 13th, 2009 07:34 PM
by Susan
|
1 |
94 |
|
|
IF by
Susan
Hello,
Having touble using the IF function with dates.
IF cell a1 has a date from and including 4/1/2009 to 4/30/2009, need the
result in cell b1 to be...
|
|
2 |
55 |
|
|
Adding Rows by
Cindy H.
How do I add multiple rows to a spreadsheet at once
|
|
1 |
55 |
|
|
Chart Data Table by
Joe R @ AA[_2_]
On a YTD Chart, I need the data table to show blanks, not zeroes for future
months.
The data sheet which the chart references for the numbers are blank. The...
|
|
0 |
67 |
|
|
|
|
2 |
90 |
|
|
|
|
2 |
79 |
|
|
Formula for non matching items by
henriques
Need a formula for the no matching items in a worksheet with the following
data:
Columns A, B and C are the data for 2008
Column A- Customer number
Column B...
|
|
3 |
66 |
|
|
Import worksheets from another workbook? by
bjwheeler
A coworker sent me his Excel workbook, and I want to import specific
worksheets into my workbook, as if to merge them, so they're located in the
same...
|
|
1 |
98 |