Excel Worksheet Functions - Page 62

Thread / Thread Starter	Last Post	Replies	Views
How do I find (not delete) duplicates in multiple spreadsheets? Nelson[_2_]	by Peo Sjoblom	1	2,189
Text in Data Validation drop down box too small. Is there any thi OTM 3	by Dave Peterson	3	2,188
Select cell containing specific text &return value from another ce plf100	by plf100	4	2,188
vlookup more than one exact match Russ B	by Harlan Grove	6	2,188
add a value to the cell value itself tkraju via OfficeKB.com	by Niek Otten	2	2,187
Command line to open a specific worksheet vIQleS	by vIQleS	2	2,187
Show Two Decimal Places After Concatenation ryguy7272	by ryguy7272	7	2,186
VLOOKUP Between Sheets MB	by Bob Phillips	3	2,186
Sumproduct-multiple criteria for same range "OR" Deeds	by Bob Phillips	3	2,186
Dividing a time span into shifts - overlapping days Heidi	by Pete_UK	17	2,186
Check box linked cell = TRUE then J5 valued reduced by 1 L. Howard	by L. Howard	16	2,185
Excel row height v. printed page Geri Rigger	by CellShocked	4	2,185
I want to turn off research task pane forever. melissa	by melissa	0	2,185
Checking a cell against a named range Memento	by Memento	8	2,184
countif using other cell values for 'range' and 'criteria' tony	by Bob Phillips[_4_]	4	2,184
format a cell when I type 10 it will multiply 10 by .585 Mikeebabe	by REReed	4	2,184
How do I create a random number generator in excel? Katie	by Alan	2	2,184
Deducting from a total!! HELP!!!!!!!!!!!!! DestinySky	by Peo Sjoblom	4	2,184
How do I produce consecutive invoice numbers in Excel? John Z	by John Z[_2_]	4	2,183
Excel Formulas in General Ledger [email protected]	by [email protected]	2	2,183
Pivot Change PivotItems - Visible/Hide with VBA [email protected]	by Debra Dalgleish	3	2,182
Does Excel 2000 have a 'datedif' function to calculate the number. Kaddy	by Ron Rosenfeld	7	2,182
Is there an adjustable rate amortization schedule in Excel? dbmmsg	by JE McGimpsey	1	2,182
Count Duplicates in text values Madiya	by John[_22_]	6	2,182
Percentage formula in excel Trevea	by Fred Smith[_4_]	5	2,182
How do I lock footers in Excel? Al@Kohler	by Dave Peterson	1	2,182
Bubble Charts with two non-numerical variables andy62	by andy62	2	2,182
How to tell if cell contains a FORMULA or user-entered number? rcmodelr	by AnimalMagic	11	2,181
Using spreadsheet to fill in forms Nicci	by Eva	2	2,181
Return cell contents based on conditional lookup jarviscars	by Krishnakumar	15	2,181
Multiple lines of type in one row? DMD guy	by Danielle	3	2,180
Calculating Rolling Peak to Valley in a Column tx12345	by Kevin Vaughn	1	2,180
Macro to convert text to date Nortos	by Nortos	2	2,180
how do i create a loan with a balloon payment in Excel? Rox A.	by Ron Coderre	1	2,180
Help adding text values Texas-DC_271	by Max	7	2,180
Clear Cell If Function = 0 Geno	by Geno	4	2,179
Excel Euler function Jayso	by Jayso	2	2,179
How do I link data from a horizontal range to a vertical range? davidge	by Roger Govier	3	2,179
How do I change date yyyymmdd to a Excel-supported date format? dan	by dan	4	2,178
How to show file creation date in a worksheet cell Big Sean	by Gord Dibben	3	2,178
lookup number greater than Ade Taiwo[_2_]	by Mike H	3	2,178
Calculating recurring date in following month, calculating # days in that period Walterius	by Walterius	6	2,178
More than 3 Conditional Formatting Conditions Beth H	by TC	12	2,177
adding more data to pivot table. shawna	by Jacqueline	3	2,177
How can I make a sequential number list that will print 1 per pg. Bonni	by Jacob Skaria	3	2,177
Deleting (almost) duplicates in Excel Ken ya help?	by pshepard[_2_]	3	2,177
Pro rata calclation Kunal Khanna	by Bernard Liengme	1	2,177
How to Make the text blink in Excel? rajesh aiyappa	by Myrna Larson	3	2,176
Use networkdays INCLUDE weekends, Exclude holidays ronnomad	by ronnomad	4	2,176
Can anyone calculate age next birthday from date field? Sheila	by Gary''s Student	1	2,176
C1 appears blank, but ISBLANK(c1) returns false Sam	by bj	4	2,176
I need to swap last name, first name in a cell to first name last Wink	by Bob Phillips	3	2,176
How do I assign numerical values to a letter? Ex: A = 4, B=3, etc Bob1023	by Greg Wilson	1	2,176
Calculate number based on percentage [email protected]	by excelking54	12	2,175
Excel Formula Bernie	by Harlan Grove[_2_]	10	2,175
How do I unstack data in a worksheet? nit	by nit	0	2,174
Averaging noncontiguous numbers ignoring zeros? Mike	by Myrna Larson	19	2,174
Rank - Specific match only Tim Elhatton	by Tim Elhatton	2	2,174
How do I insert a drop down calendar in spreadsheet? ExecAsst1	by Gord Dibben	1	2,172
Concatenate with carriage return- how to remove blanks? cindyc	by Gord Dibben	3	2,172
Using an array range in GETPIVOTDATA Steve	by Steve	0	2,172
How do you use the explode and collapse panel to hide rows? EMG03	by RagDyer	2	2,172
Macro - Open all word files in a directory Dileep Chandran	by Bob Phillips	11	2,171
How do I get my Excel 2007 worksheet to go beyond 65536 rows? Alan	by Bernard Liengme[_3_]	1	2,171
Can Autofill be used for Hyperlinks BushyII	by Simon Lloyd[_149_]	2	2,171
how do i find palindromes using excel? yan	by Ron Rosenfeld	5	2,171
how to turn positive to negative values in excel Paula1	by Bob Phillips	4	2,170
Pivot Table -- Add column to average Grand Total Lynn	by Lynn	1	2,170
Conditional Formatting Dates calculating 10 days and 30 days from a certain date Sioux[_2_]	by bj	2	2,170
How do I copy a formula all the way down a column........ lucdol	by Mike Rogers	6	2,170
formula for a pension barbarat	by barbarat	22	2,169
DSUM Criteria - find exact match only Sandy	by Peo Sjoblom[_2_]	1	2,169
How do I autosum text? staysee	by Gord Dibben	2	2,169
Worksheet Formula Returning Sum of a Series monir	by Dana DeLouis	26	2,169
Sick leave calculation' Tia[_2_]	by Teethless mama	2	2,168