Excel Worksheet Functions - Page 67

Thread / Thread Starter	Last Post	Replies	Views
how to add a drag-down list box in Excel lili	by Jay	1	2,097
Selecting a Random Sample of 15 from a Large data set RMort	by Gary''s Student	6	2,097
Add kilobytes to megabytes in the convert function Matt Thompson	by David Billigmeier	2	2,097
How do I lock a column in EXCEL to prevent changes-can add input amarie	by David Billigmeier	1	2,096
Round Up by a factor not by a digit [MROUNDUP(number,multiple)] [email protected]	by Bob Phillips	8	2,096
Excel 2003 worksheet name function? eddie_zoom	by Duke Carey	3	2,096
Convert Week number to Month KT	by KT	0	2,094
move picture to behind cells Sarah[_3_]	by Gary''s Student	2	2,093
V/HLOOKUP in both directions? thexdane	by Max	5	2,093
Vlookup in vlookup - taking the result as array name SupperDuck	by SupperDuck	2	2,093
How to autofill the same cell reference across multiple worksheet. MichiganCPA	by Gord Dibben	1	2,092
PV of uneven stream of cash flows PJF	by Bruno Campanini	8	2,092
Finding next number in a series Iriemon	by T. Valko	2	2,092
auto sum column containing words and numbers Tacrier	by Pete_UK	3	2,091
Extract emails from cells with text AJexcelQuestions	by Rick Rothstein	3	2,091
how to create a repeat formula using the same multiplier? Lisa	by Gord Dibben	2	2,091
Unable to break links GHawkins	by GHawkins	0	2,091
merging cells and not losing data Ellen	by Spiky	1	2,090
how to compare two columns on two sheets and copy associated data from one sheet to the other? [email protected]	by Ingolf	2	2,090
How to count cells which contain a formula that returns TRUE Art	by Ron Rosenfeld	15	2,090
LIFO inventory method? Tduncan	by Tduncan	2	2,090
wildcards in sumproduct functions K1	by [email protected]	10	2,090
I can't find the megastat ad-in in Excel jutayl	by Frank Kabel	1	2,090
Excel running date formula minus weekend days Eliane	by Ron Rosenfeld	2	2,090
Excel Holiday Roster Calender ksp	by ksp	2	2,090
IF function with #N/A error Roccobarocco	by Roccobarocco	4	2,090
Does anyone know how to calculate Yield to Maturity using Exel? TL1525	by Gary''s Student	1	2,089
concatenate in array formula? Squirl Girl	by Spiky	1	2,089
Scoring Rank with Tie Breaker bobdo	by Pete_UK	1	2,089
How do I set NETWORKDAYS to regard friday and saturday as weekend Shay.C.	by Sadad	2	2,089
I need a daily sales sheet to pull from monthly figures sheet Draegen	by Draegen	0	2,089
convert cells containing alpha to numeric ezu	by Ragdyer	14	2,088
How do I get rid of spare lines in an excel spread sheet? Catherine@rhpc	by Gord Dibben	2	2,088
EXCEL LINK CELL FORMULA MDL2005	by Arvi Laanemets	3	2,088
What does $ stand for in an excel formula ally	by Harlan Grove[_2_]	2	2,088
How do I change the tab order in an Excel worksheet? jhells	by L. A. McClelland	3	2,088
Formula to identify lower case vs upper case laralea	by Biff	3	2,088
evaluate a concatenate expression Russell.Ivory[_2_]	by Gord Dibben	3	2,087
Hyperlink won't open in excel JBrits	by JBrits	0	2,087
Microsoft Visual Basic: Compile error: Sum or Function not defined Dmitry	by Dmitry	12	2,087
COUNTIF - USING WITH TIME VALUE RANGES Kazman	by Jacob Skaria	2	2,087
SUMIF non-contiguous range Lady_Olara	by RagDyer	13	2,087
formulas referencing pivot table cells JW_WA	by Debra Dalgleish	1	2,086
Drop down list with multiple choices Cindy	by Debra Dalgleish	6	2,086
Sumif based on criteria on another cell Jane	by T. Valko	3	2,086
Calculating Salary based on Date Range beachrog	by beachrog	2	2,085
Function Has Too Many Arguments tb	by tb	4	2,085
formula to subtract from inventory total Dee	by Teethless mama	1	2,085
How to average a column of numbers that are greater than 0? JimNColorado	by StephenAccountant	13	2,084
extract data from one worksheet to another worksheet Jeff	by Teethless mama	5	2,084
Excel 2003 - Protecting Cells but allowing external data updates watermt	by Squeaky	3	2,084
formula "next month same day" Ubi bene ..	by Ron Rosenfeld	2	2,084
Find Median of Positive numbers only in Range MichaelC	by Ron Rosenfeld	4	2,084
How to look up and return multiple values Wendy	by Wendy	3	2,083
Average every x cells Wox	by T. Valko	3	2,083
Using Min Formula with Multiple Criteria Excluding Zeros LucyB4God	by Max	5	2,083
Vlookup DETAILED directions jander	by T. Valko	2	2,083
How do I ignore "#N/A" data in a column while calculating average Tuan	by Shane Devenshire[_2_]	2	2,082
sum absolute values of a column of numbers in Excel MRolko	by Ron Coderre	1	2,082
Loan Compound Interest Function BOBODD	by [email protected]	2	2,082
30 Day Moving Average Ignoring Blank Cells ethatch	by Harlan Grove	2	2,081
Is there a function to solve for an unknown in an equation? WA	by Bernard Liengme[_2_]	9	2,081
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string Raja Mahendiran S	by Raja Mahendiran S[_2_]	6	2,081
Formula to display nearest following Thursday in mm/dd/yyyy format BW	by T. Valko	1	2,081
Copying formulas in Columns and transpose to rows? Terri	by Gord Dibben	5	2,081
Determining the Sunday date of the third "full" weekend of a month Bob	by Bernd P	25	2,081
Count only Letters in cells that contain both letters and numbers TommyB	by TommyB	2	2,081
Formula to return ADDRESS of cell in range that meets criteria Christie	by Biff	1	2,081
Count Blocks of Data Brendan	by Brendan	4	2,081
time calculation with military time Ron Thetford	by David McRitchie	8	2,081
How to Copy a Password Protected Excel Worksheet [email protected]	by Otto Moehrbach	1	2,081
Excel Hangs while filtering Database_Aforeserve	by Dave Peterson	1	2,080
Using a macro to paste into first empty row in a new worksheet Bruce64	by Theo	3	2,080
Data Validation Error Does Not Work? Alex Mackenzie	by Debra Dalgleish	3	2,080
Create HTML code for a hyperlink from cell contents Billy_McSkintos	by Billy_McSkintos	1	2,080