Excel Worksheet Functions - Page 822

Thread / Thread Starter	Last Post	Replies	Views
How do I use DCount to exclude data? Chick N Egg	by Harlan Grove	2	809
Offset function with nested match function not finding host ss. MKunert	by Peo Sjoblom	1	3,242
How do I plot the derivative of a curve in Excel? Rients	by MrShorty	1	4,135
How do I add business days to a date field, no weekends? Ozzy	by Ron Rosenfeld	2	1,737
Change text to military time gobonniego	by gobonniego	2	580
Time difference Stephanie	by Sloth	5	570
How do i make a change in one worksheet affect the others elleblaze	by Otto Moehrbach	1	534
How to pick Home and Away results from a list [email protected]	by Biff	5	577
fixed columns mit76	by Joseph in Atlanta	1	459
AutoFilters Joli	by GaryE	1	467
How do I save an excel file with values instead of formulas? Beginner Excel User	by Peo Sjoblom	1	1,012
changing query source [email protected]	by [email protected]	2	963
IF & VLOOKUP Equaliser	by GaryE	1	388
Saving spreadsheet Beginner Excel User	by Clivey_UK	2	452
returning specific text only Jane	by Don Guillett	10	1,172
copying formulas and not values peets	by Joseph in Atlanta	2	477
How do you move cells with a formula DoriCAFL	by David McRitchie	1	962
How To Retrieve Data from Sheet2 into Sheet1 compconnj	by Clivey_UK	3	676
Excel 2000 Date Question Steven	by daddylonglegs	7	557
3 COLUME CHART BANDIT	by BANDIT	0	576
My worksheet is numbered in both row and column. Is that right? Sheila	by SteveG	1	420
How can I count items in multiple columns with different criteria. ChileRed	by ChileRed	0	693
Activesync and excel functions FangYR	by Chris	2	354
why does Excel see my simple formulae as macros now? Chris	by Chris	4	435
unprotect control button only in spreadsheet pywhacket	by pywhacket	0	451
pivot table problems CatherineC	by CatherineC	0	495
Adding "OR" to a Sumproduct Formula carl	by carl	0	435
Sort (parameter stored in cell) GerryK	by GerryK	0	555
Adding "OR" to a Sumproduct Formula Duke Carey	by Duke Carey	0	818
How do I get one worksheet to update when others change? Bdubs	by Barb Reinhardt	1	497
Display name of imported data file coa01gsb	by Gary L Brown	2	564
My worksheet is numbered in both row and column. Is that right? Sloth	by Sloth	0	375
How to sort text and letter hybrid (eg A1, A2, A10) in order? Amy	by Amy	0	1,150
IF & VLOOKUP CLR	by CLR	0	292
Multiple Criteria for Conditional Formatting Dave Y	by Dave Y	4	865
Find precentage result Pat	by Vito	1	400
Find precentage result Pat	by via135	1	413
Linking Cell to Label Caption papaitaliano	by Dave Peterson	1	444
use "button" to make calculation ignore a cell	by	5	900
List of defined names coa01gsb	by coa01gsb	4	858
Dislpay count of workdays in a month? DB Explorer	by Duke Carey	2	561
Use criteria for values in range for small function like2hike	by Duke Carey	1	985
Can't use tab after protecting sheet. tonyia	by tonyia	0	534
Help with Looking up data in multiple sheets compconnj	by compconnj	0	647
Report Krish	by Krish	0	337
Combining Multiple Columns into One J.J.	by J.J.	3	594
Does anyone use excel for A3 templates? Shannon	by Shannon	0	864
stratified sampling formula Jane	by Jane	0	2,399
How- seperate a combined list by filtering out first list of names Briana	by Vito	1	691
Function to select second-to-last non-empty cell sandr5	by sandr5	0	539
Indirect Function Sandy	by Sandy	2	551
Can I run Excel LookUp on a single cell through multiple sheets Neil	by Pete_UK	2	840
Please help, I've been struggling for weeks! Squeaker1066	by Ron Rosenfeld	11	960
Vlookup gives wrong answers when used in large data. Pls advise? Dave	by Pete_UK	4	1,237
Moving Average projection? Wild Nerd	by Wild Nerd	6	1,084
How do I tie the computer clock with formula execution? lectrous	by CLR	2	502
formulars jnf	by daddylonglegs	3	420
unable to create formula adityadhar1	by adityadhar1	0	551
how to use English excelbook in a computer with excel vers. in spa HRoblesvargas	by Niek Otten	1	384
FUNCTIONS FOR TO TRACE THE SAME VALUE IN OTHER CELL OR SHEET Sachin	by Max	1	427
Extract bold letters in a cell hbamse	by hbamse	1	598
Reference milkman	by Max	17	752
Need a number count of items on list after Filterings Taylor	by Aladin Akyurek	5	472
A book for statistical functions? Vicky	by Mike Middleton	1	396
Cell reference in formula briank	by RagDyer	1	506
Auto Filter Worker Bee	by Dave Peterson	1	479
sumif Phil	by CLR	3	333
copying data from matching cloumn kuansheng	by Biff	8	517
Copy to another sheet and??? outwest via OfficeKB.com	by Beege	3	515
Conditional formatting formula David Rose	by Pete_UK	3	388
1-2-3 @ function to Excel Assistance CMA	by Pete_UK	8	1,185
Formula Question thereclas	by Harlan Grove	4	413
Help with Forumla WeSt39	by WeSt39	2	647
Subtotal function Debby Bunce	by briank	2	593
Need help to find a date (latest date) from a column CraigNowell	by Max	4	1,223