Excel Worksheet Functions - Page 139

Thread / Thread Starter	Last Post	Replies	Views
List Management Question- Combining into one Daphtg	by Shane Devenshire[_2_]	2	495
=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	535
max-ing excel out Tami	by Gord Dibben	3	537
Total numbers in column where the row cell matches the search crit Kane	by Jacob Skaria	1	591
Vlookup Match Problem Hardeep Kanwar	by JP Ronse	5	649
Complex SUM vsoler	by JP Ronse	4	525
index, sumproduct, or other JustBreathe	by Ashish Mathur[_2_]	3	606
SUM only Cells where there is text in Another cell MCook	by Ashish Mathur[_2_]	1	477
List Management ??? Daphtg	by Shane Devenshire[_2_]	2	472
Conditional Format based upon if statement and max CARFL97	by T. Valko	11	1,633
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,289
Coloring the row and column numbering bars in Excel 2003€ arasan77	by bill kuunders	2	634
copy an exact formula without changing cell reference Vidal	by pshepard[_2_]	1	1,769
Question on my Case of grouping the SW Blue Fish[_2_]	by winnie123	1	650
Search for specific text within last non blank cell in a range Bevo	by Bevo	2	1,062
Vlookup CARFL97	by Hardeep Kanwar	3	496
How do I group text from cells into categories bseeley	by Shane Devenshire[_2_]	3	971
PUTTING YOUR OWN TEXT IN EXCEL 2007 COLUMN HEADINGS NewBee@excel2007[_2_]	by JLatham	7	940
Finding last used column ken	by ken	7	432
Combining If, Vlookup in formula HR_Payroll	by Shane Devenshire[_2_]	2	579
MRound Formula LauraLee	by Shane Devenshire[_2_]	3	655
Combine and display values in range in 1 cell but skip blank cells Swiss	by Swiss	3	1,339
Why won't target cell data changes trigger formula evaluation? laura_in_abq	by Gord Dibben	3	1,241
E-mail Addresses Won't Hyperlink in Excel 2007 Gretchen	by Gord Dibben	5	1,358
linking data from 2 wrksheets using a common cell value jmasterton	by Sean Timmons	3	688
Extend the number of arguments of a function JP Ronse	by JP Ronse	9	674
VLookup with 2 criteria Meredith	by Ben Webman	6	1,209
Average Calculation Munchkin	by JP Ronse	4	673
SORT DATA ON A PROTECTED WORKSHEET! Romileyrunner1	by Romileyrunner1	2	638
Is it possible to sort data within a password protected worksheet Romileyrunner1	by Romileyrunner1	0	598
count hemusta	by Shane Devenshire[_2_]	3	430
formula help needed stevenkeen	by Shane Devenshire[_2_]	2	422
Need reference for max and [#this row] function SCC	by SCC	2	543
ISERROR on GETPIVOTDATA Sarah (OGI)	by Shane Devenshire[_2_]	1	1,287
Need different formula in table cells SCC	by SCC	2	520
Need reference for max and [#this row] functions SCC	by Shane Devenshire[_2_]	1	867
Convert worksheet string name to date format in cell Sabosis	by Sabosis	2	1,264
Coloring the row and column numbering bars in Exce2003 arasan77	by Kassie	2	684
Create new sheet for each row and include header Sabosis	by Don Guillett	1	973
Search for number after specific text in string AMH	by AMH	8	675
XIRR versus IRR help! Seth M	by JoeU2004	6	3,113
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	580
Time lines, Gantt charts and auto-populating cells: possible? Karl	by Karl	0	1,318
dispay numbers as minutes and seconds in excel neilandko	by David Biddulph[_2_]	2	2,174
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,449
Identifying non-returning formula (blank Cell) Vibeke	by Pete_UK	9	656
Sumproduct(match range of values in 2+ cols) LisaM	by LisaM	15	1,353
Bug when hiding a table column and filtering Kevin Hendrawan	by Kevin Hendrawan	0	566
Sumproduct - range as criteria Thommo	by T. Valko	1	540
Resizing cells to fit text returned by VLOOKUP Michelle	by Joerg Mochikun	10	2,412
Formula for dividing work Dok	by Peter	2	643
Weighted Averages PhilF	by PhilF	7	1,170
If Statement with Wildcards not Working cr0375	by Ashish Mathur[_2_]	7	1,181
Indirect function help Marc W	by Marc W	3	565
Averaging Times David M	by Ashish Mathur[_2_]	2	636
Basic Percentage issue: HELP!!! Romileyrunner1	by Ashish Mathur[_2_]	9	686
Synchronous scrolling in all sheets of a wokbook. Oily Rag	by Sheikh Saadi	2	4,239
Display Current Date & Time in a cell: Everytime I open the workbo sam	by Rajesh Mehmi	4	1,308
entering data in a row and then tabbing to the next row Paradisegems	by Gord Dibben	3	569
change the default worksheet to always format formulas blue? dontgue	by Gord Dibben	5	1,059
Identifying the presence of a randomly ordered text string in a cell AG[_3_]	by AG[_3_]	2	616
Summary Help - Multifunction... Greg	by Herbert Seidenberg	2	503
Excel 2003 Data Analysis - Sampling watermt	by Shane Devenshire[_2_]	6	1,191
I AM TRYING TO STOP BEING PROMPTED TO SAVE EVERYTIME I USE EXCEL salma	by R	1	611
Linked sheets not updating properly with dual monitors PrattBratt	by Shane Devenshire[_2_]	1	896
Transfer info to new sheet by date onebodaciousbabe03	by MyVeryOwnSelf[_2_]	4	593
MTD / YTD Greg	by Jacob Skaria	6	749
Checking one cell, if number is a range then this Jenn	by Teethless mama	4	638
Return Results of a cell based on cell referenced in a cell Drew	by Jacob Skaria	4	824
How to use ERROR.TYPE in an IF function? ramudo	by ramudo	3	795
Naming Tabs HUTCH	by Jacob Skaria	1	557