Excel Worksheet Functions - Page 1101

Thread / Thread Starter	Last Post	Replies	Views
Creating a total percentage from coloured cells 1cainr	by maxpaayne	1	1,852
FVSCHEDULE reremmak	by Fred Smith[_4_]	3	1,852
How can I make an excel cell equal to the value of a frame object text box directionalman	by directionalman	1	1,852
HOW DO I SET PERMANENT GOAL SEEK IN EXCEL YKPURI	by JE McGimpsey	1	1,853
Pivot Table--Daily and MTD Total Jo	by ShaneDevenshire	7	1,853
Formula (or code) return the largest number of duplicates in a list. L. Howard	by L. Howard	16	1,853
How to link Excel worksheet tab names to dates in each worksheet? Pat	by Ken Wright	9	1,853
Average IFS (Multiple Criteria) FunChickyPoo	by AlPano	2	1,853
IF & VLOOKUP FORMULA taxmom	by taxmom	3	1,853
sum of a named range with values based on vlookup results Solutions Manager	by T. Valko	20	1,853
How to GetText() from TextBox under Visual C++ application? Danil	by Danil	0	1,853
Conditional Formatting when inserting a row zahoulik	by Barb Reinhardt	2	1,854
Collapse rows with duplicates mlcrane	by Bernie Deitrick	1	1,854
Making cell contents dependent on another cell Jen	by Pete_UK	2	1,854
make a vlookup using a variable path Alex St-Pierre	by Bob Phillips	1	1,854
How do I calculate CAGR when there are periodic additional investm Roger Phillips	by Fred Smith	3	1,854
Find matching data in two worksheet columns scootter	by scootter	3	1,855
Adding number to a cell reference not to the contents Go Buckeyes!	by Matt Lunn	1	1,855
Row_Index_Num Increment Jani	by Jani	4	1,855
formula for negative and positive numbers in different columns s.m.hardin	by Bob Phillips	5	1,855
Search range of cells for word & return value for use in formula? Peter Psych Teacher	by Ken Johnson	2	1,855
Using Survey Monkey Dee Rich.	by Mike Middleton	3	1,855
OFFSET function question Joseph Spain	by Ken Wright	11	1,855
IS A TIME BETWEEN TWO TIMES EG 12:00 & 8:00 Shirley4589	by Sandy Mann	20	1,856
GETPIVOTDATA using a reference for field name Rayo K	by Rayo K	3	1,856
Force refresh of custom functions donesquire	by bj	5	1,856
Generate random numbers between two values and with a given mean pinosan	by Jerry W. Lewis	2	1,856
AutoComplete Feature in Drop Down Lists? EricC	by L. Howard Kittle	7	1,857
Need to Count the number of times a value occurs within a dt range Gina[_2_]	by ryguy7272	9	1,857
how can I disable "cutting cells" and "drag and drop "in excel ? mwoody	by Spiky	4	1,857
Find Duplicates and Move to New Worksheet Adurr	by Max	9	1,857
Rounding Errors in 2007 Jacqueline	by Meebers[_2_]	14	1,857
Nested Functions for Conditional Formatting Formula RandyH	by Mike H	3	1,857
SUMIF based on 2 conditions TimH	by RagDyer	3	1,857
(Unsuccessfully!) Unhiding Rows in Excel 2003 [email protected]	by [email protected]	6	1,857
SUMPRODUCT - comma versus semicolon Epinn	by Epinn	6	1,857
Replace function not working properly in Excel 2000 SP3 rgbytg	by rgbytg	5	1,857
conditional formula - based on 2 separate criteria andrewo-s	by andrewo-s	10	1,857
Years of Service Calculation JS	by JS	2	1,857
Automating Polynomial Order Selection in Linest Nick Flyger	by [email protected]	3	1,858
YEAR MONTH DAYS COUNTER ad2ad79	by Shane Devenshire[_2_]	2	1,858
How do I install the networkdays function! DaZ..ign	by DaZ..ign	2	1,858
dynamic sheet name in a formula dogsnapper	by dogsnapper	4	1,858
Changing Comment Box Position - Any solutions? Stilla	by Stilla	4	1,858
count the number of rows with entries greater than zero r2rcode	by Luke M[_4_]	1	1,858
background colour of sheet gone gray need to change to whit Change Background colour of worksheet	by CLR	1	1,859
overtime templates Flash	by Niek Otten	1	1,859
Adding an accumulator for multiple cells jrambo63	by JE McGimpsey	3	1,859
Populate days of the month in a column by checking on date Joe	by T. Valko	4	1,859
How do I fix a YMD format? Frustrated	by Fred Smith[_4_]	2	1,859
How many decimal places can a cell display? Spaz	by Jerry W. Lewis	10	1,859
How to combine text and numbers in exel BG	by Rick Rothstein	3	1,859
Countif item is = 20% of total of range Randy Mis	by tarquinious	1	1,860
#N/A In Cells tb	by tb	7	1,860
How does LINEST work? DarrenO	by Jerry W. Lewis	2	1,860
In Excel can sheet tabs be placed along a side margin? SuzieQ	by Mike H	1	1,860
Error in Calculating investment return in Excel using IRR or XRR [email protected]	by ltomama0945	2	1,860
How to lookup the minimum, 2nd minimum and 3rd minimum......... Mark McDonough	by Roger Govier	8	1,860
How do I find the first value in a column less than a number? redeucer	by redeucer	6	1,860
How do you compute partial year depreciation using DDB, SYD, SLN,V Prof D	by Philip J Smith	1	1,860
Time sheet calculation of shift differntial Brett	by Gary Brown[_4_]	1	1,860
Getting wrong answer with Match Function CB1215	by Dave Peterson	3	1,861
automatically transfer data from one spreadsheet to another farley	by Mike	1	1,861
Match data in 2 columns and return data from 3rd column gwtreece[_2_]	by Dave Peterson	1	1,861
Student Marks Calculation Dr Traffic	by Ron Coderre	4	1,861
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. [email protected]	by [email protected]	2	1,861
Tournament Template? DTTODGG	by Gord Dibben	2	1,862
A Microsoft Excel recall spread sheet using calendar dates. rockconner07	by Bernard Liengme	4	1,862
subtracting time going backwards past midnight? Billman	by Teethless mama	3	1,862
Sum box at bottom toolbar of Excel DUCDB	by Jimbola	4	1,862
named range with filter dee	by Tom Ogilvy	3	1,862
Excel XMIRR function Ian Mac	by Ian Mac	0	1,862
HOW TO ROUND UP INTEGER VALUES TO NEAREST TENS EXAMPLE 376 TO 380 v k abbey	by Teethless mama	5	1,862
Macro to highlight cells based on content JimDerDog	by vezerid	1	1,863
=VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MON TH(date)-6, MON Ali	by Ali	14	1,863