|
|
|
|
2 |
112 |
|
|
Help needed with IF function by
Ed
Hi All,
I am trying to come up with a spread sheet that would convert amount in
certain foreign currency to local currency equivalent and show final value
in...
|
March 23rd, 2005 04:26 PM
by dave
|
1 |
96 |
|
|
|
|
1 |
136 |
|
|
|
March 23rd, 2005 05:59 PM
by bj
|
1 |
68 |
|
|
|
|
0 |
99 |
|
|
greater than replace numbers by
mja
I have a column of numbers.
I need to replace any amounts over $36,000.00 with the amount of $36,000.00.
|
|
1 |
90 |
|
|
Time Card by
Dan B
Hi,
I need help with a formula for a simple time card that does NOT round....so
it will show the exact hours and minutes between a start and stop time,...
|
March 23rd, 2005 08:25 PM
by Dan B
|
2 |
115 |
|
|
|
|
1 |
90 |
|
|
Cell Frequency by
james
Is there a way to count the frequency of cell contents?
Example:
A B
1Smith Joe
2Smith Mary
3Jones Fred
4Smith Joe
5Jones Fred
|
|
1 |
58 |
|
|
time card excel sheet by
Nancy Comello
I currently use excel to track over 70 employees but I
need either a formula for the following scenrio.
In 7:45am out 12:00am in 1:25pm out 6:00pm then have...
|
March 23rd, 2005 09:09 PM
by Dan B
|
1 |
195 |
|
|
CAGR by
Mike
I am trying to calculate CAGR by using the suggested fromula XIRR but contnue
to get #NAME? as an answer and not the xx%. Is this formula correct?
|
|
4 |
145 |
|
|
Referencing a worksheet name by
Greg114
Hello,
I have a workbook with 10-15 worksheets with different names. I am trying to
set up a "Summary" worksheet that will have each worksheets name in column...
|
|
3 |
87 |
|
|
IRR # NUM by
Tracy
Hi all
I have a formula that works if I change some the final value in the array,
please tell me if this number is a limitation in Excel or I am...
|
March 23rd, 2005 10:31 PM
by Tracy
|
2 |
74 |
|
|
|
|
1 |
211 |
|
|
SORT MIXED DATA by
jem
I am trying to sort a spreadsheet which has part numbers as the main
description (ie: 500111, 500123, 500111A, 500111B, 500123A ...) I want the
sort option to...
|
March 23rd, 2005 10:41 PM
by d
|
3 |
85 |
|
|
Most repeated number by
nuno
Hi all,
I have a table with several rows and columns with several numbers in it.
I was looking for a formula which could tell me what was the most...
|
March 23rd, 2005 10:47 PM
by nuno
|
4 |
94 |
|
|
Converting EST to PST by
neilalan
I would like to convert Eastern Standard Time to Pacific Standard time. In
other words, add 3 hours to a time formatted as hh:mm.
I haven't had any luck even...
|
|
3 |
88 |
|
|
Linking workbooks by
Debbie
I have many coordinators who fill out a long template with stat numbers.
(THey continue to update this template all year long and it contains each
month stats...
|
|
1 |
83 |
|
|
|
|
1 |
249 |
|
|
INDIRECT, OFFSET et. al. by
Wazooli
How do I get the following formula:
=IF(ROW()=VLOOKUP($A2,$AY$1:$BC$49,3,FALSE),MEDIAN(INDIRECT(VLOOKUP($A2,$AY$1:$BC$49,4,FALSE) & ":" &...
|
March 24th, 2005 12:23 AM
by Wazooli
|
2 |
173 |