Excel Worksheet Functions - Page 191

Thread / Thread Starter	Last Post	Replies	Views
IF Statement return wrong comparison Don B[_2_]	by Howard Silcock	1	1,162
Copy GetPivotData Function Elaine	by Elaine	2	1,161
Missing Grand Total for a Calculated Field in a Pivot Table Robert Hamilton	by Robert Hamilton	0	1,161
Automatically copy data from one worksheet to another karstens	by Max	2	1,161
#ref error with Sumproduct [email protected]	by [email protected]	5	1,161
Excel spread sheet will not print with grid lines. AustinR4	by Gord Dibben	2	1,161
How to consolidate data from multiple worksheets. SAR	by SAR	0	1,161
rounding figures to nearest thousand NathanG	by NathanG	3	1,161
How do I call number values form one workbook to another workbook Teryn	by Max	3	1,161
Sort sheet based on particuilar sort order Also	by Also	4	1,161
Using SUMIF function and conditional formatting BSM	by Bob Phillips	2	1,161
macro used to change colors Brian in FT W.	by JE McGimpsey	12	1,161
Multiplying then adding Two Rows of Numbers BRob	by Teethless mama	3	1,161
formula in cell not showing result Leolin	by Bob Phillips	8	1,161
Countdown Birthday Flag Options: Help Needed! Danny Boy	by Rick Rothstein	8	1,161
Need to convert Minutes:Seconds format to minutes with seconds con Cliff	by David Biddulph[_2_]	3	1,161
remove duplicate rows from specific data in a column; excel 2007 DS	by Mike H	1	1,161
Vlookup based on Drop down fails Phil Smith	by T. Valko	9	1,161
paste values Excel 2007 Diamond	by Matt Geare[_2_]	2	1,161
workday, networkday or something else? AJ	by Bernd P	5	1,161
Conditional format will not work without $ (removed to allow copyi CW	by CW	2	1,161
Help!: lead sheet data needs to fill appropriate subject sheets carebear	by carebear	0	1,161
sumif to add data in multiple sheets Sues	by Max	4	1,161
Not able to calculate. mark_kramarczyk	by rsorelle	1	1,161
Have DGET return Null instead of #Value! matthoffman33	by JLatham	3	1,160
Text Dates/times to d:hh:mm:ss Bigskenney	by Ron Rosenfeld[_2_]	6	1,160
link excel data to word document template Haz	by Haz	0	1,160
Aquiring data from one sheet to another sheet in the same workbook No News	by Max	10	1,160
Help with a Formula jacestamps	by jacestamps	1	1,160
If, Then formula - Multiple levels CPROULXM	by Pete_UK	1	1,160
How to copy cell values from random series pkeyl	by pkeyl	0	1,160
Formula for time cards Susieq	by Gord Dibben	3	1,160
Subtraction Rookie	by [email protected]	14	1,160
A different "Fill Color" problem JKD	by Gord Dibben	1	1,160
Select top 5 in column A, sum values in B Phillycheese5	by Aladin Akyurek	4	1,160
Calculate the CAGR Bruce	by Niek Otten	6	1,160
Tool > Compare and Merge Workbooks... This is not a highlighted . EDSBAT	by George Nicholson	1	1,160
Name Box cell reference HoJo	by Harlan Grove	3	1,160
COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 John Higgins	by Gord Dibben	2	1,160
Vlookup with multiple conditions cambrus	by Peo Sjoblom	1	1,160
How do I filter names using only the first letter? Mr_Sparkly	by Mangus Pyke	7	1,160
Countif with dynamic criteria FinChase	by Don Guillett	5	1,160
how do I add data validation dropdown lists to a Form SteveD.IFlora	by Bob Phillips	3	1,159
Extract Year Only Pam[_3_]	by Chip Pearson	5	1,159
show a customised message when a trying to edit a locked cell Emily Ladywell	by Dave Peterson	1	1,159
When updating a worksheet, how do I create a link updating the sa. Phlashh	by Bob Phillips	9	1,159
Using Advanced Filter: How do you MOVE the selected rows... ravif	by Fred Smith[_4_]	3	1,159
Graphs and sheet referencing? Graham	by Graham	2	1,159
copy subtotal information to new sheet Patience	by Tania	2	1,159
Convert text entered as minutes/seconds to minutes Kathie	by Fred Smith[_4_]	1	1,159
Automate a Solver solution Janet	by Andy Pappas	9	1,159
countif, again Liz G	by Myrna Larson	2	1,159
Weighted ranking of a series -Macca-	by -Macca-	4	1,159
1-2-3 @ function to Excel Assistance CMA	by Pete_UK	8	1,159
Number Lookup in Matrix Rod	by Harlan Grove	12	1,159
Pivot Table: I want default to be sum & not count Scott	by Debra Dalgleish	1	1,159
Can a user select more than one entry in a drop down list? Brendan	by Debra Dalgleish	1	1,159
Pivot table drill down formatting matelot	by Marlyn	1	1,159
Find numeric value at end of string Barb Reinhardt	by Harlan Grove	13	1,159
MS Query DateTime String Dean	by Dean	1	1,159
How do I convert from Euros to USDollars? It's not in EUROCONVERT EurosDollars	by Dave F	1	1,159
How do you make calculations between different tabs? Andrew1029	by Bernard Liengme	2	1,159
Indexing a row ecohen1	by Max	6	1,159
Colorful Dropdown Lists creative schwabbie	by Max	2	1,159
table formula jeel	by jeel	19	1,159
in one sheet add one word after every entry in every cell. how? Sandy	by Gord Dibben	3	1,158
one formula to make a multiplication table work Paige	by Paige	3	1,158
Sum Function sometimes displays incorrect answer John Westgate	by John Westgate	4	1,158
When I open my past invoice it keeps changing date to todays date Stop date changing to todays in Excel	by Richard Buttrey	2	1,158
How to remove all hyperlinks from a worksheet in Excel? Amos	by Nick Hodge	4	1,158
Conditional Formatting a drop down list a02227	by Joerg Mochikun	2	1,158
Drawing toolbar Icon Irv	by Mike Middleton	3	1,158
Select rows of data in a worksheet on one criteria in multiple co MrSkoot99	by bj	5	1,158
Replace single 0 without affecting other cells Cindy E	by Tom Hutchins	1	1,158
sumproduct three conditions Scire	by Scire	3	1,158