Excel Worksheet Functions - Page 1126

Thread / Thread Starter	Last Post	Replies	Views
Keyboard shortcut for Paste Special-Values skoeske	by Michael	4	6,310
Time elapsed calculation MTate	by Ron Rosenfeld	9	804
vlookup formula error Samantha	by Dave Peterson	2	543
Running total based upon current date ucastores	by Don Guillett[_2_]	5	861
Excel 2003 formula Ginger	by Don Guillett[_2_]	6	1,009
Macro - onAction arguments version83	by Dave Peterson	2	1,983
Searching based on text EJ Hill	by Dave Peterson	7	470
Summing based on dates ajnmxx	by JLatham	2	442
Countif using cell refences Gnealeuk	by Fred Smith[_4_]	4	549
Summing based on dates Mike[_28_]	by T. Valko	3	401
separate text and number raju	by ozgrid.com	4	705
Customize accounting format Rhett	by ozgrid.com	3	902
LOOKUP across a whole table and not just first row or column Eric_G	by Fakhrul Islam	5	1,999
Unprotect problem DJohnM	by DJohnM	2	803
Delete 3 end row climate	by Jacob Skaria	6	476
Freeze Column ManhattanRebel	by Roger Govier[_8_]	7	1,000
Pivot table field list missing Dianeg	by Dianeg	5	1,823
date Concatenation gb_S49	by Russell Dawson[_2_]	6	503
Find 2 lowest point to form a trendline Elton Law[_2_]	by Elton Law[_2_]	0	716
how to key in a1 information on e1 wil appear at b1 Janet	by Rick Rothstein	1	409
Adding dates in columns Roy	by ozgrid.com	2	675
Find 2 highest point to form resistance line Elton Law[_2_]	by Elton Law[_2_]	4	699
Sum with 3 conditions diepvic	by diepvic	9	523
Extract if 1 shows up Elton Law[_2_]	by Ashish Mathur[_2_]	3	510
Look for Max and second Max Elton Law[_2_]	by Elton Law[_2_]	0	541
Counting frequency in unsorted data PhilC	by PhilC	2	527
sumif.. nordiyu	by Ashish Mathur[_2_]	3	384
Return column header based on last value in row C.	by Steve Dunn	3	1,331
Help With A Spreadsheet for a silent auction Ken P	by Steve Dunn	1	4,870
Merge Cells CarlainCerebroMode	by RonaldoOneNil	1	521
If function with calculation Charlie	by Charlie	4	550
Consolidate excel 2007 Glenn	by Dave Peterson	4	689
Count if if JCRICKET	by Dave Peterson	1	412
formating JCRICKET	by Dave Peterson	1	488
Basic Question on autocomplete function kimmyhendrix	by Roger Govier[_8_]	2	579
using if in a range Sai	by Teethless mama	4	734
Format cell based on cell color Jim	by Jim	3	1,073
Counting Array element asingh	by asingh	4	660
different colour font in same cel ILMER57	by JLatham	4	687
Combine several spreadsheets with multiple worksheets into 1 file jydoug	by Ron de Bruin	5	2,484
sumif - with 2 conditions - rows and columns UKMAN	by UKMAN	2	2,333
Change formulas in a column based on a selection. Ephraim	by Ephraim	3	1,219
Combining Cells George Perrotta	by tompl	2	639
transfering cell values progressively through worksheets Mike1558	by Mike1558	8	607
Average For Filtered Cells carl	by Don Guillett[_2_]	1	1,207
Can I color a cell with "If" formula DLHedges	by JLatham	2	966
I need to write a PRODUCT formula that mimics a SUMIF eileenfz	by Tom Hutchins	3	603
locate first value greater than MPI Planner[_2_]	by MPI Planner[_2_]	6	1,910
Lose Formatting [email protected]	by [email protected]	0	472
Need to extract specific data from a text column Homecomingwarrior	by Joe User[_2_]	2	873
Averaging many non-contiguous cells if they are blank Nadine	by macropod[_2_]	1	759
Duplicates formula Soth	by Ashish Mathur[_2_]	5	463
Ignore Hidden Rows and Count of distinct values Anuma (GGK Tech)	by Ashish Mathur[_2_]	3	1,738
Sum VLOOKUP? andyoftheg	by Ashish Mathur[_2_]	4	1,711
excel formula Brian	by T. Valko	6	470
Invoice: customer database and billing information Nic Daniels	by JLatham	3	1,631
Non-contiguous range and Sumproduct to average Mifty	by T. Valko	5	1,884
vlookup and match first value greater than MPI Planner[_2_]	by Teethless mama	4	4,735
I want to add formulas from multiple sheets to master form snake941	by Fred Smith[_4_]	1	601
Conditional formatting with expired dates after current Josh	by Max	1	1,443
visible cell only Brad Autry	by T. Valko	1	712
Unable to set the FormulaArrary property of the range class RTK	by RTK	0	626
Empty Cell Result Mike H.	by Grimwadec	8	542
Help with formula Brandon	by Stefi	1	507
Removing multiple duplicate events Father John	by Ron Rosenfeld	10	862
Look for Min and second Min Elton Law[_2_]	by Steve Dunn	13	1,459
Array Formula Help Needed nelly	by nelly	5	499
Sum amount of days in another coloumn Scott_goddard	by Jacob Skaria	8	625
Combining text from multiple cells mgerken79	by Don Guillett[_2_]	6	947
Hyperlink won't open in excel JBrits	by JBrits	0	2,087
Auto-insert same value each Monday in cashflow worksheet? Scribble	by Scribble	0	680
stock control template Gary L	by Eduardo	1	2,535
Adding totals from different columns Eskercat	by Ashish Mathur[_2_]	1	474
ISNA VLOOKUP does not recognize 63023 Nain	by Dave Peterson	4	1,008
Vendor List Andri	by Andri	7	703