Excel Worksheet Functions - Page 615

Thread / Thread Starter	Last Post	Replies	Views
change the century Keith	by Gord Dibben	5	655
Copy Excel tab (worksheet) to another Excel file Stefan van der Hooft	by Gord Dibben	4	1,380
Load caption box on userform open ExcelMonkey	by Bob Phillips	1	734
Excel Loan amortization Excel X for Mac 10.1.6 Larry Rowe	by Harlan Grove[_2_]	1	1,246
Conditional Average [email protected]	by [email protected]	4	413
Using booleans in sumproduct formulas to extract boolean range ExcelMonkey	by ExcelMonkey	4	1,701
Format Cells by code Michael M	by Bob Phillips	3	606
Generating a list Dave[_3_]	by Pete_UK	1	526
Change values in multiple cells from one cell zeewaa	by Gary''s Student	1	654
How to set condition for frequency? Eric	by Eric	7	391
SUMPRODUCT Formula Help Please Joe Gieder	by Domenic	12	800
=and formulas with =if formulas spicole	by Ragdyer	2	364
Count how many persons in a month using a date mash	by Bernard Liengme	2	611
Excel Chart - Require a Formula [email protected]	by PBalmanno	2	442
sumif formula Louie	by Teethless mama	5	367
Creating Buttons using the Forms Tool bar. MK	by Jim Cone	1	481
Printing selected parts of a list.... Daniel R	by Daniel R	2	522
If time Go to Function CAB	by Stefi	1	468
Force sort before worksheet exit Kathrine	by Kathrine	2	945
Calculating moving average [email protected]	by Bob Phillips	1	472
Difference between two dates rounded up. megan	by megan	4	1,269
Calculate Range SRV....Frenzy	by Mike	1	411
date formula Dreamstar_1961	by Dreamstar_1961	0	413
Extract Client Refs from pivot table into another worksheet Sarah (OGI)	by Sarah (OGI)	0	588
Increasing font? lon8384	by Susan	2	384
lookup stock symbol on worksheet and return summary data Greg Purnell[_2_]	by Dave F	7	746
basic question - how to calculate a cumulative percentage? Prospect	by Bob Phillips	3	4,387
How Excel help to reproduce a form like this GY Fong - HK	by Bob Phillips	1	431
counting cells? alberto	by alberto	4	482
date formula Dreamstar_1961	by Dave F	3	350
Looking for formula that selects last value entered in a column? playgolf	by Billy Liddel	2	633
How to use functions after sorting a range? R13	by R13	2	402
earlest date not complete Dreamstar_1961	by Dreamstar_1961	5	459
Extracting information Paula	by Dave F	1	539
lookup the next matching record. tess	by Max	5	965
Match data in 2 columns and return data from 3rd column gwtreece[_2_]	by Dave Peterson	1	1,855
display hidden rows using conditional formatting D	by D	0	423
Using Solver with Data Table Latika	by Latika	0	1,296
How can I make my entire document CAPS? Erin	by Paul B	1	1,068
How to leave the lines on my exel work sheet BKMorris	by George Nicholson	3	1,910
Formatting Time As hhmmss Gives Me Dates Instead? Donna	by Donna	3	949
how do i get data from another workbook pfunkerausa	by pfunkerausa	2	620
Using multiple IF criteria JerryS	by Hans Knudsen	2	533
Sort Left-Right & Up-Down Ben Dummar	by Ben Dummar	0	579
Help - I need to combine both a SUMIF and COUNTIF into one formula Natty	by Clark	7	1,204
cell lookup MLK	by MLK	2	321
Dragging Data into a new worksheet and arranging it by type shryockp	by shryockp	2	391
Solver/Data Tables - help pls :) Latika	by Art	1	423
Sumproduct copying blanks or how to insert zero into blanks asg2307	by asg2307	4	881
VLOOKUP/Index&Match data format issue [email protected]	by Allan[_2_]	3	3,081
Compounding a percentage Danielle	by Art	3	428
Excel 2003 - in a formula, " changes to @ - what do I do Tory	by Joel	1	287
Convert Data in a Cell XFILES	by Joel	1	329
reference to other sheet Bakerman	by BoniM	2	316
Multiple Lookup as condition in sumproduct formula ExcelMonkey	by ExcelMonkey	2	976
Adding numerical values based on multiple values in another column Kazmaniac	by Harlan Grove[_2_]	6	1,123
Function termnology Colin	by Peo Sjoblom	2	292
This ones got me stuck DB	by DB	4	467
user defined function ub	by Dave F	6	714
rearranging data [email protected]	by [email protected]	4	550
edit links Shooter	by Peo Sjoblom	3	497
sorting without changing formats LisaD	by Bill Kuunders	4	1,734
summing daily data by month Mona	by T. Valko	1	424
Create filename based on cell contents JR Hester	by JR Hester	7	859
Nested loop [email protected]	by JMB	1	375
IF-OR Functions archsmooth	by JMB	3	340
Lookup tables? Dave	by Dave	2	306
What is the priority of Mode function? Eric	by T. Valko	1	294
Question using DGET function Jasonm	by Jasonm	1	398
dates got me stuck Suzuki Steve	by Teethless mama	3	302
create alert when in sheets are grouped Twishlist	by JMB	1	546
MS-Excel Formula muzickdoc2006	by Fred Smith	4	367
Help with nested function q3pd	by Roger Govier	10	692
sumif or something John	by Max	1	467
Validation drop-down arrow not showing for SOME users - fine with others? [email protected]	by [email protected]	2	1,088