Excel Worksheet Functions - Page 101

Thread / Thread Starter	Last Post	Replies	Views
between dates thanks	by LiLi	6	327
=TEXT(I21,"MMYY") Thank you, Heath	by Kevin Vaughn	10	751
Date in Spreadsheet that changes to random numbers Thank you for your help....Puzzled	by Gord Dibben	1	801
Use SQL statements in Excel VBA to query SQL Server Data Problem Thank You	by Thank You	0	1,520
sum multiple rows based on progressing date field on each row Thane	by Thane	0	927
numbertowords Thampoo	by Bob Phillips[_4_]	2	397
How do you update links Thami Ndadana	by Dave Peterson	1	716
The best way to create a Keyword Seach field in excel thallingdvss	by Per Jessen[_2_]	1	560
normal into Capital letters automatically thalia	by Héctor Miguel	6	1,815
arranging sheets alphabatically Thakur Praveen Kumar	by Bob Phillips[_3_]	2	483
i WANT TO CALCULATE THE NO IN A SINGLE COLUMN WHICH ARE NOT SAME. thakur	by Stephen[_2_]	1	454
price higher than... Thad	by myra_deV	2	292
need help with IF Thad	by Gav123	2	370
Printing Thad	by Frank Kabel	1	420
Excel should speak results of logical formula TH	by Dana DeLouis	4	568
tracer arrows not visable Tguy18	by Tguy18	0	500
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? [email protected]	by [email protected]	1	844
when I protect a worksheet, user cannot use check boxes tgodrich	by ExcelBanter AI	5	7,994
NOW() and SECOND() not refreshing tgmjf	by tgmjf	2	508
Cell value - detecting change tgmjf	by tgmjf	2	672
Formula Assistance tglstar	by Otto Moehrbach	1	369
How to use vlookup when lookup contains number and letters TGL	by Biff	4	1,600
Adding the changes to only one Cell tgivin	by Gord Dibben	4	328
Can a linked hyperlink be updated Tgivin	by Tgivin	0	429
Is there an Excel Function that coverts: 37 to thirty seven? tgirl26x	by Gord Dibben	2	359
Conditional formula date tghcogo	by tghcogo	0	347
Why does a simple frequency distribution count out of range data? [email protected]	by Harlan Grove	3	1,039
Formula ? Return value from rightmost non-blank cell in a row of tgdavis	by Max	8	1,311
CNTRL + END is not working properly tgdavis	by Dave Peterson	1	925
Sumifs, averageifs, countifs tgavin	by Bernard Liengme	6	590
Can you combined the SUMIF and SUBTOTAL functions in a formula? [email protected]	by Peo Sjoblom	1	1,113
Combining SUMIF and SUBTOTAL functions [email protected]	by Arvi Laanemets	1	859
Exporting TGalin	by Shane Devenshire	3	498
Worksheet Jump TGalin	by Shane Devenshire	1	450
Formula to Count TGalin	by TGalin	7	457
Remove Zero Formula TGalin	by Glenn	6	1,170
If then formulas TGags	by Chip Pearson	4	492
equals merged cells TGags	by David Biddulph[_2_]	2	1,595
How to get a formula result in a "whatif" situation TG9522	by Toppers	2	376
Average with #DIV/0! TG Engel	by Ashish Mathur[_2_]	4	1,757
Calendar Text Box all the same TG	by TG	0	465
proper way to nest AND & OR with IF? TG	by Sloth	4	409
Template Wizard/Excel as database TG	by TG	0	1,082
challenging formula(for me), counting days between dates for multipleyears TG	by Curt	5	747
Using Concatenate operator to overcome 7 nested IF's TG	by Bob Phillips	1	591
Another table lookup question [email protected]	by [email protected]	2	363
How to retrieve last date and amount from columns? tfrentz	by RagDyeR	5	601
How to caclulate porfolio returns over different time periods tfrentz	by tfrentz	6	394
How to calculate portfolio returns over different periods of time tfrentz	by Don Guillett	4	1,219
How to reference MSNStockQuote button within a macro tfrentz	by Alien	2	440
automate row insert to archive tfrentz	by Don Guillett	15	1,212
Double Clicking on link w/i workbook does't bring me to souce. tfranc	by tfranc	2	542
Date Format TFMR	by Roger Govier[_3_]	2	384
Cell Formatting TFMR	by David Biddulph[_2_]	3	391
Cell formatting TFMR	by TFMR	0	332
how to copy data TFMR	by ryguy7272	1	419
If with multiple or TFMR	by John C[_2_]	5	337
how to delete continously data TFMR	by TFMR	0	473
IF function Tflight	by Tflight	4	493
countif vs. if???? Tflight	by Shane Devenshire[_2_]	6	408
sumproduct or...? Tflight	by Gary''s Student	4	608
conditional formatting Tflight	by John[_22_]	2	381
How do I get the cell address of a VLOOKUP reference? tfleischny	by JE McGimpsey	4	1,425
Match function tflee	by Shane Devenshire[_2_]	1	359
How do you calculate number of workdays from dates entered? tfleck	by Niek Otten	1	738
Msnstockquote tfjr	by ryguy7272	1	367
Is MSNstockquote only for stocks? tfjr	by tfjr	2	414
how do i sort rows and maintain cell references tfb	by JethroUK©	1	440
how do i sort rows and maintain cell references tfb	by tfb	0	421
Eligible Vacation Days Calculator tfarley	by Gord Dibben	4	1,478
Page break when data changes.... tfarley	by tfarley	7	477
view 2 different worksheets within the Wrkbk tfall	by patele	7	470
Conditional Formating in Blank Cells TF	by T. Valko	4	693
Extract numerator from fraction tf	by ExcelBanter AI	10	8,106
Moving, deleting, and concatenating text in cells. te_butts	by te_butts	4	457