|
|
|
September 19th, 2008 03:50 AM
by T. Valko
|
20 |
1,013 |
|
|
Looking for a better solution by
ibvalentine
I am counting the number of "Yes" answers on each worksheet of a workbook.
All the yes answers on in cell B2 of each sheet. The only way I could come up
with...
( 1 2 3)
|
|
20 |
205 |
|
|
Excel Count Functions by
Gasbag
I am trying to count the number of cells in a row that contain one or more of
three letters?
( 1 2 3)
|
|
20 |
139 |
|
|
|
|
20 |
314 |
|
|
IRR by
gotahavit
I have a question regarding IRR.
I am trying to figure out the IRR for an investment (actually, this has come
up a number of times in the past)....
( 1 2 3)
|
|
20 |
155 |
|
|
Cell referncing by
heather
Is there a way to refernce the cell name, ie C3 instead of the contents in
it, using formulas in another cell
( 1 2 3)
|
February 2nd, 2009 02:46 PM
by heather
|
20 |
267 |
|
|
building comments from text cells by
Michael.Tarnowski
Hi community,
I have an Excel application where I append a new line (by a VBA macro
assign to a button) from a kind of template.
Sheet A is the application,...
( 1 2 3)
|
|
20 |
96 |
|
|
Validation List - adding new entries by
watermt
I have a Validation list (=PhysiciansLN) that lists the last names of
physicians in our hospital. If a user of this Excel file does not find the
physicians...
( 1 2 3)
|
|
20 |
151 |
|
|
|
July 23rd, 2009 10:20 PM
by Jenny S
|
20 |
348 |
|
|
|
|
20 |
305 |
|
|
significant digits by
Gordon
Is there a format available to display significant digits? If you have the
following data:
0.99
1.0
1.1
1.11
is there a format you can use to display say 2...
( 1 2 3)
|
October 1st, 2008 07:14 PM
by Bernd P
|
20 |
185 |
|
|
Suming Cells that contain text data by
Wayne
I need to know if I can sum cells that contain numbers and text in a cell IE
2C + 4T. I want to ignor the text part of the cell data and sum the...
( 1 2 3)
|
February 23rd, 2008 11:57 PM
by T. Valko
|
20 |
293 |
|
|
|
|
20 |
147 |
|
|
Get Data From Closed Workbook by
Minitman
Greetings,
I need to get data from a closed workbook. The problem is the name of
the workbook is variable according to what is in a date cell.
I have...
( 1 2 3)
|
|
20 |
129 |
|
|
Return horizontal and vertical values by
karl
Hi,
In one cell I need to return topmost corresponding horizontal value of a
table using a value from the table array.
In another cell, I need to return left...
( 1 2 3)
|
|
20 |
206 |
|
|
Rounding to nearest 9 by
GaryS
I have the following =(E5+G5) * 1.25 which results in $1446.25. I would
like it to be rounded to $1449.00. How could I do this? Thanks!
--
Gary in...
( 1 2 3)
|
|
20 |
149 |
|
|
Formula won't show sum by
Parry
I'm a novice...and self-taught, but I love Excel. Can someone please explain
why when I enter a formula to add a column of numbers, the formula is showing
in...
( 1 2 3)
|
|
20 |
385 |
|
|
How do i find a sequence by
LiAD
Sorry I have already asked this but the answer has been lost somewhere, or i
can't find it now.
I have a list of data which i want to match the words then...
( 1 2 3)
|
August 26th, 2008 05:31 PM
by LiAD
|
20 |
424 |
|
|
|
|
20 |
225 |
|
|
conditional format by
narp[_2_]
How can I create a function that will highlight a cell in Column B if the
cell info contains the info in Column D? Info in Column D is not always
aligned...
( 1 2 3)
|
|
20 |
284 |