in [Excel]

count the number of rows with entries greater than zero i need a formula that will look at the information in a range of column within a row. if the number in a column is greater than zero, then i need to add one to the total. this will allow me to know the number of columns with values greater than zero. ... 17 May 2010 13:33
excel I have a spreadsheet linked to others which retrieves data from each month and places the infor in a sumarry table. Rather than change the formulas each month is there a formula that will move the reference to the next row the next month thanks, ... 17 May 2010 09:08
circular formula gives different values I have a circular reference in my worksheet where I get two sets of values for the same input as the circular flips between two values. I have set the iteration to 100 but the values in the sheet do not give the same answer each time. ... 17 May 2010 09:08
Converting A String to a Column of Data I have some strings like this (some are as long as 4000 separated values): A;AA;AAI;AAP;AAPL I am looking for a way to convert these strings into column data like this: A AA AAI AAP AAPL Thank you in advance. ... 19 May 2010 16:03
How can stop a 9 digit number from formatting scientific I am completing a pivot table/csv file for Government Legislation requirements and my user id number for submitting the information keeps reverting to a scientific number which is unacceptable to the government site. I have tried and better tried formatting the cell, gone into tools/edit etc but to no avail I am... 18 May 2010 18:09
Find a number in a column then return a value from another cel Thank you Jacob yoyr solution is exactly what I was looking for Many thanks Mark "Jacob Skaria" wrote: Hi Mark Try the below array formula..press CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar' you can notice the curly braces at both ends like "{=<formula>}" App... 17 May 2010 05:52
to find the difference between time Hello Sir, I am a data entry operator in an organisation. I want to find the time difference. For this please help me. what i have done? i opened a worksheet. i enter the date 07.05.10 in first coloumn, then i entered the time 5:30 pm in second coloumn. In third coloumn i entered the date 09.05.10, then i... 17 May 2010 04:48
Pivot from multiple sheets Hi, I need to make a pivot from multiple sheets. I have tried to make by consolidating the sheets, hoeverthere are some limitations to that. It does not give me the flexibility for presentation of the data. for example i have the below data if i make a pivot then it wont give the breakdown of the column ... 17 May 2010 01:36
Dropdown Query Dear all, I have two columns. Each column contains a defined value and each value carries some predefined details. I am trying to place a dropdown through data validation, so that i select any value, i should be getting all the details related to that value without any extended space. Like below-: ... 17 May 2010 02:40
Fixing a formula to read a general format? 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 r... 16 May 2010 20:08 |