Excel Worksheet Functions - Page 283

Thread / Thread Starter	Last Post	Replies	Views
formula shows false mike	by John C[_2_]	6	775
Nested IF Function returns #NAME? Error bw	by John C[_2_]	8	1,080
IF Statement for On One Cell Comparing to the Other Cell Daren	by Daren	5	827
adding columns Masterzan	by Bob Phillips[_3_]	2	417
formulate all in one cell carrol	by Dave Curtis	3	503
Getting the Cell ID [email protected]	by [email protected]	2	4,483
copying formulas only AccountingStudent	by ShaneDevenshire	1	424
Prevent unhide sheet acss	by ShaneDevenshire	2	974
If Statement / Array JEFF	by T. Valko	6	565
Vlookup for multiple duplicate numerical values pete8125	by Ashish Mathur[_2_]	4	1,389
mass emailing from excel worksheet tamidee	by debbie	1	486
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,848
How to lock an ActiveX Control box on the spreadsheet? Ange	by ShaneDevenshire	1	1,648
Conditional formula whereby if A1=Intuit, Then B1=PO Box 1 An Excel Populated World	by An Excel Populated World[_2_]	3	544
Delete Rows based on value Sabosis	by Sabosis	4	1,366
Calculate Days Left in Current Year Dave C	by Dave C	3	5,547
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	840
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	872
Using Solver in VBA redbird	by Bernard Liengme	1	1,396
Replace Font within Cell Stephanie M[_2_]	by Stephanie M	1	470
Sumproduct not returning data Trish Smith	by Bernard Liengme	4	592
how can i scramble data for a sweepstakes? Ro	by redbird	2	1,125
Vlookup help with multiple results Gerd	by Gerd	2	562
Finding the most recent date - Excel 2K tech1NJ	by tech1NJ	3	652
calculating dates to now() Todd[_3_]	by T. Valko	3	678
HELP GRANDIVA77	by Sheeloo[_3_]	2	389
Display all pivottable filter selections AudKen	by AudKen	0	843
lowest figure greater than 1 Kendo	by Harlan Grove[_2_]	5	817
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	783
Formula Function SM_NCSW	by Ron Rosenfeld	23	1,732
Is anyone else have problems with this web site tonight? ShaneDevenshire	by Susan	3	545
Drop down boxes/tick boxes Jane	by Debra Dalgleish	2	895
math functions Cookie	by Max	1	434
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	632
Excel not converting file Tim	by Spiky	11	983
Format Currency Cell Yossy	by Spiky	6	589
Automatically add lines and keep formulas Matt	by Matt	2	569
Problem with multiple copying of column contents MichaelRobert	by Glenn	2	475
Skip if false? DeFautT	by DeFautT	2	5,299
Can you perform calculations w/ cells that have both numbers and t BWP	by Max	5	522
Function for getting cell ID and the last row with value [email protected]	by Roger Govier[_3_]	2	552
how to move data from single to multible collums in excel Don	by Roger Govier[_3_]	2	487
Excell Sue Parsons	by Roger Govier[_3_]	6	408
Month as a value DaveKid	by Ron Rosenfeld	1	367
How do you connect worksheets,input data in one place&it shows on excel	by Max	2	1,133
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,544
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,122
Seperating hyperlink address from viewable text Aominay	by EXCEL HELP	5	583
how do i require text in a cell how to make a cell require text	by Peo Sjoblom	4	450
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,868
Returning 0 instead of #N/A when no value is found RobertSD	by Dave Peterson	8	1,301
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