Excel Worksheet Functions - Page 11

Thread / Thread Starter	Last Post	Replies	Views
De-identify data Eilean	by Eilean	2	6,158
Using Logical OR on text in Conditional Formatting Darius Poli	by Bob Phillips[_4_]	4	6,152
Skipping cells for SUMIF or COUNTIF functions?? Zilla[_2_]	by JE McGimpsey	9	6,148
If Statement to display 3 different outputs instead of 2 MikeyB	by Teethless mama	5	6,148
Remove leading Numbers from text DBLWizard	by Jason Morin	2	6,145
Annual leave monthly calculation Tia[_3_]	by Pete_UK	2	6,145
Why won't text show in SOME cells? hollyw25	by JLatham	3	6,141
How can I set up a series with letters and numbers together? Nommer	by Gord Dibben	6	6,141
Shared workbook error message SteveR	by SteveR	8	6,138
Printing subtotals on each page slopsjon	by slopsjon	9	6,137
How do I lock/protect cells so they can't be changed Julie	by Paul B	3	6,134
Replace non printable characters TonyL	by Dave Peterson	4	6,132
Wrong sum value after calculate with Percentage Neon520	by Neon520	12	6,129
Pivot Table static columns BrianR	by Ashish Mathur[_2_]	4	6,128
How do I format cells to round up? Tom	by RagDyer	6	6,127
Anyone developed a template for employee span of control? NuBee	by Suzanne Sarah Mcallen	2	6,127
cell reference show cell name (ie. D45) and not cell value ria	by RagDyer	4	6,120
formula to switch last/first name around? Stilla	by Auric__	11	6,120
Converting a range of cells from tons to metric tons Brooksl	by Gord Dibben	2	6,110
Countif in a time range smcmoran	by vezerid	5	6,108
Splitting text divided by carriage returns Phil H[_2_]	by Rick Rothstein	2	6,105
how do I delete a new window in excel? alantats	by Dave Peterson	2	6,101
how do I create a probability distribution in excel? Spunkybear	by David F Cox	2	6,093
Find and Replace one row only Nick Wakeham	by Nick Wakeham	2	6,089
How do I write an IF function using dates? Stinky	by David Biddulph[_2_]	3	6,085
Why do I get a #Name error when I use the DateDif function? PhilS	by Fredrik Wahlgren	9	6,081
date formula returns the 15th or the end of month Steve	by Harlan Grove[_2_]	8	6,080
Sum Left Side & Right Side Numbers Rob	by Ron Rosenfeld	4	6,072
Add criteria to sumproduct Greater than or equal to Diddy	by Diddy	5	6,063
Calculating Anniversary years PH@tic[_2_]	by PH@tic[_2_]	4	6,058
how do I lock the fill color in a cell Graham	by Gord Dibben	4	6,058
combinations of numbers sum to a given amount? TimH	by Fortress	3	6,057
Excel to COUNTIF if number greater than one but less than another Rooster8	by Bob Phillips	2	6,053
How do I set up a formula for calculating an expiration date? Pizano3	by Pizano3	2	6,039
Comparing 3 numbers and displaying the lesser of the three tbible	by Arvi Laanemets	2	6,033
Calculate average with missing values Arne Hegefors	by JE McGimpsey	2	6,032
Help on percentages greater than 100 cil	by T. Valko	3	6,027
One less than Max art	by Jacob Skaria	1	6,023
Can I create an "IF" function using cell color as a logical test? JessLynn	by Marcelo	1	6,021
Return a formula as text string to a cell Sharon	by Sharon	4	6,016
How many values appear more than once in a range? Bruce Norris	by Bernie Deitrick	12	6,014
How to remove the top & bottom 10% from a list? Eric	by Max	3	6,009
How do I build a sensitivity analysis table? OS	by Mike Middleton	1	6,005
How do I do A repeated measures ANOVA on Excel 2007??? Molly F	by Shane Devenshire	1	6,004
Duplicating/Mirror Data into another worksheet within same workboo TJ	by Pete_UK	1	6,001
Date/Time Difference Excluding Weekends & Holidays Paula D	by steven_me	3	5,999
Limitations on Sumif Calculation TaraD[_2_]	by T. Valko	3	5,999
VBA function for "Mean" using Array as argument ASokolik	by vandenberg p	21	5,999
Degrees of Freedom in TTest David B	by Bernard Liengme	1	5,997
Sum based on specific condition ( 1 2) Wendy	by Harlan Grove[_2_]	43	5,995
Remove trailing spaces from multiple columns in Excel dcaissie	by Reitanos	8	5,992
Formula to Return the next 1st Tuesday of a Month ( 1 2) Sean	by Sean	42	5,988
Excel Formula if cell is empty then no if text in cell then yes Kathy	by Gary''s Student	2	5,983
How do I use countif like sumif ie (range,criteria,count_range) tmarie	by Ashish Mathur[_2_]	5	5,978
extract numbers from a alphanumeric cell Igneshwara reddy	by Bob Phillips	4	5,977
Delete first two characters in a cell... ChuckF	by bj	6	5,977
Average the POSITIVE values only John	by joeu2004	5	5,963
How to use Excel for Kolmogorov-Smirnov test Nimbus	by Gord Dibben	2	5,956
How do I layer info in Excel. Have large amts of data to sort. Sally	by CLR	2	5,949
Sigma Function? Maria Garcao	by B. R.Ramachandran	6	5,948
Drop Downs, Index Match or what? ( 1 2) Claus Busch	by [email protected]	48	5,942
Compare two columns by aligning same-values and spacing out differences Jon Davis	by Max	1	5,941
Return Sundays date of current week durex	by durex	1	5,939
looking for a rental property expense income worksheet DC	by Fred Smith[_4_]	1	5,936
Help Calculating Partial Months between 2 dates. sirscottyog	by Ashish Mathur[_2_]	2	5,933
blank date shows up as s 1/0/00 Mary	by Gord Dibben	2	5,932
Excel Loan Repayment Schedule template. stevegg	by ryguy7272	3	5,932
How to find the first nonzero cell in a row Katie	by T. Valko	9	5,932
VLOOKUP with Structured Reference to Table Header Julien Bouvier	by Roger Govier[_3_]	4	5,928
formula to average how many units per minute dfarr	by Jarek Kujawa[_2_]	2	5,920
Hide Drop Down Arrows in Table Headers Steve Haack	by Gord Dibben	4	5,917
how do I create a fifo formula in exel heidic2	by ron	3	5,915
Using the IF and VLOOKUP Function to calculate the tax rates and tax deducted nerrawsl	by GS[_6_]	3	5,914
COUNTIF across multiple workbooks JDB	by Bob Phillips	8	5,909
EXCEL 2000 - IF function returns wrong result from logical test Sean Duffy	by ShaneDevenshire	8	5,906