Excel Worksheet Functions - Page 470

Thread / Thread Starter	Last Post	Replies	Views
If statement TamIam	by Don Guillett	2	315
Averaging data if within a date range KellyF	by Max	6	1,623
If and value between two numbers Mifty	by Max	3	3,746
Max absolute number Dan	by Rick Rothstein \(MVP - VB\)	2	527
Count if not a number D	by Sandy Mann	12	4,610
Nested formula using WORKDAY function davisk	by Ron Rosenfeld	5	1,987
Problem with data validation PurpleMilk	by PurpleMilk	2	478
HELP: Averaging values if they meet certain criteria KellyF	by KellyF	3	910
Circular Reference build	by vezerid	1	736
Changing sheet reference to cell reference TeeJay	by TeeJay	3	1,167
Can I create a multiple LOOKUP formula with 'then' function??? Matthew Cardiff	by Matthew Cardiff	8	402
To find duplicates in XL sheet? Ina Andersson	by Mike H	1	450
Is it possible to create a VLOOKUP formula based on an ActiveX con Srisuephanh	by OssieMac	1	867
Cross Reference Table Data Searching vdragn	by T. Valko	3	868
Conditional formatting of cell AJK	by AJK	2	334
How to run macro automatically from range of cells Kevin	by Kevin	6	377
Automatic update of footer macro Greg	by Gord Dibben	2	1,184
nested Cell("contents", w/ cell contents reference) JASelep	by Elkar	1	1,777
trailing spaces peter	by peter	3	439
Clearing out blank rows/columns SteveDB1	by SteveDB1	3	1,637
Logical test on linked data Humphrey	by Humphrey	2	661
scrolling table Coach	by RagDyer	7	461
Random sort function for text Devin	by David Biddulph[_2_]	1	426
2 IF statements looking at two cells AndyB	by AndyB	2	389
Subtracting days from cells B J G[_2_]	by Niek Otten	1	433
Help with =IF(SUM(G64:G69)<0,SUM(B64:B69),"") [email protected]	by [email protected]	6	356
VLOOKUP may be? ab3d4u[_15_]	by ab3d4u[_16_]	2	309
How do I insert pages numbers in Excel 2007 worksheets Stroke Recovery	by Niek Otten	1	523
I have never been able to get a SumProduct formula to work..Help! BAC	by T. Valko	5	549
Why doesn't this work? yovation	by Mark Lincoln	8	519
macro to hide data (with conditional formatting?) Ginna Moore	by Sandy Mann	1	692
how do I do this: today minus hire date equals how many years mo. btaylor1990	by Gary''s Student	1	1,103
How do I protect a text box, but allow entry of data Bob	by Bob	0	378
Help - Function Count, but on dates not numbers Nadine	by T. Valko	10	676
Graphs - Y Axis Labels Rosie	by Rosie	0	316
Dividing hours between working weeks James	by James	0	268
Comparing one column of names to another Kim	by Gary''s Student	1	485
lookup error??? Daniel	by Harlan Grove	6	671
Data Validation - Calculated Error Title JASelep	by JE McGimpsey	5	485
Compare and Filter Out Large Database Doug	by Doug	0	559
Conditional Formatting Jase4now	by Gary''s Student	1	334
Counting yes/no votes Teri H	by vezerid	1	365
FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED MUSANDAI	by JE McGimpsey	2	939
PLEASE HELP URGENT Frontier	by JE McGimpsey	1	326
Find a cell in skeleton data sheet Elango	by vezerid	2	375
16-jul-07 date format to sum at quarters see example Lanette	by Lanette	2	434
how to make a macro to clear multiple cells from multiple worksheets? [email protected]	by Gord Dibben	2	3,261
Sum data, depending on cell content Mik	by Mik	6	754
datedif function ah[_2_]	by Ron Rosenfeld	5	775
OFFSET Range Daniel	by Bob Phillips	1	358
Validation,........how to use a list in another sheet susy	by Stefi	1	481
Receiving #VALUE! when using examples from Microsoft Excel, why? RickG	by RickG	2	558
Result of a formula in another cell Rich W.	by Rich W.	2	545
Graphs Rosie	by Bernard Liengme	1	338
SUMIF formula Jan T.[_2_]	by David Biddulph[_2_]	7	376
change text format to time Hans	by Hans	3	584
Formatting of all sheets at a time Radhakrishna k.v.n.r[_2_]	by Sandy Mann	4	325
Lookup function (i think) Scott R	by Max	3	361
FIND MULTIPLE TEXT FROM DATA AK	by Ron Coderre	3	438
value of a cell / expression is a whole number DavidJ	by Gary''s Student	1	767
FIND MULTIPLE TEXT FROM DATA AK	by AK	0	315
i need to generate a "distance" graph given x and y locations sneha	by sneha	8	730
How to use a UDF (module) across many users (embedd in worsheet) GRIFFO	by GRIFFO	1	469
Refer to Previous or Next Sheet build	by Peo Sjoblom	3	950
{SUM(IF((ARRRAY FORMULA)} bookman3	by David Biddulph[_2_]	8	483
Pivot Table: Variance formula Grunt_13	by Debra Dalgleish	2	1,357
Vlookup using dates in the lookup range hmteacher	by Max	5	619
Imported data buzz	by buzz	2	437
rounding absolute zero amaries	by Bernard Liengme	3	1,389
Most functions do not work and return #Name? [email protected]	by [email protected]	4	820
assigning # to day bmo	by Alan	3	358
Macro HELP PLEASE DP7	by OssieMac	4	337
trying to create a worksheet.... Pasrxu	by Pasrxu	4	372
Conditional format if cell does not display a blank Pierre	by Gord Dibben	1	604
Sort Data Cross Tabs [email protected]	by Dan R.	4	370