Excel Worksheet Functions - Page 134

Thread / Thread Starter	Last Post	Replies	Views
lookup last nth number of items in a list D. Stacy	by Jacob Skaria	6	827
U.S. Holidays that the date moves top.jimmy	by T. Valko	17	1,240
2 Conditions in VLookup Tina Hudson	by Ashish Mathur[_2_]	6	479
Average Last 100 Filtered Visible rows Sam via OfficeKB.com	by T. Valko	4	567
Trying to count the number of buyers or sellers for a given month. djcampanelli	by Teethless mama	4	540
Excel 2007 - Pivot Table - field calculation help Franci	by Herbert Seidenberg	1	578
How do I Jody S[_2_]	by Ashish Mathur[_2_]	2	449
Sorting Directory City/Street/Number Murph	by Ashish Mathur[_2_]	1	375
link worksheets by proper identificaton from master jojocuda06	by Ashish Mathur[_2_]	2	472
Compare against three columns and paste from a fourth Toney	by Bernie Deitrick	3	445
Calculating a Formula Subject to a Maximum and Minimum Value Josh Thompson	by Josh Thompson	2	4,135
How do I exclude the HIGH and LOW values in the =AVERAGE function DeWayne	by Fred Smith[_4_]	2	5,842
text converts to scientific sally t	by Teethless mama	1	508
Macro for HEAT chart - THANKS IN ADVANCE! Rachel Costanza	by Gord Dibben	15	1,449
If cel in next colum same row = less color red Nelson	by Gord Dibben	4	459
One # out of many Steve	by Steve	2	393
SUMIFS with an OR criteria Go Bucks!!![_2_]	by T. Valko	8	1,540
Check IF statement please Iriemon	by Fred Smith[_4_]	5	313
Display an Array of Data Based on Other Data golddave via OfficeKB.com	by golddave via OfficeKB.com	4	572
Adding Regressive Months Totals BadBoy	by BadBoy	2	352
Sort by setting two conditions Waveney Johnny	by Eduardo	2	471
how to return data from a right hand side/and one cell down JMALTO	by JMALTO	4	819
Contact Us link is broken pshepard[_2_]	by David Biddulph[_2_]	8	498
Sum and subtract columns when one cell contains preceding text K Tuck	by K Tuck[_2_]	4	1,057
Database in Excel Andy Mc	by Andy Mc	5	423
Adding Progressive Months Totals BadBoy	by BadBoy	5	489
Match worksheet Function displays wrong data on calculation MSJ	by MSJ	1	776
How do I create a drop down list that fills multiple cells? Shawn O	by NoodNutt	1	1,290
Excel 2007 Sindie	by Gord Dibben	4	408
Create a List Output from a Horizontal Array Input Rob	by T. Valko	4	1,363
Concatenate range (without UDF) Greg Lovern	by T. Valko	6	746
Nested If with VLookup result a 0 Tina Hudson	by T. Valko	8	1,038
nth row or column counting monza_racer	by Bernie Deitrick	1	637
Counting latest date in two columns RobertK	by RobertK	7	442
nested if function kim	by kim	5	412
Macro Amendment. Mattlynn via OfficeKB.com	by Mattlynn via OfficeKB.com	4	457
Loop based on number entered in userform Richhall[_2_]	by Paul C	1	686
my vlook up is not pulling the correct info from column 2 highonmtn	by Ashish Mathur[_2_]	1	609
countif or sumproduct ? Steve	by Steve	4	358
Using Validation Ref # within LOOKUP MichaelRobert	by MichaelRobert	3	434
Help required with complex Removing of Duplicates Miramar	by Ashish Mathur[_2_]	2	392
Count if dates meet certain criteria RobertK	by RobertK	10	772
Counting rows RobertK	by RobertK	4	328
Changing Validation List MichaelRobert	by MichaelRobert	5	432
255 Characters Stuart	by Dave Peterson	3	327
use time functions inside if loop saedeepu	by David Biddulph[_2_]	2	519
problem with a function to calculate weighted test score Drew P.	by Drew P.	2	1,027
Visual basic functions Brett	by Brett	2	468
Am I missing some easy solution to my problem? JJ	by Jacob Skaria	2	439
Function for 2nd and third low or Max Elton Law[_2_]	by Elton Law[_2_]	2	477
comment enclosed using vlookup Pran	by Pran	2	342
I need a cell to be blank. David Moore	by Pete_UK	4	375
Expanding formula to look in several sheets jkrons	by jkrons	0	446
Comments box Bryan De-Lara[_2_]	by Steven Kemp	6	594
Excel 2007 Creating a chart Red Baroness	by Jacob Skaria	1	389
Formula to subtotal monthly expense Kent	by Ashish Mathur[_2_]	5	1,851
FIND LAST CELL WITH DATA Sharon	by T. Valko	13	1,201
Conditional Formatting Pivot Table Excel 2007 MVarma	by AFSSkier	1	2,164
if function with multiple criteria LaTanya	by Ashish Mathur[_2_]	4	891
PLEASE ALWAYS INDICATE YOUR VERSION OF EXCEL Bob Umlas[_3_]	by JoeU2004	1	511
IF statement to check for numerical value Toan	by Toan	3	357
Exclude days Mya48	by Mya48	0	363
Looking up first and last DRC	by T. Valko	7	412
Count if two arguments are true LWilson	by LWilson	2	1,121
MOving Data to the next line Greg S[_2_]	by Gord Dibben	1	389
Store array ??? piero	by Dave Peterson	4	684
vlookup i think samantha	by Ms-Exl-Learner	3	491
Conditional Format 2007 Paula	by David Biddulph[_2_]	1	373
Userform Refresh on Worksheet change Richhall[_2_]	by Richhall[_2_]	3	1,929
Data cleanup sjs	by Teethless mama	1	495
Maximum number of data validation cells? Stuart	by Max	3	1,366
dates and text in excel Squidgee	by Glenn	2	375
How to use: (ERR) a form.contains 1 or more invalid refs.? Boswell[_2_]	by Boswell[_2_]	0	525
how do i select all cells in a worksheet Ken[_6_]	by Ken[_6_]	3	367
Multi area Array using IRR function Malakite	by Malakite	2	1,820