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	6,017
Excel - Calculate age from DOB in years, months days Polly	by Polly	7	4,331
how do i set up a user prompt at the start of an excel workbook ? Mark	by Mike H	1	617
How can I define date range criteria in SUMIF formula? LisaR	by Bob Phillips[_4_]	1	4,562
Excel formula help Pags10	by Ando	1	402
Data Validation Lists Sue	by WallyWallWhackr	5	810
Empty Cell-conditional formatting smack	by Fred Smith[_4_]	1	476
Sorting data field Bill C	by Fred Smith[_4_]	1	392
Calculate # of years JT	by Fred Smith[_4_]	6	735
Using the Icon Set for Conditional Formatting Gino59	by Herbert Seidenberg	1	967
'Reverse' Concatenate msnyc07	by FSt1	5	1,772
Make a product that works msnyc07	by msnyc07	12	1,066
User controlled Freeze Pane while protected FredL	by Gord Dibben	3	3,044
Drop down box issue - pat	by Ashish Mathur[_2_]	2	593
Text to Columns LeisaA	by Fred Smith[_4_]	4	424
Finding duplicates Louja	by Ashish Mathur[_2_]	2	471
Date format problems after csv import YY san.[_2_]	by Ashish Mathur[_2_]	1	2,063
Concatenate numbers and text while holding a custom number format. jpowell111	by Ashish Mathur[_2_]	9	2,591
Array Formula Andri	by Bernd P	3	345
Lookup Joe	by Luke M	1	323
Switched up to Excel 2007 lost functionality in my array equations Flcnmech	by Flcnmech	0	491
Solar cells for less than 1 USD per Watt ..	by ..	0	564
MSexcel creating index linking subjects to page nubers in footer Skulk	by Skulk	0	469
Nested COUNTIF? Astro	by Fred Smith[_4_]	15	1,778
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) retailmessiah[_2_]	by Fred Smith[_4_]	7	1,039
Change How Tab Operates RH	by Gord Dibben	2	348
Cell Color Recognition and Summing of Data Within a Specified Colo Universal Pegasus - Chad[_2_]	by Bob Phillips[_4_]	1	505
Why wont my right click functions work? purplewolf	by Teethless mama	1	627
How do I multiply ALL CELL in spreadsheet at once by .5 ? ariel	by Fred Smith[_4_]	2	1,225
Conditional Formatting with Partial name search Diane	by Diane	2	681
Offset with scrollbar H.G. Lamy	by T. Valko	5	1,701
formula to subtract from inventory total Dee	by Teethless mama	1	2,100
How do I remove the #div or N/A and make it 0 when using VLookup? JeaneIsaac	by Flcnmech	26	5,198
Set "ALWAYS CREATE BACKUP" Option Abradaxis	by Abradaxis	5	2,404
How format SUMIF formula for matching date range and column value? Kane	by Fred Smith[_4_]	4	1,719
Multiple lookup between two dates Ales	by Ales	2	1,104
formula help Soth	by Glenn	3	429
Custom views in Excel Flipper	by Flipper	0	554
How to count cells that are highlighted by conditional formatting jngbutler35	by Pete_UK	1	1,292
TransferSpreadsheet to colored fields alex	by alex	0	460
In excell 2003, increasing number of items shown in drop down list Sekani	by Teethless mama	1	783
Data Validation Lists Sue	by Sue	0	329
Stock control question Rocket	by FSt1	4	565
Button apperance ndobbo	by Garreth Lombard	1	444
auto highlighting x#of days prior to & after any given date Moovysheek	by Moovysheek	0	585
Conditional Formatting Moovysheek	by Moovysheek	0	386
how to vlookup of one cell by starting 2 digits of another cell? Uday	by Fred Smith[_4_]	1	594
SUMIFS Kristin	by David Biddulph[_2_]	6	829
How do I find how many of a certain day are in a given month Paris2459	by T. Valko	6	8,451
Calcs & Data Validation Andrew	by T. Valko	3	463
Find Last Item Entered in Row Ron	by T. Valko	4	2,012
toolbar "button" for hiding/unhiding sheets Barb in MD	by Barb in MD	2	937
vba to delete rows ericahughes	by Ashish Mathur[_2_]	1	841
Convert number to text Brookyboy	by L. Howard Kittle	3	700
maximum nested IFs Opal	by T. Valko	6	529
Macro to delete any control box and pictures Steve	by Steve	2	1,072
Help with an array and SUMPRODUCT xlcharlie	by T. Valko	3	773
VBA to count colored cells ericahughes	by FSt1	1	989
Getting a formula to do the following: Pierre	by Pierre	2	446
How can I? DaveMoore	by Mike Middleton	4	415
Looking up any match, returning data Stacie2410	by Stacie2410	5	373
Adding totals in columns Tanya	by Eduardo	2	611
Retaining conditonal formats MM	by Gord Dibben	4	406
Inconsistance Formula? Tmt	by Fred Smith[_4_]	2	530
if statement Debra Reid[_2_]	by T. Valko	5	340
If Function?? Dave Tee	by Gary''s Student	1	330
Running Total DisMusBeDaPlaz	by Luke M	3	484
Auto Populating & Name Recognition between Worksheets Leigh Anne	by Luke M	1	1,017
Count with multiple criteria in multiple cells Mike H	by Mike H	1	525
copying data Copying data errors	by Copying data errors	0	375
Formula for each # of dollar amount due + how many digits Olivia	by Glenn	7	642
Insert Data From Multiple Worksheets Into One (With Criteria) Robcole84	by Robcole84	0	609
duplicate numbers being given different rankings Mantis	by Bernd P	2	456
Extract portions of text Lupe	by Jacob Skaria	2	513
Consolidation if a least one criteria is met Nicawette	by Ashish Mathur[_2_]	4	531