Excel Worksheet Functions - Page 283

Thread / Thread Starter	Last Post	Replies	Views
formula shows false mike	by John C[_2_]	6	774
Nested IF Function returns #NAME? Error bw	by John C[_2_]	8	1,063
IF Statement for On One Cell Comparing to the Other Cell Daren	by Daren	5	814
adding columns Masterzan	by Bob Phillips[_3_]	2	414
formulate all in one cell carrol	by Dave Curtis	3	500
Getting the Cell ID [email protected]	by [email protected]	2	4,480
copying formulas only AccountingStudent	by ShaneDevenshire	1	424
Prevent unhide sheet acss	by ShaneDevenshire	2	974
If Statement / Array JEFF	by T. Valko	6	562
Vlookup for multiple duplicate numerical values pete8125	by Ashish Mathur[_2_]	4	1,386
mass emailing from excel worksheet tamidee	by debbie	1	484
Finding the most recent date -- Excel 2K tech1NJ	by ShaneDevenshire	1	520
Subtract two dates (decrementing daily) and add text Peter	by ShaneDevenshire	5	419
Countif - Sumproduct dave230	by ShaneDevenshire	3	467
sample vs. population proportion using a z-score in excel Christopher[_3_]	by Christopher[_3_]	4	2,846
How to lock an ActiveX Control box on the spreadsheet? Ange	by ShaneDevenshire	1	1,647
Conditional formula whereby if A1=Intuit, Then B1=PO Box 1 An Excel Populated World	by An Excel Populated World[_2_]	3	543
Delete Rows based on value Sabosis	by Sabosis	4	1,365
Calculate Days Left in Current Year Dave C	by Dave C	3	5,546
HI!Need to make Cell formula change for each Pg Break in a Print T usansay18	by Sheeloo[_3_]	1	406
Summing it up Violet 1	by Violet 1	5	391
Insert String Between Dates in Chart Title RyanH	by Peo Sjoblom[_2_]	5	835
How to use the rownumber of the current cell in a formula Wim Goelen	by Michael	3	1,305
if < on one tab - want total on a summary sheet BT[_2_]	by T. Valko	3	462
Auto Sort by column B Moira	by Michael	1	870
Using Solver in VBA redbird	by Bernard Liengme	1	1,395
Replace Font within Cell Stephanie M[_2_]	by Stephanie M	1	469
Sumproduct not returning data Trish Smith	by Bernard Liengme	4	590
how can i scramble data for a sweepstakes? Ro	by redbird	2	1,124
Vlookup help with multiple results Gerd	by Gerd	2	560
Finding the most recent date - Excel 2K tech1NJ	by tech1NJ	3	650
calculating dates to now() Todd[_3_]	by T. Valko	3	661
HELP GRANDIVA77	by Sheeloo[_3_]	2	387
Display all pivottable filter selections AudKen	by AudKen	0	843
lowest figure greater than 1 Kendo	by Harlan Grove[_2_]	5	813
Watermark angelparadise	by TomPl	2	393
add range in one column, subtract range in another column kasey	by Gary''s Student	1	1,098
How do I tell how many pages I have created in my spreadsheet jsnatas	by John C[_2_]	11	782
Formula Function SM_NCSW	by Ron Rosenfeld	23	1,725
Is anyone else have problems with this web site tonight? ShaneDevenshire	by Susan	3	542
Drop down boxes/tick boxes Jane	by Debra Dalgleish	2	886
math functions Cookie	by Max	1	432
Format Using Reating Symbols Needy Ned	by Spiky	4	463
Month value DaveKid	by ShaneDevenshire	3	416
Setting a cell with a value as a reference for another function Stressless	by ShaneDevenshire	1	631
Excel not converting file Tim	by Spiky	11	982
Format Currency Cell Yossy	by Spiky	6	587
Automatically add lines and keep formulas Matt	by Matt	2	569
Problem with multiple copying of column contents MichaelRobert	by Glenn	2	470
Skip if false? DeFautT	by DeFautT	2	5,298
Can you perform calculations w/ cells that have both numbers and t BWP	by Max	5	521
Function for getting cell ID and the last row with value [email protected]	by Roger Govier[_3_]	2	551
how to move data from single to multible collums in excel Don	by Roger Govier[_3_]	2	486
Excell Sue Parsons	by Roger Govier[_3_]	6	408
Month as a value DaveKid	by Ron Rosenfeld	1	366
How do you connect worksheets,input data in one place&it shows on excel	by Max	2	1,131
Diplaying results of a formula instead of the formula itself DirtyBadger	by Mike H	1	417
VLookUp - Does the VLookUp return the exact information? Cpviv	by Cpviv	2	1,526
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,974
logical formula mike	by ShaneDevenshire	2	464
Help Please! CountIf Function using 2 criteria? AlexisLovesLife	by ShaneDevenshire	4	488
automatically insert salary based on job title [email protected]	by ShaneDevenshire	2	777
compare 2 tables of dates to find the preceding dates Babi	by Max	3	1,078
Seperating hyperlink address from viewable text Aominay	by EXCEL HELP	5	582
how do i require text in a cell how to make a cell require text	by Peo Sjoblom	4	441
Bonus/Absence/Timesheet workbook help needed. klg	by Herbert Seidenberg[_3_]	6	559
Add-in analysis gm66	by Gord Dibben	5	504
SumIf - when I fill down the Range, Criteria & sum range changes markholt	by Sheeloo[_3_]	3	1,866
Returning 0 instead of #N/A when no value is found RobertSD	by Dave Peterson	8	1,299
conditional formula DiazFamily	by Sheeloo[_3_]	1	447
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	432
HyperLinkDumbIam NotGood@All	by Dave Peterson	2	366
Sumif date=date red	by T. Valko	3	402