Excel Worksheet Functions - Page 931

Thread / Thread Starter	Last Post	Replies	Views
Converting numbers to text Graeme	by Gary''s Student	3	389
create reference formula that looks through all sheets for matchin BMW	by BMW	2	635
search all tabs for tab name specified & lookup reference? BMW	by BMW	5	587
Interpolation Bent Hansen	by Gary''s Student	3	809
How can I correct this Time formula John	by John	11	1,005
Replace on a password protected sheet Matt	by Matt	0	473
Navagating issue Beantown20	by Beantown20	2	354
Range used in a macro needs to be variable DaveP	by Bob Phillips	3	766
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,098
How can I include bmp file in excel 2000 header? siv	by Dave Peterson	1	562
Sorting imported .txt data in Excel clickmule	by Gary L Brown	3	667
How do you link 2 drop-down menus? jd1655	by John Michl	4	572
how to format Doe,John to Doe, John (space after a comma) asuncionw	by asuncionw	8	1,195
RSQ function gives incorrect result imurch	by Jerry W. Lewis	1	710
Ordering fields formatted YYYY Mth in a Pivot Matt D Francis	by Matt D Francis	2	416
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	784
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	489
multiple hits in random sequences bill gras	by bill gras	2	527
Count cells with strikethrough font? Mike Echo	by Mike Echo	2	1,669
Referring to Cells in a forumula using a function LRL	by LRL	2	778
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	827
Counting the number of times a specific character appears in a cell PCLIVE	by Ashish Mathur	3	877
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	397
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	733
PLEASE HELP maxime	by RagDyer	2	325
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	628
=if(and(.... Lift Off	by Lift Off	2	390
drop down box Dreamstar_1961	by Dreamstar_1961	0	342
Comparing and Merging data Scott	by bpeltzer	1	513
Add a unique formula trainer07	by Mladen_Dj	1	371
significant digits for decimals Raj	by Jerry W. Lewis	7	806
Dates in Excel T	by RagDyer	3	434
Can I set up a sort by clicking on table a heading Aaron	by Dave Peterson	5	561
Printing in Excel2000? PaulM	by Dave Peterson	2	467
Translating an IF formula from Lotus 1-2-3 to Excel fsufan13	by Ron Rosenfeld	6	1,320
IF formula works one way and not the other Joe Gieder	by Biff	1	726
Combining sheets on one em8195	by damorrison	5	471
create a list of single values from multiple values Jordan	by Ron de Bruin	3	1,056
Convert mins:secs to seconds only ronedwards	by ronedwards	3	988
How do I display colour on my EXCEL spreadsheet? WokinghamXloutXXXX	by WokinghamXloutXXXX	0	492
Mortgage Calculation Question/s Tywardreath	by Tywardreath	6	416
Help with IF Statement Cheryl B.	by Cheryl B.	3	409
How can I using Excel custom document properties in the header? ecalvo	by Duke Carey	4	2,996
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	864
hide sheets use data j2thea	by gotigs88	3	514
"IF" function - 7 nested limit Ed	by Harlan Grove	7	697
In the worksheet_change event, how do I determine what occured? Tim Patton	by Tim Patton	6	856
Update one spreadsheet and reflect on another Acctgbean	by Acctgbean	0	630
How copy Excel macros from Excel XP (or before) to Excel 2003? ixoye	by Gary L Brown	3	1,054
Has anyone successfully used NETWORKDAYS with arrays? Seymour	by Seymour	0	353
VBA Code To have a macro repeat on all sheets in a workbook carl	by Gary L Brown	3	1,376
Extract Fractional Numbers as Numbers NOT Date MrBill	by Ron Rosenfeld	11	1,095
matching the column b(sku)c(count)with A sammc2	by sammc2	0	688
checkbox? rwijnia	by rwijnia	4	544
formula that calc the diff in time, with a less than function? Debbs	by Gary L Brown	1	374
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,097
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,506
Vlookup based on designated occurrence of value bill9340	by Harlan Grove	4	731
Extrapolate numeric values from text string Henrik	by Harlan Grove	4	1,331
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,429
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,201