Excel Worksheet Functions - Page 1049

Thread / Thread Starter	Last Post	Replies	Views
Sum Column above current cell dynamically using function call TopSlice	by TopSlice	7	690
filter and relations between fields Dennis Cheung	by Pete_UK	1	388
If cell contains a value, multiply... JFro	by JFro	3	1,451
Adding multiple numbers in one cell pandd15	by Glenn	16	1,726
Calculating the days between two dates pandd15	by Sam Wilson	2	530
countif using multiple if statements Raymond	by David Biddulph[_2_]	4	1,262
Return blank cell if data cell is blank imckinne	by imckinne	4	1,490
Help with Excel if function and macros perl	by perl	3	365
Excel Function to Count Renegade	by T. Valko	2	410
Calculating Cell Occupation Colin Hayes	by Colin Hayes	2	375
Data Connection Parameter Issue Scytok	by Scytok	0	1,030
Designing master schedule Kelli Jordan	by Rich/rerat	4	1,295
order of opening files with sumproduct returning #REF! sharon p	by sharon p	2	792
functions/Formulas RH	by Jacob Skaria	6	423
Formula Help for Novice User - Lookup Option maybe Gayle	by Gayle	4	518
Want to display day and month in date and hide the formula vickyisindy	by Gord Dibben	1	628
If Statement to subtract €œtime€ if condition met BumblebeeFan	by BumblebeeFan	7	513
counting afdmello	by afdmello	8	381
Finding multiple data values in a column PeteJ	by PeteJ	2	520
formula date range Kalida Williams	by T. Valko	4	489
STDEV Limited Number of Arguments nc_pinz	by barry houdini[_31_]	1	855
Automatically merge mulitiple cells to one cells Edward Wang	by Edward Wang	5	763
Remove data in a cell sjs	by sjs	2	349
Cell References a	by Nebulous	4	341
Formatted Result from an IF function Sri Harsha[_2_]	by Eden397	3	369
Finding a single word match in a text string and assigning a code Morton Detwyler[_2_]	by T. Valko	6	624
Tough formula to cause auto-updates in multiple cells Access Joe	by Access Joe	2	320
change appearance of cell being used so it stands out yogirhonda	by Gord Dibben	1	420
CLEAN function - macro?? George Applegate[_2_]	by smartin	2	984
Averageifs where subgroups are used Go Bucks!!![_2_]	by Ashish Mathur[_2_]	4	460
count cells ocl0	by Ashish Mathur[_2_]	4	409
Extract data from a cell sjs	by Ashish Mathur[_2_]	4	773
add apostrophe to text in cell WJS	by Ashish Mathur[_2_]	3	5,179
Please Help with this formula...Thanks Schedule Formula - Please Help - Thanks!	by Schedule Formula - Please Help - Thanks![_2_]	1	424
Looking up data. Kewlstix	by Ms-Exl-Learner	2	363
Spaces at the end of data sjs	by Ron Rosenfeld	5	1,582
How create a formula series with series inside Ric	by Jacob Skaria	3	864
XIRR non adjacent cells PJM	by JoeU2004	2	2,567
Pivot Tables by Macro Max2073	by Max2073	2	376
function to reference value selected with autofilter cm	by ryguy7272	2	379
Dates format Hardeep Kanwar	by Hardeep Kanwar	2	359
Where is the list function in the data menu? Spinycollard	by Teethless mama	3	1,049
Cell Validation Lists JAdams80	by Jacob Skaria	1	387
I WANT TO INSERT A LETTER IN FRONT OF A NUMBERS Nathan	by Jacob Skaria	6	3,460
pivottable bug Robin Krupp	by Paul Francis	5	918
I want to secure a column from have the same number entered twice John	by Jacob Skaria	1	496
Add COUNTIF TO USERFORM TEXTBOX Richhall[_2_]	by Richhall[_2_]	4	4,007
A logical test in the If function for blank, i.e., If blank? egii	by Showboat911	5	2,405
Spreadsheet usage [email protected]	by Joel	1	402
Formula Suggestion Ward	by Ward	0	319
Multi area Array using IRR function Malakite	by Malakite	2	1,798
how do i select all cells in a worksheet Ken[_6_]	by Ken[_6_]	3	361
How to use: (ERR) a form.contains 1 or more invalid refs.? Boswell[_2_]	by Boswell[_2_]	0	513
dates and text in excel Squidgee	by Glenn	2	370
Maximum number of data validation cells? Stuart	by Max	3	1,350
Data cleanup sjs	by Teethless mama	1	472
Userform Refresh on Worksheet change Richhall[_2_]	by Richhall[_2_]	3	1,893
Conditional Format 2007 Paula	by David Biddulph[_2_]	1	357
vlookup i think samantha	by Ms-Exl-Learner	3	485
Store array ??? piero	by Dave Peterson	4	652
MOving Data to the next line Greg S[_2_]	by Gord Dibben	1	379
Count if two arguments are true LWilson	by LWilson	2	1,116
Looking up first and last DRC	by T. Valko	7	404
Exclude days Mya48	by Mya48	0	357
IF statement to check for numerical value Toan	by Toan	3	352
PLEASE ALWAYS INDICATE YOUR VERSION OF EXCEL Bob Umlas[_3_]	by JoeU2004	1	487
if function with multiple criteria LaTanya	by Ashish Mathur[_2_]	4	878
Conditional Formatting Pivot Table Excel 2007 MVarma	by AFSSkier	1	2,148
FIND LAST CELL WITH DATA Sharon	by T. Valko	13	1,193
Formula to subtotal monthly expense Kent	by Ashish Mathur[_2_]	5	1,807
Excel 2007 Creating a chart Red Baroness	by Jacob Skaria	1	386
Comments box Bryan De-Lara[_2_]	by Steven Kemp	6	576
Expanding formula to look in several sheets jkrons	by jkrons	0	441
I need a cell to be blank. David Moore	by Pete_UK	4	369
comment enclosed using vlookup Pran	by Pran	2	331