Excel Worksheet Functions - Page 657

Thread / Thread Starter	Last Post	Replies	Views
file.xls is locked for editing by "user" Mack Neff[_3_]	by Mack Neff[_3_]	2	2,922
password protecting a column for data entry in a sheet, how? kashi	by JLatham	1	738
Automating a line item for several worksheets? tpmax	by Vasant Nanavati	1	433
how to change number to text with specific format in function ViestaWu	by Teethless mama	4	706
VBE Expert Help, Code linked to Cells JVANWORTH	by JVANWORTH	12	817
Looking for a function ××œ×™	by ××œ×™	6	432
Complex timesheets Jesse James	by Niek Otten	1	574
Formula - IF...then? Catherine	by paul[_2_]	2	379
Find & Replace (DOH of the week) gb_S49	by Dave Peterson	3	404
How to combine a symbol and a formula Heine	by Heine	2	1,039
2 woorksheets 1 workbook, help with lookup David D	by Sandy Mann	3	367
Find and Add a number in a text field dereksmom	by Bob Umlas	1	623
Index or Match or what? klafert	by Bernard Liengme	1	323
Conditional formatting of a text box ? Steve	by Steve	7	1,040
alternating colors bobblehead86	by Bernard Liengme	1	440
HOW TO USE BAHTTEXT FUNCTION? phani	by Peo Sjoblom	1	732
Limitations to 2 variable data tables? DInwood	by Max	2	1,795
Auto Sum not working Robojohn	by Rick Rothstein \(MVP - VB\)	8	1,767
Multiple passwords Silver	by Silver	2	490
What Excel formula caluclates number of months between two dates? kk	by Rick Rothstein \(MVP - VB\)	4	1,130
Excel- option button Excel Master Wannabe	by T. Valko	7	820
vlookup for the second value of a list alext49	by T. Valko	9	1,600
COUNTIF cell reference won't work Kenny Newbry	by bj	4	2,496
Date of last refresh? Robin G	by ShaneDevenshire	1	2,548
Grouping Date Data in a Pivot Table Raymond[_2_]	by Jim Thomlinson	1	507
Automatic sorting [email protected]	by [email protected]	0	662
Count on Multiple Criteria over whole column George	by George	7	511
Insert text in a formula petbi	by Elkar	2	582
Average across cells with formulas Arlene	by Arlene	3	412
Automatically go to a certain cell nabanco	by nabanco	3	1,053
Can the worksheets in a work book be sorted ascending? Jo123	by Vasant Nanavati	3	603
Function to Identify the Modification of a Worksheet Penny	by Vasant Nanavati	1	492
Checking and IF ? mohamadhafiz	by Teethless mama	5	618
would like to substitute and return value of 0 for vlookup #N/A er egols	by egols	3	403
Two conditions in a SUMIF function Tim	by Sandy Mann	3	364
Custom Section Numbering MAnderson	by Max	6	5,292
formula help - maybe vlookup, not sure Ann	by Max	7	385
summation ExcelQuestion	by Ragdyer	11	942
Check Box & Counter RANI	by RANI	0	412
Mouse click automatically enters character into cell. Jeffrey M. Coffin	by EP	10	1,632
Dragging a formula containing external links Keith W.	by Dave Peterson	8	501
If statement to replace #VALUE! code jeannie v	by Peo Sjoblom	8	883
Counting instances of text??? tpmax	by Ragdyer	7	593
Error message - PivotTable will not fit on sheet. Show as much as Donna W	by ilia	2	3,417
How to change amount in figure to amount in words? Lotis	by Rick Rothstein \(MVP - VB\)	3	1,667
How to find the first non-blank number in a row? RLind	by Teethless mama	7	1,458
Trying to merge from excel to word. New names won't merge ruth tozer	by ruth tozer	0	669
Combo box displays positions not date Richhall	by Richhall	2	533
Run Time Error 1004 jeannie v	by Roger Govier	3	395
How to count the occurences in my range with 2 characters only? Jen[_4_]	by Pete_UK	5	534
OLAP and number formatting Hood	by Hood	0	437
muliple sheet range + sumif / sumproduct andy	by andy	3	419
Compare 2 data set TouchTone	by David Biddulph[_2_]	3	515
Calculating Conditional Standard Deviation? Harimau	by Jerry W. Lewis	5	3,196
Name Embedded Chart Jen[_4_]	by Jen[_4_]	1	719
Find where else in a spreadsheet a cell is referenced with formula Analyser	by Niek Otten	1	415
Getting a cell reference when a value is less than 0 in Excel Works Bob	by Bob	0	362
Date and Time Formatting Daren	by Daren	2	355
Web Site Lookup No Name	by Bernie Deitrick	4	436
Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet Doctorjones_md	by FSt1	3	1,106
IF - AND Function Michael	by Peo Sjoblom	3	442
Inserting Additional Text in Spreadsheet SEBA Branch Inventory	by ryguy7272	3	624
Getting a cell reference when a value is less than 0 Bob	by T. Valko	5	374
Batch Printing - filtered by Picklist naz	by Pete_UK	1	699
Advanced filter I think DP7	by Debra Dalgleish	4	351
Help with COMPARE??? IF??? VLOOKUP??? Don't know which to use jessshouse	by Pete_UK	3	349
How to return multiple cells from a data sheet in a seperate workbook [email protected]	by [email protected]	19	1,328
How can I open an Excel Doc from the AutoSave option? Time2have	by Gord Dibben	1	602
how to display mainframe negative numbers on excel Mario	by Pete_UK	8	1,130
mirroring worksheets Natalie	by Max	4	508
Excel 2003 Time Calculation WR Cheng	by Pete_UK	1	615
Sorting into Groups equal size tay4432	by tay4432	2	1,279
Getting text data from a pivot table David Morris Evans	by David Morris Evans	0	540
Macro for Conditionally Formatting Comments Daren	by Daren	2	351
Conditional Formatting for Comments Daren	by Norm (I know nothing)	1	402