Excel Worksheet Functions - Page 149

Thread / Thread Starter	Last Post	Replies	Views
How do I remove all text to the left of the @ in an email address David M	by David M	6	1,341
sum function for minutes and seconds in Excel Brian McM	by Anne Troy	4	1,341
Copying a Formula into Every other Cell In a Column carl	by Bob Phillips	1	1,341
can I put units in MS excel like 200 mm in formulae ? Prashant	by Barb Reinhardt	1	1,341
How get true response when numbers divisible by 12? lax_fan	by lax_fan	2	1,341
lookup single value in one sheet, return multiple results from theother sheet Chuck[_3_]	by Chuck[_3_]	1	1,341
Can we use multiple if with VLookup function Multiple IF's with Vlookup	by Harlan Grove	11	1,341
sumproduct causing memory errors? dave	by Neil_J	1	1,341
Custom Formating Letters to Numbers while Displaying Letters Luke Androsiglio	by Gord Dibben	2	1,341
counting consecutive absences jerry37917	by StaceyJ	6	1,341
How do I format a column to automatically make it a negative numbe Kathy	by Roland	1	1,341
Date comparison adimar	by adimar	14	1,341
Starting payment when increase rate is known & total payment is kn Shailendra Harri	by Fred Smith	12	1,341
How to make a Let statement in Excel? Blain M	by Blain M[_2_]	2	1,341
Mortgage calculation after a large extra payment Gary Wachs	by Dana DeLouis	4	1,340
using hlookup to reference a column in a vlookup formula? joemeshuggah	by joemeshuggah	3	1,340
I want to jump to a worksheet from a contents sheet John C	by Ian P	2	1,340
end of worksheet question olmedic	by Dave Peterson	1	1,340
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 parag	by Biff	3	1,340
feasibility study yenisey	by Marcelo	3	1,340
Reconcile Inventories Using excel Greg	by Max	10	1,340
How do I correct rounding errors in Excel formulas? C. Van Dam	by Ron Rosenfeld	1	1,340
how do i insert rows in a cell Julia	by Stefi	1	1,340
Formula to return lowest value of 3 datapoints Enzo	by Don Guillett	3	1,340
Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only Daniel CHEN	by Peo Sjoblom	3	1,340
need help using vlookup,max and offset functions! glowdark	by glowdark	0	1,340
Count Distinct Values by Group Using Pivot Table (NM) MCP	by Debra Dalgleish	3	1,340
Count unique values and create list based on these values vipa2000	by RagDyer	7	1,340
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, sarah	by JE McGimpsey	2	1,340
Parsing full name into salutation, First, middle, last, Suffix Ez Mozo	by Ron Rosenfeld[_2_]	1	1,340
Auto fit row height and Word Wrap Kayla Dickson	by Gord Dibben	1	1,340
Sum and If Function Problem with Excel 2007 David	by T. Valko	5	1,339
How to set formula for poping up the date of next Wednesday.... J	by Mike H	2	1,339
Dynamic Rolling Average Lancer940	by Lancer940	5	1,339
E-mail Addresses Won't Hyperlink in Excel 2007 Gretchen	by Gord Dibben	5	1,339
convert time to 1/4 hours lktx	by lktx	2	1,339
complex count question JBoulton	by Ron Rosenfeld	13	1,339
MSN MoneyCentral Stock Quotes support historical price look-ups Travis	by Travis	0	1,339
Repeat the macro using different ranges BeSmart	by BeSmart	1	1,339
Multiple lists with repeated values for dependet drop down lists mcmanusb	by Tieske	1	1,339
Auto Filter does not show all the data in the column Char	by Char	2	1,339
Format spreadsheet so no input allowed if certain cell is =<0 Jan Buckley	by Gord Dibben	9	1,339
How to link endings balances to beginning balances on different sh judyskiskd	by Peo Sjoblom	1	1,338
Thousand/Decimal seperator Gertjan Huiskes	by Sheeloo[_3_]	3	1,338
Sum unique values based on criteria yshridhar	by yshridhar	4	1,338
Vlookup in external file Tami	by Tami	2	1,338
Copyit Macro Kendra	by Kendra	16	1,338
Conditional Formats to ignore blank cells mnwankpah	by mnwankpah	4	1,338
Concatenate columns, separated by double quotes Felicia	by Felicia	2	1,338
Using Conditional Format Joe Gieder	by Joe Gieder	13	1,338
COUNTIF cell A1 is x and cell B1 is y Heather Murch	by Peo Sjoblom	2	1,338
Logarithmic curve formulas in charts and LOGEST fx values? Rich	by Jerry W. Lewis	4	1,338
How do I determine a winning % based on wins, losses, and ties? rolly g	by Sloth	3	1,338
Formatting Cell To Display Value Instead Of Formula derek_m_taylor	by derek_m_taylor	2	1,338
Is there a way to sort without losing individual set formulas? Rachael-R	by Jon Quixley	2	1,338
XIRR Function Error Vince	by Myrna Larson	1	1,338
When do we use -- (double minus) in a formula Vk	by Niek Otten	1	1,338
Display a countdown timer HAL	by HAL	3	1,337
Principal & Interest Formula Scoober	by Niek Otten	1	1,337
Find latest date from list and corresponding info MCRH	by Teethless mama	2	1,337
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS [email protected]	by Ron Rosenfeld[_2_]	2	1,337
How would I set up auto sum in the Excel 2007 Quick Access bar? Chancey	by Chancey	0	1,337
Help with months Nitya Satheesh	by Nitya Satheesh	9	1,337
Help with parameter substitution in formula (&value), vbScript circuit_breaker	by Don Guillett	1	1,337
Parsing in Excel? DavidMunday	by wickedchew	1	1,337
area under the graph sustainability now	by Hans Terkelsen	3	1,337
Running a Daily MTD average. Mike Punko	by Domenic	4	1,337
Locate max value of one column based on criteria in another colum JDay01	by Duke Carey	2	1,337
calculating a value if adjacent cell has value Matt Stayton[_2_]	by JE McGimpsey	3	1,337
Most simple formula to calculate date+ 30 months? KR	by Harlan Grove	4	1,337
how can I make a form number change everytime the form is opened babydumplingspita	by Paul B	1	1,337
find cells that contain specific characters mshornet	by mshornet	8	1,337
Data referencing and auto fill across worksheets in one workbook.. Corey Helms	by Corey Helms	0	1,337
how do I show the fractions shown on a ruler? detroitcarpenterbob	by Ron Rosenfeld	1	1,337
how can i round a dollar amount to the nearest thousand? Karen	by [email protected]	1	1,337