Excel Worksheet Functions - Page 931

Thread / Thread Starter	Last Post	Replies	Views
Converting numbers to text Graeme	by Gary''s Student	3	374
create reference formula that looks through all sheets for matchin BMW	by BMW	2	611
search all tabs for tab name specified & lookup reference? BMW	by BMW	5	569
Interpolation Bent Hansen	by Gary''s Student	3	787
How can I correct this Time formula John	by John	11	964
Replace on a password protected sheet Matt	by Matt	0	449
Navagating issue Beantown20	by Beantown20	2	344
Range used in a macro needs to be variable DaveP	by Bob Phillips	3	747
how to change a color of cell 2a to blue if 2b contains a value? Jon	by B. R.Ramachandran	2	647
Excel: custom header - is it possible to paste into header? Maureen D.	by Maureen D.	0	1,054
How can I include bmp file in excel 2000 header? siv	by Dave Peterson	1	538
Sorting imported .txt data in Excel clickmule	by Gary L Brown	3	641
How do you link 2 drop-down menus? jd1655	by John Michl	4	550
how to format Doe,John to Doe, John (space after a comma) asuncionw	by asuncionw	8	1,133
RSQ function gives incorrect result imurch	by Jerry W. Lewis	1	672
Ordering fields formatted YYYY Mth in a Pivot Matt D Francis	by Matt D Francis	2	385
How do you Stop Entering Duplicate Data in a Column? Satraj	by Barb Reinhardt	7	691
Need to Sum Mon-Sat each seven days; Average Sunday Robert Moore	by Robert Moore	7	761
Hide 0% figures in Pivot Table Matt D Francis	by Matt D Francis	4	1,007
Want #VALUE! to show as blank cell JoeyW	by Bob Phillips	2	1,779
Income Tax Payable from table with escalating marginal percentage rates. Bosko	by Roger Govier	5	1,195
Convert weeknr to a date converting 05445 to 2005-10-04	by Roger Govier	6	478
multiple hits in random sequences bill gras	by bill gras	2	503
Count cells with strikethrough font? Mike Echo	by Mike Echo	2	1,636
Referring to Cells in a forumula using a function LRL	by LRL	2	756
simple MAX + comparison formula j0e	by j0e	5	610
Link A Cell In O ne Workbook To A Formula In Another Workbook Minitman	by Minitman	0	802
Counting the number of times a specific character appears in a cell PCLIVE	by Ashish Mathur	3	837
Is there a pull down Box to alert for minus balance such as ($5.00 wildman	by Barb Reinhardt	1	446
could someone help! maxime	by Barb Reinhardt	1	386
Mathematical explanations/equations for Excel functions in "Help" mta7000	by mta7000	0	831
How to add an ActiveX control in Excel? Dicaprio	by Dicaprio	0	706
PLEASE HELP maxime	by RagDyer	2	304
excel spreadsheet into address labels maxime	by Mladen_Dj	4	669
how can I get the name of the active worksheet? Mark Dvorkin	by Mark Dvorkin	3	603
=if(and(.... Lift Off	by Lift Off	2	382
drop down box Dreamstar_1961	by Dreamstar_1961	0	328
Comparing and Merging data Scott	by bpeltzer	1	481
Add a unique formula trainer07	by Mladen_Dj	1	348
significant digits for decimals Raj	by Jerry W. Lewis	7	780
Dates in Excel T	by RagDyer	3	422
Can I set up a sort by clicking on table a heading Aaron	by Dave Peterson	5	548
Printing in Excel2000? PaulM	by Dave Peterson	2	453
Translating an IF formula from Lotus 1-2-3 to Excel fsufan13	by Ron Rosenfeld	6	1,297
IF formula works one way and not the other Joe Gieder	by Biff	1	701
Combining sheets on one em8195	by damorrison	5	451
create a list of single values from multiple values Jordan	by Ron de Bruin	3	1,003
Convert mins:secs to seconds only ronedwards	by ronedwards	3	958
How do I display colour on my EXCEL spreadsheet? WokinghamXloutXXXX	by WokinghamXloutXXXX	0	468
Mortgage Calculation Question/s Tywardreath	by Tywardreath	6	411
Help with IF Statement Cheryl B.	by Cheryl B.	3	389
How can I using Excel custom document properties in the header? ecalvo	by Duke Carey	4	2,953
external import of multiple worksheet data & create pivot table prospects	by prospects	0	788
Is there any "autonumber" in Excel? Tech	by Conrad Carlberg	1	849
hide sheets use data j2thea	by gotigs88	3	491
"IF" function - 7 nested limit Ed	by Harlan Grove	7	673
In the worksheet_change event, how do I determine what occured? Tim Patton	by Tim Patton	6	828
Update one spreadsheet and reflect on another Acctgbean	by Acctgbean	0	592
How copy Excel macros from Excel XP (or before) to Excel 2003? ixoye	by Gary L Brown	3	1,013
Has anyone successfully used NETWORKDAYS with arrays? Seymour	by Seymour	0	338
VBA Code To have a macro repeat on all sheets in a workbook carl	by Gary L Brown	3	1,338
Extract Fractional Numbers as Numbers NOT Date MrBill	by Ron Rosenfeld	11	1,060
matching the column b(sku)c(count)with A sammc2	by sammc2	0	654
checkbox? rwijnia	by rwijnia	4	509
formula that calc the diff in time, with a less than function? Debbs	by Gary L Brown	1	345
Why doesn't my resized worksheet have a minimize or close box in . Wade www	by Debra Dalgleish	3	1,058
Moving a sheet from one work book to another? WTG	by Gary L Brown	1	1,068
how do I include advance payments in the PMT function Razzle Dazzle	by Gary L Brown	1	490
How do I write a formula in Excel L@FUTUREALL	by Ron Rosenfeld	11	1,480
Vlookup based on designated occurrence of value bill9340	by Harlan Grove	4	705
Extrapolate numeric values from text string Henrik	by Harlan Grove	4	1,189
Eliminating blank cells in a list on a ROW grime	by Domenic	5	681
Countif using Wildcard * and number 1 southdaytona	by Harlan Grove	4	2,401
Locking linked cells satkinson	by satkinson	0	593
How do I fill the upper or lower half of a cell with color? dtmd	by John	1	1,161