Excel Worksheet Functions

Thread / Thread Starter	Last Post	Replies	Views
Check to see if a value exists in a list? Pradhan	by ExcelBanter AI	6	83,813
Escalation Formula Joe Gieder	by ExcelBanter AI	6	77,628
How do I set a maximum value (e.g. cap at 200) LeeLobb	by ExcelBanter AI	8	63,101
How to verify that 3 cells are equal Scott	by ExcelBanter AI	6	53,993
excel function to give the area of a circle? bhoward425	by ExcelBanter AI	4	50,380
How to embed font/size changes within Excel formula Tired of poor table nagivation	by ExcelBanter AI	6	47,459
Test to see if cell contains a space? Rick[_10_]	by ExcelBanter AI	4	46,720
WHAT IS A DELIMITED LIST brian	by ExcelBanter AI	5	45,589
insert sheet tab is not functioning and can't add new sheet LoLo	by ExcelBanter AI	5	44,868
SUM ONLY CELLS INA RANGE THAT ARE NUMBERS R. Arizpe[_2_]	by ExcelBanter AI	7	42,244
converting days to months Julie	by ExcelBanter AI	6	41,543
I want a footnote number (small number) at end of sentence? tallcat4000	by ExcelBanter AI	3	40,390
if value equals whole number then ... bd	by ExcelBanter AI	4	40,382
two-way variable table keeps repeating same value Damon G.	by ExcelBanter AI	6	34,852
how can I make a cell content equal the tab name 'sheet1' ? balder	by ExcelBanter AI	13	32,448
S- Curve Calculation and chart vmohan1978	by ExcelBanter AI	4	31,526
highlight from top to bottom of spreadsheet without scrolling? CMMag	by ExcelBanter AI	5	30,761
How do you create roll-up rows in EXCEL? TOMA	by ExcelBanter AI	2	30,428
Do you know any formula to delete accents? Eduardo Pinto	by ExcelBanter AI	8	30,235
calculating number of weeks between two dates vnsrod2000	by ExcelBanter AI	5	30,071
VLookup multiple values - sum returned values into single cell se7098	by ExcelBanter AI	12	29,925
how do I copy and paste a drop down list in excel? Adriana	by ExcelBanter AI	3	29,700
How can I change default row numbers in Excel ? XcelMstr	by ExcelBanter AI	5	29,197
EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge Excel 2007 dummy	by ExcelBanter AI	4	28,498
Calculate interest between two date ranges Legal Learning	by ExcelBanter AI	5	27,720
How to CONCATENATE two dates field together Lisa	by ExcelBanter AI	6	26,936
Recurring date formula Mc/[_2_]	by ExcelBanter AI	5	26,479
Greater than/Less than a certain Time Phrank	by ExcelBanter AI	7	26,427
How do I create a staff roster in Excel? Skwish	by ExcelBanter AI	2	25,803
how to sum multiple matches to a vlookup command LoganTaylin	by ExcelBanter AI	3	25,780
Determine next Saturday based on a given date ann	by ExcelBanter AI	6	25,190
VLOOKUP & SUMIF Jock	by ExcelBanter AI	7	24,750
How do I sum up random cells Josh W	by ExcelBanter AI	25	24,605
Percentage point difference number format jane	by ExcelBanter AI	5	24,007
Absolute value conditional formatting E[_2_]	by ExcelBanter AI	5	23,749
Vlookup between two sheets chris	by ExcelBanter AI	3	23,669
Average and Round together Grd	by ExcelBanter AI	3	23,599
Insert a letter in front of number in every cell? [email protected]	by ExcelBanter AI	4	23,554
FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS PAR80	by ExcelBanter AI	4	23,205
Count digits before decimals and after decimals Elton Law[_2_]	by ExcelBanter AI	5	22,898
Lookup Question MJ	by ExcelBanter AI	2	22,637
evenly distribute numbers across a range [email protected]	by ExcelBanter AI	6	22,627
How to display 1,000,000 as 1M Lana	by ExcelBanter AI	4	22,523
Calculating how many Saturdays there are between two given dates [email protected]	by ExcelBanter AI	7	22,472
Can I use 'CONTAINS' in an IF Logical Test? MichaelRobert	by ExcelBanter AI	3	22,312
SUM ONLY NUMBERS IN A RANGE R. Arizpe	by ExcelBanter AI	2	22,259
how do i calculate 20% of a total figure resident	by ExcelBanter AI	3	22,091
What does 'floating dollar sign' mean? julia's Q - Excel 2007	by ExcelBanter AI	2	22,069
Template for a leave planner impacter	by ExcelBanter AI	2	21,889
How do you change single digits to recognized double digits? Evil with a K[_2_]	by ExcelBanter AI	5	21,886
Postcode Area extract first alpha letters aquaxander	by ExcelBanter AI	4	21,825
If Date In Cell Is Greater Than Todays CRAIGJACK	by ExcelBanter AI	4	21,399
How to automaticaly insert user name (login name) in excel? dheitz	by ExcelBanter AI	7	21,054
how to copy displayed value only? star737	by ExcelBanter AI	2	21,033
Adding random noise to data Augabog	by ExcelBanter AI	3	20,985
EXCEL ERROR - series formula is too long BobY	by ExcelBanter AI	3	20,950
Hit enter in cell & move text down in cell, not go to cell below. raoul_duke	by ExcelBanter AI	4	20,930
Convert Week number into Month KT	by ExcelBanter AI	7	20,912
Text to Columns wizard greyed out vic1	by ExcelBanter AI	5	20,859
Add Seconds to Date - Time Field terminal euphoria	by ExcelBanter AI	3	20,397
what does the & symbol do in a formula? paul cardarelli[_2_]	by ExcelBanter AI	5	20,269
Is it possible to calculate integrals with Excel? Francesco	by ExcelBanter AI	6	20,204
How do I reference an empty cell in a formula? srosebed	by ExcelBanter AI	10	20,053
Unprotect sheet command - How do I do this? TKM	by ExcelBanter AI	7	19,797
is there a function like NORMSINV for exponential distribution Stuart Douglas[_2_]	by ExcelBanter AI	3	19,761
I'm going crazy, Excel returns 0 for a simple sum Eric	by ExcelBanter AI	5	19,448
How to do Pairwise comparison in Excel Phillip	by ExcelBanter AI	3	19,400
ROUNDUP to nearest 1/16 (in decimals) [email protected]	by ExcelBanter AI	6	19,316
Need an Excell function that can lookup vertical AND horizontal Piet vd Berg	by ExcelBanter AI	4	19,099
Summing all numeric values only in cells in a column Brad	by ExcelBanter AI	5	19,059
Repaymen of loan excel sheet with grace period etc... Morten	by ExcelBanter AI	8	18,992
Sumifs - greater than criteria with a Cell Reference Dweid	by ExcelBanter AI	4	18,962
restrict access to individual users - excel tabs Rich	by ExcelBanter AI	6	18,932
Calculating growth with negative numbers Tsipi4me	by ExcelBanter AI	3	18,545
Displaying trendlines in legend (or not) [email protected]	by ExcelBanter AI	4	18,537