Excel Worksheet Functions - Page 139

Thread / Thread Starter	Last Post	Replies	Views
List Management Question- Combining into one Daphtg	by Shane Devenshire[_2_]	2	479
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG" MAHMOUD	by T. Valko	5	1,506
I am using a macro and it cancels my formula Nelly	by Don Guillett	3	512
max-ing excel out Tami	by Gord Dibben	3	517
Total numbers in column where the row cell matches the search crit Kane	by Jacob Skaria	1	569
Vlookup Match Problem Hardeep Kanwar	by JP Ronse	5	640
Complex SUM vsoler	by JP Ronse	4	506
index, sumproduct, or other JustBreathe	by Ashish Mathur[_2_]	3	591
SUM only Cells where there is text in Another cell MCook	by Ashish Mathur[_2_]	1	459
List Management ??? Daphtg	by Shane Devenshire[_2_]	2	454
Conditional Format based upon if statement and max CARFL97	by T. Valko	11	1,612
Obtain Middle vlaue of text with unknow length Abdul Shakeel[_2_]	by Teethless mama	3	582
page break with auto sub total Sudipta Sen[_2_]	by Sudipta Sen[_2_]	0	1,271
Coloring the row and column numbering bars in Excel 2003€ arasan77	by bill kuunders	2	621
copy an exact formula without changing cell reference Vidal	by pshepard[_2_]	1	1,743
Question on my Case of grouping the SW Blue Fish[_2_]	by winnie123	1	630
Search for specific text within last non blank cell in a range Bevo	by Bevo	2	1,033
Vlookup CARFL97	by Hardeep Kanwar	3	485
How do I group text from cells into categories bseeley	by Shane Devenshire[_2_]	3	954
PUTTING YOUR OWN TEXT IN EXCEL 2007 COLUMN HEADINGS NewBee@excel2007[_2_]	by JLatham	7	919
Finding last used column ken	by ken	7	416
Combining If, Vlookup in formula HR_Payroll	by Shane Devenshire[_2_]	2	564
MRound Formula LauraLee	by Shane Devenshire[_2_]	3	638
Combine and display values in range in 1 cell but skip blank cells Swiss	by Swiss	3	1,311
Why won't target cell data changes trigger formula evaluation? laura_in_abq	by Gord Dibben	3	1,212
E-mail Addresses Won't Hyperlink in Excel 2007 Gretchen	by Gord Dibben	5	1,338
linking data from 2 wrksheets using a common cell value jmasterton	by Sean Timmons	3	671
Extend the number of arguments of a function JP Ronse	by JP Ronse	9	651
VLookup with 2 criteria Meredith	by Ben Webman	6	1,182
Average Calculation Munchkin	by JP Ronse	4	650
SORT DATA ON A PROTECTED WORKSHEET! Romileyrunner1	by Romileyrunner1	2	599
Is it possible to sort data within a password protected worksheet Romileyrunner1	by Romileyrunner1	0	557
count hemusta	by Shane Devenshire[_2_]	3	420
formula help needed stevenkeen	by Shane Devenshire[_2_]	2	402
Need reference for max and [#this row] function SCC	by SCC	2	518
ISERROR on GETPIVOTDATA Sarah (OGI)	by Shane Devenshire[_2_]	1	1,273
Need different formula in table cells SCC	by SCC	2	505
Need reference for max and [#this row] functions SCC	by Shane Devenshire[_2_]	1	851
Convert worksheet string name to date format in cell Sabosis	by Sabosis	2	1,244
Coloring the row and column numbering bars in Exce2003 arasan77	by Kassie	2	669
Create new sheet for each row and include header Sabosis	by Don Guillett	1	948
Search for number after specific text in string AMH	by AMH	8	625
XIRR versus IRR help! Seth M	by JoeU2004	6	3,083
Macro help: moving specific cells based upon content Scheetsky	by Don Guillett	7	923
Preventing data input until a particular cell is used R	by Susan	3	559
Time lines, Gantt charts and auto-populating cells: possible? Karl	by Karl	0	1,303
dispay numbers as minutes and seconds in excel neilandko	by David Biddulph[_2_]	2	2,160
Sumproduct error caused by too many curly brackets? Romileyrunner1	by Ashish Mathur[_2_]	7	1,000
COnfidence Intervals in Multiple Regression FredZack	by Jerry W. Lewis	4	1,426
Identifying non-returning formula (blank Cell) Vibeke	by Pete_UK	9	636
Sumproduct(match range of values in 2+ cols) LisaM	by LisaM	15	1,331
Bug when hiding a table column and filtering Kevin Hendrawan	by Kevin Hendrawan	0	537
Sumproduct - range as criteria Thommo	by T. Valko	1	528
Resizing cells to fit text returned by VLOOKUP Michelle	by Joerg Mochikun	10	2,367
Formula for dividing work Dok	by Peter	2	629
Weighted Averages PhilF	by PhilF	7	1,076
If Statement with Wildcards not Working cr0375	by Ashish Mathur[_2_]	7	1,162
Indirect function help Marc W	by Marc W	3	550
Averaging Times David M	by Ashish Mathur[_2_]	2	614
Basic Percentage issue: HELP!!! Romileyrunner1	by Ashish Mathur[_2_]	9	659
Synchronous scrolling in all sheets of a wokbook. Oily Rag	by Sheikh Saadi	2	4,205
Display Current Date & Time in a cell: Everytime I open the workbo sam	by Rajesh Mehmi	4	1,290
entering data in a row and then tabbing to the next row Paradisegems	by Gord Dibben	3	534
change the default worksheet to always format formulas blue? dontgue	by Gord Dibben	5	1,000
Identifying the presence of a randomly ordered text string in a cell AG[_3_]	by AG[_3_]	2	581
Summary Help - Multifunction... Greg	by Herbert Seidenberg	2	484
Excel 2003 Data Analysis - Sampling watermt	by Shane Devenshire[_2_]	6	1,151
I AM TRYING TO STOP BEING PROMPTED TO SAVE EVERYTIME I USE EXCEL salma	by R	1	583
Linked sheets not updating properly with dual monitors PrattBratt	by Shane Devenshire[_2_]	1	872
Transfer info to new sheet by date onebodaciousbabe03	by MyVeryOwnSelf[_2_]	4	574
MTD / YTD Greg	by Jacob Skaria	6	739
Checking one cell, if number is a range then this Jenn	by Teethless mama	4	613
Return Results of a cell based on cell referenced in a cell Drew	by Jacob Skaria	4	795
How to use ERROR.TYPE in an IF function? ramudo	by ramudo	3	773
Naming Tabs HUTCH	by Jacob Skaria	1	531