Excel Worksheet Functions - Page 197

Thread / Thread Starter	Last Post	Replies	Views
changing worksheet reference name when copying down cells ferne	by ferne	5	1,595
month name pat67	by bala_vb	5	1,406
How do I determine which data in a range add up to a fixed number? Mray	by Tom-S[_2_]	5	1,785
putting a date in an if statement pat67	by T. Valko	5	734
Sum in a column if there are 3 conditions in another column DogmaDot	by Dazed&Confused	5	834
Formulas displayed in cell rather than calculated values? Don M.	by Don M.	5	1,837
Sorting Worksheets in a workbook Doehead	by Chip Pearson	5	934
Summing multi-level bill of material Nathan356	by Steve Dunn	5	2,157
Ref in two worksheets wm	by T. Valko	5	811
EXTENSION OF EXCEL SHEET COLUMNS BEYOND IV GRID Jayanta Pramanik	by Billns	5	2,975
Changing dates across multiple worksheets Malcolm	by Gord Dibben	5	3,274
MLK b-day as holiday date Greg	by Mike H	5	508
Time formula Dottie	by Luke M[_4_]	5	659
Find the last number in a row David Brogelli	by T. Valko	5	920
Which function will shorten IF-THEN-ELSE ? Jack Ryan	by Roger Govier[_8_]	5	681
Cell Referencing WLMPilot	by WLMPilot	5	701
A list which don not include zero Manos	by Ms-Exl-Learner	5	558
count of number of rows within a range with a certain text cooey	by Bernd P	5	1,069
SD0310 -how do I just get the numbers at the end in cell after Helen Maguire	by L. Howard Kittle	5	987
Transpose link Ana via OfficeKB.com	by Jacob Skaria	5	1,006
Cell format Esradekan	by isabelle	5	682
Using COUNTIF with criteria in an adjacent column? Mr Molio	by Mr Molio	5	768
Formula Help PLease Jennifer[_5_]	by Gord Dibben[_2_]	5	641
Stopping one sheet from calculating Xt	by Xt	5	630
Counting errors kittronald	by joeu2004	5	570
Printing and scaling: why does Excel behave in such a way? PLZ HELP!!! Domanda	by Domanda	5	739
Returning Cell Value if Matches Another cell frankjh19701	by frankjh19701	5	4,988
Multiple IF's with an OR Nadine	by Ms-Exl-Learner	5	1,092
How do I unhide collom a? Honnesty	by Steve Dunn	5	906
Match Formula for three fields to produce result AHK	by T. Valko	5	926
Alternate Rounding Up & Down of .50 in a column HunterX	by Gord Dibben	5	1,643
How do I delete a space at the end of an amount or text Maureen	by Jacob Skaria	5	1,046
modifying T. Valko ws function Steve	by Steve	5	967
Multi-Condition Formula Malcolm	by Malcolm	5	772
Source and Destination worksheet difference Malcolm	by Malcolm	5	935
If calculation Sandy[_2_]	by Steve Dunn	5	522
RANDBETWEEN generating numbers outside range Penny Black	by Mike Middleton[_2_]	5	1,268
How to I combine excel worksheets? msnyc07	by Ron de Bruin	5	1,608
Multiple variables to sort and sum, return values<0 with sum refer Stinky	by Steve Dunn	5	672
List the UNIQUE certain fields from the database Andri	by Dana DeLouis[_3_]	5	706
11 months and 1 day from a given date pk	by Ashish Mathur[_2_]	5	781
Rounding Seconds in 4/21/2010 4:30:23 PM Tom Langley[_2_]	by Joe User[_2_]	5	511
Counting values in an array where value in one column is not null CW	by Ashish Mathur[_2_]	5	594
combining columns and using concatenate Donna[_2_]	by Donna[_2_]	5	688
Sum Function Visible Cells only Brian	by Mike H	5	1,869
Finding duplicate addresses Donna[_2_]	by T. Valko	5	535
annuity calculation for monthly payments but quarterly compoundin JayM	by Joe User[_2_]	5	2,315
workday, networkday or something else? AJ	by Bernd P	5	1,161
question related to merging multiple statements Dharmesh[_2_]	by Rick Rothstein	5	652
Autogroup then sum - can it be done? Jessica Robinson	by John[_22_]	5	1,303
automaticely highlight the row that I am working on Cindy	by Luke M[_4_]	5	2,436
Should I trust XIRR or Legal & General? Ian Jemmett	by Mark Nowell	5	783
Concatenate HTML containing double quotes Chas	by Rob Pye	5	2,461
Morefunc 5.06 Steve	by Alli2	5	2,726
running clock Ted	by Gord	5	2,006
IFERROR in Excel 2007 Dirrk	by Danny Rocks	5	983
ALPHABETIZE WORKSHEETS AUTOMATICALLY RSJAAG	by Jeff C[_2_]	5	972
Worksheet Functions Denrae	by Gord Dibben	5	802
IF formula help? daisy	by Ms-Exl-Learner	5	585
Formula Help Danny Boy	by Danny Boy	5	691
Auto insert sheetname into chart title? Ian R[_3_]	by Bob Ryan	5	3,922
Colour code specific name if it appears in a group of names Wendy	by Ashish Mathur[_2_]	5	1,697
update vlookup formula sheet reference for multiple sheets SRH@Boise	by Jacob Skaria	5	3,168
Is there a way to format a cell to show aging? Carolina Girl[_2_]	by David Biddulph[_2_]	5	2,065
Using SUM + INDEX in array formula Dave Ramage	by Dave Ramage	5	2,041
Time calculations over 24hrs Ian R[_3_]	by Ian R[_3_]	5	1,212
Name Box in Excel 2007 Old Keith	by William Mumba	5	1,472
averaging a range suprsonic	by bala_vb	5	731
Multiple AND OR functions Woodi2	by Steve Dunn	5	860
IF, THEN HELP Grammie	by Grammie	5	801
dates on worksheets Ann	by Gord Dibben	5	602
result given from content of selected cells. Rik_A	by Mike H	5	671
adding time in a work schedule Chris	by Jacob Skaria	5	1,046
if function help kathy	by Ashish Mathur[_2_]	5	615
Formula Help jlo	by Joe User[_2_]	5	673