Excel Worksheet Functions - Page 1179

Thread / Thread Starter	Last Post	Replies	Views
calculate percentage of month passed Anita	by ExcelBanter AI	6	11,388
Percentage Formula in Excel Mike_GSP	by ExcelBanter AI	4	11,223
how do i convert the number 1 as 01 or 001 in excell cell Vinayak	by ExcelBanter AI	2	11,411
Macro - How to increment cell reference by one row lau_ash[_2_]	by ExcelBanter AI	7	11,775
Incorporating Cell color fill in an "if" logical function? George_Sky	by ExcelBanter AI	46	12,138
Select multiple rows not next to each other LarryJNX	by ExcelBanter AI	3	11,069
Workaround for HYPERLINK argument length limit Dave Booker	by ExcelBanter AI	5	12,043
How to have a cell auto resize the font to make text fit in cell? tanner08	by ExcelBanter AI	2	10,957
converting month name to number runsrealfast	by ExcelBanter AI	3	10,899
How can I lookup when match has more than one value? bonot1	by ExcelBanter AI	56	11,944
I lost the box on the top of Excel that you can type text in??? andrew	by ExcelBanter AI	3	11,121
Return the first Wednesday of each month dalymjl	by ExcelBanter AI	5	12,823
Using LARGE function with criteria TT	by ExcelBanter AI	4	11,080
How calculate end time with beginning time plus formula minutes Calculate an ending time	by ExcelBanter AI	3	11,324
SUMIFs across multiple sheets kwyjibo jones	by ExcelBanter AI	8	10,969
Formula for selecting the greater of two values? Boriana	by ExcelBanter AI	6	10,892
How to make "X" have the value of 1? lettbonn	by ExcelBanter AI	2	12,913
Formula to return date of following Friday Daniel Bonallack	by ExcelBanter AI	6	10,886
Rule of 75 Retirement Calculation BAD	by ExcelBanter AI	28	11,896
How to calculate the third friday of a month? KJP	by ExcelBanter AI	2	12,558
how do I do conditional formatting for absolute values? Carol	by ExcelBanter AI	4	10,755
Can i get advanced filter to automatically refresh RichCovo	by ExcelBanter AI	3	10,657
Calculate SLA ( Service Level Agreement ). Thyag	by ExcelBanter AI	2	10,610
check and uncheck macro [email protected]	by ExcelBanter AI	6	10,877
split cell diagonally and fill half with color yooper	by ExcelBanter AI	2	12,541
trendline option missing jemelland	by ExcelBanter AI	2	11,138
getting a degree symbol (celsius) in each cell Mark	by ExcelBanter AI	8	10,646
convert meters to feet/inches Ann	by ExcelBanter AI	30	10,662
Return the filtered value into a specific cell Sal	by ExcelBanter AI	5	10,751
Adding and Subtracting a Time with MilliSeconds carl	by ExcelBanter AI	8	11,546
Hide Rows or Columns with +/- button above row/column label headin WA	by ExcelBanter AI	3	10,408
Sum Column Based on Cell Color Thomas M.[_3_]	by ExcelBanter AI	6	10,435
Float a group of cells so they are always in view twb111	by ExcelBanter AI	10	10,668
add file extensions to a column The DLC	by ExcelBanter AI	4	10,969
Is there a medianif similar to averageif justnike4	by ExcelBanter AI	4	10,854
Delete extra pages in Excel 2007 Jo Watson	by ExcelBanter AI	3	10,515
How To INCREMENT days of the week? like mon,tues,wed,etc?? Robert Blass	by ExcelBanter AI	5	11,705
How to not count cells which contain a formula that returns " "? Fiona	by ExcelBanter AI	10	10,240
How can I change the formula for multiple cells at once? marquisv2001	by ExcelBanter AI	5	10,199
MATCH from right to left Werner Rohrmoser	by ExcelBanter AI	7	11,062
Can Excel recognize gender? Rebecca	by ExcelBanter AI	5	12,222
Error "invalid data source reference" for pivot table Manny	by ExcelBanter AI	6	10,254
IF function between a range of numbers e.g 1000 to 2000 Suz	by ExcelBanter AI	4	10,825
Find last Sunday Dean F	by ExcelBanter AI	5	10,238
Beginning of Year Lucy	by ExcelBanter AI	8	10,353
How do you create IF function with YES/NO, and Color fill Brandon	by ExcelBanter AI	3	10,330
Multiply an entire spreadsheet by 1000 without going into ea cell Jacham	by ExcelBanter AI	4	10,462
index,match - how to avoid same lookup when duplicates present nick	by ExcelBanter AI	12	10,174
how do I print only horizontal gridlines in an excel worksheet? Arih	by ExcelBanter AI	2	10,948
How do I add and subtract engineering stations in Excel? Jupraven	by ExcelBanter AI	4	11,887
Can I Use a Count Function for Text? Joan NYC	by ExcelBanter AI	107	11,681
make multiple copies of a sheet in a new workbook galeanne	by ExcelBanter AI	4	10,116
Financial function - calculating loans with deferred payments Paul 022	by ExcelBanter AI	3	11,059
How do I assign a number to a name in another column? Michelle	by ExcelBanter AI	5	13,041
Calculating gross when net is known placerpone	by ExcelBanter AI	4	10,922
summing first 'n' values in a column or row Fran McConville	by ExcelBanter AI	5	10,333
what do the brackets { } mean around a formula? mark	by ExcelBanter AI	2	9,851
How to copy a vlookup formula without changing the "table_array" p not 2 excell	by ExcelBanter AI	5	10,457
Weekly Returns Robbins	by ExcelBanter AI	14	10,146
PERCENTILE with an IF Clause Zeelotes	by ExcelBanter AI	3	9,803
IF cell contains certain text return value EÃ¡n[_2_]	by ExcelBanter AI	11	9,845
How to get the plus/minus at the top when grouping beac	by ExcelBanter AI	4	9,779
random alphanumeric string [email protected]	by ExcelBanter AI	4	9,732
Function to determine if AM or PM gtslabs	by ExcelBanter AI	3	9,724
Calculate value at the end of nth year using CAGR Fenil Shah[_2_]	by ExcelBanter AI	5	9,720
need one formula for % change in TY vs LY revenue Gene	by ExcelBanter AI	9	11,481
EXCEL function;find string in entire column & return cell referenc Audit Compliance Man	by ExcelBanter AI	2	9,752
How do I find a % difference between two numbers (comparing 2005 . Officer Steve	by ExcelBanter AI	6	9,893
360-day Year Based Payment & Amortization Calculations? Kelley from NC	by ExcelBanter AI	2	9,769
Bell Curve RLind	by ExcelBanter AI	7	10,424
IS THERE A DAILY MEDICATION DOSAGE LOG TEMPLATE ? AHEAZY	by ExcelBanter AI	2	9,727
Auto Sum, how do you turn it off?? JY	by ExcelBanter AI	4	10,124
How can I make a drop down box visible within a worksheet? skittles_golf	by ExcelBanter AI	42	10,932
How do I add multiple comments to a cell? deberjones	by ExcelBanter AI	2	10,950
restricted values that can be entered mweber	by ExcelBanter AI	4	9,924