Excel Worksheet Functions - Page 470

Thread / Thread Starter	Last Post	Replies	Views
If statement TamIam	by Don Guillett	2	329
Averaging data if within a date range KellyF	by Max	6	1,656
If and value between two numbers Mifty	by Max	3	3,767
Max absolute number Dan	by Rick Rothstein \(MVP - VB\)	2	559
Count if not a number D	by Sandy Mann	12	4,641
Nested formula using WORKDAY function davisk	by Ron Rosenfeld	5	2,032
Problem with data validation PurpleMilk	by PurpleMilk	2	501
HELP: Averaging values if they meet certain criteria KellyF	by KellyF	3	941
Circular Reference build	by vezerid	1	767
Changing sheet reference to cell reference TeeJay	by TeeJay	3	1,203
Can I create a multiple LOOKUP formula with 'then' function??? Matthew Cardiff	by Matthew Cardiff	8	422
To find duplicates in XL sheet? Ina Andersson	by Mike H	1	480
Is it possible to create a VLOOKUP formula based on an ActiveX con Srisuephanh	by OssieMac	1	881
Cross Reference Table Data Searching vdragn	by T. Valko	3	917
Conditional formatting of cell AJK	by AJK	2	380
How to run macro automatically from range of cells Kevin	by Kevin	6	395
Automatic update of footer macro Greg	by Gord Dibben	2	1,216
nested Cell("contents", w/ cell contents reference) JASelep	by Elkar	1	1,823
trailing spaces peter	by peter	3	471
Clearing out blank rows/columns SteveDB1	by SteveDB1	3	1,657
Logical test on linked data Humphrey	by Humphrey	2	677
scrolling table Coach	by RagDyer	7	476
Random sort function for text Devin	by David Biddulph[_2_]	1	467
2 IF statements looking at two cells AndyB	by AndyB	2	401
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	368
VLOOKUP may be? ab3d4u[_15_]	by ab3d4u[_16_]	2	317
How do I insert pages numbers in Excel 2007 worksheets Stroke Recovery	by Niek Otten	1	541
I have never been able to get a SumProduct formula to work..Help! BAC	by T. Valko	5	570
Why doesn't this work? yovation	by Mark Lincoln	8	567
macro to hide data (with conditional formatting?) Ginna Moore	by Sandy Mann	1	712
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	398
Help - Function Count, but on dates not numbers Nadine	by T. Valko	10	697
Graphs - Y Axis Labels Rosie	by Rosie	0	332
Dividing hours between working weeks James	by James	0	277
Comparing one column of names to another Kim	by Gary''s Student	1	513
lookup error??? Daniel	by Harlan Grove	6	698
Data Validation - Calculated Error Title JASelep	by JE McGimpsey	5	501
Compare and Filter Out Large Database Doug	by Doug	0	585
Conditional Formatting Jase4now	by Gary''s Student	1	349
Counting yes/no votes Teri H	by vezerid	1	378
FILTER FUNCTION DOES NOT SHOW TOTAL RECORDS SELECTED MUSANDAI	by JE McGimpsey	2	971
PLEASE HELP URGENT Frontier	by JE McGimpsey	1	337
Find a cell in skeleton data sheet Elango	by vezerid	2	388
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,361
Sum data, depending on cell content Mik	by Mik	6	781
datedif function ah[_2_]	by Ron Rosenfeld	5	803
OFFSET Range Daniel	by Bob Phillips	1	382
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	577
Result of a formula in another cell Rich W.	by Rich W.	2	620
Graphs Rosie	by Bernard Liengme	1	349
SUMIF formula Jan T.[_2_]	by David Biddulph[_2_]	7	387
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	337
Lookup function (i think) Scott R	by Max	3	384
FIND MULTIPLE TEXT FROM DATA AK	by Ron Coderre	3	461
value of a cell / expression is a whole number DavidJ	by Gary''s Student	1	782
FIND MULTIPLE TEXT FROM DATA AK	by AK	0	327
i need to generate a "distance" graph given x and y locations sneha	by sneha	8	760
How to use a UDF (module) across many users (embedd in worsheet) GRIFFO	by GRIFFO	1	488
Refer to Previous or Next Sheet build	by Peo Sjoblom	3	964
{SUM(IF((ARRRAY FORMULA)} bookman3	by David Biddulph[_2_]	8	503
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	490
rounding absolute zero amaries	by Bernard Liengme	3	1,419
Most functions do not work and return #Name? [email protected]	by [email protected]	4	843
assigning # to day bmo	by Alan	3	371
Macro HELP PLEASE DP7	by OssieMac	4	365
trying to create a worksheet.... Pasrxu	by Pasrxu	4	391
Conditional format if cell does not display a blank Pierre	by Gord Dibben	1	627
Sort Data Cross Tabs [email protected]	by Dan R.	4	394