Excel Worksheet Functions - Page 97

Thread / Thread Starter	Last Post	Replies	Views
display different images based on cell value? deisenlohr	by Gord Dibben	1	1,702
Finding matches in two columns Erik	by T. Valko	4	1,702
Doing a countif against a substring of the range to be scanned jetboy2k	by jetboy2k	1	1,702
How do I set all caps as the default? Mark Barnard	by Gord Dibben	10	1,702
Allocating Intergers based on Relative Percentage Jim Thomlinson	by JoeU2004	22	1,701
how I can Check the color of font in excel cell ? im-EGY	by Gord Dibben	2	1,701
Ignoring Blank value in a drop down list shail	by shail	15	1,701
Add cells on two adjacent rows but non-adjacent columns Eve	by Eve	14	1,701
Cross-referencing dates in Excel gantt chart Karl	by Bob Phillips[_3_]	4	1,701
Using booleans in sumproduct formulas to extract boolean range ExcelMonkey	by ExcelMonkey	4	1,701
Creating a stationary column Still Learning	by Still Learning	2	1,701
I need to randomize a column of alphanumeric employee ID's for a . topkick	by Tushar Mehta	9	1,701
Nesting Networkdays function inside and If function Addison	by Bob Phillips	2	1,701
How do/can I calculate the date for every Tuesday??? Jay	by Bob Phillips	6	1,700
Remove single spaces Bruno	by Ron Rosenfeld	1	1,700
back transforming log10 standard error fluff	by JoeU2004	1	1,700
returning a text cell based on a number cell Josh7777777	by Aladin Akyurek	2	1,700
Excel AverageIF issue... PLEASE HELP! [email protected]	by Gary''s Student	1	1,700
Hide Row command using if statement DME	by DME	2	1,700
How to sum number values, excluding data returned #N/A during Vloo Dyer	by Dave Peterson	2	1,700
SUMIF data that falls within a range Racer X	by T. Valko	3	1,699
Find combinations of numbers to equal a value jubu	by Bernie Deitrick	1	1,699
Excel 2007 balks at 7 nested IFs Hal mcl	by T. Valko	5	1,699
Why is the sum formula is not adding correctly? justmeamw70	by joeu2004	3	1,699
Merging Columns Titanium	by vhnbvb	13	1,698
Ignore Blanks in Countifs statement Kcope8302	by T. Valko	4	1,698
Obtain the value in a cell offset form the first cell of a named range [email protected]	by [email protected]	7	1,698
Capturing Insert/Delete Events in Excel Sheet using c# Gaurav Nanda[_2_]	by Gaurav Nanda[_2_]	0	1,698
conditional format if cell value 0 pattern red value blank nothing Matt	by Pete_UK	1	1,697
Colour code specific name if it appears in a group of names Wendy	by Ashish Mathur[_2_]	5	1,697
why does Excel convert 63781403840072 to 6.37814E+13 & how prevent dodie	by David Biddulph[_2_]	2	1,697
How do I copy/paste odd or even rows from Exel? GM	by Max	2	1,697
Rounding error in Stdev function result. David K	by Jerry W. Lewis	15	1,697
How do I show number with spelling word example "89" as " eighty . Currency number spelling	by Ashish Mathur[_2_]	2	1,696
SUMIF? week, month & year-to-date totals FSFGgirl	by Fred Smith[_4_]	1	1,696
How can I lookup when match has more than one value? Paulynn	by Jacob Skaria	2	1,696
Do not advance to next cell helphv	by helphv	6	1,696
vlookup with lookup value of different length accl	by	3	1,696
How can I create an array formula for non-sequential cells Sue	by Sue	7	1,696
Excel 2003 - Shared Workbook NOT Saving Changes C. Sharp	by C. Sharp	0	1,696
Error: Value in Formula of wrong data type mak_nyce	by mak_nyce	0	1,695
calculations of weekends only tmj8901	by Ron Rosenfeld	2	1,695
3rd friday in month [email protected]	by [email protected]	17	1,695
what can I do to randomly select cells that contain text? gmadden2	by Glenn	2	1,695
Random letter and number generator Marie1uk	by Marie1uk	4	1,695
Fill Color If Statement Elgee	by Elgee	3	1,695
Select only colored cells BBlue	by BBlue	2	1,695
How do I change the loan period in a amortization from years to mo Paigem21	by Gord Dibben	7	1,695
excel workbook opens small Jaso	by Dave Peterson	3	1,695
Can you do a function like =TODAY() PLUS 1? Donnie	by Bob Phillips	6	1,694
How do I change the plus to a negative in a column of numbers? JKB	by Arvi Laanemets	2	1,694
Explain INDEX MATCH Nadine	by Eduardo	3	1,694
Tally function in excel bgbrady	by Manish Bajpai	1	1,694
Vlookup Cell Format Richard	by Dave Peterson	3	1,694
30, 60 or 90 day averages Bendleton	by Arvi Laanemets	3	1,694
SUMIF division bob	by Luke M[_4_]	2	1,693
Find last occurance of text in range farutherford	by farutherford	5	1,693
calculate weeks from a start date ( not yr weeks) Todd F.	by Todd F.	6	1,693
calculate diffence between old salary and new salary Felicia Pickett	by Billns	4	1,693
compare time in IF statement	by JE McGimpsey	4	1,693
Sorting merged cellsHow do I sort merged cells not identically siz Laval	by Paul Corrado	1	1,692
XIRR Gilles	by Fred Smith	10	1,692
How format SUMIF formula for matching date range and column value? Kane	by Fred Smith[_4_]	4	1,692
VLOOKUP returns #N/A and causes VBA routine to halt [email protected]	by Dave Peterson	1	1,692
VLOOKUP not returning correct value leigh	by Roger Govier	6	1,692
Excel 2007 Ribbon Clay	by Clay	2	1,692
How to Input date & Time [NOW()], then stop it updating? jonathandr	by Gord Dibben	3	1,692
How do i ignore letters in a formula? ineedhelp	by ineedhelp	2	1,691
Pivot table refresh problem mindyg	by Debra Dalgleish	2	1,691
Match and Count duplicate names Donald B	by Donald B[_2_]	4	1,691
DGET Function - using a split criteria range? (Excel 2007) MikeT	by MikeT	0	1,691
do the same thing to multiple hard coded cells Sam	by Gord Dibben	3	1,691
Average Non-Continuous Cells Without Zero's raeleanne	by Domenic	8	1,690
How do I ask for multiple criteria when creating a "sumif" formul. Rachelle	by JE McGimpsey	3	1,690
pivot tables reports - altering display of (blank) cells cak	by Dave Peterson	1	1,690