Excel Worksheet Functions - Page 21

Thread / Thread Starter	Last Post	Replies	Views
help with a formula Charles	by gromit	12	1,002
Two Variable Lookup with approximate ranges cardosol	by Ken Johnson	12	1,267
HELP - Too long coding for Macro Eric	by Dave Peterson	12	964
Using COUNTIF for multiple text data creating a logic statment Scott	by Pete_UK	12	936
Editing Comments Please Help	by pbrindman	12	913
IF and Caroline	by Gord Dibben	12	958
Challenging formatting formula robnet	by Gord Dibben	12	1,102
sorting excel data [email protected]	by [email protected]	12	973
Look up 2 values, return result in a different workbook Positive	by Positive	12	1,301
Conditional formatting to exclude weekend and Bank Holidays Paul	by Ron Rosenfeld	12	2,573
Another #DIV/0! Issue Debbie	by Debbie	12	1,077
editing numbers stremetzky	by stremetzky	12	654
Protect_Unprotect Macro modification. Colin Hayes	by Colin Hayes	12	806
Excel 2007: Create a pivot table where data is in multible sheets Kenneth Andersen	by Kenneth Andersen	12	1,364
Creating a numbered list on a filtered worksheet Louise	by JMB	12	1,430
Conditional Format - Outline Border Sam via OfficeKB.com	by T. Valko	12	1,514
Nested IFs Not Calculating Debbie	by Debbie	12	692
Using "D"functions JR Hester	by T. Valko	12	998
Locating the First Comma in a Text caldog	by T. Valko	12	891
copying conditon formats with $ Mark	by Max	12	839
count values in a column, but. . . tree	by T. Valko	12	1,068
Countif with multiple criteria and date range Pedro Dias Ferreira	by David Biddulph[_2_]	12	1,951
Need Help with "SUM" AND "ABS" in same formula Randy	by T. Valko	12	1,578
How do I keep 3-D reference the same when inserting one row on one jcrowe	by Harlan Grove[_2_]	12	841
Calculating someone's age at a given date Deb	by Sean Timmons	12	952
How do I calc the time difference in hh:mm for shift work? TomS	by David Biddulph[_2_]	12	1,044
find and replace Excel 2007 Lynne	by Lynne	12	1,437
Locating a Worksheet from another Workbook Walter	by Walter	12	1,143
Help - sumif help on sales data between dates? Owl	by Owl	12	679
Auto Rename Excel Sheets in Workbook Kulin Shah	by Don Guillett	12	4,077
Find Capital Letter Boogie	by Glenn	12	4,118
Lookup to return multiple values lesg46	by Max	12	1,574
change font color depending on cell value Mickey	by Rooster	12	1,338
Function within a cell that has a number TÃ©	by Gord Dibben	12	828
change regular 24 hour format to military time in excel kidsmeasy	by Spiky	12	3,686
Time difference w/o weekends AG[_3_]	by Shane Devenshire	12	863
Match Multiple Columns phuser[_2_]	by phuser[_2_]	12	1,140
Nesting LWilson	by LWilson	12	1,026
Change sheet name on linked cell by dropdown box Mikeice	by mangesh_yadav	12	1,306
Count excluding Duplicates GRM via OfficeKB.com	by topola	12	2,770
Function or Formula Dave	by Dave	12	726
Correlation Tables -- Setup Zeelotes	by [email protected]	12	1,020
Function 2 divide a number (ie $1.00) by % (ie 25%) to = ($4.00)? Gonecoastal1	by Therese	12	1,010
2nd and 4th Wednesdays formula? lawdoggy	by lawdoggy	12	1,375
Average last 6 Kwanjangnim	by RagDyeR	12	633
If a cell is blank do no let a user print or save? Havenstar	by Havenstar	12	1,227
Explain return of #N/A Biff	by Biff	12	1,142
Confusion on adding percentage of cost to that cost. [email protected]	by Robert Morewood	12	1,842
Macro to delete rows with same data Connie Martin	by Bernie Deitrick	12	2,256
How do I ignore cells in Excel? texanfanrocket	by Max	12	1,390
lookup function Ron	by Max	12	823
Find a non-blank cell and bring back text a in same row Rod	by Rod	12	1,896
DAY FUNCTION Malcolm Austin	by Ron Rosenfeld	12	839
Return 1st of the Month JJalomo	by Ron Rosenfeld	12	1,653
RANK Function Modified? Don	by Daniel.M	12	1,224
A & B & C & D an	by Dave R.	12	781
daily average JBoulton	by JBoulton	12	1,409
Unable to search for a text value with IF Steve Jackson	by Ken Johnson	12	911
Warning message if one column contains any text and another column is blank Dileep Chandran	by Ian	12	1,527
How to convert 120608 in Excel into 12 Feet 6 inches 8 sixteenths Trussman	by Ron Coderre	12	2,342
Excel 2003 Linest Function Bug JimK	by JimK	12	1,951
Custom Function basic Joe_Germany	by Pete_UK	12	678
Auto Filter soteman	by Gord Dibben	12	697
Custom functions calculating time arguments Help Desperate Bill_De	by Bill_De	12	3,363
Month end calculation Tony	by Tony	12	970
Multiple countif()s or a better way? Mike Echo	by Bob Phillips	12	1,172
Sumproduct function not working Scott Summerlin	by Scott Summerlin	12	4,489
Sumif Cells Are Not Blank Powlaz	by Kevin Vaughn	12	3,182
custimise the "IF" formula function [email protected]	by [email protected]	12	1,067
More then 7 IF functions? CdFMarshall	by EricCartman	12	659
Counting occurrences in one column based on an occurrence in anoth Jim Jackson	by Ron Coderre	12	1,524
List date adjacent to duplicates? smoore	by smoore	12	919
formula to find the filter criteria [email protected]	by Bruce Kovacs	12	918
how to remove gridlines from part of a worksheet only joe	by Eduardo	12	1,945
CONDITIONAL FORMAT John	by John	12	767