Excel Worksheet Functions - Page 5

Thread / Thread Starter	Last Post	Replies	Views
how do I print only horizontal gridlines in an excel worksheet? Arih	by ExcelBanter AI	2	10,348
index,match - how to avoid same lookup when duplicates present nick	by ExcelBanter AI	12	10,041
Multiply an entire spreadsheet by 1000 without going into ea cell Jacham	by ExcelBanter AI	4	10,104
How do you create IF function with YES/NO, and Color fill Brandon	by ExcelBanter AI	3	9,944
Beginning of Year Lucy	by ExcelBanter AI	8	9,977
Find last Sunday Dean F	by ExcelBanter AI	5	10,059
IF function between a range of numbers e.g 1000 to 2000 Suz	by ExcelBanter AI	4	10,231
Error "invalid data source reference" for pivot table Manny	by ExcelBanter AI	6	10,032
Can Excel recognize gender? Rebecca	by ExcelBanter AI	5	11,181
MATCH from right to left Werner Rohrmoser	by ExcelBanter AI	7	10,522
How can I change the formula for multiple cells at once? marquisv2001	by ExcelBanter AI	5	10,089
How to not count cells which contain a formula that returns " "? Fiona	by ExcelBanter AI	10	10,144
How To INCREMENT days of the week? like mon,tues,wed,etc?? Robert Blass	by ExcelBanter AI	5	10,753
Delete extra pages in Excel 2007 Jo Watson	by ExcelBanter AI	3	10,232
Is there a medianif similar to averageif justnike4	by ExcelBanter AI	4	10,484
add file extensions to a column The DLC	by ExcelBanter AI	4	10,513
Float a group of cells so they are always in view twb111	by ExcelBanter AI	10	10,502
Sum Column Based on Cell Color Thomas M.[_3_]	by ExcelBanter AI	6	10,279
Hide Rows or Columns with +/- button above row/column label headin WA	by ExcelBanter AI	3	10,281
Adding and Subtracting a Time with MilliSeconds carl	by ExcelBanter AI	8	10,777
Return the filtered value into a specific cell Sal	by ExcelBanter AI	5	10,503
convert meters to feet/inches Ann	by ExcelBanter AI	30	10,445
getting a degree symbol (celsius) in each cell Mark	by ExcelBanter AI	8	10,505
trendline option missing jemelland	by ExcelBanter AI	2	10,624
split cell diagonally and fill half with color yooper	by ExcelBanter AI	2	10,738
check and uncheck macro [email protected]	by ExcelBanter AI	6	10,608
Calculate SLA ( Service Level Agreement ). Thyag	by ExcelBanter AI	2	10,530
Can i get advanced filter to automatically refresh RichCovo	by ExcelBanter AI	3	10,556
how do I do conditional formatting for absolute values? Carol	by ExcelBanter AI	4	10,601
How to calculate the third friday of a month? KJP	by ExcelBanter AI	2	11,453
Rule of 75 Retirement Calculation BAD	by ExcelBanter AI	28	11,060
Formula to return date of following Friday Daniel Bonallack	by ExcelBanter AI	6	10,672
How to make "X" have the value of 1? lettbonn	by ExcelBanter AI	2	11,618
Formula for selecting the greater of two values? Boriana	by ExcelBanter AI	6	10,739
SUMIFs across multiple sheets kwyjibo jones	by ExcelBanter AI	8	10,756
How calculate end time with beginning time plus formula minutes Calculate an ending time	by ExcelBanter AI	3	10,952
Using LARGE function with criteria TT	by ExcelBanter AI	4	10,900
Return the first Wednesday of each month dalymjl	by ExcelBanter AI	5	11,521
I lost the box on the top of Excel that you can type text in??? andrew	by ExcelBanter AI	3	10,855
How can I lookup when match has more than one value? ( 1 2) bonot1	by ExcelBanter AI	56	11,029
converting month name to number runsrealfast	by ExcelBanter AI	3	10,838
How to have a cell auto resize the font to make text fit in cell? tanner08	by ExcelBanter AI	2	10,879
Workaround for HYPERLINK argument length limit Dave Booker	by ExcelBanter AI	5	11,393
Select multiple rows not next to each other LarryJNX	by ExcelBanter AI	3	10,989
Incorporating Cell color fill in an "if" logical function? ( 1 2) George_Sky	by ExcelBanter AI	46	11,228
Macro - How to increment cell reference by one row lau_ash[_2_]	by ExcelBanter AI	7	11,394
how do i convert the number 1 as 01 or 001 in excell cell Vinayak	by ExcelBanter AI	2	11,170
Percentage Formula in Excel Mike_GSP	by ExcelBanter AI	4	11,098
calculate percentage of month passed Anita	by ExcelBanter AI	6	11,232
Excel Pivot Table How to Sort data as Percent of Row Pat	by ExcelBanter AI	10	11,477
Sorting Numbers with letter suffixes Terry Bennett	by ExcelBanter AI	13	11,444
Shortcut key for comma format? Pierre	by ExcelBanter AI	3	11,358
I need a Line of Credit Calculator Titanium	by ExcelBanter AI	6	11,580
Average Symbol Workbook	by ExcelBanter AI	9	13,037
how to insert tally mark in excel shawn	by ExcelBanter AI	8	11,580
Remove Characters Until a Specific Character is Reached Frosty 1234	by ExcelBanter AI	8	11,277
drag a formula downa column keeping one value the same? column formula with a constant value	by ExcelBanter AI	4	11,256
IF Statement with two variables RoadKill	by ExcelBanter AI	9	11,386
Effective Annual Interest Rate John	by ExcelBanter AI	4	11,329
IF statements referencing an absolute value or a range of values skaminski	by ExcelBanter AI	6	11,389
Excel 2003 worksheet tabs missing at bottom of my laptop display Quixote	by ExcelBanter AI	5	11,416
bulk replacement of cell reference within formula Twishlist	by ExcelBanter AI	3	11,773
How do I do sensitivity analysis in excel 2007? Kat	by ExcelBanter AI	3	11,426
looking up a value between two numbers and returning a related value JulieD	by ExcelBanter AI	14	11,422
how do I calculate staffing ratios Xfiles325	by ExcelBanter AI	5	11,705
Referencing a named range on another sheet Jan B	by ExcelBanter AI	5	11,401
How do I add an equals sign to a cell that already has numbers in George	by ExcelBanter AI	9	11,795
'TABLE' array function JB2010	by ExcelBanter AI	5	12,090
Array formulae do not recalculate Thanks	by ExcelBanter AI	3	11,577
Copy Multiple Columns, Paste Under a Single column Sriram	by ExcelBanter AI	12	11,695
Text "comparison" operator for "contains" used in an "IF" Function Pawaso	by ExcelBanter AI	4	11,585
BIN2DEC conversion for large binary numbers ahmedmidany	by ExcelBanter AI	21	11,632
how to insert a special character (arrow) in IF statement HA@Work	by ExcelBanter AI	4	12,204
Return first 2 numbers of a cell Patrick C. Simonds	by ExcelBanter AI	3	11,631
How to use Ara and ARP fucntions on Ms Excel? ANJAN	by ExcelBanter AI	7	11,899