Excel Worksheet Functions - Page 569

Thread / Thread Starter	Last Post	Replies	Views
VLOOKUP/Index&Match data format issue [email protected]	by Allan[_2_]	3	3,081
Sumproduct copying blanks or how to insert zero into blanks asg2307	by asg2307	4	881
Solver/Data Tables - help pls :) Latika	by Art	1	423
Dragging Data into a new worksheet and arranging it by type shryockp	by shryockp	2	391
cell lookup MLK	by MLK	2	321
Help - I need to combine both a SUMIF and COUNTIF into one formula Natty	by Clark	7	1,204
Sort Left-Right & Up-Down Ben Dummar	by Ben Dummar	0	579
Using multiple IF criteria JerryS	by Hans Knudsen	2	533
how do i get data from another workbook pfunkerausa	by pfunkerausa	2	620
Formatting Time As hhmmss Gives Me Dates Instead? Donna	by Donna	3	949
How to leave the lines on my exel work sheet BKMorris	by George Nicholson	3	1,910
How can I make my entire document CAPS? Erin	by Paul B	1	1,068
Using Solver with Data Table Latika	by Latika	0	1,296
display hidden rows using conditional formatting D	by D	0	423
Match data in 2 columns and return data from 3rd column gwtreece[_2_]	by Dave Peterson	1	1,855
lookup the next matching record. tess	by Max	5	966
Extracting information Paula	by Dave F	1	539
earlest date not complete Dreamstar_1961	by Dreamstar_1961	5	459
How to use functions after sorting a range? R13	by R13	2	402
Looking for formula that selects last value entered in a column? playgolf	by Billy Liddel	2	633
date formula Dreamstar_1961	by Dave F	3	350
counting cells? alberto	by alberto	4	482
How Excel help to reproduce a form like this GY Fong - HK	by Bob Phillips	1	431
basic question - how to calculate a cumulative percentage? Prospect	by Bob Phillips	3	4,387
lookup stock symbol on worksheet and return summary data Greg Purnell[_2_]	by Dave F	7	746
Increasing font? lon8384	by Susan	2	384
Extract Client Refs from pivot table into another worksheet Sarah (OGI)	by Sarah (OGI)	0	588
date formula Dreamstar_1961	by Dreamstar_1961	0	413
Calculate Range SRV....Frenzy	by Mike	1	411
Difference between two dates rounded up. megan	by megan	4	1,269
Calculating moving average [email protected]	by Bob Phillips	1	472
Force sort before worksheet exit Kathrine	by Kathrine	2	945
If time Go to Function CAB	by Stefi	1	468
Printing selected parts of a list.... Daniel R	by Daniel R	2	522
Creating Buttons using the Forms Tool bar. MK	by Jim Cone	1	481
sumif formula Louie	by Teethless mama	5	367
Excel Chart - Require a Formula [email protected]	by PBalmanno	2	442
Count how many persons in a month using a date mash	by Bernard Liengme	2	611
=and formulas with =if formulas spicole	by Ragdyer	2	364
SUMPRODUCT Formula Help Please Joe Gieder	by Domenic	12	800
How to set condition for frequency? Eric	by Eric	7	391
Change values in multiple cells from one cell zeewaa	by Gary''s Student	1	654
Generating a list Dave[_3_]	by Pete_UK	1	526
Format Cells by code Michael M	by Bob Phillips	3	606
Using booleans in sumproduct formulas to extract boolean range ExcelMonkey	by ExcelMonkey	4	1,701
Conditional Average [email protected]	by [email protected]	4	413
Excel Loan amortization Excel X for Mac 10.1.6 Larry Rowe	by Harlan Grove[_2_]	1	1,246
Load caption box on userform open ExcelMonkey	by Bob Phillips	1	734
Copy Excel tab (worksheet) to another Excel file Stefan van der Hooft	by Gord Dibben	4	1,380
change the century Keith	by Gord Dibben	5	655
2nd lowest Value in Array Dale	by Harlan Grove[_2_]	2	2,044
how do i use code39 bar codes that update as a cells value chages woody	by Thomas Lutz	1	662
Hide macro's clippan	by clippan	2	319
Lookups or something ConfusedNExcel	by ConfusedNExcel	0	442
Fiscal Quarter Conversion Andrew	by Harlan Grove[_2_]	7	1,320
Merging Databases archsmooth	by MH[_2_]	1	488
how to combine workbooks or spreadsheets in to one???? musiclover	by musiclover	1	532
formula or vba solution [email protected]	by Mike	1	403
My Buttons shrink with every click [email protected]	by Susan	3	1,396
Pivot Table: Change dates to fiscal year denhamlee	by Dave F	1	879
Counting two numbers vijaydsk1970	by Domenic	3	420
checking for duplicates Ted Metro	by Dave F	1	438
change language setting using VBA code ub	by ub	0	5,073
I want to assign a ranking number to a series of values. tdkdik	by Dave F	1	974
Ignoring Cells with Only Spaces Heliocracy	by Ron Coderre	5	595
Compare and group like numbers and info John L[_2_]	by John L[_2_]	5	441
Sheet creation and colouring the tabs SYBS	by SYBS	8	450
Enter data, move automatically to next unprotected cell Patrick Riley	by Susan	10	4,074
Change Cell Format SRV....Frenzy	by Bob Phillips	5	333
Filter [email protected]	by Roger Govier	3	379
need to do a calculation. Mushtaque	by David Biddulph[_2_]	1	490
How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric? ship	by Ron Rosenfeld	4	1,284
Sorting and Matching criteria across rows to return a result in the last cell frankjh19701	by frankjh19701	8	887
Atlantic City Excel User Conference - Registration deadline Damon Longworth	by Damon Longworth	0	364
Multiple CheckBoxes can be selected require additional info if sel Goldenfoot	by Susan	1	506