Excel Worksheet Functions - Page 712

Thread / Thread Starter	Last Post	Replies	Views
how can I trap the change event (Tab Press key) of these controls Padam	by Bob Phillips	1	851
When I sort an excel spreadsheet the data disappears. janell	by janell	1	712
Reference workbook name Chris	by PCLIVE	3	510
What function? Dipwind	by Franz Verga	16	821
List of Control functions Louise	by Louise	5	893
in excel 2003 a formula if cells have 0 = n 1-3 =s 4ormore=s Vick	by SteveG	8	406
SumProduct Returns Zero ronnomad	by ronnomad	4	1,111
how can I trap the change event (Tab Press key) of these controls Padam	by Padam	0	566
MMULT Dave F	by Dav	1	558
Drop down bar to hide column according to the content of a cell [email protected]	by Otto Moehrbach	3	577
Average-Range Change Each Month Jani	by Don Guillett	6	629
Excel Throwing Circular Errors When No Errors Exist MDW	by Dave F	1	1,017
sumif with criteria Tiya	by Dav	1	494
Formula to rank cells alphabetically Dave Shaw	by Dave Shaw	2	460
IRR function jiang	by jiang	2	419
importing a particular excel worksheet into another excel file dinouk	by dinouk	0	1,024
Strange Data Look Up Problem redstang423	by redstang423	1	339
Sorting large worksheets Desmonda	by Dave Shaw	2	605
IF statement (non nested) that compares cell value against range r2d3	by swatsp0p	4	1,048
IF function girth69	by jts	7	408
Side by Side Comparison Add-on TomCat	by CLR	5	583
changing x axis of column graphs Blah	by Ken Johnson	1	751
how do I count the number of gray-shaded cells within a range? Y	by Bob Phillips	4	1,688
Hiding/Unhiding Columns Karen McKenzie	by Bob Phillips	3	809
Urgent enquiry jiang	by Bob Phillips	6	520
Links Br0WN0	by Br0WN0	0	336
delete empty rows in workbook TooN	by Ron de Bruin	1	584
MATCH() and duplicate values -- is there a workaround? JimmyQ	by Leo Heuser	1	833
Multiple Lookup and CountIF exxon99	by AndyH	2	477
Advancing formula spankydata	by spankydata	3	413
msg box Mr. G.	by Mr. G.	2	303
Autocopy of data filtered by drop down list Jeff	by Max	3	650
How do I set up an Investments Trading and Cash Template? Bambo Excel	by Bambo Excel	0	453
Page Break Preview Problem Re learning Excel	by Re learning Excel	2	842
Sumif Problem Jay	by Jay	0	493
Finding Missing Data Jordan	by iturnrocks	1	379
number comparion function kysiow	by iturnrocks	2	308
Relative Cell Reference Keith	by RagDyeR	2	514
Importing a file(s) dan	by dan	1	383
HOW DO INSERT AN AUTONUMBER INTO AN INVOICE TEMPLATE IN EXCEL JW69	by Paul B	8	1,588
Edit Links Trouble edwardpestian	by edwardpestian	0	365
Data collation killing me!! rhani111	by rhani111	19	979
Or function with invalid number "zero/zero" Mandy	by Dante Alighieri	2	304
help with array sa02000	by JMB	7	395
Secret Code for Confirmation Dinesh	by Dinesh	3	935
Help! I need multiple formulas for one cell. mbdbiz	by CLR	3	470
Fun With Functions Liv	by Liv	3	1,361
find cell function flyingmeatball	by flyingmeatball	4	457
Multiple criteria Krish	by Bob Phillips	1	345
Function that searches cell for string? IanMcGreene	by KePaHa	7	430
formulas and decimal places Dilys Duplock	by DonCam65	2	1,113
I want to be able to type vertical text on an excel worksheet Darla	by Gord Dibben	4	721
Is there a way MATCH() can cope with duplicate values? JimmyQ	by Harlan Grove	3	1,527
Selecting Multiple Columns in a Named Selection Griffithpt	by Griffithpt	0	670
Matching multiple columns and retrieving a value shzdug	by Biff	1	526
Help with Match() function MandMsRED3	by Sloth	2	236
Lookup Array Calendar Don Quixote	by Don Quixote	4	686
Accessing Attached xls File shannyshanhan	by shannyshanhan	0	670
hiding then printing a row S S	by S S	4	386
Drop Down Box font size m-e Sue	by Ron de Bruin	1	614
Lookup? Annette	by Ron de Bruin	1	312
formula to add cells in multiple shts in the same wkbk busker	by bpeltzer	2	431
Time sheet calculations [email protected]	by [email protected]	0	375
How do I add all "B1" cells on each worksheet? Church Accountant	by bpeltzer	1	387
Offset question Chris	by SteveG	2	448
Add a guidebar in Excel ajagger	by Otto Moehrbach	1	368
Put filename in a cell DanD	by Gord Dibben	2	486
Reverse a spreadsheet reversing columns and rows? Becca	by Gord Dibben	3	955
Can you automatically filter for unique records? hankinator	by Gord Dibben	3	455
how can i set more than three conditional formats to xl worksheet Andy A112	by Gord Dibben	2	645
VLOOKUP from Access Tables Mraggie	by Mraggie	0	658
text and numbers in cell Henk	by Gord Dibben	2	373
hyperlink: back to last worksheet my	by PCLIVE	1	709
Download excel doc from website, can this be done? Billznik	by Gord Dibben	1	647
histogram and macros bjorn	by Gord Dibben	1	677