Excel Worksheet Functions - Page 51

Thread / Thread Starter	Last Post	Replies	Views
Vlookup and if formula edwin	by Jacob Skaria	2	552
CONVERT ROMAN TO ARABIC NUMERALS JOHN	by Ron Rosenfeld	7	3,242
Conditional Formatting based on match to external list Dawn Mann	by Steve Dunn	1	1,202
SumIf Debi	by Mike H	3	414
Vlookup & relative cell reference? Cecilia	by Jacob Skaria	2	1,402
Icon sets - conditional formatting - in Excel 2003 Lou	by ozgrid.com	1	1,910
Countif for finding a Time input Meebers[_4_]	by Meebers[_4_]	4	435
SUMIF Function Traci P.[_2_]	by Ashish Mathur[_2_]	2	426
Assigning a number value to text SoupNazi	by Fred Smith[_4_]	5	8,978
Days in Text to Dates SPECIAL DOUG	by Ron Rosenfeld	1	471
How do i convert dates to text but keep the date format SallyP	by Gord Dibben	1	4,933
Find and Replace Pierre	by Tom Hutchins	4	351
Help Creating Excel Formula jamesvh	by jamesvh	4	681
changing formula Excel formula	by Excel formula	0	379
Can I use Sumproduct with the LEFT Function? Chris	by T. Valko	11	3,405
data validation using named range from another file pat67	by Gord Dibben	3	1,697
Counting with 2 criteria Amethyst	by Amethyst	3	335
row height issue Mike SoCal	by Gord Dibben	1	750
Average using Sumproduct Basenji	by Joe User[_2_]	4	3,898
Rounding Cynthia	by Cynthia	4	399
Change the weekends Sadad	by Mike H	1	370
Conditional IF formula using multi-dimensional arrays iperlovsky	by iperlovsky	2	593
How do I set NETWORKDAYS to regard friday and saturday as weekend Shay.C.	by Sadad	2	2,024
Date Diff - excluding working days Scott_goddard	by Rick Rothstein	2	1,102
Median with Criteria Demosthenes	by Demosthenes	2	1,990
Vendor List Andri	by Andri	7	583
ISNA VLOOKUP does not recognize 63023 Nain	by Dave Peterson	4	902
Adding totals from different columns Eskercat	by Ashish Mathur[_2_]	1	426
stock control template Gary L	by Eduardo	1	2,496
Auto-insert same value each Monday in cashflow worksheet? Scribble	by Scribble	0	621
Hyperlink won't open in excel JBrits	by JBrits	0	2,028
Combining text from multiple cells mgerken79	by Don Guillett[_2_]	6	895
Sum amount of days in another coloumn Scott_goddard	by Jacob Skaria	8	520
Array Formula Help Needed nelly	by nelly	5	422
Look for Min and second Min Elton Law[_2_]	by Steve Dunn	13	1,383
Removing multiple duplicate events Father John	by Ron Rosenfeld	10	801
Help with formula Brandon	by Stefi	1	447
Empty Cell Result Mike H.	by Grimwadec	8	474
Unable to set the FormulaArrary property of the range class RTK	by RTK	0	565
visible cell only Brad Autry	by T. Valko	1	679
Conditional formatting with expired dates after current Josh	by Max	1	1,316
I want to add formulas from multiple sheets to master form snake941	by Fred Smith[_4_]	1	551
vlookup and match first value greater than MPI Planner[_2_]	by Teethless mama	4	4,661
Non-contiguous range and Sumproduct to average Mifty	by T. Valko	5	1,790
Invoice: customer database and billing information Nic Daniels	by JLatham	3	1,586
excel formula Brian	by T. Valko	6	396
Sum VLOOKUP? andyoftheg	by Ashish Mathur[_2_]	4	1,639
Ignore Hidden Rows and Count of distinct values Anuma (GGK Tech)	by Ashish Mathur[_2_]	3	1,689
Duplicates formula Soth	by Ashish Mathur[_2_]	5	406
Averaging many non-contiguous cells if they are blank Nadine	by macropod[_2_]	1	671
Need to extract specific data from a text column Homecomingwarrior	by Joe User[_2_]	2	811
Lose Formatting [email protected]	by [email protected]	0	401
locate first value greater than MPI Planner[_2_]	by MPI Planner[_2_]	6	1,827
I need to write a PRODUCT formula that mimics a SUMIF eileenfz	by Tom Hutchins	3	553
Can I color a cell with "If" formula DLHedges	by JLatham	2	866
Average For Filtered Cells carl	by Don Guillett[_2_]	1	1,162
transfering cell values progressively through worksheets Mike1558	by Mike1558	8	543
Combining Cells George Perrotta	by tompl	2	540
Change formulas in a column based on a selection. Ephraim	by Ephraim	3	1,163
sumif - with 2 conditions - rows and columns UKMAN	by UKMAN	2	2,255
Combine several spreadsheets with multiple worksheets into 1 file jydoug	by Ron de Bruin	5	2,332
different colour font in same cel ILMER57	by JLatham	4	621
Counting Array element asingh	by asingh	4	572
Format cell based on cell color Jim	by Jim	3	1,021
using if in a range Sai	by Teethless mama	4	632
Basic Question on autocomplete function kimmyhendrix	by Roger Govier[_8_]	2	530
formating JCRICKET	by Dave Peterson	1	394
Count if if JCRICKET	by Dave Peterson	1	347
Consolidate excel 2007 Glenn	by Dave Peterson	4	638
If function with calculation Charlie	by Charlie	4	518
Merge Cells CarlainCerebroMode	by RonaldoOneNil	1	444
Help With A Spreadsheet for a silent auction Ken P	by Steve Dunn	1	4,519
Return column header based on last value in row C.	by Steve Dunn	3	1,193
sumif.. nordiyu	by Ashish Mathur[_2_]	3	326
Counting frequency in unsorted data PhilC	by PhilC	2	432