|
|
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS by
JingleRock
My formula is in a sheet named "Values"; the only other sheet is named
"Data". The workbook contains EXCEL VBA code; Automatic Calculation
is selected.
The...
( 1 2 3)
|
|
28 |
296 |
|
|
Return Unquie Values by
Javier Diaz
So guys, heres another one
Say in CElls A2:A10 I have values like so;
food
food
test
trial
trial
test
( 1 2 3)
|
|
27 |
351 |
|
|
|
|
27 |
339 |
|
|
Rule of 75 Retirement Calculation by
BAD
I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea...
( 1 2 3)
|
October 21st, 2008 03:40 PM
by ~L
|
27 |
393 |
|
|
Counting Unique Values by
RJL0323
Hello All,
I have a question related to counting unique values in a column of
data. I will try to illustrate my question. I have a column of data
with 1000...
( 1 2 3)
|
|
27 |
595 |
|
|
multiple worksheet help by
darkbearpooh1
sure this has been asked before but wth =)
ok... trying to figure out if i create two work sheets one will have
something similiar to a person's name in one...
( 1 2 3)
|
|
27 |
382 |
|
|
|
|
27 |
274 |
|
|
|
|
27 |
517 |
|
|
assigning a unique value by
Dino
I have a spreadsheet of names, and I need to assign a unique number to each
of the names. Some entries are repeated, so each duplicate should have the
same...
( 1 2 3)
|
|
27 |
357 |
|
|
|
February 10th, 2010 05:15 PM
by Flcnmech
|
27 |
482 |
|
|
|
|
26 |
154 |
|
|
Weighted Averages by
Chad Fields
Is there a way to calculated weighted averages in Excel?
Lotus has a function called WEIGHTAVG, this is what I am
looking for in Excel.
Thanks
( 1 2 3)
|
|
26 |
779 |
|
|
ALTERNATIVE TO SUMPRODUCT NEEDED by
Rog
I need to use two columns and search for two things and count how often the
two occur together. In col X will occur the word "warranty" and in column AD
will...
( 1 2 3)
|
August 2nd, 2007 08:50 PM
by Rog
|
26 |
297 |
|
|
|
|
26 |
271 |
|
|
Find value in array by
Brook6
I am trying to do something that seems simple, but not sure how to do it...
I want to have a table of text where the first column is a category and the...
( 1 2 3)
|
|
26 |
279 |
|
|
|
|
26 |
193 |
|
|
|
May 10th, 2010 07:57 PM
by Angie
|
26 |
641 |
|
|
Average of top 3 numbers. by
Belzbub
Hi, im making a worksheet for our shooting results. I need the average of the
top 3 results from collum E6 to W6 and top 3 reults from Y6 to AJ6. Can
anyone...
( 1 2 3)
|
|
26 |
301 |
|
|
Significance of =+ in formulas by
Frank Kabel
Hi
it's the same as '='. Possible a user who has used Lotus Notes did
enter this combination of '=+'
So you can just delete the '+' sign in these...
( 1 2 3)
|
|
26 |
308 |
|
|
|
|
26 |
546 |