|
|
What funtion to use? by
fetzer[_2_]
Not sure what function to use; vlookup, ISNA, MAtch, etc.. One of my
spreadsheets (sheet 2) has 36 different tables (not a pivot table) of 4
columns each...
|
November 3rd, 2009 02:55 PM
by JLatham
|
2 |
156 |
|
|
|
November 3rd, 2009 02:32 PM
by JLatham
|
3 |
184 |
|
|
Need multiple blanks between words by
skaizun
I have two words, say, "ALPHA BETA", that are in a merged column(s)
and are text fields and are oriented downward, such that they read as
follows:
A
L
P
H
A
B
|
|
1 |
142 |
|
|
Filter in between dates by
Linda RQ
Hi Everyone,
Using Excel 2003. I have a list of patients who were on a particular
therapy and in a certain unit. Many where on the therapy in other units...
|
|
6 |
142 |
|
|
Links between files by
Gene L.[_2_]
I have an Excel 2007 workbook that displays the message "This file contains links that cannot be updated". This workbook has never been a problem in the past...
|
November 2nd, 2009 02:04 PM
by Eduardo
|
1 |
125 |
|
|
division formula by
Rohit
when i try to divide 100 by 0, its gives me error message #DIV/0!. This i
undersatnd is immpossible. But can i setup a formula if any number being
divided by...
|
November 2nd, 2009 08:44 AM
by FloMM2
|
2 |
155 |
|
|
|
November 1st, 2009 08:01 PM
by JLatham
|
1 |
111 |
|
|
|
|
2 |
163 |
|
|
|
|
5 |
309 |
|
|
1 Tab per work day in a month by
BetaDocuments
Hi,
I have reports that I do at work, I need one spreadsheet per month
with one work day, or 5 tabs per week. Is there any non macro way to
have this being...
|
|
7 |
189 |
|
|
|
|
1 |
123 |
|
|
default values in a cell by
KRK
Hello, can you help me please
Cell B1 contains a complex mathematical formula which requires (in several
places) a number from cell A1.
Cell A1 can contain...
|
|
1 |
137 |
|
|
help with a formula please by
KRK
Hello,
I have a long list of numbers (over 600) in a single column, say they are in
A1..A600 (they are daily meter readings) .
In column B I want to...
|
October 31st, 2009 12:03 PM
by KRK
|
3 |
112 |
|
|
How to retrieve tabs by
Jorge Cervantes
Hi,
I am using Excel 07 (with WinXP Pro).
In an excel file (xlsx), there are many tabs.
Right now, I do not see any tabs at all.
Please advise me how to view...
|
|
1 |
130 |
|
|
Create flashing cells in Excel 2002 by
Mei_Mienzi
I've a spreadsheet containing numerous mathematical formulas. I would like
to be able to make cells containing a formula flash when the results fall
below a...
|
|
1 |
210 |
|
|
Duplicate entries by
wally
I have been using Conditional Formatting to indicate duplicate entries in a
column. This highlights entries seen 2 or more times. This is working well,...
|
|
5 |
172 |
|
|
|
|
2 |
150 |
|
|
|
|
5 |
150 |
|
|
Can a table be linked by
Linda
It's been requested that a table in one worksheet be linked to the same table
in another worksheet. Can Excel update ALL information changed in the first...
|
October 28th, 2009 11:36 PM
by JLatham
|
3 |
200 |
|
|
left vlookup with max by
Morgan
hi there,
i have two columns of data, for example Column P has a description and
Column R has the value, is it possible to find the max value in Col R and...
|
October 28th, 2009 10:04 PM
by Morgan
|
2 |
157 |