Excel Worksheet Functions - Page 1097

Thread / Thread Starter	Last Post	Replies	Views
Calculated Field in Pivot Table Spencer Hutton	by Debra Dalgleish	1	834
Problem using sumproduct Hiughs	by Jerry W. Lewis	4	585
=IF logical test to search only part of a cell Robbie in Houston	by Biff	2	1,256
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda	by Elijah-Dadda	0	2,556
MATCH function - 2 columns w/ SIMILAR, not EXACT data Jane	by Fred Smith	3	1,563
MATCH function JayL	by JayL	0	603
How do I automatically hide columns in a worksheet based on a cell value? dkhedkar	by David McRitchie	1	1,604
vlookup Horacio	by David McRitchie	1	446
How do I protect cell formulas used for daily counts? Pilar	by Pilar	0	764
Autofil color to a row from dropdown list choices Alesia	by Gord Dibben	1	474
Formula to return ADDRESS of cell in range that meets criteria Christie	by Biff	1	2,116
Inserting a Space in The Same Place Formula carl	by Myrna Larson	2	734
Less than Greater than function GreenMonster	by crossingmind	7	630
How do I set up a drop-down menu/list in Excel? Nicole	by Debra Dalgleish	1	720
vlookup for multiple columns MXC	by MXC	6	1,014
Increment a counter in Excel COSdl	by COSdl	2	1,985
increase increment lindajoy57	by Peo Sjoblom	1	384
Is there a function to show future date taxmom	by taxmom	2	940
how do I convert a date and time column to a time column thdorsky2	by Peo Sjoblom	1	1,197
delete repeating rows aledger	by aledger	2	1,183
PRINT SPREADSHEET ON 1 PAGE LEGIBLY [email protected]	by [email protected]	0	879
Auto Adjust Spread Sheet so it will print on 1 page/legal/landscap Pam :)	by Pam :)	0	643
Countif Function with and Statement Matt	by Peo Sjoblom	3	498
How get rid of these errors if cell has no vals? Jay	by Wazooli	3	469
Formulas Kent	by Kent	2	389
Formulas Kent	by Kent	0	348
How to add add'l sheet tabs in Excel Scorpion rising	by Peo Sjoblom	2	816
My New Macro JulianB	by JulianB	3	327
saving page Juco	by Juco	0	315
Please Help If You Can Dmorri254	by Dmorri254	2	515
How to find if a string starts with a digit galsaba	by Jason Morin	1	809
How to simplify this IF formula Bojana	by Arvi Laanemets	2	496
how do i sort? MXC	by Max	8	581
My New Macro from Bernie JulianB	by Bernie Deitrick	1	395
How to convert string to a date galsaba	by Peo Sjoblom	3	1,123
using colour Bob	by Basil	3	553
Function limitation JayL	by Peo Sjoblom	1	596
Date Math Problem Dkline	by Dave R.	4	1,401
Macro Modification Help Dmorri254	by Dmorri254	0	520
Backing Up Greg B	by Greg B	7	557
Pivot table drilldown Spencer Hutton	by Debra Dalgleish	1	946
Where is DateDiff function in Excel 2002 ? Nigel Welch	by Bob Phillips	4	2,778
I need help with creating a special macro . JulianB	by JulianB	9	692
Large function Peter B	by Bernard Liengme	1	468
Help!!!! Need help with IF statement!! mel	by Mel	3	432
Count on multiple columns Emece	by Aladin Akyurek	2	767
HELP!!! NEED formula!!! mel	by mel	3	415
Count in tables Natalie	by Bob Phillips	3	450
Auto Filter in Excel cduckett	by David McRitchie	1	632
how do I make a spreadsheet fit the right margin. cwood	by David McRitchie	1	787
Can you nest a MID function within a IF function in Excel Dawn-Anne	by Dawn-Anne	2	1,351
INSERT ROWS WITHOUT SCREWING-UP FORMULAS! BILL GATES - I WANNA WORD WITH YOU!	by David McRitchie	1	1,501
add characters to beginning of text Natalie	by R.VENKATARAMAN	3	655
How can I do a lookup to a specific cell on multiple worksheets? Ray Stubblefield	by raystub	6	1,980
Excel formatting SBazemore	by SBazemore	1	437
Conditional Formatting if any value in the cell Metallo	by Bob Phillips	5	1,285
Auto filter in Excel cduckett	by Jason Morin	1	705
the limit on how many rows can be in one spreadsheet liz	by Jason Morin	2	676
All formulas display zero....HELP!!! Drew Pruitt	by Neil_J	1	417
$ added to formula automatically Steve	by Steve	0	654
Using excel display a roster as hourly coverage in units Steve	by Steve	0	1,331
Splitting Data jez123456	by Andy Brown	4	494
Advanced analysis tool in Excel KC	by David Jessop	1	821
Training on macros in Excel97 using Windows 98 BT Bill	by Andy Brown	1	548
Addendum to "Subtotal has stopped working" Tim Mc	by Tim Mc	0	491
LEFT function AJPendragon	by Roger Govier	3	521
Insert $ to make address absolute Roger Govier	by Roger Govier	0	409
Lookup then Match and insert value from next column Tenacity	by Tenacity	3	1,852
AMATCH Brett	by Brett	0	436
How come my formulas work in one cell but not the other? aledger	by David McRitchie	3	573
Problem of Open Office and MS Office PKH	by PKH	0	617
Averaging noncontiguous numbers ignoring zeros? Mike	by Myrna Larson	19	2,206
round function in excel 2000 lots of questions	by Ron Rosenfeld	2	743
Prevent duplicate entries Teri	by Gord Dibben	1	755
Replacing characters OhhAhh	by Aladin Akyurek	10	1,149