Excel Worksheet Functions - Page 47

Thread / Thread Starter	Last Post	Replies	Views
count colored cells? DKY	by [email protected]	21	2,574
Find last cell in column then SUM in cell directly below Giggly4g	by Mike	11	2,573
return the Cell address of a value Jack_442	by T. Valko	3	2,573
Return last and second last "populated" cell in column Grant Tucker	by Steve Nickerson	4	2,573
index to a range of cells Frank Kabel	by Frank Kabel	0	2,572
Pivot tables - how do I change default from "count of" to "sum of" Cathy H	by Cathy H	2	2,572
Excel-Match 1st text character in a string to a known character? bushlite	by Ron Coderre	2	2,572
tertiles Sriram	by [email protected]	2	2,572
How can i test a cell for bold style in a cell (Excel 2003)? Mike A.	by David McRitchie	2	2,570
How do I enter the PV function to determine the ending balance of Rettarie	by bpeltzer	2	2,570
How do I delete the +four didgets from a Zip Code Column? RI Foodie	by T. Valko	4	2,570
hyperlink not working in excel 2007, if worksheet is hide or hidden skyexcel	by skyexcel	3	2,569
Copy formula into multiple cells without changing range frankjh19701	by frankjh19701	4	2,569
Using AutoFilter to Sort Data Pulled in by INDEX / MATCH A Romeo Jr	by Max	7	2,568
How to return multiple instances using VLOOKUP Jaybisco	by Alan Beban	3	2,568
Shortcut to change change cell reference to Absolute reference? richk	by Rick Rothstein	12	2,567
Age band formula SCOOBYDOO	by SCOOBYDOO	11	2,567
XIRR non adjacent cells PJM	by JoeU2004	2	2,566
Sumproduct to ignore text and "" Ricky Pang	by Ricky Pang	6	2,565
How do I enclose all data values in a column in double quotes? ms.kitty	by tim m	2	2,564
How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy Amy Ann	by CLR	3	2,564
SUMIFS, one criteria range, multiple criteria GavinS	by joeu2004[_2_]	2	2,564
VBA range selection question Pete[_7_]	by joeu2004	24	2,563
How do I override fixed decimal place settings in EXcel 2003? jroyv	by Bzltyr	2	2,562
Sum Begin/End selectivity Dkline	by Dkline	4	2,562
COUNT BLANK AND ZERO AS THE SAME THING jjlang	by Ron Rosenfeld	6	2,562
Find cell address of last cell in a column with text mike in texas	by Ashish Mathur[_2_]	8	2,562
MODE fx in array using multiple criteria Jon Young	by Rick Rothstein \(MVP - VB\)[_107_]	4	2,561
Filter by multiple colors Michelle	by Michelle	0	2,561
Average without Hidden Cells Goody	by Luke M[_4_]	4	2,561
keeping a running total in a single cell shrtdawg73	by Gord Dibben	10	2,560
Running Macros in protected workbook petunia	by Paul B	3	2,560
Copy only visible cells after filter is applied/ sum after filter MAM	by MAM	0	2,560
Concatenating a range of cells from another sheet, possible? [email protected]	by [email protected]	7	2,560
HLOOKUP with multiple conditions Fin Analyst	by Fin Analyst	2	2,559
Calculating business days minus holidays RJ Swain	by Peo Sjoblom	4	2,559
How do I enter a Formula for entire column? Gary	by JLatham	4	2,558
What does Excel's RAND function really do Brakeshoe	by Jerry W. Lewis	4	2,558
Excel spin box - no Control tab in Format Control dialong box tocoau	by Gord Dibben	7	2,558
make hidden window or workbook visible without specify the name mango	by Dave Peterson	1	2,558
Excel "mode" function returns different results based on sort orde Mark Neuffer	by Harlan Grove	7	2,558
Missing values from a pivot table field Kelli[_2_]	by Jim Thomlinson	1	2,557
Rounding to Nearest 250 Scott G	by Scott G	6	2,557
CountIf or leave blank bcags7	by Jacob Skaria	3	2,557
Trying to plot two lines onto a single graph in excel [email protected]	by [email protected]	3	2,557
Handling Dashes in IF statement Ant	by Ant	4	2,557
Using DGET to extract multiple records Bob	by Harlan Grove	9	2,556
Incorrect result using NPER worksheet function KG Old Wolf	by rkaye	7	2,556
How to use VBA variable in COUNTIF function? terry	by Tushar Mehta	10	2,556
Twin cells Amnon Wilensky	by Shane Devenshire	5	2,556
Calculating days between current date and a date in future NETWORKDAYS() function Faheem Khan	by Ron Rosenfeld	2	2,556
How do I perform multiple regression in Excel using two independe Freda	by Freda	2	2,555
what function do I use for excel to choose the 2nd highest number ematboy	by Roger Govier	2	2,554
LINEST and Dynamic Regression Winslow	by Winslow	0	2,553
Insert rows based on specific value bob	by Shoney	6	2,553
How do I link multiple cells from another workbook? Deb T	by ShaneDevenshire	2	2,553
Make Change Case in Excel a format rather than formula Kevin	by Gary Brown	1	2,553
COUNT A CORRESPONDING CELL IF A CONDITION IS MET Sandizet	by bosco_yip[_2_]	4	2,552
How do I use an If= statement with an apostrophe (IF(s4="jack's",. Denver Tiffany	by Teethless mama	5	2,552
plus and minus sign in cells ivoryhunter	by ivoryhunter	3	2,552
Stock control formula Rocket	by Rocket	0	2,552
How to exclude dates which equal SUNDAY from a fill series? Amber	by John C[_2_]	8	2,551
How can I use DGET in Excel with criteria that changes each line? Werf Nort	by Werf Nort	4	2,551
Use a multiplier to change List Prices to Net prices Dangada	by Anne Troy	1	2,551
training tracker medicdice	by Herbert Seidenberg	3	2,550
coverting answer from Radian mode to degree mode Xmastrzman	by JE McGimpsey	1	2,550
Combobox to fit the size of a cell Lotus123	by Lotus123	0	2,550
Permanently Group Worksheets Krysta Davis	by GS[_6_]	1	2,549
Exceptions to Validation Rules Jim Johnson	by Max	5	2,549
How to calculate CAGR for mutual fund performance using XIRR Dick in SL	by Dick in SL	6	2,549
Sorting Options are not available in Excel... codwilco	by codwilco	2	2,549
Pivot Table data source "data source contains no visible tables" Jane	by Jane	0	2,548
Can excel read numbers in the Sexagesimal system (DMS)? George	by Ron Rosenfeld	1	2,548
Date of last refresh? Robin G	by ShaneDevenshire	1	2,548
Protect Sheet but allow sorting LucyK	by George M	4	2,547