Excel Worksheet Functions - Page 156

Thread / Thread Starter	Last Post	Replies	Views
Count values from Pivot Table lesg46	by Max	11	1,306
sumproduct - cell reference eugene	by Max	4	1,305
How do you export MathType from Word into Excel and be able to so. [email protected]	by Bernard Liengme	1	1,305
Sumproduct based on substring? altopalo	by RagDyeR	4	1,305
VLOOKUP and LEN/ISNA to match names? LTUser54	by Ken Hudson	6	1,305
if specific value from list A equals one of the values from list b... broer konijn	by Toppers	7	1,305
drop down menu containing worksheet names J-Rad	by J-Rad	3	1,305
Ad-In Rowliner Eurika Stemmet	by Gord Dibben	4	1,305
Counting non-blank cells in a column, excluding hidden rows SisterDell	by Don Guillett	3	1,305
count number of columns based on values across a row r2rcode	by Luke M[_4_]	1	1,305
How do I do math on a cell name in formula? Mark Mulik	by Mark Mulik	3	1,305
sort function for dates does not sort properly in Office 2007 Exc. Rosalie	by Pete_UK	1	1,305
Why is it important to check the range placed in the SUM function. CUTIE	by Bernard Liengme	2	1,305
Excel Page orientation Sam	by Duke Carey	1	1,304
Auto text color Gallego	by Dan Oakes	14	1,304
counting unique items(values or text) guneet_ahuja	by guneet_ahuja	11	1,304
sum difference cells on multiple sheets JulieD	by Fawn	8	1,304
Top border in a footer in Excel, Connie J	by Connie J	0	1,304
test expression for empty cell in =SUMIF() fgrose	by fgrose	12	1,304
Does anyone know how to cross reference two worksheets Christie	by Christie	14	1,304
Find certain text in a cell Elton Law[_2_]	by Teethless mama	3	1,304
Sliding Scale Cory Tilton	by Gord Dibben[_2_]	5	1,304
Validation of input against the active directory Sing Chung[_2_]	by Hii Sing Chung	1	1,304
how do i calculate time cards kljohnson	by Peo Sjoblom	1	1,304
How do I insert a scroll bar into the excell sheet? Jason S	by Gord Dibben	2	1,304
A function to get a variable row reference for range in XNPV funct Tex1960	by Tex1960	6	1,304
Maskerr function not working on my new computer - help? Russo	by Michael R Middleton	1	1,304
Duplicate Values in Excel 2007 Ed2	by Max	6	1,304
How do I copy only the month from a date CCW	by Thief_	2	1,304
how do i restrict cells to not accept formulas? John	by ryguy7272	3	1,304
Lookup function w/Text and Year Josh O.	by nbrcrunch	1	1,303
SubTotal for Sum function returning zeros ForestFeeder	by ForestFeeder	2	1,303
ColorIndexOfOneCell shank	by shank	8	1,303
How do I write this logical argument? Matthew G	by Pete_UK	4	1,303
Splitting text in one column into two (or more) columns. RickyDee	by RickyDee	4	1,303
SumIf with NA ArthurJ	by Sheeloo[_3_]	7	1,303
How to convert all words to CAPS Christine[_3_]	by franciz	6	1,303
How are empty cells referenced in Excel in IF statements? MOnewt	by kassie	6	1,303
If I have X,Y data how do I sum the Y values using a set of bins based on x values ScottBerger	by Myrna Larson	1	1,303
HELP: Access table linked to Excel - calculated fields? K Zox	by Jamie Collins	3	1,303
Why are my dates show up as (example) 39538 in formula? Neall	by Neall	9	1,303
Generate random numberes using reference to the other cell. ramana	by ramana	7	1,303
copy values generated by conditional formula in one sheet to the other work sheet as values ramana	by Dave Peterson	1	1,303
max function with a less than or equal to masterbaker	by Tom Hutchins	4	1,302
Need to know formula to make expire in a year. tlbailey79	by David Biddulph[_2_]	5	1,302
Autogroup then sum - can it be done? Jessica Robinson	by John[_22_]	5	1,302
Sum If on multiple columns with range of criteria 44judester	by T. Valko	1	1,302
definite integral dmahn14	by dmahn14	0	1,302
Extract characters from Right of string ashg657	by ashg657	5	1,302
Who can I make a Cumulative calculation in Excel sheet? Ahmed	by Jerry W. Lewis	2	1,302
Conditional Formatting Work around? John	by Myrna Larson	2	1,302
Auto Highlight a Row carl	by Don Guillett	5	1,302
Filtering Text Data from Multiple columns Brad	by Debra Dalgleish	6	1,302
Search for a specific character in a cell in an if statement mcl	by JE McGimpsey	2	1,302
Font too small in Incell drop down list Keith	by Keith	2	1,302
how to format numbers stored as text or vice versa to use vlookup teneagle	by Myrna Larson	1	1,302
Rounding numbers to the nearest 5 or 0 Fieldmedic	by Fieldmedic	3	1,302
count no. of dates in a column that falls on certain month & year RawSugar	by Harlan Grove	2	1,302
Function to return True/False if all are validated as True by ISNU Tetsuya Oguma	by paul	2	1,302
Sum/average numbers in column A dependant on value in column B Sue	by Bob Phillips	3	1,302
hyperlink using cell contents [email protected]	by [email protected]	2	1,302
Data validation with hyperlinks [email protected]	by [email protected]	1	1,302
How do I anchor hundreds of cells easily Ken	by Gord Dibben	3	1,302
selecting a single sheet from a volume of sheets in a workbook No News	by No News	12	1,302
change time into simple number Plan Ahead	by Dave Peterson	3	1,302
Setting up a list where an item can only be picked once in Excel J.	by Debra Dalgleish	2	1,302
Number Formatting in a concatenated cell ibgolfn	by T. Valko	4	1,301
VLookup with wildcard orejas	by T. Valko	6	1,301
COUNTIF with Dates SRL	by ShaneDevenshire	3	1,301
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? Daniel	by David McRitchie	1	1,301
In excel change color of a range of cells based on a cell value kwitt	by Squeaky	1	1,301
how do I copy format (eg colour of cells) in a drop down list Gord Dibben	by Gord Dibben	0	1,301
Look up 2 values, return result in a different workbook Positive	by Positive	12	1,301
Copy function with Excel 2003 not performing correctly wtztips	by Gary''s Student	2	1,301
hyperlink to a powerpoint slide Papu	by Shane Devenshire	1	1,301