|
|
subtotal, match? by
Steve
Morning all.
I need to do a name check to match with a subtotal function. Is that
possible?
I was thinking that subtotal(Func_Num,match(....)) might handle...
( 1 2)
|
February 17th, 2010 04:44 PM
by T. Valko
|
10 |
157 |
|
|
Counting days from a date by
Sunshine
in cell D5 I have the date 2/12/10...in cell D6 is blank but is assumed to be
today's date...in cell D7 I need it to calculate the number of days from 2/12...
|
February 17th, 2010 04:35 PM
by T. Valko
|
3 |
112 |
|
|
Multiple name appearances by
Pat318
Have a list of 1000 names trying to sort by appearances 5.
Not sure if Lookup or Hlookup?
|
|
1 |
206 |
|
|
Excel files take long time to open by
Rick KH
I just upgraded to office 2007. I have files that were created in older
versions of excel. Some of them contain macros and some don't. When I go to
my...
|
February 17th, 2010 04:07 PM
by Rick KH
|
0 |
278 |
|
|
|
February 17th, 2010 03:23 PM
by JLatham
|
2 |
119 |
|
|
multiple criteria date range by
Pat318
I'm trying to countif in 2 columns 1has "O" or "MV". The other column has
date ranges.
So if dates 1/1/1985 -12/31/1985 "O" count how many. And do the same...
|
February 17th, 2010 02:47 PM
by Mike H
|
4 |
82 |
|
|
Formula for unique records by
Keithlearn
I am trying to make a report a little more user friendly for a novice excel
user, and I am trying to use all formula's instead of pivotables on large
data...
|
February 17th, 2010 02:47 PM
by Max
|
2 |
95 |
|
|
If function with format by
Khusro
=if(a10,a1,"")
A1 "text" or "number" in red color
I want to print the value of cell A1 in Cell B1 with its format if above
condition is true. Is it possible ?
|
February 17th, 2010 02:46 PM
by JLatham
|
1 |
85 |
|
|
|
February 17th, 2010 02:13 PM
by Richard
|
3 |
104 |
|
|
MS Word equation by
qamar
How can I edit MS Word equation after pasting it in excel sheet?
|
|
1 |
100 |
|
|
|
|
1 |
153 |
|
|
|
February 17th, 2010 01:10 PM
by WFariss
|
4 |
150 |
|
|
Unmoveable SUM by
LiAD
Hi,
I have a very simple formula =sum(A1:A100).
If I highlight lines 20 to 40 and then delete the entire line the formula
will update to =sum(A1:A80).
Is...
|
February 17th, 2010 11:40 AM
by LiAD
|
4 |
98 |
|
|
|
February 17th, 2010 06:39 AM
by Champ
|
1 |
125 |
|
|
|
February 17th, 2010 06:24 AM
by KSO
|
6 |
115 |
|
|
Not sure what type of formula to use by
woodson87
I'm trying to find in one of my rows of my excel spreadsheet specific
countries like Germany, Italy, France, etc. I need a formula that will
display IF one...
|
February 17th, 2010 04:12 AM
by T. Valko
|
2 |
92 |
|
|
if statements for multiple entries by
DLB
I have a spreadsheet that has a ID number in column A and an airport
identifier in column B in sheet 1. I want to return a value ("1") if the ID
number and...
|
February 17th, 2010 03:41 AM
by T. Valko
|
1 |
99 |
|
|
|
February 17th, 2010 01:40 AM
by T. Valko
|
8 |
131 |
|
|
|
February 17th, 2010 01:23 AM
by Beverly
|
2 |
109 |
|
|
convert meters to feet/inches by
Ann
i'm trying to convert from meters to feet and inches (not just feet or not
just inches).
so if i have 2 meters, i want the result to read 6 feet, 2 inches for...
( 1 2 3)
|
|
21 |
306 |