Excel Worksheet Functions - Page 57

Thread / Thread Starter	Last Post	Replies	Views
Why can't my macro use Auto Filter when I told the Sheet Protecti. KC Rippstein	by Frank Kabel	1	2,292
Arbitrary Lookups - return ALL found values baki	by Gord Dibben	8	2,292
How to perform 2SLS with excel B.B.Dave	by B.B.Dave	0	2,292
Return Value of last cell in column with a value in Excel? mike	by mike	3	2,292
Proper Formula is stuck and does not work Diggsy	by [email protected]	6	2,291
Excel 2003 SP2 computes the power of a negative number wrong. Giovanni Ciriani	by Roger Govier	26	2,291
Count number of rows with specific text Rock	by Rock	2	2,291
Select a range of non-adjacent cells in Excel? hodgsonk	by Biff	12	2,291
How to connect two columns in Excel VBA?? [email protected]	by [email protected]	4	2,291
consolidation of tables in excel with text and figures samenvoegen van sheets	by Ron Coderre	8	2,290
Difference (weekdays) between two dates ant1983	by Myrna Larson	5	2,290
Inverse to WEEKNUM Alonso[_2_]	by David Biddulph[_2_]	12	2,289
Cell Reference Math Ralph Howarth	by Ralph Howarth	0	2,289
Conditional Array Formula IPerlovsky	by IPerlovsky	2	2,288
group/ungroup protected sheets? RLD	by Gord Dibben	1	2,288
Remove text leading zero in text string Cheryl B.	by Peo Sjoblom	5	2,288
how to copy cell formatting in formula JBW	by Ron Rosenfeld	5	2,288
Limit drop down list and linking to other info Intuit	by Biff	13	2,287
Selecting Random Records From an Excel Sreadsheet Trevor Aiston[_2_]	by Lars-Åke Aspelin[_2_]	3	2,287
Calculate a 30-day moving average based on the last x number of entries and date gimiv	by Domenic	14	2,286
MEDIAN, STDEV of a range IF another range = specific value Barb Reinhardt	by Barb Reinhardt	6	2,286
VLOOKUP - Multiple cells in lookup value RMF	by Bob Phillips	1	2,286
Vacation Accrual formula vane0326	by [email protected]	1	2,285
Condensing a list with duplicates to a list with non-duplicates Nuclear	by M Kan	2	2,285
Convert three separate columns of values to dates jack	by jack	3	2,285
How do I change the colour of/remove the Freeze Panes line in Exce katya_1978	by Jimbola	1	2,285
How to apply a formula to all cells in a column Gillian White	by Pete_UK	3	2,284
modulus 11 formula Mich modulus 11	by vezerid	1	2,284
How to generate sets of random numbers without having duplicates William	by Tushar Mehta	1	2,284
Return Numerical Label for LAST value Subtracted to reach Sum Target Value Sam via OfficeKB.com	by Ron Rosenfeld	17	2,284
pounds shillings pence format in excel peter	by Bernard Liengme[_2_]	2	2,284
Quintile Returns Tom Freeman	by Shane Devenshire	4	2,284
SUM until blank cell JasonUT	by RagDyer	2	2,283
linking data from sharepoint to excel spreadsheet? phrog164	by phrog164	0	2,283
Yieldmat function BarryHWhite	by JoeU2004	8	2,283
Create an array of separate cells Rickemil	by Ron Rosenfeld[_2_]	3	2,283
Driver Hours Of Service dunrite	by dunrite	0	2,281
How do I make JUST the header row always visible in Excel? t.261	by Gord Dibben	2	2,281
vlookup in the row below the target row AG	by AG	2	2,281
$ in functions [email protected]	by Pete_UK	4	2,280
Extract Middle Initial from Name Dave Y	by Ron Rosenfeld	10	2,280
Auto Filter Comma Dilemiation weswhite7	by Shane Devenshire[_2_]	2	2,279
SUMIFS - How to use a variable with or < in criteria Jeff Lowenstein	by RagDyer	2	2,279
Find a range of values in a range of cells Jack Taylor	by Ron Coderre	20	2,279
Finding the longest sequence of 0's in a row MJW[_2_]	by Peo Sjoblom	7	2,279
Rank Function with Multiple Criteria KellyC	by Rick Rothstein $MVP - VB$[_716_]	9	2,278
Excel 2003: Match one list against another and highlight differenc smithers2002	by JulieD	1	2,278
Auto Filter not showing all data dcknie	by Gord Dibben	5	2,278
Using icon sets with relative references parmstrong	by parmstrong	0	2,278
Formula to evaluate dates bigbird98	by Pete_UK	2	2,277
fill a cell based on another cells value r2rcode	by pmartglass	3	2,277
Augmenting an integer in a column to reflect duplicates in another Colin Hayes	by Colin Hayes	23	2,277
solving for NPer w/o function (algebra question) Karl	by [email protected]	11	2,277
How to prepare Multi Stock Valuation on Fifo Basis in Excel md12nov	by md12nov	0	2,277
3 months prior and 3 months post a date renee	by Bob Phillips	2	2,276
Creating an hourly planner from excel data graeme_706	by graeme_706	0	2,276
Please add an INTERPOLATE function. For vector or array data. Dan Gauthier	by David Biddulph[_2_]	15	2,276
How do I write a formula in excel that calculates payroll? Excel overtime formula	by Naz	3	2,276
How to display dash instead of #REF [email protected]	by [email protected]	13	2,275
I have dual monitors, how can I view excel workbooks side by side Johnson County	by Dave Peterson	1	2,275
Starting drop down lists at the top test123	by Héctor Miguel	1	2,275
Standard Deviation from Goal, NOT Mean Victoria	by Jerry W. Lewis	5	2,275
excel-hrs spreadsheet-work 8:15 - 5:30 (how calculate total hrs?) Harris	by Irina	2	2,275
reference other worksheets via variable names Huggy	by Huggy	4	2,274
Accumulated percentage calculation Terence C	by Herbert Seidenberg	2	2,274
remove colored rows climate	by Gord Dibben	6	2,274
Conditional Formatting to Lock Cells dd	by dd	2	2,274
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. stan-the-man	by Harlan Grove	7	2,274
display a value from Sheet1-A1:A10 in Sheet2-B1 sam	by Rajesh Mehmi	2	2,274
Excel Time Sheet - Rounding To Quarter Hours C A	by C A	2	2,273
Can VLOOKUP return multiple answers based on several identical lo. jddtct	by CarlosAntenna	3	2,273
Globally change relative-addressed hyperlinks to absolute-addr Herman H	by Roland	1	2,272
Can't change part of an array Geoff Newham	by Sean Timmons	5	2,272
Pivot Table Conditonal Format of the Grand Total michelle	by Roger Govier	3	2,271
Using text as a criteria in Excel Baba	by Pete_UK	4	2,271