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	419
programming date functions Gail	by Ron Coderre	2	666
how can I count blank cells as a zero, when using formula please?? Ted	by Ian	5	1,046
Display text depending on values of 3 different cells? henrat	by henrat	6	1,157
How do I compare the difference in two spreadsheets? Daysi	by Richard Buttrey	1	900
Cross-referenced drop-down menu (nested drop-downs?) creativeops	by creativeops	4	4,568
VLOOKUP used only when IF condition is met Bradley	by Richard Buttrey	3	1,314
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman	by cs02000	1	4,068
0 in linked cells when watched steve	by Roger Govier	1	598
formulahelp aem	by Roger Govier	2	413
Find a negative number in a range Scott at Culvers	by Roger Govier	1	1,786
how can I calculate VAT for selective data in the same column of a Pathma	by Roger Govier	2	637
remove all "," gregory	by John Michl	1	517
Rolling 3 mth Average dallin	by Roger Govier	1	757
Functions dale1948	by dale1948	2	401
collect data's from different excel files Alex	by Alex	2	866
Searching for multiple results in one cell VLB	by Domenic	1	644
#N/A is not text, cannot use it in functions R-P	by R-P	3	718
Insert-Subtotals makes Column Outlines disappear gpie	by gpie	1	565
halving contents of a cell Louise	by Louise	4	687
count and arrange cell numeric values amrezzat	by DOR	5	476
IF statement joemoran7	by MDBCT	1	428
hyperlinks in drop down menu MikeyB	by MikeyB	0	723
hyperlinks in drop down menu MikeyB	by MikeyB	0	627
Problem with #VALUE/0! error Ted	by Ted	2	565
OT? Microsoft Works Database Import? Lee Harris	by Lee Harris	2	546
ROUND CENTS TO EITHER 49 OR 99 AMOUNTS PRICEMGR	by Bernie Deitrick	5	2,489
Can somebody help me with this formula Inga	by Sloth	3	425
How do I filter out duplicate values in Excel 2000? missy2992	by missy2992	4	572
get a total based on criteria in two columns rar	by Bob Phillips	2	881
Function has worked for 5 years is now in error umloew43	by umloew43	2	463
Using hide in excel get "cannot shift objects off sheet" snowbounduk	by Gary L Brown	1	1,040
IF function Sailor	by Sailor	8	487
Macro to delete rows with same data Connie Martin	by Bernie Deitrick	12	2,319
Dynamic Ranges using INDIRECT JAP	by JAP	0	617
XML function Louise	by Louise	0	429
Vertical Lookup problem William	by James	3	560
Sumproduct masterkeys	by masterkeys	2	472
formula ignores last infor - please help sonar	by Max	8	756
formula question	by Max	1	676
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,077
lookup to return larger value Christobee	by Christobee	4	723
Adding text Jay Taylor	by Jay Taylor	0	575
This should be easy Kypreo	by Rowan Drummond	5	707
roy.okinawa roy.okinawa	by roy.okinawa	0	596
shift right 5 columns raymond chiu	by Gord Dibben	1	641
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	561
Jumping colums in Excel 2000 Lolly	by Ed Ferrero	5	564
OPPOSITE FORMULA roy.okinawa	by roy.okinawa	6	872
Breaking up a string into separate columns Loz	by Ron Rosenfeld	5	1,775
Index Match function for multiple linked variables Bob	by Bob	0	1,063
copying and pasting a formula William	by Gord Dibben	2	672
delete series of letter in spreadsheet kendraa	by Gord Dibben	6	846
Data Validation KenNZ	by Gord Dibben	3	774
Should I use STDEVP Grd	by Grd	2	3,455
Sumproduct carl	by Domenic	5	696
Make stair columns Chunrima	by Dave Peterson	3	594
HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS? daveylee	by daveylee	2	769
Help with #VALUE! error please... Ted	by Ron Rosenfeld	9	586
help me on rearrange cells based on its numerical values without repeating any number amrezzat	by amrezzat	0	817
Very weird error Stian	by Gord Dibben	4	573
Trim Function Matt M HMS	by Bob Phillips	5	825
can I reference a sheet name in a cell as text? Karl Barthel	by GerryK	1	868
How can I get excel to ignore formula in dependant cells... Ted	by Roger Govier	4	6,464
Global Print Specs Steve Williams	by Steve Williams	0	603
Sumproduct formulas & slow response Darby	by Bernie Deitrick	1	1,061
Frustrated Cook Wazza McG	by Wazza McG	11	1,517
Formula help Daniel Bonallack	by Daniel Bonallack	6	397
Count If Array Formula carl	by GerryK	2	604
Print titles: can noncontiguous columns at left be printed & how? HatMar	by Gord Dibben	2	1,559
Change Excel default Workbook Template? Matt D Francis	by Gord Dibben	2	1,030