Excel Worksheet Functions - Page 917

Thread / Thread Starter	Last Post	Replies	Views
Clearing #N/A's in one go? Lee Harris	by Gord Dibben	5	502
getting the last cell value in a column amrezzat	by Ron Coderre	1	410
programming date functions Gail	by Ron Coderre	2	640
how can I count blank cells as a zero, when using formula please?? Ted	by Ian	5	1,020
Display text depending on values of 3 different cells? henrat	by henrat	6	1,129
How do I compare the difference in two spreadsheets? Daysi	by Richard Buttrey	1	883
Cross-referenced drop-down menu (nested drop-downs?) creativeops	by creativeops	4	4,509
VLOOKUP used only when IF condition is met Bradley	by Richard Buttrey	3	1,298
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman	by cs02000	1	4,006
0 in linked cells when watched steve	by Roger Govier	1	564
formulahelp aem	by Roger Govier	2	399
Find a negative number in a range Scott at Culvers	by Roger Govier	1	1,755
how can I calculate VAT for selective data in the same column of a Pathma	by Roger Govier	2	607
remove all "," gregory	by John Michl	1	499
Rolling 3 mth Average dallin	by Roger Govier	1	736
Functions dale1948	by dale1948	2	393
collect data's from different excel files Alex	by Alex	2	854
Searching for multiple results in one cell VLB	by Domenic	1	623
#N/A is not text, cannot use it in functions R-P	by R-P	3	702
Insert-Subtotals makes Column Outlines disappear gpie	by gpie	1	543
halving contents of a cell Louise	by Louise	4	678
count and arrange cell numeric values amrezzat	by DOR	5	465
IF statement joemoran7	by MDBCT	1	418
hyperlinks in drop down menu MikeyB	by MikeyB	0	706
hyperlinks in drop down menu MikeyB	by MikeyB	0	604
Problem with #VALUE/0! error Ted	by Ted	2	553
OT? Microsoft Works Database Import? Lee Harris	by Lee Harris	2	521
ROUND CENTS TO EITHER 49 OR 99 AMOUNTS PRICEMGR	by Bernie Deitrick	5	2,359
Can somebody help me with this formula Inga	by Sloth	3	408
How do I filter out duplicate values in Excel 2000? missy2992	by missy2992	4	553
get a total based on criteria in two columns rar	by Bob Phillips	2	860
Function has worked for 5 years is now in error umloew43	by umloew43	2	445
Using hide in excel get "cannot shift objects off sheet" snowbounduk	by Gary L Brown	1	1,004
IF function Sailor	by Sailor	8	479
Macro to delete rows with same data Connie Martin	by Bernie Deitrick	12	2,256
Dynamic Ranges using INDIRECT JAP	by JAP	0	591
XML function Louise	by Louise	0	413
Vertical Lookup problem William	by James	3	544
Sumproduct masterkeys	by masterkeys	2	457
formula ignores last infor - please help sonar	by Max	8	732
formula question	by Max	1	621
XIRR with non contigous cells topola	by topola	2	777
Lookup type formula Lee Harris	by Max	1	635
lookup to return larger value Christobee	by Christobee	2	1,057
lookup to return larger value Christobee	by Christobee	4	660
Adding text Jay Taylor	by Jay Taylor	0	570
This should be easy Kypreo	by Rowan Drummond	5	686
roy.okinawa roy.okinawa	by roy.okinawa	0	588
shift right 5 columns raymond chiu	by Gord Dibben	1	632
sumProduct (gimme a 1 if this is true, gimme the value) what is th Scott	by Max	8	731
is there a standard formula for this? keith	by Biff	1	544
Jumping colums in Excel 2000 Lolly	by Ed Ferrero	5	547
OPPOSITE FORMULA roy.okinawa	by roy.okinawa	6	857
Breaking up a string into separate columns Loz	by Ron Rosenfeld	5	1,747
Index Match function for multiple linked variables Bob	by Bob	0	1,026
copying and pasting a formula William	by Gord Dibben	2	634
delete series of letter in spreadsheet kendraa	by Gord Dibben	6	825
Data Validation KenNZ	by Gord Dibben	3	766
Should I use STDEVP Grd	by Grd	2	3,437
Sumproduct carl	by Domenic	5	671
Make stair columns Chunrima	by Dave Peterson	3	577
HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS? daveylee	by daveylee	2	757
Help with #VALUE! error please... Ted	by Ron Rosenfeld	9	574
help me on rearrange cells based on its numerical values without repeating any number amrezzat	by amrezzat	0	795
Very weird error Stian	by Gord Dibben	4	546
Trim Function Matt M HMS	by Bob Phillips	5	803
can I reference a sheet name in a cell as text? Karl Barthel	by GerryK	1	851
How can I get excel to ignore formula in dependant cells... Ted	by Roger Govier	4	6,401
Global Print Specs Steve Williams	by Steve Williams	0	583
Sumproduct formulas & slow response Darby	by Bernie Deitrick	1	1,026
Frustrated Cook Wazza McG	by Wazza McG	11	1,474
Formula help Daniel Bonallack	by Daniel Bonallack	6	389
Count If Array Formula carl	by GerryK	2	568
Print titles: can noncontiguous columns at left be printed & how? HatMar	by Gord Dibben	2	1,506
Change Excel default Workbook Template? Matt D Francis	by Gord Dibben	2	984