Functions

Changing a formula to read a general value?
A few months ago I had asked a question and got this answer: Question: I have a a set of values in A1 through A100. I need to look up each value and find a match in another set of values located in C1 through C200. If a match is found then I need the formula located in column B to return the value in the same ... 13 May 2010 17:10

count of number of rows within a range with a certain text
Hi. Sample data: R1: No, Yes, No R2: Yes, Yes, Yes R3: No, No, No How do get a count of the rows that contain No? So for the sample above, the output i'm looking for is 2 (2 rows where No exists). TIA! ... 13 May 2010 16:03

RONA Spreadsheet
I am in need of an Excel speadsheet that will calculate my company financal RONA or "Return on Net Asset" ... 13 May 2010 16:03

Average with Conditions
Source sheet Column J contains the vlaues for condition 1 Column B contains the values for condition 2 Column D contains the numbers I wish to average In my results sheet I need a formula that averages based on meeting the 2 conditions above Hope that makes sense thanks -- ce ... 13 May 2010 11:37

Conditional formating dates
I have a range of dates in a column and I would like it if I could highlight any date that is more that 3 years old. So if the date reads 02/10/2004 this should be highlighted red. I would really appriciate a bit of help. ... 13 May 2010 11:37

How can I set up a shortcut key for Autosum?
On 2007, works perfect... you the man! "Ron Coderre" wrote: Try this: Hold down the [Alt] key and press the equal key [=] Does that help? *********** Regards, Ron XL2002, WinXP-Pro "dsapan" wrote: I used the Autosum button (on the top toolbar) all of the tim... 13 May 2010 10:30

Google Adsense Account Approval Tricks
Google Adsense Account Approval Tricks New Unique Genuine Google Adsense Account Approval Trick Only For Rs. 1000/-. Take This Trick & Create Unlimited Google Adsense Accounts & Be A Master Of Creating Adsense Accounts. If You Are Interested Mail Me To "abcdall4u(a)gmail.com". Any Country Account Approved Wit... 13 May 2010 10:30

Variable Sumproduct Range
Hoping someone far smarter than myself can help. The below formula will give a result where column A=Monday, col B=John and sum the corresponding values in column C. =sumproduct(--(A5:A10="Monday"),--(B5:B10="John"),(C5:C10)) But what if I need the (C5:C10) part to be variable from anywhere between colum... 13 May 2010 21:36

convert matrices to table
Hi to everyone, is it possible to view a matrix in table mode? I have a matrix like this b c d e f ... b 1 0 3 4 5 c 2 5 8 6 5 d 2 3 6 8 e f .... I want to convert it in a 3 row table: ROW COL VALUE b b 1 b c 0 b ... 13 May 2010 13:50

How to look up a value?
I have two column like this: A B 1 23 2 21 4 20 1 19 4 18 ....etc (The numbers in column A are random and do repeat) What I want to do is to look up a specific value in column A, like 4, and return the corresponding value of column B with the largest row number... 23 May 2010 20:09