Excel Worksheet Functions - Page 283

Thread / Thread Starter	Last Post	Replies	Views
formula shows false mike	by John C[_2_]	6	777
Nested IF Function returns #NAME? Error bw	by John C[_2_]	8	1,094
IF Statement for On One Cell Comparing to the Other Cell Daren	by Daren	5	840
adding columns Masterzan	by Bob Phillips[_3_]	2	425
formulate all in one cell carrol	by Dave Curtis	3	516
Getting the Cell ID [email protected]	by [email protected]	2	4,488
copying formulas only AccountingStudent	by ShaneDevenshire	1	437
Prevent unhide sheet acss	by ShaneDevenshire	2	982
If Statement / Array JEFF	by T. Valko	6	578
Vlookup for multiple duplicate numerical values pete8125	by Ashish Mathur[_2_]	4	1,401
mass emailing from excel worksheet tamidee	by debbie	1	491
Finding the most recent date -- Excel 2K tech1NJ	by ShaneDevenshire	1	535
Subtract two dates (decrementing daily) and add text Peter	by ShaneDevenshire	5	430
Countif - Sumproduct dave230	by ShaneDevenshire	3	474
sample vs. population proportion using a z-score in excel Christopher[_3_]	by Christopher[_3_]	4	2,857
How to lock an ActiveX Control box on the spreadsheet? Ange	by ShaneDevenshire	1	1,657
Conditional formula whereby if A1=Intuit, Then B1=PO Box 1 An Excel Populated World	by An Excel Populated World[_2_]	3	545
Delete Rows based on value Sabosis	by Sabosis	4	1,376
Calculate Days Left in Current Year Dave C	by Dave C	3	5,554
HI!Need to make Cell formula change for each Pg Break in a Print T usansay18	by Sheeloo[_3_]	1	414
Summing it up Violet 1	by Violet 1	5	397
Insert String Between Dates in Chart Title RyanH	by Peo Sjoblom[_2_]	5	854
How to use the rownumber of the current cell in a formula Wim Goelen	by Michael	3	1,314
if < on one tab - want total on a summary sheet BT[_2_]	by T. Valko	3	471
Auto Sort by column B Moira	by Michael	1	886
Using Solver in VBA redbird	by Bernard Liengme	1	1,409
Replace Font within Cell Stephanie M[_2_]	by Stephanie M	1	478
Sumproduct not returning data Trish Smith	by Bernard Liengme	4	610
how can i scramble data for a sweepstakes? Ro	by redbird	2	1,130
Vlookup help with multiple results Gerd	by Gerd	2	577
Finding the most recent date - Excel 2K tech1NJ	by tech1NJ	3	660
calculating dates to now() Todd[_3_]	by T. Valko	3	690
HELP GRANDIVA77	by Sheeloo[_3_]	2	394
Display all pivottable filter selections AudKen	by AudKen	0	854
lowest figure greater than 1 Kendo	by Harlan Grove[_2_]	5	824
Watermark angelparadise	by TomPl	2	395
add range in one column, subtract range in another column kasey	by Gary''s Student	1	1,108
How do I tell how many pages I have created in my spreadsheet jsnatas	by John C[_2_]	11	795
Formula Function SM_NCSW	by Ron Rosenfeld	23	1,744
Is anyone else have problems with this web site tonight? ShaneDevenshire	by Susan	3	553
Drop down boxes/tick boxes Jane	by Debra Dalgleish	2	913
math functions Cookie	by Max	1	447
Format Using Reating Symbols Needy Ned	by Spiky	4	471
Month value DaveKid	by ShaneDevenshire	3	416
Setting a cell with a value as a reference for another function Stressless	by ShaneDevenshire	1	643
Excel not converting file Tim	by Spiky	11	993
Format Currency Cell Yossy	by Spiky	6	599
Automatically add lines and keep formulas Matt	by Matt	2	580
Problem with multiple copying of column contents MichaelRobert	by Glenn	2	485
Skip if false? DeFautT	by DeFautT	2	5,306
Can you perform calculations w/ cells that have both numbers and t BWP	by Max	5	534
Function for getting cell ID and the last row with value [email protected]	by Roger Govier[_3_]	2	559
how to move data from single to multible collums in excel Don	by Roger Govier[_3_]	2	493
Excell Sue Parsons	by Roger Govier[_3_]	6	415
Month as a value DaveKid	by Ron Rosenfeld	1	381
How do you connect worksheets,input data in one place&it shows on excel	by Max	2	1,138
Diplaying results of a formula instead of the formula itself DirtyBadger	by Mike H	1	432
VLookUp - Does the VLookUp return the exact information? Cpviv	by Cpviv	2	1,555
How to find out how long it's been since a link updated GuinnessT	by Gary''s Student	1	663
run macro after paste K	by K	3	2,985
logical formula mike	by ShaneDevenshire	2	474
Help Please! CountIf Function using 2 criteria? AlexisLovesLife	by ShaneDevenshire	4	495
automatically insert salary based on job title [email protected]	by ShaneDevenshire	2	784
compare 2 tables of dates to find the preceding dates Babi	by Max	3	1,127
Seperating hyperlink address from viewable text Aominay	by EXCEL HELP	5	596
how do i require text in a cell how to make a cell require text	by Peo Sjoblom	4	454
Bonus/Absence/Timesheet workbook help needed. klg	by Herbert Seidenberg[_3_]	6	559
Add-in analysis gm66	by Gord Dibben	5	517
SumIf - when I fill down the Range, Criteria & sum range changes markholt	by Sheeloo[_3_]	3	1,879
Returning 0 instead of #N/A when no value is found RobertSD	by Dave Peterson	8	1,309
conditional formula DiazFamily	by Sheeloo[_3_]	1	462
How can I bolden H8 in the formula =(I8)&UPPER(H8)&CHAR(10)&B8? tonyanj	by David Biddulph[_2_]	1	411
time difference Linda	by Peo Sjoblom[_2_]	5	438
HyperLinkDumbIam NotGood@All	by Dave Peterson	2	370
Sumif date=date red	by T. Valko	3	414