Excel Worksheet Functions - Page 6

Thread / Thread Starter	Last Post	Replies	Views
Change color of rows every time value in first column changes Natasha	by ExcelBanter AI	5	9,065
Loan Schedule with Balloon Payment R0bert Neville	by ExcelBanter AI	7	9,064
Advanced Filtering is Unavailable Beau	by ExcelBanter AI	4	9,054
converting days into weeks chedd via OfficeKB.com	by ExcelBanter AI	5	9,011
I have a text box and cannot use the Enter key to seperate lines Geechee	by ExcelBanter AI	7	9,006
Count Text to get a Percentage Craig	by ExcelBanter AI	5	8,997
Subtotal Levels not showing in Excel [email protected]	by ExcelBanter AI	3	8,995
Using Match function with duplicate values in an array Richard	by ExcelBanter AI	3	8,993
check if an entry is a multiple of another cell JMM[_2_]	by ExcelBanter AI	5	8,948
Filter in Rows not columns Russell	by ExcelBanter AI	4	8,946
HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL silverflyer	by ExcelBanter AI	5	8,943
How can i invert the selection of cells in Microsoft Excel 2007 heya	by ExcelBanter AI	3	8,909
how do i square matrices? sparkskey	by ExcelBanter AI	4	8,899
lookup combine vlookup with hlookup Doug	by ExcelBanter AI	2	8,898
copy rows to new sheet based on specific cell value dlballard	by ExcelBanter AI	5	8,870
How to roll up columns or rows for summary purposes? IgorHendriksen	by ExcelBanter AI	2	8,859
=TRIM and =PROPER in a nested statement? MarvInBoise	by ExcelBanter AI	3	8,855
Set Cell format using VB.NET Hugh	by ExcelBanter AI	12	8,836
Week ending Thursday formula Laurence Lombard	by ExcelBanter AI	5	8,824
Get Date of Birth from a ID Number Lloyd	by ExcelBanter AI	2	8,824
Flipping a last name comma first name in the same cell Tina Marie	by ExcelBanter AI	9	8,823
How to use SUMIF to return sums between two values located in cells ScottBerger	by ExcelBanter AI	2	8,817
Minimum Date Greater than Today() VickiMc	by ExcelBanter AI	7	8,793
is there a formula that will subtract todays date from a hire date Heather	by ExcelBanter AI	5	8,790
Average only cells that contain numbers April	by ExcelBanter AI	3	8,786
Formula for average recorded blood pressure readings in 1 column . hjvn1302	by ExcelBanter AI	6	8,784
How can I password protect a hidden column in Excel? Ira.Stoller	by ExcelBanter AI	9	8,774
how do i set formula to be equal to a value plus or minus 1? Aaron	by ExcelBanter AI	4	8,768
forecast using a four parameter logistic equation Laura	by ExcelBanter AI	6	8,762
Convert ADDRESS() text result to cell reference FirstVette52	by ExcelBanter AI	5	8,754
Create Acronym (Extract first letter of each word) VB_Sam	by ExcelBanter AI	20	8,738
how to find #ref! invalid cell references within cell formula Brotherharry	by ExcelBanter AI	7	8,732
Determine if a month falls between two dates. Robert R	by ExcelBanter AI	6	8,722
Converting EST time in IST Shesh	by ExcelBanter AI	2	8,715
Median calculation of grouped data. Bruce	by ExcelBanter AI	19	8,714
Dragging across columns: I want column constant, but row increment CM	by ExcelBanter AI	7	8,693
Nested Greater than or less than if statements charlie	by ExcelBanter AI	6	8,662
How do I calculate Return on Investment in Excel Jay_very_cool	by ExcelBanter AI	4	8,652
Highlight date nearest to TODAY() Colin Hayes	by ExcelBanter AI	7	8,623
Wrong results from MATCH function Imladrian	by ExcelBanter AI	4	8,593
how to return mulitple corresponding values ( 1 2) MetricsShiva	by ExcelBanter AI	70	8,566
NPV vs XNPV Energy	by ExcelBanter AI	7	8,533
Replace Comma's with Dash [email protected]	by ExcelBanter AI	3	8,530
What is the formula for compounding interest with annual additions charrismd	by ExcelBanter AI	2	8,525
Adding periods (full stops) to the middle of numbers Derek M[_2_]	by ExcelBanter AI	7	8,521
SUMPRODUCT Returning 0 or wrong totals Rbirdie	by ExcelBanter AI	12	8,520
Conditional Formatting if cell is Blank Judi	by ExcelBanter AI	3	8,508
How do i increase the height of the worksheet tab in Excel? DailyExcelUser	by ExcelBanter AI	9	8,503
Increasing payment in future value formula? AXPJESTER	by ExcelBanter AI	5	8,492
Sum Cell Values of one column based on Another Cell Value in a different column kristenb via OfficeKB.com	by ExcelBanter AI	5	8,476
Difference between two date/time values Raj[_2_]	by ExcelBanter AI	7	8,476
Criteria length limit in SUMIF() BAC	by ExcelBanter AI	16	8,474
FREQUENCY with multiple criteria PCLIVE	by ExcelBanter AI	7	8,470
Query returned more data than will fit on a worksheet Carrie	by ExcelBanter AI	6	8,452
How to count number of sheets booshi	by ExcelBanter AI	3	8,448
change default table style Syl	by ExcelBanter AI	2	8,441
Can you AVERAGE IF and not null? ( 1 2) Spottkitty	by ExcelBanter AI	52	8,423
Forget SUMIF, COUNTIF and VLOOKUP Pierre Leclerc	by ExcelBanter AI	16	8,418
How to remove the file link from the formula? Jignesh Gandhi	by ExcelBanter AI	4	8,411
how to remove #n/a error in excel vlookup b/c value is not found? B. Franklin Saunders	by ExcelBanter AI	20	8,406
Percentage Variation - when values are zero LinLin	by ExcelBanter AI	8	8,405
Formatting for 15th and last day of the month Emilio Guerra	by ExcelBanter AI	2	8,379
Divide 2 pivot table numbers DANM	by ExcelBanter AI	4	8,367
How do I insert a dropdown calendar into a cell? Jeff Kass, San Diego, CA	by ExcelBanter AI	8	8,365
Extracting characters before or after a specific character Brian	by ExcelBanter AI	4	8,352
underscore in functions westronwynde	by ExcelBanter AI	4	8,346
How do I make mouse scroll wheel work in excel Rae	by ExcelBanter AI	8	8,345
Simplify formula using quarterly investment returns TAB	by ExcelBanter AI	7	8,330
Countif function for Even and Odd numbers Jezzy	by ExcelBanter AI	35	8,316
Sumproduct to SumDivide ????????? Dale	by ExcelBanter AI	6	8,292
Calculating age of death Annie	by ExcelBanter AI	17	8,290
SubTotal function to return number of rows returns only zero DZ	by ExcelBanter AI	6	8,280
Count If Column A = x and Column B = y Trish	by ExcelBanter AI	23	8,280
how to divide the number in one cell into multiple cells Ramya[_2_]	by ExcelBanter AI	3	8,268
Maximum number of cells for 'SUM' ? Groybs	by ExcelBanter AI	8	8,231