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	838
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	482
Average Last 100 Filtered Visible rows Sam via OfficeKB.com	by T. Valko	4	575
Trying to count the number of buyers or sellers for a given month. djcampanelli	by Teethless mama	4	546
Excel 2007 - Pivot Table - field calculation help Franci	by Herbert Seidenberg	1	591
How do I Jody S[_2_]	by Ashish Mathur[_2_]	2	450
Sorting Directory City/Street/Number Murph	by Ashish Mathur[_2_]	1	382
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	457
Calculating a Formula Subject to a Maximum and Minimum Value Josh Thompson	by Josh Thompson	2	4,148
How do I exclude the HIGH and LOW values in the =AVERAGE function DeWayne	by Fred Smith[_4_]	2	5,855
text converts to scientific sally t	by Teethless mama	1	509
Macro for HEAT chart - THANKS IN ADVANCE! Rachel Costanza	by Gord Dibben	15	1,450
If cel in next colum same row = less color red Nelson	by Gord Dibben	4	473
One # out of many Steve	by Steve	2	394
SUMIFS with an OR criteria Go Bucks!!![_2_]	by T. Valko	8	1,540
Check IF statement please Iriemon	by Fred Smith[_4_]	5	321
Display an Array of Data Based on Other Data golddave via OfficeKB.com	by golddave via OfficeKB.com	4	587
Adding Regressive Months Totals BadBoy	by BadBoy	2	362
Sort by setting two conditions Waveney Johnny	by Eduardo	2	482
how to return data from a right hand side/and one cell down JMALTO	by JMALTO	4	825
Contact Us link is broken pshepard[_2_]	by David Biddulph[_2_]	8	501
Sum and subtract columns when one cell contains preceding text K Tuck	by K Tuck[_2_]	4	1,067
Database in Excel Andy Mc	by Andy Mc	5	435
Adding Progressive Months Totals BadBoy	by BadBoy	5	497
Match worksheet Function displays wrong data on calculation MSJ	by MSJ	1	786
How do I create a drop down list that fills multiple cells? Shawn O	by NoodNutt	1	1,303
Excel 2007 Sindie	by Gord Dibben	4	415
Create a List Output from a Horizontal Array Input Rob	by T. Valko	4	1,371
Concatenate range (without UDF) Greg Lovern	by T. Valko	6	757
Nested If with VLookup result a 0 Tina Hudson	by T. Valko	8	1,045
nth row or column counting monza_racer	by Bernie Deitrick	1	647
Counting latest date in two columns RobertK	by RobertK	7	451
nested if function kim	by kim	5	425
Macro Amendment. Mattlynn via OfficeKB.com	by Mattlynn via OfficeKB.com	4	469
Loop based on number entered in userform Richhall[_2_]	by Paul C	1	700
my vlook up is not pulling the correct info from column 2 highonmtn	by Ashish Mathur[_2_]	1	616
countif or sumproduct ? Steve	by Steve	4	361
Using Validation Ref # within LOOKUP MichaelRobert	by MichaelRobert	3	449
Help required with complex Removing of Duplicates Miramar	by Ashish Mathur[_2_]	2	403
Count if dates meet certain criteria RobertK	by RobertK	10	787
Counting rows RobertK	by RobertK	4	335
Changing Validation List MichaelRobert	by MichaelRobert	5	442
255 Characters Stuart	by Dave Peterson	3	332
use time functions inside if loop saedeepu	by David Biddulph[_2_]	2	527
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	454
Function for 2nd and third low or Max Elton Law[_2_]	by Elton Law[_2_]	2	491
comment enclosed using vlookup Pran	by Pran	2	352
I need a cell to be blank. David Moore	by Pete_UK	4	377
Expanding formula to look in several sheets jkrons	by jkrons	0	447
Comments box Bryan De-Lara[_2_]	by Steven Kemp	6	605
Excel 2007 Creating a chart Red Baroness	by Jacob Skaria	1	399
Formula to subtotal monthly expense Kent	by Ashish Mathur[_2_]	5	1,855
FIND LAST CELL WITH DATA Sharon	by T. Valko	13	1,214
Conditional Formatting Pivot Table Excel 2007 MVarma	by AFSSkier	1	2,176
if function with multiple criteria LaTanya	by Ashish Mathur[_2_]	4	902
PLEASE ALWAYS INDICATE YOUR VERSION OF EXCEL Bob Umlas[_3_]	by JoeU2004	1	523
IF statement to check for numerical value Toan	by Toan	3	365
Exclude days Mya48	by Mya48	0	372
Looking up first and last DRC	by T. Valko	7	416
Count if two arguments are true LWilson	by LWilson	2	1,135
MOving Data to the next line Greg S[_2_]	by Gord Dibben	1	400
Store array ??? piero	by Dave Peterson	4	696
vlookup i think samantha	by Ms-Exl-Learner	3	492
Conditional Format 2007 Paula	by David Biddulph[_2_]	1	384
Userform Refresh on Worksheet change Richhall[_2_]	by Richhall[_2_]	3	1,937
Data cleanup sjs	by Teethless mama	1	506
Maximum number of data validation cells? Stuart	by Max	3	1,380
dates and text in excel Squidgee	by Glenn	2	385
How to use: (ERR) a form.contains 1 or more invalid refs.? Boswell[_2_]	by Boswell[_2_]	0	531
how do i select all cells in a worksheet Ken[_6_]	by Ken[_6_]	3	369
Multi area Array using IRR function Malakite	by Malakite	2	1,833