Excel Worksheet Functions - Page 82

Thread / Thread Starter	Last Post	Replies	Views
Sumif with an array for criteria Chris	by T. Valko	3	832
count how many different numbers in the column and return to the n CC	by Shane Devenshire[_2_]	2	1,145
DMax with No Criteria Paul Kraemer	by Shane Devenshire[_2_]	2	1,009
repost of question from 2/4 "Using drop-down lists" RoofIL	by Shane Devenshire[_2_]	2	422
Using wildcards with logical (IF, AND) conditional formatting olddog	by Shane Devenshire[_2_]	2	1,846
formula question Cindy	by Cindy	1	343
Formaula for less than date and name begins with...!!! HELP!!! Senor Martinez	by David Biddulph[_2_]	4	435
Is Vlookup the correct way to do this? tammyncook	by Dave Peterson	9	571
Adding text to an IF statement effeciently Bishop	by Bishop	2	1,122
Conditional Formatting Not Working As Intended Bishop	by Bishop	3	780
Using drop-down lists RoofIL	by Gord Dibben	4	468
Excel 2007 drop down lists Angela9520	by Gord Dibben	6	1,141
Function needed to search and pull data from 1 table to another Heidi	by Heidi	4	637
multiply criteria in a range using sumifs dloc	by dloc	1	1,245
combining =SEARCH & =IF statements McRibIsBack	by Teethless mama	4	587
Auto Fill-Down? msnyc07	by msnyc07	2	481
Question About Sorting Nancy	by Gord Dibben	2	421
IF Formulas MR4815	by Bob Phillips[_4_]	2	301
Formula for if name begins with and date is less than or equal to. Senor Martinez[_2_]	by Senor Martinez[_2_]	5	371
Transfering a changing cell value progressively through a workbook Mike1558	by Gord Dibben	3	831
Formula to count data in a column that falls between a range Paul_UK	by Eduardo	3	703
Track Changes History Worksheet cathym	by cathym	0	1,143
limited cell movement thebusinessbus	by Eduardo	2	653
Function needed Jen_T	by Jen_T	2	398
Frequency Amar	by Teethless mama	1	504
Stopping duplication within Data validation SNA400	by Luke M	1	406
Search for data in Excel and hide rows Bjarne Jensen	by Luke M	2	1,491
Excluding a column from range in COUNTIF function connole99	by Eduardo	3	1,427
Find the cell ID of last row in the column and use it in SUMIF for YY san.[_2_]	by Bob Phillips[_4_]	2	621
need a formula Aaargh	by Gareth_Evans (InterCall EMEA)	8	542
help creating a time function Josh	by David Biddulph[_2_]	8	647
SUMIF and text Silja	by Silja	3	2,787
need help with a solution - maybe vlookup? Noetic76	by Noetic76	3	462
data consolidation Stupac	by Bernie Deitrick	1	420
Formula in dropdown list David Pickering	by David Pickering	2	552
Bill Payment Form JWR	by Fred Smith[_4_]	6	1,026
#REF! error with Multiple Documents zxcvbnm6000	by zxcvbnm6000	7	626
list in data validation benji	by L. Howard Kittle	4	447
printing SBAIG	by Teethless mama	2	361
printing SBAIG	by SBAIG	0	366
Countif - problem counting text, other text gmoore3055	by T. Valko	1	737
simple countif formula Brian	by Lars-Åke Aspelin[_2_]	2	856
selecting an item at random for QA sampling Eric F.	by Eric F.	1	821
I wish to group my worksheets under group tabs Art	by Dave Peterson	1	700
indirect function WINDMILL	by Dave Peterson	2	889
if is error then "No Data", if not then average range SK08	by Teethless mama	1	1,133
Value list Maint Girl	by Otto Moehrbach[_2_]	1	321
Switch First and Last Names Karen	by Teethless mama	3	446
edit a comment while protect sheet is on the cell is unprotected Rubber 4 u	by Gord Dibben	1	615
calculating the "mean" for a group of numbers rob	by David Biddulph[_2_]	2	685
Turning =E13 to =$E$13 Bishop	by Pete_UK	3	1,373
Password Maria Elena	by Eduardo	1	380
HELP Roozo	by Roozo	0	388
How do I force the y-intercept value Tony41	by Tony41	0	646
match ganga	by Bernie Deitrick	3	368
Returning a Value from Another Worksheet TLH3934	by Kristin	2	329
Sumproduct cell reference vs embedded "values" BobMcBarker	by Teethless mama	3	1,527
Sumproduct Search, Sum Durations mp80237	by Pete_UK	5	562
Count rows based on multiple criteria dmg	by Glenn	3	906
Lookup function for two variables and return another cell? dcw0405	by T. Valko	2	1,271
Averaging with IFs John	by John	2	342
Cell =Now() << Can I get this to auto-update? Paul Kraemer	by Luke M	2	1,141
Extract the month name from a month Grd	by T. Valko	11	1,032
Sorting in Custom Alphabetical Order Raj[_2_]	by Raj[_2_]	2	739
If Function Jen_T	by Teethless mama	1	387
Stoping Excel from Calculating? John	by Teethless mama	2	364
Deleting Duplicates Angie M.	by Iriemon	2	564
Combine Sumif and Countif John	by John	3	5,511
First column of range in VLOOKUP contains formula Pluggie	by Pluggie	2	603
Lookup Joe	by Joe	0	324
Statistical functions on non-consequtive columns Frode	by Frode	7	441
percentages Mich	by Gareth_Evans (InterCall EMEA)	2	363
Percentage format dpal	by FSt1	1	415
How do you extract day/time/month/year information SV[_2_]	by SV[_2_]	7	1,058
Could someone please help me with a solution to my problem? Eamon	by Eamon	3	548