Excel Worksheet Functions - Page 931

Thread / Thread Starter	Last Post	Replies	Views
Converting numbers to text Graeme	by Gary''s Student	3	381
create reference formula that looks through all sheets for matchin BMW	by BMW	2	632
search all tabs for tab name specified & lookup reference? BMW	by BMW	5	584
Interpolation Bent Hansen	by Gary''s Student	3	805
How can I correct this Time formula John	by John	11	997
Replace on a password protected sheet Matt	by Matt	0	464
Navagating issue Beantown20	by Beantown20	2	346
Range used in a macro needs to be variable DaveP	by Bob Phillips	3	759
how to change a color of cell 2a to blue if 2b contains a value? Jon	by B. R.Ramachandran	2	666
Excel: custom header - is it possible to paste into header? Maureen D.	by Maureen D.	0	1,092
How can I include bmp file in excel 2000 header? siv	by Dave Peterson	1	552
Sorting imported .txt data in Excel clickmule	by Gary L Brown	3	659
How do you link 2 drop-down menus? jd1655	by John Michl	4	566
how to format Doe,John to Doe, John (space after a comma) asuncionw	by asuncionw	8	1,188
RSQ function gives incorrect result imurch	by Jerry W. Lewis	1	706
Ordering fields formatted YYYY Mth in a Pivot Matt D Francis	by Matt D Francis	2	414
How do you Stop Entering Duplicate Data in a Column? Satraj	by Barb Reinhardt	7	716
Need to Sum Mon-Sat each seven days; Average Sunday Robert Moore	by Robert Moore	7	781
Hide 0% figures in Pivot Table Matt D Francis	by Matt D Francis	4	1,028
Want #VALUE! to show as blank cell JoeyW	by Bob Phillips	2	1,842
Income Tax Payable from table with escalating marginal percentage rates. Bosko	by Roger Govier	5	1,250
Convert weeknr to a date converting 05445 to 2005-10-04	by Roger Govier	6	486
multiple hits in random sequences bill gras	by bill gras	2	527
Count cells with strikethrough font? Mike Echo	by Mike Echo	2	1,661
Referring to Cells in a forumula using a function LRL	by LRL	2	773
simple MAX + comparison formula j0e	by j0e	5	620
Link A Cell In O ne Workbook To A Formula In Another Workbook Minitman	by Minitman	0	824
Counting the number of times a specific character appears in a cell PCLIVE	by Ashish Mathur	3	874
Is there a pull down Box to alert for minus balance such as ($5.00 wildman	by Barb Reinhardt	1	459
could someone help! maxime	by Barb Reinhardt	1	394
Mathematical explanations/equations for Excel functions in "Help" mta7000	by mta7000	0	867
How to add an ActiveX control in Excel? Dicaprio	by Dicaprio	0	723
PLEASE HELP maxime	by RagDyer	2	318
excel spreadsheet into address labels maxime	by Mladen_Dj	4	726
how can I get the name of the active worksheet? Mark Dvorkin	by Mark Dvorkin	3	623
=if(and(.... Lift Off	by Lift Off	2	389
drop down box Dreamstar_1961	by Dreamstar_1961	0	338
Comparing and Merging data Scott	by bpeltzer	1	501
Add a unique formula trainer07	by Mladen_Dj	1	360
significant digits for decimals Raj	by Jerry W. Lewis	7	804
Dates in Excel T	by RagDyer	3	427
Can I set up a sort by clicking on table a heading Aaron	by Dave Peterson	5	560
Printing in Excel2000? PaulM	by Dave Peterson	2	464
Translating an IF formula from Lotus 1-2-3 to Excel fsufan13	by Ron Rosenfeld	6	1,311
IF formula works one way and not the other Joe Gieder	by Biff	1	716
Combining sheets on one em8195	by damorrison	5	461
create a list of single values from multiple values Jordan	by Ron de Bruin	3	1,053
Convert mins:secs to seconds only ronedwards	by ronedwards	3	980
How do I display colour on my EXCEL spreadsheet? WokinghamXloutXXXX	by WokinghamXloutXXXX	0	492
Mortgage Calculation Question/s Tywardreath	by Tywardreath	6	413
Help with IF Statement Cheryl B.	by Cheryl B.	3	402
How can I using Excel custom document properties in the header? ecalvo	by Duke Carey	4	2,987
external import of multiple worksheet data & create pivot table prospects	by prospects	0	832
Is there any "autonumber" in Excel? Tech	by Conrad Carlberg	1	859
hide sheets use data j2thea	by gotigs88	3	508
"IF" function - 7 nested limit Ed	by Harlan Grove	7	695
In the worksheet_change event, how do I determine what occured? Tim Patton	by Tim Patton	6	845
Update one spreadsheet and reflect on another Acctgbean	by Acctgbean	0	625
How copy Excel macros from Excel XP (or before) to Excel 2003? ixoye	by Gary L Brown	3	1,053
Has anyone successfully used NETWORKDAYS with arrays? Seymour	by Seymour	0	343
VBA Code To have a macro repeat on all sheets in a workbook carl	by Gary L Brown	3	1,369
Extract Fractional Numbers as Numbers NOT Date MrBill	by Ron Rosenfeld	11	1,094
matching the column b(sku)c(count)with A sammc2	by sammc2	0	680
checkbox? rwijnia	by rwijnia	4	535
formula that calc the diff in time, with a less than function? Debbs	by Gary L Brown	1	372
Why doesn't my resized worksheet have a minimize or close box in . Wade www	by Debra Dalgleish	3	1,092
Moving a sheet from one work book to another? WTG	by Gary L Brown	1	1,095
how do I include advance payments in the PMT function Razzle Dazzle	by Gary L Brown	1	507
How do I write a formula in Excel L@FUTUREALL	by Ron Rosenfeld	11	1,503
Vlookup based on designated occurrence of value bill9340	by Harlan Grove	4	726
Extrapolate numeric values from text string Henrik	by Harlan Grove	4	1,328
Eliminating blank cells in a list on a ROW grime	by Domenic	5	703
Countif using Wildcard * and number 1 southdaytona	by Harlan Grove	4	2,422
Locking linked cells satkinson	by satkinson	0	634
How do I fill the upper or lower half of a cell with color? dtmd	by John	1	1,200