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	909
When I sort an excel spreadsheet the data disappears. janell	by janell	1	721
Reference workbook name Chris	by PCLIVE	3	518
What function? Dipwind	by Franz Verga	16	827
List of Control functions Louise	by Louise	5	913
in excel 2003 a formula if cells have 0 = n 1-3 =s 4ormore=s Vick	by SteveG	8	409
SumProduct Returns Zero ronnomad	by ronnomad	4	1,127
how can I trap the change event (Tab Press key) of these controls Padam	by Padam	0	607
MMULT Dave F	by Dav	1	564
Drop down bar to hide column according to the content of a cell [email protected]	by Otto Moehrbach	3	582
Average-Range Change Each Month Jani	by Don Guillett	6	636
Excel Throwing Circular Errors When No Errors Exist MDW	by Dave F	1	1,049
sumif with criteria Tiya	by Dav	1	499
Formula to rank cells alphabetically Dave Shaw	by Dave Shaw	2	475
IRR function jiang	by jiang	2	421
importing a particular excel worksheet into another excel file dinouk	by dinouk	0	1,056
Strange Data Look Up Problem redstang423	by redstang423	1	349
Sorting large worksheets Desmonda	by Dave Shaw	2	618
IF statement (non nested) that compares cell value against range r2d3	by swatsp0p	4	1,059
IF function girth69	by jts	7	411
Side by Side Comparison Add-on TomCat	by CLR	5	599
changing x axis of column graphs Blah	by Ken Johnson	1	761
how do I count the number of gray-shaded cells within a range? Y	by Bob Phillips	4	1,733
Hiding/Unhiding Columns Karen McKenzie	by Bob Phillips	3	835
Urgent enquiry jiang	by Bob Phillips	6	531
Links Br0WN0	by Br0WN0	0	340
delete empty rows in workbook TooN	by Ron de Bruin	1	595
MATCH() and duplicate values -- is there a workaround? JimmyQ	by Leo Heuser	1	856
Multiple Lookup and CountIF exxon99	by AndyH	2	484
Advancing formula spankydata	by spankydata	3	424
msg box Mr. G.	by Mr. G.	2	310
Autocopy of data filtered by drop down list Jeff	by Max	3	670
How do I set up an Investments Trading and Cash Template? Bambo Excel	by Bambo Excel	0	467
Page Break Preview Problem Re learning Excel	by Re learning Excel	2	852
Sumif Problem Jay	by Jay	0	506
Finding Missing Data Jordan	by iturnrocks	1	388
number comparion function kysiow	by iturnrocks	2	311
Relative Cell Reference Keith	by RagDyeR	2	529
Importing a file(s) dan	by dan	1	402
HOW DO INSERT AN AUTONUMBER INTO AN INVOICE TEMPLATE IN EXCEL JW69	by Paul B	8	1,603
Edit Links Trouble edwardpestian	by edwardpestian	0	371
Data collation killing me!! rhani111	by rhani111	19	987
Or function with invalid number "zero/zero" Mandy	by Dante Alighieri	2	315
help with array sa02000	by JMB	7	407
Secret Code for Confirmation Dinesh	by Dinesh	3	943
Help! I need multiple formulas for one cell. mbdbiz	by CLR	3	483
Fun With Functions Liv	by Liv	3	1,415
find cell function flyingmeatball	by flyingmeatball	4	471
Multiple criteria Krish	by Bob Phillips	1	351
Function that searches cell for string? IanMcGreene	by KePaHa	7	440
formulas and decimal places Dilys Duplock	by DonCam65	2	1,119
I want to be able to type vertical text on an excel worksheet Darla	by Gord Dibben	4	726
Is there a way MATCH() can cope with duplicate values? JimmyQ	by Harlan Grove	3	1,548
Selecting Multiple Columns in a Named Selection Griffithpt	by Griffithpt	0	699
Matching multiple columns and retrieving a value shzdug	by Biff	1	540
Help with Match() function MandMsRED3	by Sloth	2	247
Lookup Array Calendar Don Quixote	by Don Quixote	4	693
Accessing Attached xls File shannyshanhan	by shannyshanhan	0	708
hiding then printing a row S S	by S S	4	400
Drop Down Box font size m-e Sue	by Ron de Bruin	1	627
Lookup? Annette	by Ron de Bruin	1	318
formula to add cells in multiple shts in the same wkbk busker	by bpeltzer	2	453
Time sheet calculations [email protected]	by [email protected]	0	395
How do I add all "B1" cells on each worksheet? Church Accountant	by bpeltzer	1	391
Offset question Chris	by SteveG	2	456
Add a guidebar in Excel ajagger	by Otto Moehrbach	1	374
Put filename in a cell DanD	by Gord Dibben	2	501
Reverse a spreadsheet reversing columns and rows? Becca	by Gord Dibben	3	968
Can you automatically filter for unique records? hankinator	by Gord Dibben	3	479
how can i set more than three conditional formats to xl worksheet Andy A112	by Gord Dibben	2	663
VLOOKUP from Access Tables Mraggie	by Mraggie	0	684
text and numbers in cell Henk	by Gord Dibben	2	381
hyperlink: back to last worksheet my	by PCLIVE	1	735
Download excel doc from website, can this be done? Billznik	by Gord Dibben	1	669
histogram and macros bjorn	by Gord Dibben	1	682