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	521
getting the last cell value in a column amrezzat	by Ron Coderre	1	430
programming date functions Gail	by Ron Coderre	2	679
how can I count blank cells as a zero, when using formula please?? Ted	by Ian	5	1,055
Display text depending on values of 3 different cells? henrat	by henrat	6	1,171
How do I compare the difference in two spreadsheets? Daysi	by Richard Buttrey	1	907
Cross-referenced drop-down menu (nested drop-downs?) creativeops	by creativeops	4	4,579
VLOOKUP used only when IF condition is met Bradley	by Richard Buttrey	3	1,316
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman	by cs02000	1	4,077
0 in linked cells when watched steve	by Roger Govier	1	607
formulahelp aem	by Roger Govier	2	417
Find a negative number in a range Scott at Culvers	by Roger Govier	1	1,802
how can I calculate VAT for selective data in the same column of a Pathma	by Roger Govier	2	650
remove all "," gregory	by John Michl	1	522
Rolling 3 mth Average dallin	by Roger Govier	1	770
Functions dale1948	by dale1948	2	416
collect data's from different excel files Alex	by Alex	2	876
Searching for multiple results in one cell VLB	by Domenic	1	648
#N/A is not text, cannot use it in functions R-P	by R-P	3	732
Insert-Subtotals makes Column Outlines disappear gpie	by gpie	1	576
halving contents of a cell Louise	by Louise	4	688
count and arrange cell numeric values amrezzat	by DOR	5	488
IF statement joemoran7	by MDBCT	1	440
hyperlinks in drop down menu MikeyB	by MikeyB	0	734
hyperlinks in drop down menu MikeyB	by MikeyB	0	639
Problem with #VALUE/0! error Ted	by Ted	2	577
OT? Microsoft Works Database Import? Lee Harris	by Lee Harris	2	547
ROUND CENTS TO EITHER 49 OR 99 AMOUNTS PRICEMGR	by Bernie Deitrick	5	2,490
Can somebody help me with this formula Inga	by Sloth	3	428
How do I filter out duplicate values in Excel 2000? missy2992	by missy2992	4	585
get a total based on criteria in two columns rar	by Bob Phillips	2	895
Function has worked for 5 years is now in error umloew43	by umloew43	2	473
Using hide in excel get "cannot shift objects off sheet" snowbounduk	by Gary L Brown	1	1,051
IF function Sailor	by Sailor	8	501
Macro to delete rows with same data Connie Martin	by Bernie Deitrick	12	2,329
Dynamic Ranges using INDIRECT JAP	by JAP	0	617
XML function Louise	by Louise	0	440
Vertical Lookup problem William	by James	3	568
Sumproduct masterkeys	by masterkeys	2	473
formula ignores last infor - please help sonar	by Max	8	761
formula question	by Max	1	679
XIRR with non contigous cells topola	by topola	2	803
Lookup type formula Lee Harris	by Max	1	644
lookup to return larger value Christobee	by Christobee	2	1,085
lookup to return larger value Christobee	by Christobee	4	732
Adding text Jay Taylor	by Jay Taylor	0	586
This should be easy Kypreo	by Rowan Drummond	5	708
roy.okinawa roy.okinawa	by roy.okinawa	0	596
shift right 5 columns raymond chiu	by Gord Dibben	1	652
sumProduct (gimme a 1 if this is true, gimme the value) what is th Scott	by Max	8	740
is there a standard formula for this? keith	by Biff	1	567
Jumping colums in Excel 2000 Lolly	by Ed Ferrero	5	573
OPPOSITE FORMULA roy.okinawa	by roy.okinawa	6	873
Breaking up a string into separate columns Loz	by Ron Rosenfeld	5	1,789
Index Match function for multiple linked variables Bob	by Bob	0	1,070
copying and pasting a formula William	by Gord Dibben	2	672
delete series of letter in spreadsheet kendraa	by Gord Dibben	6	848
Data Validation KenNZ	by Gord Dibben	3	787
Should I use STDEVP Grd	by Grd	2	3,468
Sumproduct carl	by Domenic	5	698
Make stair columns Chunrima	by Dave Peterson	3	596
HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS? daveylee	by daveylee	2	779
Help with #VALUE! error please... Ted	by Ron Rosenfeld	9	596
help me on rearrange cells based on its numerical values without repeating any number amrezzat	by amrezzat	0	826
Very weird error Stian	by Gord Dibben	4	584
Trim Function Matt M HMS	by Bob Phillips	5	837
can I reference a sheet name in a cell as text? Karl Barthel	by GerryK	1	872
How can I get excel to ignore formula in dependant cells... Ted	by Roger Govier	4	6,473
Global Print Specs Steve Williams	by Steve Williams	0	611
Sumproduct formulas & slow response Darby	by Bernie Deitrick	1	1,067
Frustrated Cook Wazza McG	by Wazza McG	11	1,519
Formula help Daniel Bonallack	by Daniel Bonallack	6	400
Count If Array Formula carl	by GerryK	2	618
Print titles: can noncontiguous columns at left be printed & how? HatMar	by Gord Dibben	2	1,562
Change Excel default Workbook Template? Matt D Francis	by Gord Dibben	2	1,045