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	815
U.S. Holidays that the date moves top.jimmy	by T. Valko	17	1,228
2 Conditions in VLookup Tina Hudson	by Ashish Mathur[_2_]	6	464
Average Last 100 Filtered Visible rows Sam via OfficeKB.com	by T. Valko	4	559
Trying to count the number of buyers or sellers for a given month. djcampanelli	by Teethless mama	4	518
Excel 2007 - Pivot Table - field calculation help Franci	by Herbert Seidenberg	1	567
How do I Jody S[_2_]	by Ashish Mathur[_2_]	2	433
Sorting Directory City/Street/Number Murph	by Ashish Mathur[_2_]	1	366
link worksheets by proper identificaton from master jojocuda06	by Ashish Mathur[_2_]	2	465
Compare against three columns and paste from a fourth Toney	by Bernie Deitrick	3	431
Calculating a Formula Subject to a Maximum and Minimum Value Josh Thompson	by Josh Thompson	2	4,055
How do I exclude the HIGH and LOW values in the =AVERAGE function DeWayne	by Fred Smith[_4_]	2	5,809
text converts to scientific sally t	by Teethless mama	1	493
Macro for HEAT chart - THANKS IN ADVANCE! Rachel Costanza	by Gord Dibben	15	1,433
If cel in next colum same row = less color red Nelson	by Gord Dibben	4	445
One # out of many Steve	by Steve	2	379
SUMIFS with an OR criteria Go Bucks!!![_2_]	by T. Valko	8	1,512
Check IF statement please Iriemon	by Fred Smith[_4_]	5	307
Display an Array of Data Based on Other Data golddave via OfficeKB.com	by golddave via OfficeKB.com	4	546
Adding Regressive Months Totals BadBoy	by BadBoy	2	345
Sort by setting two conditions Waveney Johnny	by Eduardo	2	428
how to return data from a right hand side/and one cell down JMALTO	by JMALTO	4	794
Contact Us link is broken pshepard[_2_]	by David Biddulph[_2_]	8	483
Sum and subtract columns when one cell contains preceding text K Tuck	by K Tuck[_2_]	4	1,046
Database in Excel Andy Mc	by Andy Mc	5	411
Adding Progressive Months Totals BadBoy	by BadBoy	5	475
Match worksheet Function displays wrong data on calculation MSJ	by MSJ	1	764
How do I create a drop down list that fills multiple cells? Shawn O	by NoodNutt	1	1,270
Excel 2007 Sindie	by Gord Dibben	4	393
Create a List Output from a Horizontal Array Input Rob	by T. Valko	4	1,345
Concatenate range (without UDF) Greg Lovern	by T. Valko	6	663
Nested If with VLookup result a 0 Tina Hudson	by T. Valko	8	1,024
nth row or column counting monza_racer	by Bernie Deitrick	1	630
Counting latest date in two columns RobertK	by RobertK	7	425
nested if function kim	by kim	5	403
Macro Amendment. Mattlynn via OfficeKB.com	by Mattlynn via OfficeKB.com	4	449
Loop based on number entered in userform Richhall[_2_]	by Paul C	1	667
my vlook up is not pulling the correct info from column 2 highonmtn	by Ashish Mathur[_2_]	1	599
countif or sumproduct ? Steve	by Steve	4	354
Using Validation Ref # within LOOKUP MichaelRobert	by MichaelRobert	3	406
Help required with complex Removing of Duplicates Miramar	by Ashish Mathur[_2_]	2	385
Count if dates meet certain criteria RobertK	by RobertK	10	761
Counting rows RobertK	by RobertK	4	320
Changing Validation List MichaelRobert	by MichaelRobert	5	421
255 Characters Stuart	by Dave Peterson	3	320
use time functions inside if loop saedeepu	by David Biddulph[_2_]	2	506
problem with a function to calculate weighted test score Drew P.	by Drew P.	2	970
Visual basic functions Brett	by Brett	2	417
Am I missing some easy solution to my problem? JJ	by Jacob Skaria	2	420
Function for 2nd and third low or Max Elton Law[_2_]	by Elton Law[_2_]	2	458
comment enclosed using vlookup Pran	by Pran	2	330
I need a cell to be blank. David Moore	by Pete_UK	4	364
Expanding formula to look in several sheets jkrons	by jkrons	0	439
Comments box Bryan De-Lara[_2_]	by Steven Kemp	6	574
Excel 2007 Creating a chart Red Baroness	by Jacob Skaria	1	386
Formula to subtotal monthly expense Kent	by Ashish Mathur[_2_]	5	1,803
FIND LAST CELL WITH DATA Sharon	by T. Valko	13	1,189
Conditional Formatting Pivot Table Excel 2007 MVarma	by AFSSkier	1	2,147
if function with multiple criteria LaTanya	by Ashish Mathur[_2_]	4	875
PLEASE ALWAYS INDICATE YOUR VERSION OF EXCEL Bob Umlas[_3_]	by JoeU2004	1	484
IF statement to check for numerical value Toan	by Toan	3	350
Exclude days Mya48	by Mya48	0	352
Looking up first and last DRC	by T. Valko	7	401
Count if two arguments are true LWilson	by LWilson	2	1,111
MOving Data to the next line Greg S[_2_]	by Gord Dibben	1	376
Store array ??? piero	by Dave Peterson	4	651
vlookup i think samantha	by Ms-Exl-Learner	3	480
Conditional Format 2007 Paula	by David Biddulph[_2_]	1	356
Userform Refresh on Worksheet change Richhall[_2_]	by Richhall[_2_]	3	1,885
Data cleanup sjs	by Teethless mama	1	471
Maximum number of data validation cells? Stuart	by Max	3	1,347
dates and text in excel Squidgee	by Glenn	2	366
How to use: (ERR) a form.contains 1 or more invalid refs.? Boswell[_2_]	by Boswell[_2_]	0	512
how do i select all cells in a worksheet Ken[_6_]	by Ken[_6_]	3	359
Multi area Array using IRR function Malakite	by Malakite	2	1,796