Excel Worksheet Functions - Page 82

Thread / Thread Starter	Last Post	Replies	Views
Sumif with an array for criteria Chris	by T. Valko	3	856
count how many different numbers in the column and return to the n CC	by Shane Devenshire[_2_]	2	1,153
DMax with No Criteria Paul Kraemer	by Shane Devenshire[_2_]	2	1,054
repost of question from 2/4 "Using drop-down lists" RoofIL	by Shane Devenshire[_2_]	2	455
Using wildcards with logical (IF, AND) conditional formatting olddog	by Shane Devenshire[_2_]	2	1,912
formula question Cindy	by Cindy	1	352
Formaula for less than date and name begins with...!!! HELP!!! Senor Martinez	by David Biddulph[_2_]	4	447
Is Vlookup the correct way to do this? tammyncook	by Dave Peterson	9	590
Adding text to an IF statement effeciently Bishop	by Bishop	2	1,137
Conditional Formatting Not Working As Intended Bishop	by Bishop	3	821
Using drop-down lists RoofIL	by Gord Dibben	4	490
Excel 2007 drop down lists Angela9520	by Gord Dibben	6	1,171
Function needed to search and pull data from 1 table to another Heidi	by Heidi	4	661
multiply criteria in a range using sumifs dloc	by dloc	1	1,267
combining =SEARCH & =IF statements McRibIsBack	by Teethless mama	4	607
Auto Fill-Down? msnyc07	by msnyc07	2	499
Question About Sorting Nancy	by Gord Dibben	2	440
IF Formulas MR4815	by Bob Phillips[_4_]	2	317
Formula for if name begins with and date is less than or equal to. Senor Martinez[_2_]	by Senor Martinez[_2_]	5	392
Transfering a changing cell value progressively through a workbook Mike1558	by Gord Dibben	3	865
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	420
Frequency Amar	by Teethless mama	1	526
Stopping duplication within Data validation SNA400	by Luke M	1	426
Search for data in Excel and hide rows Bjarne Jensen	by Luke M	2	1,514
Excluding a column from range in COUNTIF function connole99	by Eduardo	3	1,449
Find the cell ID of last row in the column and use it in SUMIF for YY san.[_2_]	by Bob Phillips[_4_]	2	639
need a formula Aaargh	by Gareth_Evans (InterCall EMEA)	8	564
help creating a time function Josh	by David Biddulph[_2_]	8	688
SUMIF and text Silja	by Silja	3	2,802
need help with a solution - maybe vlookup? Noetic76	by Noetic76	3	487
data consolidation Stupac	by Bernie Deitrick	1	446
Formula in dropdown list David Pickering	by David Pickering	2	575
Bill Payment Form JWR	by Fred Smith[_4_]	6	1,051
#REF! error with Multiple Documents zxcvbnm6000	by zxcvbnm6000	7	649
list in data validation benji	by L. Howard Kittle	4	463
printing SBAIG	by Teethless mama	2	379
printing SBAIG	by SBAIG	0	381
Countif - problem counting text, other text gmoore3055	by T. Valko	1	759
simple countif formula Brian	by Lars-Åke Aspelin[_2_]	2	870
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	901
if is error then "No Data", if not then average range SK08	by Teethless mama	1	1,148
Value list Maint Girl	by Otto Moehrbach[_2_]	1	339
Switch First and Last Names Karen	by Teethless mama	3	463
edit a comment while protect sheet is on the cell is unprotected Rubber 4 u	by Gord Dibben	1	691
calculating the "mean" for a group of numbers rob	by David Biddulph[_2_]	2	706
Turning =E13 to =$E$13 Bishop	by Pete_UK	3	1,414
Password Maria Elena	by Eduardo	1	393
HELP Roozo	by Roozo	0	401
How do I force the y-intercept value Tony41	by Tony41	0	668
match ganga	by Bernie Deitrick	3	390
Returning a Value from Another Worksheet TLH3934	by Kristin	2	355
Sumproduct cell reference vs embedded "values" BobMcBarker	by Teethless mama	3	1,545
Sumproduct Search, Sum Durations mp80237	by Pete_UK	5	578
Count rows based on multiple criteria dmg	by Glenn	3	939
Lookup function for two variables and return another cell? dcw0405	by T. Valko	2	1,333
Averaging with IFs John	by John	2	349
Cell =Now() << Can I get this to auto-update? Paul Kraemer	by Luke M	2	1,189
Extract the month name from a month Grd	by T. Valko	11	1,085
Sorting in Custom Alphabetical Order Raj[_2_]	by Raj[_2_]	2	759
If Function Jen_T	by Teethless mama	1	407
Stoping Excel from Calculating? John	by Teethless mama	2	376
Deleting Duplicates Angie M.	by Iriemon	2	609
Combine Sumif and Countif John	by John	3	5,560
First column of range in VLOOKUP contains formula Pluggie	by Pluggie	2	632
Lookup Joe	by Joe	0	333
Statistical functions on non-consequtive columns Frode	by Frode	7	463
percentages Mich	by Gareth_Evans (InterCall EMEA)	2	370
Percentage format dpal	by FSt1	1	424
How do you extract day/time/month/year information SV[_2_]	by SV[_2_]	7	1,071
Could someone please help me with a solution to my problem? Eamon	by Eamon	3	566