|
|
|
|
4 |
138 |
|
|
need qualifier statement by
Abbey Somebody
Hey guys...
I have a weekly check sheet and the days of the week auto-fill from the
"week starting date" that I fill in in another cell. That works fine. ...
|
|
5 |
172 |
|
|
|
|
14 |
250 |
|
|
|
|
3 |
168 |
|
|
Formula help in Excel 2007 by
Millie[_2_]
I know it's possible to link cells from one worksheet to another but not sure
if what I want to achieve is possible (I use only the basic functions in...
|
|
3 |
184 |
|
|
year - 1 by
alvin Kuiper
Hi
Is there a way in a worksheet - Functions where i can
take a cell value (date) and make it a year less
like 01-11-2009 (danish date) shall be 01-11-2008...
|
|
5 |
143 |
|
|
|
|
1 |
175 |
|
|
|
|
4 |
196 |
|
|
|
|
16 |
294 |
|
|
Approximate match on string of text by
Pierre
I am looking for a solution to the following problem: I have a long list of
companies in an EXCEL sheet, and would like to find, company by company, if
there...
|
|
7 |
207 |
|
|
Countif question by
Patrick C. Simonds
I need to be able to check the range D19:AB19 for any occurrence of the
phrase On Call. That is easy enough with the formula below so my problem is
it could...
|
|
4 |
137 |
|
|
Calculating a dollar-weighted return by
Petrak
I am trying to calculate a dollar-weighted investment return for a month
period with some cash flows on some days in the month,
For example:
Jan 1: $100 ...
|
May 16th, 2009 09:36 PM
by Petrak
|
3 |
150 |
|
|
|
|
10 |
268 |
|
|
Summarize range by
willemeulen[_10_]
I want to make an automatic summary of value's present in a certain
column in ascending order.
Example:
Column
8
10
12
10
|
|
4 |
189 |
|
|
Problem working with Vlookup by
Patrick C. Simonds
I have the following table (A1:B6) from which I want to return the
appropriate value from column 1. This is my formula:
VLOOKUP(R16,'Sunday...
|
|
3 |
104 |
|
|
matching texts in 2 columns by
my_melody
Can I match texts in 2 columns (one column has a longer string than the other
column so let's say it should be able to match the first 5 characters) and
then...
|
|
1 |
115 |
|
|
|
May 16th, 2009 04:44 PM
by Mark
|
2 |
140 |
|
|
Text Separation Function by
kateconrey
I have a database with one column of information including names (First Last,
or First Middle Last) and for some names, locations in parenthesis. I am...
|
|
3 |
249 |
|
|
Count based on two criteria. by
MJKelly
Hi,
How do I get a summary of a table of data according to two criteria?
I want to check instances of "A" in one column and then where "A" is
found, check...
|
|
2 |
153 |
|
|
|
May 16th, 2009 02:08 PM
by Gene
|
8 |
161 |