Functions

How to find a value with multi-column, multi-record list
I have a spreadsheet with $costs arranged according to values in both rows and columns. How do I create drop down lists for both the rows and columns and then return the cell value? eg if I have 5 rows (2-6) and 6 columns (B-G) with costs arranged in each cell within this group how do I create drop downs for ea... 30 May 2010 13:16

Password to open excel file
How a password is set in excel sheet. When double click an excel file, first of all you see protected and a window appeared, asking for password to open that excel file. I want to know how is that possible or how to make such password without that one even can't open the file. Suresh ... 30 May 2010 11:06

copy and past cells found by SUMPRODUCT
I have colum A and B. I use SUMPRODUCT to calculate the sum of values in column B with a criteria. What I would like to do is copy the cells from column A (some row that SUMPRODUCT have use) and paste them elsewhere. ... 30 May 2010 10:02

Remove non-space spaces?
I have a large spreadhsheet with data I've manually copied/pasted from various sources including web pages. As I am trying to do things like import to Mysql or even Trim in Excel I find there are many spaced between words which aren't recognized as such (I know this because they don't Trim, and or when doing s... 31 May 2010 09:46

Count number of people
We will be hosting a large fund raiser. I need to know the number of people attending. Here's my problem................ Some people come as couples, and some as singles. For example, I have listed Jim & Susan Brown. But in the same list I have Bill Smith, and Ann Johnson. If ALL of these people RSVP with... 31 May 2010 09:46

Conditional formula with text and number in cell
Hello, Can a conditional formula be written to convert a cell with text and a number to a cellw ith just a number? I have a cell with the number 10 and the word "weak" in it. 10 weak Can a conditional formula convert this to just the number "10"? I did =If(b1= 10 weak,"10") but it does not work. Than... 1 Jun 2010 10:52

countblank with sumproduct?
Hi, SUMPRODUCT(--(S3:S44="A"),--(E3:M44>100),--(E3:M44<=200))/SUMPRODUCT(--(S3:S44="A"),--(E3:M44<>"")) doesn't work unless it is E3:E44 Looking to modify the formula to include rows with text in s3:s44 in addition to the "A" Also, looking for a formula that will compute the percentage of e3:m44 when s3:s... 29 May 2010 22:18

Conditional formula yeilds non-number result
Hello, I made conditional formulas but with the numbers that result I am unable to calculate their average. I get the #DIV/0! error. They are formatted as "General" but even when I format them as numbers they cannot be averaged. I have to copy them and "paste special" them as values, then there is an error m... 30 May 2010 12:11

Conditional formula
Hello, I want to make all the conditions occur in cell b1: if cell a1 = 1 then cell b = 7 if cell a1 = 2 then cell b = 6 if cell a1 = 3 then cell b = 5 if cell a1 = 4 then cell b = 4 I know how to do =IF(G2=1,"7") but I can't figure out how to add the rest of the conditions to it so they are all in cell ... 29 May 2010 14:39

Latest Taxation Books available at jain book depot LATEST BOOK RELEASES
Dear Sir/ Madam NABHI is NABHI We are pleased to inform you that the 39th complete Revised Edition of the book NABHI's Income Tax Guidelines & Mini Ready Reckoner 2010-11 & 2011-12 alongwith tax planning and wealth tax (In English) By Nabhi Board of Editors after the passing of the Budget, 2010 @ Rs240/-. The s... 29 May 2010 09:12