|
|
|
|
1 |
202 |
|
|
|
April 20th, 2010 07:36 PM
by JLatham
|
3 |
308 |
|
|
conditional formula needed by
kylefoley2000
it might be possible to do this as a conditional formula (=if) otherwise a
macro might be needed.
the thing i'm unsure about is this formula looks at the...
|
|
2 |
216 |
|
|
|
|
3 |
220 |
|
|
Counting consecutive negative value by
Wallace
Hi,
I have a column with positive and negative numbers.
I need to count the largest number of consecutive negative numbers and don't
really know how to do...
|
|
6 |
266 |
|
|
Sum Function Visible Cells only by
Brian
if column a has the number 1, column b has the number 1 and column c has the
number 1, column d has the function sum(A1:C1) for a total of 3. how can a...
|
April 20th, 2010 06:04 PM
by Mike H
|
5 |
293 |
|
|
Averaging times that are not in a range by
Nancy D[_2_]
I am trying to get an average response time for numbers that are not listed
in a range. They are formated as a custom format like this: h:mm:ss. I have
been...
|
April 20th, 2010 05:19 PM
by Nancy D
|
3 |
253 |
|
|
Count if past today () - 30 days by
Scott_goddard
Hi all,
Trying to count the amount of risks the are open and and past todays date by
30 days...
So far i have
=COUNTIF(C9:C98,"Open"'(R2) Risks...
|
|
3 |
209 |
|
|
Reconciling Invoice & Credit by
Casper
Hi there, can somebody please help. Below is the data table I have. On the
4th column "Status", I need to know which invoices remain outstanding and
which...
|
|
2 |
199 |
|
|
Vlookup issue by
Tomwireless
When using vlookup fuction - not looking up numeric only data
=IF(ISNA(VLOOKUP(A3,'Inventory Items'!$A$3:$D$888,'Inventory...
|
|
2 |
249 |
|
|
|
|
5 |
228 |
|
|
revised q on report from tables by
UKMAN
Hi
Would still love help on previous regarding 20 tables but in a panic. :(
I have now ref all tables to 1 long list so as a quick fix:
the col headings of...
|
|
7 |
217 |
|
|
Date refrencing by
Amin
hi i have two sheets one is inventory the other is summary with the same
style and clumn headings.
now i want the date of the summary sheet to record the...
|
April 20th, 2010 04:08 PM
by Amin
|
3 |
206 |
|
|
Avg % above 0% by
Wendy
How can I get the average percentage of a collumn of percentages without it
including any 0%. e.g. A1=0% A2=100%, A3=70% if it averaged the 3 cells it...
|
|
2 |
168 |
|
|
Functions / Drop Downs won't calculate by
Bunecke
I have a complex workbook (Excel 2003) that has been in use for over a year.
Most users can use the workbook just fine. However, recently, I have had two...
|
|
1 |
210 |
|
|
|
April 20th, 2010 03:10 PM
by JessLRC
|
0 |
175 |
|
|
how do I drag and fill hyperlinks? by
coreygreat
I have a master lists of document names that I'm trying to hyperlink sections
to different sheets in the same workbook. I can't seem to figure out how to...
|
|
3 |
211 |
|
|
Data Encryption by
Confused
Is there a way to anonymize say a column of employee numbers in Excel? I want
it done in such a way that for each year of data the number is encrypted the...
|
April 20th, 2010 01:46 PM
by JLatham
|
1 |
220 |
|
|
|
|
1 |
210 |
|
|
worksheet by
Abhishek
i have saved a excel file in workspaces wrongly what is the proceedure to
change this file in excel
|
April 20th, 2010 01:00 PM
by Eduardo
|
2 |
180 |