Excel Worksheet Functions - Page 408

Thread / Thread Starter	Last Post	Replies	Views
counting duplicates and uniques comparing two columns Johndb	by T. Valko	3	823
Dynamic Date Drop-down List Rob	by T. Valko	3	829
replace state names with state code abbreviations se7098	by Gord Dibben	3	2,190
countig of nonblank cells with speciffic condition Danko Jotanovic	by Danko Jotanovic	3	545
Change Picture based on cell value Jim	by Simon Lloyd[_333_]	3	5,648
Auto expanding charts Martin	by Martin	3	951
Comparing 2 sets of data to fill in gaps Awrex	by Awrex	3	584
Average of time each month Kelway07	by Kelway07	3	582
calculate tax based on y or N marsjune68	by JoeU2004	3	642
using worksheet name in a formula but not current worksheet Sing Chung	by T. Valko	3	563
scroll down today () with weekdays only Stephen Christian	by Shane Devenshire[_2_]	3	578
The date in a excel worksheet is wrong. =now() responds 1-0-1900 David	by Ron Rosenfeld	3	599
if condition combined with SMALL kaveran	by Teethless mama	3	442
Formatting Val	by Gord Dibben	3	445
SUMIF criteria in different column is met? spandangled	by Eduardo	3	1,603
LOOKUP function reversed? Chris	by OssieMac	3	529
vlookup column based on user input berniean	by Max	3	892
Copying formula vertically, to pick up horizontal cell values Jammings	by jkiser	3	5,544
Conditional format stoplight based on worst color Morgimo	by Gord Dibben	3	679
set default value for a cell CEM Matt	by Fred Smith[_4_]	3	3,677
Commision Rate by margin Brian	by Fred Smith[_4_]	3	947
How do I delete alternating rows in excel gump	by Gord Dibben	3	1,596
Using a variable in the Range function Dee Sperling	by Dave Peterson	3	506
percentage calculation rpi929	by JoeU2004	3	520
conditional formatting of dates Gretchster	by Shane Devenshire[_2_]	3	455
How to start week numbering (WEEKNUM) on a certain day? Simon Lloyd[_344_]	by Glenn	3	1,146
Macro & VB101 and Excel Ty	by p45cal[_6_]	3	432
How to round down a value to the inferior multiple of 5 jimmy	by jimmy	3	1,058
Help with SUMIF formula Iriemon	by RagDyer	3	378
Date field from text field Jack Deuce	by Gord Dibben	3	827
Count Number of occurences of several texts in a range of cells kbeirne	by Mike H	3	464
how do I convert sq. meters to hectares in a batch 1bigfokker	by David Biddulph[_2_]	3	5,883
Countif contains a word in a reference cell Go Bucks!!![_2_]	by RagDyeR	3	1,888
Formular for refrencing two referances steve clarke	by steve clarke	3	575
Return a Value in Vlookup Q Seanie	by Max	3	569
Help with Editing VB (a really beginner question) nadhra	by Simon Lloyd[_339_]	3	405
Formula corresponding to row it is in? REBANEEDSTOKNOW	by Max	3	446
Searching several items from one document to another REBANEEDSTOKNOW	by Shane Devenshire[_2_]	3	509
AVERAGE Keith - NRCS[_2_]	by Teethless mama	3	410
insert Rajat Soni	by Ashish Mathur[_2_]	3	402
Lock Unlock Cell Protection Mike Josephson	by Simon Lloyd[_312_]	3	720
Need to set character limit in cells of a worksheet. Justine	by T. Valko	3	655
Conditional Formatting H	by Luke M	3	450
How do I change the direction when pressing ENTER? (dn, rt, etc.) CGN Bear	by PCLIVE	3	956
SUMPRODUCT or SUMIF if any values in a range equal any values in another range PCLIVE	by Lars-Åke Aspelin[_2_]	3	1,654
Hyperlink to cells in other workbooks keep changing GHawkins[_2_]	by Dave Peterson	3	1,586
What is wrong with this nested function? A little stuck	by Lars-Åke Aspelin[_2_]	3	449
Oracle import Steved	by Steved	3	420
selecting the penultimate cell from a column of data jfp	by jfp	3	1,452
Copy Paste in Excel 2007 NoviceAccessUser-Melanie	by Liliana[_4_]	3	783
Changing case Dingbaticus-Maximus	by Rick Rothstein	3	446
sumif function or something else needed? kathy	by Don Guillett	3	369
customer Name against Unique customer number count Nelson	by Don Guillett	3	462
Inserting Rows and the affect on Functions Mike O.	by Liliana[_3_]	3	618
IF formula returns blank cells--only want values to show Wilma	by Wilma	3	724
How do I use ColorRank()? billw0483	by Michael.Tarnowski	3	702
Embeded picture in Excel Hintzcm	by Gord Dibben	3	1,897
Formula for calculating YTD values Suan	by JoeU2004	3	1,985
Max with Multiple Ifs ChrisWWiese	by ChrisWWiese	3	1,929
Remove Password Zita	by Gord Dibben	3	903
Counting Column Cul	by Shane Devenshire[_2_]	3	388
Excel 2007 worksheet to WEB page JAW	by JAW	3	432
=SUMPRODUCT((C481:C507<"")/COUNTIF(C481:C507,C481:C507&"")) Jeff	by Eduardo	3	359
Identifying correct elements with Countif Lady Success	by T. Valko	3	608
copy & pasting automatic formulas AtlantaResearch	by Shane Devenshire[_2_]	3	594
Spliting dimensions down PSM[_17_]	by Ron Rosenfeld	3	478
How do you get excel to spell out the amount (ie $5.55 = five dol. Elvira	by Taurien	3	755
formula for work rosters to deduct for different breaks vefl	by Liliana[_4_]	3	1,687
Want more 256 column in 2007 Bachadega	by macropod[_2_]	3	512
How do I automatically select a Excel record randomly? Italian1	by Italian1	3	629
Using SUMIF with a drop down. Steve	by Steve	3	2,855
Define a generic name Nelson	by Dave Peterson	3	436
vlookups lfrick	by T. Valko	3	543
Run a macro in active cell only. Want to place current date/time. time clock watcher	by Simon Lloyd[_319_]	3	1,389
How do I get cursor to move left and right in excel? Q-Bear	by Meebers[_2_]	3	3,376