Excel Worksheet Functions - Page 514

Thread / Thread Starter	Last Post	Replies	Views
Formula to ignore negative numbers in a column? Tia	by Dana DeLouis	3	2,471
MORE THAN ONE LOGIC TEST jan kay	by paul	3	1,227
Date dif jj33002	by jj33002	3	588
Loan Amoritization Spreadhsheet Issue...please help anonymous	by Fred Smith	3	452
Bi weekly payments per month Don Ray	by Ron Rosenfeld	3	497
How do I expand the checkbook register to more than 98 entries? Marcia Ann Miller	by paul	3	823
help interpreting expression anny	by anny	3	539
Reference range of cells and perform subtraction or nothing depending on contents bob-hamilton	by Peo Sjoblom	3	618
Question regarding formula Joe Gieder	by Joe Gieder	3	445
Comparing Entries to a list Davegrier	by Max	3	350
Why won't my formulas work until I save the worksheet? gwwillits	by Peo Sjoblom	3	3,833
Need to get rid of 0's and replace with Blanks Intuit	by Intuit	3	1,229
NA() lucas	by lucas	3	403
currency Problem irresistible007	by Bernard Liengme	3	398
Week Number Decreenisi	by Decreenisi	3	662
Data compiling formula FangYR	by Max	3	829
I am trying to round a list of numbers (prices) to xx.95. Is the Comexe35	by Pete	3	477
summing values appearing in col B when col A has been filtered choc_penguin	by Kevin Vaughn	3	652
FillDown Macro Nick Junod	by Nick Junod	3	458
Count # of A's in a Cell JavyD	by Martin P	3	538
Extending a nested IF function. Wanderer	by Kevin Vaughn	3	632
Formula Bar tad	by Dave Peterson	3	412
How can I create a fill that increments based on worksheet numbers Amanda097	by Amanda097	3	465
Replace a long list of abbreviations with full words in Excel jgundel	by jgundel	3	2,703
Formula that 'contains' a specific word TMF in MN	by Kevin Vaughn	3	624
Histogram from multi-page info pdberger	by Mike Middleton	3	716
How do I use a wildcard or multiple of a cell value in a formula? Vic	by Vic	3	547
Is there a way to autoinsert current row into a formula Michael P. Fleming	by Peo Sjoblom	3	428
Sort is turned off. How do I turn it on? Ludwig1251	by Dave Peterson	3	510
Date Function Gos-C	by Kevin Vaughn	3	353
Worksheet controller praveen_khm	by praveen_khm	3	429
use address function to indicate range in calculation Mayo	by just_jon	3	514
Multiple IF Phippsy	by	3	381
V-lookup and summing values if more than 1 matches criteria holcay	by Dave Peterson	3	687
Why won't Excel let me copy and paste my concantenate formula now Jennifer	by	3	1,178
Finding a minimum value and selecting the cell containing this val Kokomojo	by Ron Coderre	3	519
Ignoring negative number my47620	by Roger Govier	3	452
First occurance greater than or equal to a specified value [email protected]	by [email protected]	3	2,425
Excel - remaining wks in a year formula GimmeStars	by Gary L Brown	3	2,636
Updating inventory quantity kuansheng	by Max	3	583
Color Code Date Checking drvortex	by [email protected]	3	498
Extracting entries from long list Molly	by Max	3	449
Rank & Match Problem Nuno D	by Aladin Akyurek	3	423
How to make autosum update totals in excel Miranda	by Anne Troy	3	2,318
Autofill cels based on two dates in adjacent cels William2	by William2	3	691
=Average(if( formula using different worksheets aka_krakur	by Ashish Mathur	3	1,914
index/match elrussell	by Biff	3	351
autofill dragging result rather than formula, why? DebraAnn	by Anne Troy	3	680
Adding months to dates should account for 28-30-31 day months Graham	by Ron Rosenfeld	3	971
Compare two Numbers - Determine Decrease, Increase, Same Michael	by Ashish Mathur	3	1,667
Splitting single column data into two loopkid1	by CLR	3	448
causing macros to run at insertion point Inobugs	by [email protected]	3	548
Trimmean for limited array Sige	by Sige	3	537
Text string inverting cagolden2003	by Gerrit-Jan Linker	3	370
Count Occurrences and Print Total Lilbit	by Lilbit	3	450
How to show the defined name of another cell Bol	by Bol	3	423
Getting macro to copy to starting cell sony654	by sony654	3	498
Time Display ? Bob Newman	by Peo Sjoblom	3	571
enter date(A) and have (B) total to current day? jeffcol777	by Bob Phillips	3	443
Using the AVERAGE Function Tia	by Tia	3	351
COUNTIF using exclusions djDaemon	by djDaemon	3	698
Extract certain parts of string djDaemon	by Biff	3	698
if equation Robert	by kjs	3	537
A counting question... ranj	by ranj	3	321
Repeat in functions? Ruatha	by Ruatha	3	346
product from k= 0 to n sylphide	by Niek Otten	3	404
Combining 2 or more worksheets Steve Lewington	by KemS	3	596
Returning Multiple Text or Address Locations jdurrmsu	by Max	3	491
time elapsed formula sue	by Fred Smith	3	1,132
Is there an AVERAGEIF function similar to COUNTIF - how do I do i. John Emhof	by John Emhof	3	628
Vlookup problem Graham Haughs	by CLR	3	556
Automate Spreadsheet Karen	by Ron de Bruin	3	1,021
How do I advance filter to multiple locations at once? imills	by Ron de Bruin	3	1,044
I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS PAULP	by Pete	3	1,173
quirky array not working BorisS	by Bob Phillips	3	496