Excel Worksheet Functions - Page 139

Thread / Thread Starter	Last Post	Replies	Views
List Management Question- Combining into one Daphtg	by Shane Devenshire[_2_]	2	487
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG" MAHMOUD	by T. Valko	5	1,542
I am using a macro and it cancels my formula Nelly	by Don Guillett	3	526
max-ing excel out Tami	by Gord Dibben	3	531
Total numbers in column where the row cell matches the search crit Kane	by Jacob Skaria	1	587
Vlookup Match Problem Hardeep Kanwar	by JP Ronse	5	648
Complex SUM vsoler	by JP Ronse	4	516
index, sumproduct, or other JustBreathe	by Ashish Mathur[_2_]	3	605
SUM only Cells where there is text in Another cell MCook	by Ashish Mathur[_2_]	1	468
List Management ??? Daphtg	by Shane Devenshire[_2_]	2	467
Conditional Format based upon if statement and max CARFL97	by T. Valko	11	1,623
Obtain Middle vlaue of text with unknow length Abdul Shakeel[_2_]	by Teethless mama	3	593
page break with auto sub total Sudipta Sen[_2_]	by Sudipta Sen[_2_]	0	1,286
Coloring the row and column numbering bars in Excel 2003€ arasan77	by bill kuunders	2	629
copy an exact formula without changing cell reference Vidal	by pshepard[_2_]	1	1,765
Question on my Case of grouping the SW Blue Fish[_2_]	by winnie123	1	642
Search for specific text within last non blank cell in a range Bevo	by Bevo	2	1,052
Vlookup CARFL97	by Hardeep Kanwar	3	496
How do I group text from cells into categories bseeley	by Shane Devenshire[_2_]	3	962
PUTTING YOUR OWN TEXT IN EXCEL 2007 COLUMN HEADINGS NewBee@excel2007[_2_]	by JLatham	7	933
Finding last used column ken	by ken	7	430
Combining If, Vlookup in formula HR_Payroll	by Shane Devenshire[_2_]	2	570
MRound Formula LauraLee	by Shane Devenshire[_2_]	3	654
Combine and display values in range in 1 cell but skip blank cells Swiss	by Swiss	3	1,338
Why won't target cell data changes trigger formula evaluation? laura_in_abq	by Gord Dibben	3	1,231
E-mail Addresses Won't Hyperlink in Excel 2007 Gretchen	by Gord Dibben	5	1,354
linking data from 2 wrksheets using a common cell value jmasterton	by Sean Timmons	3	678
Extend the number of arguments of a function JP Ronse	by JP Ronse	9	665
VLookup with 2 criteria Meredith	by Ben Webman	6	1,209
Average Calculation Munchkin	by JP Ronse	4	670
SORT DATA ON A PROTECTED WORKSHEET! Romileyrunner1	by Romileyrunner1	2	628
Is it possible to sort data within a password protected worksheet Romileyrunner1	by Romileyrunner1	0	590
count hemusta	by Shane Devenshire[_2_]	3	423
formula help needed stevenkeen	by Shane Devenshire[_2_]	2	420
Need reference for max and [#this row] function SCC	by SCC	2	533
ISERROR on GETPIVOTDATA Sarah (OGI)	by Shane Devenshire[_2_]	1	1,286
Need different formula in table cells SCC	by SCC	2	517
Need reference for max and [#this row] functions SCC	by Shane Devenshire[_2_]	1	862
Convert worksheet string name to date format in cell Sabosis	by Sabosis	2	1,253
Coloring the row and column numbering bars in Exce2003 arasan77	by Kassie	2	681
Create new sheet for each row and include header Sabosis	by Don Guillett	1	969
Search for number after specific text in string AMH	by AMH	8	664
XIRR versus IRR help! Seth M	by JoeU2004	6	3,110
Macro help: moving specific cells based upon content Scheetsky	by Don Guillett	7	948
Preventing data input until a particular cell is used R	by Susan	3	574
Time lines, Gantt charts and auto-populating cells: possible? Karl	by Karl	0	1,317
dispay numbers as minutes and seconds in excel neilandko	by David Biddulph[_2_]	2	2,167
Sumproduct error caused by too many curly brackets? Romileyrunner1	by Ashish Mathur[_2_]	7	1,018
COnfidence Intervals in Multiple Regression FredZack	by Jerry W. Lewis	4	1,439
Identifying non-returning formula (blank Cell) Vibeke	by Pete_UK	9	649
Sumproduct(match range of values in 2+ cols) LisaM	by LisaM	15	1,352
Bug when hiding a table column and filtering Kevin Hendrawan	by Kevin Hendrawan	0	558
Sumproduct - range as criteria Thommo	by T. Valko	1	540
Resizing cells to fit text returned by VLOOKUP Michelle	by Joerg Mochikun	10	2,403
Formula for dividing work Dok	by Peter	2	642
Weighted Averages PhilF	by PhilF	7	1,169
If Statement with Wildcards not Working cr0375	by Ashish Mathur[_2_]	7	1,175
Indirect function help Marc W	by Marc W	3	559
Averaging Times David M	by Ashish Mathur[_2_]	2	636
Basic Percentage issue: HELP!!! Romileyrunner1	by Ashish Mathur[_2_]	9	676
Synchronous scrolling in all sheets of a wokbook. Oily Rag	by Sheikh Saadi	2	4,229
Display Current Date & Time in a cell: Everytime I open the workbo sam	by Rajesh Mehmi	4	1,301
entering data in a row and then tabbing to the next row Paradisegems	by Gord Dibben	3	561
change the default worksheet to always format formulas blue? dontgue	by Gord Dibben	5	1,053
Identifying the presence of a randomly ordered text string in a cell AG[_3_]	by AG[_3_]	2	608
Summary Help - Multifunction... Greg	by Herbert Seidenberg	2	495
Excel 2003 Data Analysis - Sampling watermt	by Shane Devenshire[_2_]	6	1,181
I AM TRYING TO STOP BEING PROMPTED TO SAVE EVERYTIME I USE EXCEL salma	by R	1	600
Linked sheets not updating properly with dual monitors PrattBratt	by Shane Devenshire[_2_]	1	887
Transfer info to new sheet by date onebodaciousbabe03	by MyVeryOwnSelf[_2_]	4	592
MTD / YTD Greg	by Jacob Skaria	6	744
Checking one cell, if number is a range then this Jenn	by Teethless mama	4	628
Return Results of a cell based on cell referenced in a cell Drew	by Jacob Skaria	4	817
How to use ERROR.TYPE in an IF function? ramudo	by ramudo	3	787
Naming Tabs HUTCH	by Jacob Skaria	1	547