Excel Worksheet Functions - Page 470

Thread / Thread Starter	Last Post	Replies	Views
If statement TamIam	by Don Guillett	2	324
Averaging data if within a date range KellyF	by Max	6	1,656
If and value between two numbers Mifty	by Max	3	3,759
Max absolute number Dan	by Rick Rothstein \(MVP - VB\)	2	548
Count if not a number D	by Sandy Mann	12	4,630
Nested formula using WORKDAY function davisk	by Ron Rosenfeld	5	2,032
Problem with data validation PurpleMilk	by PurpleMilk	2	493
HELP: Averaging values if they meet certain criteria KellyF	by KellyF	3	938
Circular Reference build	by vezerid	1	767
Changing sheet reference to cell reference TeeJay	by TeeJay	3	1,193
Can I create a multiple LOOKUP formula with 'then' function??? Matthew Cardiff	by Matthew Cardiff	8	417
To find duplicates in XL sheet? Ina Andersson	by Mike H	1	477
Is it possible to create a VLOOKUP formula based on an ActiveX con Srisuephanh	by OssieMac	1	875
Cross Reference Table Data Searching vdragn	by T. Valko	3	906
Conditional formatting of cell AJK	by AJK	2	370
How to run macro automatically from range of cells Kevin	by Kevin	6	385
Automatic update of footer macro Greg	by Gord Dibben	2	1,216
nested Cell("contents", w/ cell contents reference) JASelep	by Elkar	1	1,818
trailing spaces peter	by peter	3	462
Clearing out blank rows/columns SteveDB1	by SteveDB1	3	1,647
Logical test on linked data Humphrey	by Humphrey	2	671
scrolling table Coach	by RagDyer	7	466
Random sort function for text Devin	by David Biddulph[_2_]	1	465
2 IF statements looking at two cells AndyB	by AndyB	2	391
Subtracting days from cells B J G[_2_]	by Niek Otten	1	448
Help with =IF(SUM(G64:G69)<0,SUM(B64:B69),"") [email protected]	by [email protected]	6	358
VLOOKUP may be? ab3d4u[_15_]	by ab3d4u[_16_]	2	315
How do I insert pages numbers in Excel 2007 worksheets Stroke Recovery	by Niek Otten	1	538
I have never been able to get a SumProduct formula to work..Help! BAC	by T. Valko	5	569
Why doesn't this work? yovation	by Mark Lincoln	8	557
macro to hide data (with conditional formatting?) Ginna Moore	by Sandy Mann	1	702
how do I do this: today minus hire date equals how many years mo. btaylor1990	by Gary''s Student	1	1,119
How do I protect a text box, but allow entry of data Bob	by Bob	0	388
Help - Function Count, but on dates not numbers Nadine	by T. Valko	10	687
Graphs - Y Axis Labels Rosie	by Rosie	0	328
Dividing hours between working weeks James	by James	0	272
Comparing one column of names to another Kim	by Gary''s Student	1	511
lookup error??? Daniel	by Harlan Grove	6	696
Data Validation - Calculated Error Title JASelep	by JE McGimpsey	5	492
Compare and Filter Out Large Database Doug	by Doug	0	584
Conditional Formatting Jase4now	by Gary''s Student	1	341
Counting yes/no votes Teri H	by vezerid	1	375
FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED MUSANDAI	by JE McGimpsey	2	968
PLEASE HELP URGENT Frontier	by JE McGimpsey	1	337
Find a cell in skeleton data sheet Elango	by vezerid	2	378
16-jul-07 date format to sum at quarters see example Lanette	by Lanette	2	457
how to make a macro to clear multiple cells from multiple worksheets? [email protected]	by Gord Dibben	2	3,355
Sum data, depending on cell content Mik	by Mik	6	773
datedif function ah[_2_]	by Ron Rosenfeld	5	800
OFFSET Range Daniel	by Bob Phillips	1	372
Validation,........how to use a list in another sheet susy	by Stefi	1	505
Receiving #VALUE! when using examples from Microsoft Excel, why? RickG	by RickG	2	571
Result of a formula in another cell Rich W.	by Rich W.	2	620
Graphs Rosie	by Bernard Liengme	1	341
SUMIF formula Jan T.[_2_]	by David Biddulph[_2_]	7	385
change text format to time Hans	by Hans	3	597
Formatting of all sheets at a time Radhakrishna k.v.n.r[_2_]	by Sandy Mann	4	332
Lookup function (i think) Scott R	by Max	3	384
FIND MULTIPLE TEXT FROM DATA AK	by Ron Coderre	3	451
value of a cell / expression is a whole number DavidJ	by Gary''s Student	1	780
FIND MULTIPLE TEXT FROM DATA AK	by AK	0	317
i need to generate a "distance" graph given x and y locations sneha	by sneha	8	753
How to use a UDF (module) across many users (embedd in worsheet) GRIFFO	by GRIFFO	1	479
Refer to Previous or Next Sheet build	by Peo Sjoblom	3	963
{SUM(IF((ARRRAY FORMULA)} bookman3	by David Biddulph[_2_]	8	497
Pivot Table: Variance formula Grunt_13	by Debra Dalgleish	2	1,385
Vlookup using dates in the lookup range hmteacher	by Max	5	642
Imported data buzz	by buzz	2	488
rounding absolute zero amaries	by Bernard Liengme	3	1,409
Most functions do not work and return #Name? [email protected]	by [email protected]	4	843
assigning # to day bmo	by Alan	3	368
Macro HELP PLEASE DP7	by OssieMac	4	356
trying to create a worksheet.... Pasrxu	by Pasrxu	4	384
Conditional format if cell does not display a blank Pierre	by Gord Dibben	1	626
Sort Data Cross Tabs [email protected]	by Dan R.	4	383