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,328
how do i set up a user prompt at the start of an excel workbook ? Mark	by Mike H	1	602
How can I define date range criteria in SUMIF formula? LisaR	by Bob Phillips[_4_]	1	4,558
Excel formula help Pags10	by Ando	1	399
Data Validation Lists Sue	by WallyWallWhackr	5	800
Empty Cell-conditional formatting smack	by Fred Smith[_4_]	1	464
Sorting data field Bill C	by Fred Smith[_4_]	1	380
Calculate # of years JT	by Fred Smith[_4_]	6	732
Using the Icon Set for Conditional Formatting Gino59	by Herbert Seidenberg	1	954
'Reverse' Concatenate msnyc07	by FSt1	5	1,763
Make a product that works msnyc07	by msnyc07	12	1,063
User controlled Freeze Pane while protected FredL	by Gord Dibben	3	3,038
Drop down box issue - pat	by Ashish Mathur[_2_]	2	586
Text to Columns LeisaA	by Fred Smith[_4_]	4	412
Finding duplicates Louja	by Ashish Mathur[_2_]	2	457
Date format problems after csv import YY san.[_2_]	by Ashish Mathur[_2_]	1	2,054
Concatenate numbers and text while holding a custom number format. jpowell111	by Ashish Mathur[_2_]	9	2,582
Array Formula Andri	by Bernd P	3	333
Lookup Joe	by Luke M	1	322
Switched up to Excel 2007 lost functionality in my array equations Flcnmech	by Flcnmech	0	483
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,763
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) retailmessiah[_2_]	by Fred Smith[_4_]	7	1,024
Change How Tab Operates RH	by Gord Dibben	2	341
Cell Color Recognition and Summing of Data Within a Specified Colo Universal Pegasus - Chad[_2_]	by Bob Phillips[_4_]	1	491
Why wont my right click functions work? purplewolf	by Teethless mama	1	619
How do I multiply ALL CELL in spreadsheet at once by .5 ? ariel	by Fred Smith[_4_]	2	1,224
Conditional Formatting with Partial name search Diane	by Diane	2	668
Offset with scrollbar H.G. Lamy	by T. Valko	5	1,688
formula to subtract from inventory total Dee	by Teethless mama	1	2,097
How do I remove the #div or N/A and make it 0 when using VLookup? JeaneIsaac	by Flcnmech	26	5,187
Set "ALWAYS CREATE BACKUP" Option Abradaxis	by Abradaxis	5	2,391
How format SUMIF formula for matching date range and column value? Kane	by Fred Smith[_4_]	4	1,708
Multiple lookup between two dates Ales	by Ales	2	1,091
formula help Soth	by Glenn	3	426
Custom views in Excel Flipper	by Flipper	0	544
How to count cells that are highlighted by conditional formatting jngbutler35	by Pete_UK	1	1,282
TransferSpreadsheet to colored fields alex	by alex	0	458
In excell 2003, increasing number of items shown in drop down list Sekani	by Teethless mama	1	779
Data Validation Lists Sue	by Sue	0	318
Stock control question Rocket	by FSt1	4	560
Button apperance ndobbo	by Garreth Lombard	1	438
auto highlighting x#of days prior to & after any given date Moovysheek	by Moovysheek	0	576
Conditional Formatting Moovysheek	by Moovysheek	0	376
how to vlookup of one cell by starting 2 digits of another cell? Uday	by Fred Smith[_4_]	1	591
SUMIFS Kristin	by David Biddulph[_2_]	6	826
How do I find how many of a certain day are in a given month Paris2459	by T. Valko	6	8,442
Calcs & Data Validation Andrew	by T. Valko	3	453
Find Last Item Entered in Row Ron	by T. Valko	4	2,000
toolbar "button" for hiding/unhiding sheets Barb in MD	by Barb in MD	2	927
vba to delete rows ericahughes	by Ashish Mathur[_2_]	1	834
Convert number to text Brookyboy	by L. Howard Kittle	3	684
maximum nested IFs Opal	by T. Valko	6	518
Macro to delete any control box and pictures Steve	by Steve	2	1,071
Help with an array and SUMPRODUCT xlcharlie	by T. Valko	3	761
VBA to count colored cells ericahughes	by FSt1	1	976
Getting a formula to do the following: Pierre	by Pierre	2	436
How can I? DaveMoore	by Mike Middleton	4	410
Looking up any match, returning data Stacie2410	by Stacie2410	5	362
Adding totals in columns Tanya	by Eduardo	2	597
Retaining conditonal formats MM	by Gord Dibben	4	393
Inconsistance Formula? Tmt	by Fred Smith[_4_]	2	529
if statement Debra Reid[_2_]	by T. Valko	5	328
If Function?? Dave Tee	by Gary''s Student	1	320
Running Total DisMusBeDaPlaz	by Luke M	3	477
Auto Populating & Name Recognition between Worksheets Leigh Anne	by Luke M	1	1,014
Count with multiple criteria in multiple cells Mike H	by Mike H	1	514
copying data Copying data errors	by Copying data errors	0	369
Formula for each # of dollar amount due + how many digits Olivia	by Glenn	7	632
Insert Data From Multiple Worksheets Into One (With Criteria) Robcole84	by Robcole84	0	600
duplicate numbers being given different rankings Mantis	by Bernd P	2	444
Extract portions of text Lupe	by Jacob Skaria	2	502
Consolidation if a least one criteria is met Nicawette	by Ashish Mathur[_2_]	4	530