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,222
how do i convert the number 1 as 01 or 001 in excell cell Vinayak	by ExcelBanter AI	2	11,410
Macro - How to increment cell reference by one row lau_ash[_2_]	by ExcelBanter AI	7	11,774
Incorporating Cell color fill in an "if" logical function? George_Sky	by ExcelBanter AI	46	12,135
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,041
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,931
I lost the box on the top of Excel that you can type text in??? andrew	by ExcelBanter AI	3	11,118
Return the first Wednesday of each month dalymjl	by ExcelBanter AI	5	12,820
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,968
Formula for selecting the greater of two values? Boriana	by ExcelBanter AI	6	10,891
How to make "X" have the value of 1? lettbonn	by ExcelBanter AI	2	12,911
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,894
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,656
Calculate SLA ( Service Level Agreement ). Thyag	by ExcelBanter AI	2	10,610
check and uncheck macro [email protected]	by ExcelBanter AI	6	10,876
split cell diagonally and fill half with color yooper	by ExcelBanter AI	2	12,539
trendline option missing jemelland	by ExcelBanter AI	2	11,137
getting a degree symbol (celsius) in each cell Mark	by ExcelBanter AI	8	10,643
convert meters to feet/inches Ann	by ExcelBanter AI	30	10,661
Return the filtered value into a specific cell Sal	by ExcelBanter AI	5	10,750
Adding and Subtracting a Time with MilliSeconds carl	by ExcelBanter AI	8	11,543
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,431
Float a group of cells so they are always in view twb111	by ExcelBanter AI	10	10,667
add file extensions to a column The DLC	by ExcelBanter AI	4	10,965
Is there a medianif similar to averageif justnike4	by ExcelBanter AI	4	10,853
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,704
How to not count cells which contain a formula that returns " "? Fiona	by ExcelBanter AI	10	10,238
How can I change the formula for multiple cells at once? marquisv2001	by ExcelBanter AI	5	10,198
MATCH from right to left Werner Rohrmoser	by ExcelBanter AI	7	11,062
Can Excel recognize gender? Rebecca	by ExcelBanter AI	5	12,218
Error "invalid data source reference" for pivot table Manny	by ExcelBanter AI	6	10,253
IF function between a range of numbers e.g 1000 to 2000 Suz	by ExcelBanter AI	4	10,824
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,329
Multiply an entire spreadsheet by 1000 without going into ea cell Jacham	by ExcelBanter AI	4	10,461
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,879
Can I Use a Count Function for Text? Joan NYC	by ExcelBanter AI	107	11,678
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,056
How do I assign a number to a name in another column? Michelle	by ExcelBanter AI	5	13,037
Calculating gross when net is known placerpone	by ExcelBanter AI	4	10,920
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,850
How to copy a vlookup formula without changing the "table_array" p not 2 excell	by ExcelBanter AI	5	10,456
Weekly Returns Robbins	by ExcelBanter AI	14	10,145
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,731
Function to determine if AM or PM gtslabs	by ExcelBanter AI	3	9,723
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,478
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,892
360-day Year Based Payment & Amortization Calculations? Kelley from NC	by ExcelBanter AI	2	9,768
Bell Curve RLind	by ExcelBanter AI	7	10,423
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,122
How can I make a drop down box visible within a worksheet? skittles_golf	by ExcelBanter AI	42	10,929
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,922