|
|
Updated Formula question by
TLC
Here is an update to my question posted last week:
I have a spreadsheet with close to 700 lines of information on it. The
current format of the spreadsheet...
( 1 2)
|
August 25th, 2009 05:41 PM
by Pete_UK
|
10 |
194 |
|
|
|
|
1 |
170 |
|
|
|
August 25th, 2009 04:40 PM
by Pete_UK
|
6 |
159 |
|
|
|
|
3 |
113 |
|
|
#NAME? Error by
mp
I have a spreadsheet that I sent to a collegeau who is having difficulty with
one of the formulas. The formula is returning the #NAME? error in the cell. ...
|
|
3 |
160 |
|
|
sum across range of sheets for a cost code by
monkeydoom
I'm trying to create a summary sheet at the end of a workbook that will
automatically total the amount spent from a specific cost code.
My first sheet is...
|
|
1 |
119 |
|
|
Help with formulas automatically updating by
Bobbo
I have the following in a cell. {=SUM(('Evaluation
Form'!F7:F7="Technical")*('Evaluation Form'!K7:K7="Reject"))}. The problem is
when I enter information on...
|
|
1 |
102 |
|
|
what function to use by
[email protected]
Hi
I'm creating a spreadsheet with percentages in one column and in the
next column i need to a specific word according the value of the
percentage.
For...
|
|
4 |
121 |
|
|
|
|
1 |
102 |
|
|
|
|
1 |
99 |
|
|
Database Lookup by
Modawg
Hi,
I am trying to pull information from an array that contain these
information. I need to be able to pull the information if the status is
'OPEN' along...
|
August 25th, 2009 01:24 PM
by Modawg
|
2 |
117 |
|
|
excel IF formula by
shib
I AM WORKING IN AN EXCEL SPREAD SHEET WHICH CONSISTS OF
TWO COLUMNS. ONE IS DEDUCTEE NAME AND ANOTHER IS PAN NO. OF THE PARTICULAR
DEDUCTEE.
I WANT TO PUT A...
|
August 25th, 2009 11:44 AM
by Mike H
|
3 |
95 |
|
|
conditional formatting by
Mary Lou
i have a vlookup formula as follows:
=IF(ISNA(VLOOKUP($A56,'2006 Top
40'!$A$8:$B$470,2,FALSE)),IF(ISERROR(VLOOKUP($A56,'2006 All...
|
August 25th, 2009 09:29 AM
by Pete_UK
|
6 |
110 |
|
|
How do I combine ISNA and IF functions by
ottodesque
I am trying to write a formula which will return a value of blank if the
contents of cell All Audit Compilation 1'!K3584 are NA or P and a value of 1
if not...
|
August 25th, 2009 09:01 AM
by karenk
|
8 |
100 |
|
|
|
|
1 |
115 |
|
|
|
August 25th, 2009 07:13 AM
by tipoo
|
2 |
138 |
|
|
|
August 25th, 2009 06:03 AM
by Vijay
|
0 |
108 |
|
|
Paste Special Menu by
chanse44
When I click on the paste special menu like always it now brings up the
hyperlink menu (paste bitmap, etc.) rather than the paste special menu of
(all,...
|
August 25th, 2009 04:47 AM
by Sheeloo
|
1 |
104 |
|
|
|
August 25th, 2009 03:53 AM
by JLatham
|
1 |
118 |
|
|
Time and the Max Function by
Jules
I have a large data set, column A has many dates (there can be many of the
same dates), B has pt out time, C has room number (1-6).
A
Date pt out ...
( 1 2)
|
|
15 |
286 |