Excel Worksheet Functions - Page 58

Thread / Thread Starter	Last Post	Replies	Views
Need to extract specific data from a text column Homecomingwarrior	by Joe User[_2_]	2	883
Lose Formatting [email protected]	by [email protected]	0	485
locate first value greater than MPI Planner[_2_]	by MPI Planner[_2_]	6	1,923
I need to write a PRODUCT formula that mimics a SUMIF eileenfz	by Tom Hutchins	3	614
Can I color a cell with "If" formula DLHedges	by JLatham	2	988
Average For Filtered Cells carl	by Don Guillett[_2_]	1	1,224
transfering cell values progressively through worksheets Mike1558	by Mike1558	8	616
Combining Cells George Perrotta	by tompl	2	649
Change formulas in a column based on a selection. Ephraim	by Ephraim	3	1,245
sumif - with 2 conditions - rows and columns UKMAN	by UKMAN	2	2,349
Combine several spreadsheets with multiple worksheets into 1 file jydoug	by Ron de Bruin	5	2,494
different colour font in same cel ILMER57	by JLatham	4	698
Counting Array element asingh	by asingh	4	671
Format cell based on cell color Jim	by Jim	3	1,083
using if in a range Sai	by Teethless mama	4	745
Basic Question on autocomplete function kimmyhendrix	by Roger Govier[_8_]	2	601
formating JCRICKET	by Dave Peterson	1	496
Count if if JCRICKET	by Dave Peterson	1	421
Consolidate excel 2007 Glenn	by Dave Peterson	4	701
If function with calculation Charlie	by Charlie	4	561
Merge Cells CarlainCerebroMode	by RonaldoOneNil	1	533
Help With A Spreadsheet for a silent auction Ken P	by Steve Dunn	1	4,921
Return column header based on last value in row C.	by Steve Dunn	3	1,346
sumif.. nordiyu	by Ashish Mathur[_2_]	3	394
Counting frequency in unsorted data PhilC	by PhilC	2	550
Look for Max and second Max Elton Law[_2_]	by Elton Law[_2_]	0	563
Extract if 1 shows up Elton Law[_2_]	by Ashish Mathur[_2_]	3	526
Sum with 3 conditions diepvic	by diepvic	9	530
Find 2 highest point to form resistance line Elton Law[_2_]	by Elton Law[_2_]	4	705
Adding dates in columns Roy	by ozgrid.com	2	685
how to key in a1 information on e1 wil appear at b1 Janet	by Rick Rothstein	1	419
Find 2 lowest point to form a trendline Elton Law[_2_]	by Elton Law[_2_]	0	734
date Concatenation gb_S49	by Russell Dawson[_2_]	6	510
Pivot table field list missing Dianeg	by Dianeg	5	1,833
Freeze Column ManhattanRebel	by Roger Govier[_8_]	7	1,011
Delete 3 end row climate	by Jacob Skaria	6	480
Unprotect problem DJohnM	by DJohnM	2	808
LOOKUP across a whole table and not just first row or column Eric_G	by Fakhrul Islam	5	2,018
Customize accounting format Rhett	by ozgrid.com	3	913
separate text and number raju	by ozgrid.com	4	710
Summing based on dates Mike[_28_]	by T. Valko	3	411
Countif using cell refences Gnealeuk	by Fred Smith[_4_]	4	555
Summing based on dates ajnmxx	by JLatham	2	456
Searching based on text EJ Hill	by Dave Peterson	7	478
Macro - onAction arguments version83	by Dave Peterson	2	2,018
Excel 2003 formula Ginger	by Don Guillett[_2_]	6	1,015
Running total based upon current date ucastores	by Don Guillett[_2_]	5	869
vlookup formula error Samantha	by Dave Peterson	2	560
Time elapsed calculation MTate	by Ron Rosenfeld	9	831
Keyboard shortcut for Paste Special-Values skoeske	by Michael	4	6,325
Updating Next Consecutive Cell in Range Stilltrader47	by Stilltrader47	8	834
How to set up a conditinal formula w/letters vs numbers? lz	by Dave	2	535
Multiple table lookup tornado1981	by T. Valko	13	1,142
How do I set up a formula to give me an average based on IF? Kris M	by Teethless mama	1	527
Average with Conditions Curtis[_2_]	by ozgrid.com	3	536
Help for Medical Records sorting Gerry St	by Gerry St	4	1,051
Counting Merged Cells Excel Ella	by FSt1	5	1,050
Formatting does not follow when copying from one cell to another Banker	by Gord Dibben	7	822
Excel 2007 - AVERAGEIF on rows that are non-continuous tcbooks	by Bob Phillips[_4_]	2	1,416
SUMIF with OFFSET Lewis Clark	by T. Valko	5	4,488
Line Feed in Formula Adds Double Quotes? CarlT	by julie kothari	3	2,622
How to count merged cells Excel Ella	by JLatham	2	3,035
How do I conditionally format only some of the text in a cell? Goo	by Dave Peterson	9	1,301
return 0 if cell has data? kathysonisland	by Joe User[_2_]	4	700
#VALUE error-- some cells? roborat	by Luke M[_4_]	3	947
Return 0 if cell has data, of copy if it doesn't kathysonisland	by Joe User[_2_]	2	1,007
sum column based on single cell match? adodson	by Luke M[_4_]	1	1,047
How do I truncate linked text? Jenni	by Dave Peterson	1	697
Counting text within an Entire Workbook Carrie_Loos via OfficeKB.com	by Carrie_Loos via OfficeKB.com	5	715
open workbook to specific sheet Mr E[_2_]	by Gary Brown[_6_]	1	900
IF Formula SilviaG	by David Biddulph[_2_]	1	479
Excel Bear	by David Biddulph[_2_]	2	440
Format custom number: C-0000-L Sonia	by tompl	3	1,054
Excel is reading formula as a value Louise[_3_]	by Louise[_3_]	3	496
Conditional Formatting Confusion... frakincaprica	by David Biddulph[_2_]	2	477