Worksheet Functions - Page 461

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
Sumifs function by Alan I've entered the formula, it appears correct, and the correct result is displayed in the function argument box, however only the formula displays in the...	July 13th, 2009 07:16 PM by Luke M	2	110
Using =MAX() or =MAXA() on Pivot results doesn't work by circuit_breaker Hi, I created a VBS file that creates a Pivot Table that looks like: Count of ReleaseVer ReleaseVer Total --------------------- N/A ...	July 13th, 2009 06:46 PM by Teethless mama	1	99
Rounding Of Concatenated Costs Field by Caldo The second field in my concatenate function is actual costs, the first is line of business. One value, for example, is $29,501,341.16 which I can round down... ( 1 2)	July 13th, 2009 06:25 PM by Caldo	10	150
Circular Error by Johnnie[_2_] In worksheet 2, cell G1 I have the following formula: =IF(F1M1,F1,IF(F1M1,M1,0)) I want to pull the results of this formula into worksheet 1, cell Y1 as...	July 13th, 2009 06:03 PM by Francis	2	99
IF, INDIRECT, & Wild cards by javablood I have the following formula in a worksheet cell that captures data from another worksheet: =IF(INDIRECT("'"&$T$1&"'!" & "h"&$N37) = "U",...	July 13th, 2009 05:42 PM by T. Valko	8	114
header row by Bridgettesmom I am trying to resort and subtotal an old worksheet, but no matter what I do, I cannot get excel to recognize the first row as a header row.	July 13th, 2009 05:02 PM by Niek Otten	2	89
Formula to calculate differently based on original value by Pam I have tried to use an "IF" formula to do this but to no avail... What I want to do is have a column of data that will be decimal values such as 0.6, 0.8,...	July 13th, 2009 04:41 PM by T. Valko	6	112
CONDITIONAL FORMATING by Kanmi Please i'm trying to conditional formating the cell and waht to figure out which way is the best way n right formular to use. thanks for your ideas greater...	July 13th, 2009 04:12 PM by Bernard Liengme[_2_]	3	85
Rate vs. IRR by Phin Lars Hi, I'm building an LBO model and I don't understand the difference between using an IRR function (over a stream of cash flows) and the rate function (equity...	July 13th, 2009 04:12 PM by JoeU2004	1	101
what is the meaning of ? by bitwhite Can anybody please let me know what is the meaning of symbol " " ? Thanks.	July 13th, 2009 04:02 PM by DILipandey[_2_]	3	95
Can you combine Hyperlink and Vlookup in Excel? by Niall I have two spreasheets that have a common column what I want to do is be able to click on a cell in the common column in the first spreadsheet so that it...	July 13th, 2009 03:55 PM by Luke M	1	85
delete a range by The Weather Girl I cant delete a range... I have read the other forums from others with the same question, but i dont have and insert namedelete function...not sure if i'm...	July 13th, 2009 03:51 PM by Bernard Liengme[_2_]	4	150
Run Excel macro from Scheduled Task by coolthinking Hello, My target is to run everyday at 06:00 a macro within my Excel document without being connected to the server where the file is located. Based on...	July 13th, 2009 03:35 PM by coolthinking	4	74
determining best data using functions? by ivory_kitten here is my problem and i'm not sure which functions will get me the answer that i need! # of persons: 20 Each person can have 1 item from each...	July 13th, 2009 03:16 PM by Max	2	95
excell 2003 result in t by results in separate sheet I'd like to get in a third sheet differences -( thatis what is not in first or second sheet.Can excell do that and how? Thanks in advance!	July 13th, 2009 02:57 PM by Max	1	63
Check 3 cells, only one of the cells my be filled by Peter Jonkers I have 3 cells called "overtime" Traveltime"and "Servicetime" Those cells are in a single row. I am looking for a way so that only ONE of those cells are...	July 13th, 2009 01:39 PM by Peter Jonkers	7	110
How do I get the week in month from a date? by Oke I am searching for a formula to provide the week of the month given a date. For example 13, July 2009 is the 2nd Monday in July 2009. Does anyone know a...	July 13th, 2009 11:29 AM by Ron Rosenfeld	2	96
Sumproduct? by Looping through I am tring to count the number of time a specific text appears in a range. The following formula counts the total number of entries in my range but is not...	July 13th, 2009 08:56 AM by NMT	4	83
Excel is seeing the date as dd/mm/yyyy by Lisa I have a column of dates that I'd like to use in a formula. Problem is Excel sees the dates as dd/mm/yyyy when they are actually entered as mm/dd/yyyy. For...	July 13th, 2009 08:50 AM by Vishal	4	102
Array Help? by Danny Boy I must have a brain cramp because I can't get the formula below to work. In Column A I have items to buy, in Column B I have dollar amounts associated with...	July 13th, 2009 08:29 AM by David Biddulph	6	82

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