Excel Worksheet Functions - Page 80

Thread / Thread Starter	Last Post	Replies	Views
Hightlight cells that contain special characters Gareth_Evans (InterCall EMEA)	by Stefi	12	5,866
Excel - Calculate age from DOB in years, months days Polly	by Polly	7	4,313
how do i set up a user prompt at the start of an excel workbook ? Mark	by Mike H	1	588
How can I define date range criteria in SUMIF formula? LisaR	by Bob Phillips[_4_]	1	4,532
Excel formula help Pags10	by Ando	1	387
Data Validation Lists Sue	by WallyWallWhackr	5	786
Empty Cell-conditional formatting smack	by Fred Smith[_4_]	1	453
Sorting data field Bill C	by Fred Smith[_4_]	1	366
Calculate # of years JT	by Fred Smith[_4_]	6	715
Using the Icon Set for Conditional Formatting Gino59	by Herbert Seidenberg	1	930
'Reverse' Concatenate msnyc07	by FSt1	5	1,728
Make a product that works msnyc07	by msnyc07	12	1,049
User controlled Freeze Pane while protected FredL	by Gord Dibben	3	2,994
Drop down box issue - pat	by Ashish Mathur[_2_]	2	568
Text to Columns LeisaA	by Fred Smith[_4_]	4	405
Finding duplicates Louja	by Ashish Mathur[_2_]	2	452
Date format problems after csv import YY san.[_2_]	by Ashish Mathur[_2_]	1	2,028
Concatenate numbers and text while holding a custom number format. jpowell111	by Ashish Mathur[_2_]	9	2,507
Array Formula Andri	by Bernd P	3	329
Lookup Joe	by Luke M	1	308
Switched up to Excel 2007 lost functionality in my array equations Flcnmech	by Flcnmech	0	469
Solar cells for less than 1 USD per Watt ..	by ..	0	547
MSexcel creating index linking subjects to page nubers in footer Skulk	by Skulk	0	465
Nested COUNTIF? Astro	by Fred Smith[_4_]	15	1,754
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) retailmessiah[_2_]	by Fred Smith[_4_]	7	1,008
Change How Tab Operates RH	by Gord Dibben	2	333
Cell Color Recognition and Summing of Data Within a Specified Colo Universal Pegasus - Chad[_2_]	by Bob Phillips[_4_]	1	477
Why wont my right click functions work? purplewolf	by Teethless mama	1	606
How do I multiply ALL CELL in spreadsheet at once by .5 ? ariel	by Fred Smith[_4_]	2	1,214
Conditional Formatting with Partial name search Diane	by Diane	2	657
Offset with scrollbar H.G. Lamy	by T. Valko	5	1,664
formula to subtract from inventory total Dee	by Teethless mama	1	2,084
How do I remove the #div or N/A and make it 0 when using VLookup? JeaneIsaac	by Flcnmech	26	5,123
Set "ALWAYS CREATE BACKUP" Option Abradaxis	by Abradaxis	5	2,378
How format SUMIF formula for matching date range and column value? Kane	by Fred Smith[_4_]	4	1,692
Multiple lookup between two dates Ales	by Ales	2	1,080
formula help Soth	by Glenn	3	421
Custom views in Excel Flipper	by Flipper	0	536
How to count cells that are highlighted by conditional formatting jngbutler35	by Pete_UK	1	1,267
TransferSpreadsheet to colored fields alex	by alex	0	441
In excell 2003, increasing number of items shown in drop down list Sekani	by Teethless mama	1	758
Data Validation Lists Sue	by Sue	0	307
Stock control question Rocket	by FSt1	4	538
Button apperance ndobbo	by Garreth Lombard	1	432
auto highlighting x#of days prior to & after any given date Moovysheek	by Moovysheek	0	563
Conditional Formatting Moovysheek	by Moovysheek	0	363
how to vlookup of one cell by starting 2 digits of another cell? Uday	by Fred Smith[_4_]	1	571
SUMIFS Kristin	by David Biddulph[_2_]	6	809
How do I find how many of a certain day are in a given month Paris2459	by T. Valko	6	8,032
Calcs & Data Validation Andrew	by T. Valko	3	446
Find Last Item Entered in Row Ron	by T. Valko	4	1,984
toolbar "button" for hiding/unhiding sheets Barb in MD	by Barb in MD	2	915
vba to delete rows ericahughes	by Ashish Mathur[_2_]	1	823
Convert number to text Brookyboy	by L. Howard Kittle	3	667
maximum nested IFs Opal	by T. Valko	6	497
Macro to delete any control box and pictures Steve	by Steve	2	1,062
Help with an array and SUMPRODUCT xlcharlie	by T. Valko	3	746
VBA to count colored cells ericahughes	by FSt1	1	961
Getting a formula to do the following: Pierre	by Pierre	2	428
How can I? DaveMoore	by Mike Middleton	4	405
Looking up any match, returning data Stacie2410	by Stacie2410	5	348
Adding totals in columns Tanya	by Eduardo	2	586
Retaining conditonal formats MM	by Gord Dibben	4	378
Inconsistance Formula? Tmt	by Fred Smith[_4_]	2	521
if statement Debra Reid[_2_]	by T. Valko	5	323
If Function?? Dave Tee	by Gary''s Student	1	311
Running Total DisMusBeDaPlaz	by Luke M	3	464
Auto Populating & Name Recognition between Worksheets Leigh Anne	by Luke M	1	993
Count with multiple criteria in multiple cells Mike H	by Mike H	1	493
copying data Copying data errors	by Copying data errors	0	354
Formula for each # of dollar amount due + how many digits Olivia	by Glenn	7	608
Insert Data From Multiple Worksheets Into One (With Criteria) Robcole84	by Robcole84	0	593
duplicate numbers being given different rankings Mantis	by Bernd P	2	432
Extract portions of text Lupe	by Jacob Skaria	2	455
Consolidation if a least one criteria is met Nicawette	by Ashish Mathur[_2_]	4	523