|
|
Points Ranking Formulas by
Cabo Wabo Jim
I have a spread sheet in which I enter players names and the place they
finished for a certain event. I would like the sheet to calculate their
points...
( 1 2 3)
|
November 3rd, 2005 02:52 PM
by Max
|
22 |
472 |
|
|
how to count if cell "contains" a word by
cjlatta
(Using Excel2003/WinXP) I am trying to count the number of times 2 values
are in a cell. The string may contain the values ",abcd, abcf," or ",abcf,
abcd,"...
( 1 2 3)
|
|
22 |
241 |
|
|
Alphanumeric by
hardeep via OfficeKB.com
Dear sir
I have list of 15000 of Alphanumeric data for ex. ADEDO125ADSD589ADF121,
UIEIROIWS12556ERE545,ADAS15455212AD4564AD2
And so on. Now I want to extract...
( 1 2 3)
|
|
22 |
250 |
|
|
|
|
22 |
397 |
|
|
SUMIF with 2 conditions by
JBoyer
I'm trying to use a SUMIF function with one sum range and two seperate ranges
with seperate conditions.
For example: I'm trying to sum the cells in the "I"...
( 1 2 3)
|
|
22 |
276 |
|
|
|
November 30th, 2008 05:28 AM
by T. Valko
|
22 |
300 |
|
|
|
|
22 |
223 |
|
|
|
|
22 |
354 |
|
|
|
September 29th, 2009 10:53 PM
by JoeU2004
|
22 |
418 |
|
|
|
|
22 |
294 |
|
|
|
|
22 |
291 |
|
|
formula for a pension by
barbarat
Help, please...I am using Excel 2003...as a newbie...
I need to calculate (in Column I) the match for a 401(k) as follows:
Column G is compensation, H is...
( 1 2 3)
|
December 10th, 2005 02:18 PM
by barbarat
|
22 |
308 |
|
|
hash function for large strings by
jheby
Excel vlookup function returns #VALUE when the lookup value exceeds 256
characters. I need a hash function to transform large strings into a value
that does...
( 1 2 3)
|
March 16th, 2006 08:07 PM
by jheby
|
22 |
311 |
|
|
1st Monday of a month in date range?? by
scwilly
Hello everyone,
I need to determine the number of 1st Mondays or any weeday e.g. 5th
Fridays between a date range e.g. 1/1/2006 - 4/1/2006.
I've noticed a...
( 1 2 3)
|
April 26th, 2006 04:49 AM
by scwilly
|
22 |
257 |
|
|
|
|
22 |
293 |
|
|
|
|
22 |
156 |
|
|
lock cell based on a condition by
Amanda
I would like a cell to be locked or unfillable based on the results of
another cell.
For example:
Column B has a formula that the results are "" or "x".
If...
( 1 2 3)
|
|
22 |
235 |
|
|
|
|
22 |
227 |
|
|
Formulas in 2007 not working in 2003 by
Andrew
I created a formula in Excel 2007:
=COUNTIFS(Workflow!G9:G305,"New Facility",Workflow!S9:S305,"Yes") and
=SUMIFS(Workflow!U9:U305,Workflow!G9:G305,"New...
( 1 2 3)
|
|
22 |
224 |
|
|
Validation of UK VAT Number by
Rob
Hi,
I want to check a number of VAT numbers using a formula, the first check is
to ensure the number is 9 digits (may need to remove spaces to ensure clean...
( 1 2 3)
|
|
22 |
920 |