Excel Worksheet Functions - Page 82

Thread / Thread Starter	Last Post	Replies	Views
Sumif with an array for criteria Chris	by T. Valko	3	851
count how many different numbers in the column and return to the n CC	by Shane Devenshire[_2_]	2	1,149
DMax with No Criteria Paul Kraemer	by Shane Devenshire[_2_]	2	1,052
repost of question from 2/4 "Using drop-down lists" RoofIL	by Shane Devenshire[_2_]	2	447
Using wildcards with logical (IF, AND) conditional formatting olddog	by Shane Devenshire[_2_]	2	1,908
formula question Cindy	by Cindy	1	349
Formaula for less than date and name begins with...!!! HELP!!! Senor Martinez	by David Biddulph[_2_]	4	446
Is Vlookup the correct way to do this? tammyncook	by Dave Peterson	9	584
Adding text to an IF statement effeciently Bishop	by Bishop	2	1,130
Conditional Formatting Not Working As Intended Bishop	by Bishop	3	814
Using drop-down lists RoofIL	by Gord Dibben	4	481
Excel 2007 drop down lists Angela9520	by Gord Dibben	6	1,161
Function needed to search and pull data from 1 table to another Heidi	by Heidi	4	651
multiply criteria in a range using sumifs dloc	by dloc	1	1,262
combining =SEARCH & =IF statements McRibIsBack	by Teethless mama	4	607
Auto Fill-Down? msnyc07	by msnyc07	2	496
Question About Sorting Nancy	by Gord Dibben	2	435
IF Formulas MR4815	by Bob Phillips[_4_]	2	310
Formula for if name begins with and date is less than or equal to. Senor Martinez[_2_]	by Senor Martinez[_2_]	5	382
Transfering a changing cell value progressively through a workbook Mike1558	by Gord Dibben	3	855
Formula to count data in a column that falls between a range Paul_UK	by Eduardo	3	709
Track Changes History Worksheet cathym	by cathym	0	1,209
limited cell movement thebusinessbus	by Eduardo	2	722
Function needed Jen_T	by Jen_T	2	410
Frequency Amar	by Teethless mama	1	521
Stopping duplication within Data validation SNA400	by Luke M	1	420
Search for data in Excel and hide rows Bjarne Jensen	by Luke M	2	1,507
Excluding a column from range in COUNTIF function connole99	by Eduardo	3	1,440
Find the cell ID of last row in the column and use it in SUMIF for YY san.[_2_]	by Bob Phillips[_4_]	2	630
need a formula Aaargh	by Gareth_Evans (InterCall EMEA)	8	562
help creating a time function Josh	by David Biddulph[_2_]	8	682
SUMIF and text Silja	by Silja	3	2,802
need help with a solution - maybe vlookup? Noetic76	by Noetic76	3	482
data consolidation Stupac	by Bernie Deitrick	1	443
Formula in dropdown list David Pickering	by David Pickering	2	565
Bill Payment Form JWR	by Fred Smith[_4_]	6	1,050
#REF! error with Multiple Documents zxcvbnm6000	by zxcvbnm6000	7	641
list in data validation benji	by L. Howard Kittle	4	460
printing SBAIG	by Teethless mama	2	373
printing SBAIG	by SBAIG	0	380
Countif - problem counting text, other text gmoore3055	by T. Valko	1	749
simple countif formula Brian	by Lars-Åke Aspelin[_2_]	2	867
selecting an item at random for QA sampling Eric F.	by Eric F.	1	832
I wish to group my worksheets under group tabs Art	by Dave Peterson	1	711
indirect function WINDMILL	by Dave Peterson	2	900
if is error then "No Data", if not then average range SK08	by Teethless mama	1	1,143
Value list Maint Girl	by Otto Moehrbach[_2_]	1	329
Switch First and Last Names Karen	by Teethless mama	3	460
edit a comment while protect sheet is on the cell is unprotected Rubber 4 u	by Gord Dibben	1	688
calculating the "mean" for a group of numbers rob	by David Biddulph[_2_]	2	696
Turning =E13 to =$E$13 Bishop	by Pete_UK	3	1,404
Password Maria Elena	by Eduardo	1	390
HELP Roozo	by Roozo	0	396
How do I force the y-intercept value Tony41	by Tony41	0	667
match ganga	by Bernie Deitrick	3	387
Returning a Value from Another Worksheet TLH3934	by Kristin	2	349
Sumproduct cell reference vs embedded "values" BobMcBarker	by Teethless mama	3	1,535
Sumproduct Search, Sum Durations mp80237	by Pete_UK	5	573
Count rows based on multiple criteria dmg	by Glenn	3	930
Lookup function for two variables and return another cell? dcw0405	by T. Valko	2	1,326
Averaging with IFs John	by John	2	348
Cell =Now() << Can I get this to auto-update? Paul Kraemer	by Luke M	2	1,186
Extract the month name from a month Grd	by T. Valko	11	1,082
Sorting in Custom Alphabetical Order Raj[_2_]	by Raj[_2_]	2	752
If Function Jen_T	by Teethless mama	1	400
Stoping Excel from Calculating? John	by Teethless mama	2	376
Deleting Duplicates Angie M.	by Iriemon	2	606
Combine Sumif and Countif John	by John	3	5,548
First column of range in VLOOKUP contains formula Pluggie	by Pluggie	2	625
Lookup Joe	by Joe	0	330
Statistical functions on non-consequtive columns Frode	by Frode	7	456
percentages Mich	by Gareth_Evans (InterCall EMEA)	2	367
Percentage format dpal	by FSt1	1	421
How do you extract day/time/month/year information SV[_2_]	by SV[_2_]	7	1,067
Could someone please help me with a solution to my problem? Eamon	by Eamon	3	565