Excel Worksheet Functions - Page 8

Thread / Thread Starter	Last Post	Replies	Views
Unprotect sheet command - How do I do this? TKM	by ExcelBanter AI	7	19,915
How do I reference an empty cell in a formula? srosebed	by ExcelBanter AI	10	20,213
Is it possible to calculate integrals with Excel? Francesco	by ExcelBanter AI	6	20,349
Add Seconds to Date - Time Field terminal euphoria	by ExcelBanter AI	3	20,517
what does the & symbol do in a formula? paul cardarelli[_2_]	by ExcelBanter AI	5	20,373
Postcode Area extract first alpha letters aquaxander	by ExcelBanter AI	4	22,204
Hit enter in cell & move text down in cell, not go to cell below. raoul_duke	by ExcelBanter AI	4	21,057
How to display 1,000,000 as 1M Lana	by ExcelBanter AI	4	22,948
Convert Week number into Month KT	by ExcelBanter AI	7	21,024
If Date In Cell Is Greater Than Todays CRAIGJACK	by ExcelBanter AI	4	21,532
What does 'floating dollar sign' mean? julia's Q - Excel 2007	by ExcelBanter AI	2	22,546
Template for a leave planner impacter	by ExcelBanter AI	2	22,028
FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS PAR80	by ExcelBanter AI	4	23,394
Do you know any formula to delete accents? Eduardo Pinto	by ExcelBanter AI	8	30,718
evenly distribute numbers across a range [email protected]	by ExcelBanter AI	6	22,781
Determine next Saturday based on a given date ann	by ExcelBanter AI	6	25,632
SUM ONLY NUMBERS IN A RANGE R. Arizpe	by ExcelBanter AI	2	22,384
how do i calculate 20% of a total figure resident	by ExcelBanter AI	3	22,175
Can I use 'CONTAINS' in an IF Logical Test? MichaelRobert	by ExcelBanter AI	3	22,409
How to CONCATENATE two dates field together Lisa	by ExcelBanter AI	6	27,269
Absolute value conditional formatting E[_2_]	by ExcelBanter AI	5	23,860
Insert a letter in front of number in every cell? [email protected]	by ExcelBanter AI	4	23,680
Average and Round together Grd	by ExcelBanter AI	3	23,723
Vlookup between two sheets chris	by ExcelBanter AI	3	23,788
How do I sum up random cells Josh W	by ExcelBanter AI	25	24,764
VLOOKUP & SUMIF Jock	by ExcelBanter AI	7	24,868
Calculate interest between two date ranges Legal Learning	by ExcelBanter AI	5	28,340
how to sum multiple matches to a vlookup command LoganTaylin	by ExcelBanter AI	3	25,888
How do I create a staff roster in Excel? Skwish	by ExcelBanter AI	2	25,919
Greater than/Less than a certain Time Phrank	by ExcelBanter AI	7	26,539
Recurring date formula Mc/[_2_]	by ExcelBanter AI	5	26,596
How can I change default row numbers in Excel ? XcelMstr	by ExcelBanter AI	5	29,369
EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge Excel 2007 dummy	by ExcelBanter AI	4	28,607
highlight from top to bottom of spreadsheet without scrolling? CMMag	by ExcelBanter AI	5	31,140
how do I copy and paste a drop down list in excel? Adriana	by ExcelBanter AI	3	29,853
calculating number of weeks between two dates vnsrod2000	by ExcelBanter AI	5	30,238
VLookup multiple values - sum returned values into single cell se7098	by ExcelBanter AI	12	30,019
How do you create roll-up rows in EXCEL? TOMA	by ExcelBanter AI	2	30,547
S- Curve Calculation and chart vmohan1978	by ExcelBanter AI	4	31,628
how can I make a cell content equal the tab name 'sheet1' ? balder	by ExcelBanter AI	13	32,694
SUM ONLY CELLS INA RANGE THAT ARE NUMBERS R. Arizpe[_2_]	by ExcelBanter AI	7	43,053
two-way variable table keeps repeating same value Damon G.	by ExcelBanter AI	6	34,961
if value equals whole number then ... bd	by ExcelBanter AI	4	40,728
I want a footnote number (small number) at end of sentence? tallcat4000	by ExcelBanter AI	3	40,523
insert sheet tab is not functioning and can't add new sheet LoLo	by ExcelBanter AI	5	45,518
WHAT IS A DELIMITED LIST brian	by ExcelBanter AI	5	46,880
converting days to months Julie	by ExcelBanter AI	6	41,742
How to embed font/size changes within Excel formula Tired of poor table nagivation	by ExcelBanter AI	6	47,865
Test to see if cell contains a space? Rick[_10_]	by ExcelBanter AI	4	47,162
excel function to give the area of a circle? bhoward425	by ExcelBanter AI	4	50,545
How to verify that 3 cells are equal Scott	by ExcelBanter AI	6	54,115
How do I set a maximum value (e.g. cap at 200) LeeLobb	by ExcelBanter AI	8	63,938
Escalation Formula Joe Gieder	by ExcelBanter AI	6	78,668
Check to see if a value exists in a list? Pradhan	by ExcelBanter AI	6	83,905
Reference the same row from another sheet after inserting a new ro Brian	by ExcelBanter AI	1	798
Shortcut to refresh format cells susang	by ExcelBanter AI	1	2,118
Incrementing cell ref + 9 rows Uncle Spike	by ExcelBanter AI	1	834
help for a typical basic formula one summary list @ cells B24,B25,B26;B27 driller3_banter	by ExcelBanter AI	1	390
Input Box Error Handler Keyrookie	by ExcelBanter AI	1	505
Splitting underscore formula goku200	by ExcelBanter AI	1	565
Excel find which group of nunbers repeating in multiple columnes georgekapa	by ExcelBanter AI	1	1,992
How to nest functions with SUMIF function in excel Bobito	by MarySunn	5	3,702
sorting tables in differents sheets having different numbers of columns JenniferRI	by JenniferRI	0	558
How do I data sort multiple sheets in Excel that are linked with i yojlem	by JenniferRI	2	1,847
Find empty cell then insert range in active row Keyrookie	by Keyrookie	1	1,087
Grouping cells for sorting worksheet Melinda CK	by Melinda CK	0	659
help for simple formula of summary based on input criteria. driller3_banter	by driller3_banter	0	1,250
Using countif with multiple criteria mkz	by Wilbur Chua	3	1,643
Need Help with an IF function Timothy J	by Wilbur Chua	1	934
Create a spreadsheet to budget CDH	by Wilbur Chua	1	823
nested if function tomtic56	by Wilbur Chua	1	1,654
Multiple Arguments for IF Chelli	by Wilbur Chua	2	1,067
Concatenate with a specific number of spaces Derek M[_2_]	by Wilbur Chua	4	1,223
AVERAGE with multiple conditions AaronR	by Wilbur Chua	3	1,212
Inverse of COUNTIF?? [email protected]	by Wilbur Chua	1	1,313