Excel Worksheet Functions - Page 58

Thread / Thread Starter	Last Post	Replies	Views
Pivot Table Conditonal Format of the Grand Total michelle	by Roger Govier	3	2,272
rounding decimals to nearest quarter ajeuck	by Bob Phillips[_3_]	4	2,271
Using text as a criteria in Excel Baba	by Pete_UK	4	2,271
excel links update not working in auto, calculations in auto Mikey Boy	by Mikey Boy	0	2,270
how to count unique values in excel based on multiple criteria IDBUGM	by Tom Ogilvy	3	2,270
Urgent help needed! skarbanan	by Biff	23	2,270
formula to lookup value and return value from cell at left of target Tony Strazzeri	by Roger Govier	14	2,269
Iserror is too cumbersome as I use it - is there an alternative? [email protected]	by ilia	5	2,269
Multiple Item Lookup Chad F	by Chad F[_2_]	33	2,269
AutoFilter settings in shared workbook Jill	by Jill	2	2,269
Partial String Match & Wild Cards Using VLOOKUP djDaemon	by djDaemon	0	2,269
VBA error - End If without Block If Jane	by Gary L Brown	2	2,268
Count and Sum of cells if conditions fulfilled Bono	by Max	12	2,268
filter for round numbers Julieeeee	by Pete_UK	2	2,268
How to make a cell trigger a Sound in Excel justice	by CC	3	2,268
countifs criteria includes date range JayH	by Ashish Mathur[_2_]	4	2,268
Indirect function with national language catherine	by Stefi	7	2,268
Excel Formula - Add column of numbers but ignore negative numbers view for Distribution List members	by bpeltzer	1	2,267
Wildcard for dsum formula jeq214	by jeq214	7	2,267
IF statements across Worksheets rgold	by rgold	2	2,266
Convert Numeric into Text Monty	by Monty	0	2,266
Here is Mortgage Calculator with Amortization sldfghtrike	by Stan Brown	12	2,265
Count No of days past due Mrs H	by Michael.Tarnowski	4	2,264
Conditional Formatting Multiple Columns JessP27	by JessP27	2	2,263
Extract Data From Textbox SEA	by Alan Pederson	6	2,263
Show forecast accuracy of customer schedules as a percentage Dave Dobson	by Dave Dobson	6	2,263
Repayment of loan excel sheet with variables of principal free pay Morten	by JoeU2004	1	2,263
plus-minus buttons in far left column (1) Steve	by Steve	3	2,262
Date if before or after 15th of month wf315	by TomPl	4	2,262
Vlookup not working properly Jaime	by Jaime	3	2,262
Display contents of adjacent cells Nigel Sunley	by Stefi	3	2,262
average based on weekday Nick	by Max	9	2,262
funcion de distribucion empirica Sonia	by Mayte	1	2,262
How do I insert a line break when using the CONCATENATE function? ShaneRuth	by Gord Dibben	2	2,261
Lookup Value and Return Column Heading eb	by eb	6	2,261
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. [email protected]	by [email protected]	1	2,261
Date Calculation to exclude weekends Vim	by [email protected]	2	2,261
how do you calculate compound interest with multiple payments? Wahine15	by Wahine15	8	2,260
Cannot insert worksheet in exel - not available in insert menu pedro39	by Dave Peterson	1	2,260
calc. an anniversary date(50 years) after marriage date in excel datakop	by Ashish Mathur[_2_]	3	2,259
Row = Application.Caller.Row Charles Woll	by Charles Woll	8	2,258
Do nothing in excel formula rovest	by matteo garibotti	5	2,258
Conditional Cell Shading (based on the shading of other cells) Tubby	by GEOFF	2	2,258
1-4-1 is not a date how do I stop excel from changing whats enter Perry Monroe	by Chip Pearson	4	2,258
click on or hover on cell to enlarge temporarily lost in Chicago	by Gord Dibben	1	2,257
combine multiple spreadsheets into one workbook Jen	by Duke Carey	1	2,257
Array Lookup to Find Closest Date and Next Closest Date [email protected]	by RagDyer	7	2,256
What excel snyntax and or function will add leading spaces Sharon	by Dave Peterson	3	2,256
Macro to delete rows with same data Connie Martin	by Bernie Deitrick	12	2,256
is there a formula that remove duplicate values from a range Martin R	by Mallycat	3	2,256
Insert Variable Number of Rows; With Loop ryguy7272	by ryguy7272	2	2,256
Opening a worksheet automatically at start up of computer LUVMEEDOO	by Gord Dibben	3	2,256
Canadian Postal Code format? Fritz	by Gord Dibben	9	2,256
advanced filter criteria "begins with" and "does not begin with" raph_baril	by raph_baril	3	2,255
How do i cross reference two excel spreadsheets? Paula	by James	6	2,255
Interpolating Yield Curve [email protected]	by [email protected]	3	2,255
Last Friday of the month Alfredo_CPA	by T. Valko	9	2,255
Retain font/cell color on lookup/copy JPS	by JE McGimpsey	3	2,254
STDEV (1st, 2nd, 3rd) and excluding datapoints Tom	by joeu2004	1	2,254
My discovery on DATEDIF and leap year Epinn	by Epinn	14	2,253
Dividing multiple cells by 1000 Debbie	by Pred	4	2,253
concatenate, force new line JohnT	by	2	2,253
How to draw a circle in excel with specific radius Mile	by Arvi Laanemets	1	2,253
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr Steve	by Steve	2	2,252
How do I create a combo box of hyperlinks? Laura Jordan	by Laura Jordan[_2_]	2	2,252
Two types of Data Validation in a cell? Lakeville	by sreenivas p	9	2,252
In Excel can I move the tabs to the left side of the workbook? kit	by Ken Wright	1	2,251
Pivot table calculated field: multiply Sum of FieldA with Max ofFieldB Amedee Van Gasse	by Amedee Van Gasse	4	2,251
how to use Gamma on excel? Meryem	by Bernard Liengme	1	2,250
find out average even rows in a particular range Muralikrishnan	by Muralikrishnan	9	2,250
Is there a keyboard shortcut for using Paintbrush? Mike M[_2_]	by Don Guillett	8	2,250
Lookup Function? Employee Number with Employee Name Lance Hebert[_2_]	by Eva	1	2,248
Excel: How to import multiple XML "Repeating child elements" same. l8vj	by l8vj	0	2,248
How to record time in Excel in military (0730) format? fontana	by David Biddulph[_2_]	17	2,248
Better performance Vlookup or Index/Match? Dan	by Infinitogool	1	2,247