|
|
vlookup formula error by
Samantha
I am trying to lookup a value in one worksheet, find an approximate match in
another table, and return the corresponding value from the 2nd column of the...
|
|
2 |
99 |
|
|
Time elapsed calculation by
MTate
I have a text string in a cell that comes from an AS400. I need for this
string to convert to a time value.
Example text: 20100409073000
In the AS400 this...
|
|
9 |
117 |
|
|
Keyboard shortcut for Paste Special-Values by
skoeske
I find myself using "Paste Special - Values" a ton, a keyboard shortcut for
this function would be fabulous.
I'd also like to see a keyboard short cut for...
|
April 10th, 2010 06:55 AM
by Michael
|
4 |
204 |
|
|
Updating Next Consecutive Cell in Range by
Stilltrader47
I am trending a bank account balance. Every time I enter the current value
in cell c3, I would like it to update the value in the next empty cell in
range...
|
|
8 |
193 |
|
|
|
April 10th, 2010 05:34 AM
by Dave
|
2 |
162 |
|
|
Multiple table lookup by
tornado1981
A B
1 Name Code
2 London 301
3 Paris 302
4 Rome 303
5 Moscow 304
6 Madrid 305
7 Berlin 306
9 Name Code
( 1 2)
|
|
12 |
265 |
|
|
|
|
1 |
103 |
|
|
Average with Conditions by
Curtis[_6_]
I need to a formula that will look at column c and if it contains a certain
text say "dog" I want to average the price located in column H
Thanks
--
ce
|
|
3 |
126 |
|
|
Help for Medical Records sorting by
Gerry St[_2_]
I know this has been queried before but unfortunately, I cannot locate
it. Our office deals with medical records numbers and we often have
need to sort them...
|
|
3 |
130 |
|
|
Counting Merged Cells by
Excel Ella
Is there a formula I can use to:
1. Count the number of merged cells (comprised of 3 cells) in a column AND
how many of those are blank?
2. Count the number...
|
April 10th, 2010 01:54 AM
by FSt1
|
5 |
215 |
|
|
|
|
7 |
118 |
|
|
|
|
2 |
115 |
|
|
SUMIF with OFFSET by
Lewis Clark[_2_]
Hello
I am trying to find a way to use SUMIF with OFFSET on a range of variable
length. My data is organized in this manner:
Each row represents one fee...
|
|
5 |
78 |
|
|
Line Feed in Formula Adds Double Quotes? by
CarlT
I am trying to use a formula to create multiline text that I can copy and
paste into another application. The problem is the pasted text always comes...
|
|
3 |
128 |
|
|
How to count merged cells by
Excel Ella
Can someone help me in developing a formula that will:
1. Count how many merged cells in a column that are created from 2 cells
AND contain both text and...
|
April 9th, 2010 10:28 PM
by JLatham
|
2 |
138 |
|
|
|
|
9 |
149 |
|
|
return 0 if cell has data? by
kathysonisland
I feel stupid asking this question.......I just cannot figure a formula out
that I know I know.........
I need a formula to display 0 in a cell if another...
|
|
4 |
86 |
|
|
#VALUE error-- some cells? by
roborat
I am doing a VLOOKUP moving out comments from a Pivot Table to separate
column. I have 115 rows, 100 of which work perfectly... but 15 of them give
me the...
|
|
3 |
98 |
|
|
|
|
2 |
64 |
|
|
sum column based on single cell match? by
adodson
This seems so simple and yet the solution eludes me...
In row 2 I want Excel to match a cell's contents (ex: find 3200). Once
finding the column that...
|
|
1 |
90 |