Excel Worksheet Functions - Page 37

Thread / Thread Starter	Last Post	Replies	Views
Help on VLOOKUP with currencies AndyB	by AndyB	10	820
Lookup smooney	by T. Valko	10	721
vlookup lloyd	by Jeff Gordon	10	732
Geomean function BobA5835	by BobA5835	10	1,792
trailing minus via135	by via135	10	757
Formula modification yshridhar	by yshridhar	10	742
to pull from multiple sheets-index,match,vlookup,if,and,or??? ladygr	by Pete_UK	10	1,527
Vlookup displays wrong result Melbridge	by Melbridge	10	1,382
how to count occurences of word in spreadsheet formula JBW	by Rick Rothstein \(MVP - VB\)	10	1,015
Cursor Movement? micah	by micah	10	1,228
How do I set all caps as the default? Mark Barnard	by Gord Dibben	10	1,705
Sheet name needed for formula JBW	by JE McGimpsey	10	891
Counting unique values by date saylur	by Balan	10	801
Calculation using result from Index/Match diaare	by Pete_UK	10	1,392
Compare/Find Exact Date match with varying time sweens319	by David Biddulph[_2_]	10	859
Automatically insert rows with formula susy	by susy	10	4,340
Protect single sheets in the woorkbook Aron	by MM	10	728
Creating Forms in Excel Greengard	by Dave Peterson	10	1,150
Lookup Formula help DavidFarnsworth	by DavidFarnsworth	10	941
Eliminating blank cells PointerMan	by Max	10	1,056
#NAME? VoxBox-Richard	by VoxBox-Richard	10	1,095
Gas Temperature correction factors in an excel spreadsheet. greg	by Rick Rothstein	10	4,628
Followup to "worksheet function" SteveDB1	by SteveDB1	10	763
Function to recognize 1st of month? terryc[_2_]	by T. Valko	10	929
Rand between 1 and 50 Colin	by Bernd P	10	1,477
IF Function based on right value MIKE F	by muddan madhu	10	1,021
Problems with using TEXT, INDIRECT and ADDRESS within an array for Philip Hunt	by Philip Mark Hunt	10	851
Rand() formula Bernd P	by Luke	10	816
Summing up Data Tom K[_2_]	by Tom K[_2_]	10	969
countif Amanda	by Roger Govier	10	886
Help with time interval [email protected]	by T. Valko	10	1,095
Nested if(and(or)) function? budward	by budward	10	807
Conditional Format Using A Time Figure As The Trigger Minitman	by David Biddulph[_2_]	10	1,050
Nesting SUMIF within SUMPRODUCT sj2008	by Bernie Deitrick	10	2,245
I need to switch currencies based on a pull-down selection rband	by willrsf	10	1,447
Need a formula to 'find' word in cells of column from a long list Deden	by T. Valko	10	1,487
If with Vlookup Looping through	by Carim	10	856
checking for a string & No. Christopher Naveen[_2_]	by Christopher Naveen[_2_]	10	765
Conditional subtotals tx12345	by tx12345	10	1,075
Will the COUNTIF function work with auto-filtering? RC	by Bob Phillips	10	1,501
creating an aging report PSikes	by Manic Diva	10	2,353
Pasting constant formula where referral sheet changes Nicole M.	by Nicole M.	10	1,156
Standard Deviation Carlos	by Carlos	10	1,548
SUMIF exluding text Father	by Father	10	855
random number with text T Harris	by Sandy Mann	10	1,207
Lookup help, please lmatt	by lmatt	10	628
the numbers are always in text and i cant seem to change them??? neil	by Gord Dibben	10	1,027
How to make Horizontal data go Vertical tx12345	by Max	10	2,720
Subtracting Date/Time pairs Jason Adolf	by Pete_UK	10	1,054
count problem bill gras	by bill gras	10	791
Looking up Top N using criteria Roddd	by Max	10	659
How do you insert an "or" operator in an "IF" statement. Jim C.	by Max	10	1,056
Could you help me to calculate overtime Svetlana	by Svetlana	10	1,582
How can I do a lookup and get multiple row results? Rashmi	by .	10	1,195
Search and Get Function Help angelsimpson	by angelsimpson	10	979
Help with a hide row macro (not using filter) [email protected]	by Don Guillett	10	1,344
Hiding Sheets Rain	by Rain	10	968
sumproduct not working Tester	by Ron Coderre	10	1,110
if statement Dorothy Rural New Jersey	by John Bundy	10	847
ROW() phocused	by phocused	10	761
SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year) Sam via OfficeKB.com	by Sam via OfficeKB.com	10	1,517
How do I get data validation to disallow specific entries a-one-and-a-two	by T. Valko	10	1,218
count in several colums lee	by RagDyeR	10	739
Find missing values in a series petermcwerner	by petermcwerner	10	1,752
Finding the highest alphabetic name in a list of names s	by T. Valko	10	886
Need to find each day prior to first friday, monthly PaulRMcHanJr	by macropod	10	1,413
Association between words and numbers wandering	by Ken Wright	10	1,067
setting the print area from a macro Joe Farruggio	by Jim Cone	10	1,591
How to copy an array without changing relative cell references? Dmitry	by Ken Johnson	10	1,196
Can anyone help please? vertigo	by kassie	10	698
Text Compare Function JimK	by Ron Coderre	10	878
How to create hyperlink from 2 cells, then open Word Phil	by Kevin Vaughn	10	607
Adding time Ken Davie	by Bruno Campanini	10	934
Unexplainable results from my vlookup Mary-Lou	by Max	10	849
Lookup two different columns Sunryzz	by Kevin Vaughn	10	1,085