Worksheet Functions - Page 1501

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
sumif more conditions by Pierre via OfficeKB.com Hi experts, I have the following code that works fine: =SOMPRODUCT(('nieuwe productie 2006'!G4:G1004="DUO Bedrijfspensioen")* ('nieuwe productie...	January 2nd, 2006 10:49 PM by Bob Phillips	6	108
SumProduct Formula by carl this is part of a sumproduct formula I am using: --($D$137:$D$318=C123) Is it possible to modify the formula so that it will look for values on C123 between...	January 31st, 2006 08:14 PM by Biff	2	108
How do I add time abouve 10000 hours in excel? by Byron I am adding times in excel, and everything is fine until I get above 10,000 hours. The sum feature in the program will not allow additions above 10,000, or at...	February 2nd, 2006 06:17 AM by Biff	4	108
Advanced Filter by Dee I have a spreadsheet that has a list of sites and names of people at each site. The site name is repeated many times if there is more than one person listed at...	February 8th, 2006 04:21 PM by Ron de Bruin	1	108
powers to negative numbers by Dave.e How can I find the inverse function of sine and also how do you find powers to negative numbers	February 10th, 2006 05:27 PM by Bernard Liengme	6	108
Days360 problem by jellorain Seeing a problem that could possibly be an excel glitch in the days360 function. I'm running O2k3sp2 and have tried this on several machines including...	February 10th, 2006 05:22 PM by Niek Otten	6	108
Adding Cells across Worksheets by TJ7933 I have a set of about 35 worksheets. I need to add up the total in all cells that are the same. I mean D38 from all the worksheets, onto one primay "TOTAL"...	February 13th, 2006 04:11 PM by Philip J Smith	2	108
Build Formula by lynnc I am looking for syntex that will build a formula. I want to replace this reference ='Capacity Synopsis'!L19 with a formula that will build the reference...	February 13th, 2006 11:24 PM by Harlan Grove	4	108
VLOOKUP or... by Jaan Ihave...	February 14th, 2006 07:23 PM by Jaan	2	108
Custom formatting not functioning in Excel by Seenath I have an Excel sheet in which date related formulae were working properly. But now the Format-Cells-Custom- ddd, d/mmm/yyyy is not accepted by Excel. Date...	January 28th, 2006 12:33 PM by Niek Otten	1	108
Sorting by Tom In a workbook I would like a macro to sort a column (a-z) that has blanks rows between the data to be sorted. Example: Before ...	January 27th, 2006 11:49 PM by Dave Peterson	3	108
New data will not sort with existing data from copied file by Carolyn I have copied a file within the same worksheet, it is for tracking purposes. Any new data I have entered will not sort with the old data. It will sort the new...	January 5th, 2006 02:11 PM by Gary L Brown	3	108
Ghost numbers in blank cells by scott Just a questilon. In my ss I had a value erro show up, the formula was correct and when I tracked down the cell that the formla was using it was blank. I...	January 5th, 2006 06:53 PM by Lotus123	2	108
DATEVALUE works on one sheet, not another by Kim I have a datevalue formula - "=DATEVALUE(H41)-DATEVALUE(Summary!$I$1)" that works on one worksheet but not another in same file. Changing arguements in either...	January 16th, 2006 05:21 PM by Kim	4	108
Price function difference in Output formula vis a vis Manual Calculation by abhi_23 Hi I am trying to calculate the Price of a bond using the price formula there apprears to be a difference in the results when the Price is calculated as per...	January 17th, 2006 07:57 AM by abhi_23	0	108
View the rows in alternate black and white by jjaammess Excel 2003: When dealing with large spreadsheets and trying to scan across the sheet to read/edit data it would be helpful if you could format large areas of...	January 23rd, 2006 03:43 PM by Chip Pearson	2	108
How to solve tie when using the Rank function? by Skeep I am currently using the rank function and when a tie occurs they have the same rank. So assume I have three months of sales that are the same......	January 26th, 2006 08:56 AM by Skeep	2	108
Dates and periods by Coliber Hi, I have a "small" problem with dates-related formula. SCENARIO _Period_Range_Worksheet_ Column A - name of a period ie. Period01 2005, Period02 2005 and so...	January 26th, 2006 09:14 PM by Coliber	6	108
Macro to Delete blank cells by GarToms I have a table of data and i want to delete a block of blank cells within it. i.e. A b c d e f g h i 1 x x x x x x x x x 2 x x x x x...	January 26th, 2006 07:39 PM by Dave Peterson	1	108
Time formatting:data 1:30:20 entered reads in 1:30:20 pm by Ellen I am trying to get data entered in format 1:30:25 etc... to read 1:30:25 PM but it keeps reverting back to am.	February 17th, 2006 02:10 AM by GS	2	108

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed