Excel Worksheet Functions - Page 777

Thread / Thread Starter	Last Post	Replies	Views
A Challenge: Detection of first and Last +ve number in a range Chris Gorham	by Harlan Grove	1	604
How to Limit Cell Values to Multiple of 10? [email protected]	by Bernard Liengme	3	671
Summing range that contains text quailc	by quailc	2	539
To XIRR or Not To XIRR Jonathan	by Jonathan	3	928
Lookup Question Barb Reinhardt	by Bob Phillips	1	429
Can I get Excel to calculate hours:minutes when sum exceeds 24? nickq2	by nickq2	5	1,404
prepaid/depreciation formulas markx	by Marcelo	1	500
Excel Dates Leon	by Leon	4	368
vlookup returning a #N/A value Ian	by Dave Peterson	5	1,007
Need a shaded row in Excel that doesn't move as data changes czr	by Ken Johnson	1	515
Lookup Funtion Don - Mundane Government Worker	by Marcelo	3	420
nested IF w/ LEN and ROUNDUP?? LTUser54	by LTUser54	5	943
Average MLShef	by Marcelo	2	364
keeping cell format with formula JAB	by JAB	2	3,783
calling up cells from a table. tanner	by Pete_UK	5	449
Help with Formula Dave G	by Pete_UK	2	394
multi column of sumif birdsting	by Don Guillett	3	497
insert formula [email protected]	by [email protected]	0	445
Dynamic Hyperlink Larry S	by Larry S	5	2,096
Is this formula 100*(PRODUCT(1+C3:N3/100)-1) recognised by Excel Chwee Mee	by Bob Phillips	1	2,708
Sumproduct question? wahur	by Bob Phillips	1	375
Complicated formulas XCESIV	by Niek Otten	6	455
Combining formula and cell reference Drew	by Drew	3	697
Double IF - is this possible Alan Davies	by Bob Phillips	3	432
DCOUNT WITH MULTIPLE CRITERIAS cltjohn	by cltjohn	2	609
working out quarters (three-month periods) between two dates [email protected]	by [email protected]	1	2,075
Offset Function jagbabbra	by jagbabbra	0	637
Formated Print Area in WEB page. Tissy	by Tissy	0	479
compare adjacent cells and calculate averages Marquismarce	by MM	5	1,005
Refusal to calculate Daniel Bonallack	by Charles Williams	2	518
Help please! Blade2304	by Bondi	3	320
Want a serious muslim match?Join our club and start searching now!!! [email protected]	by [email protected]	0	431
Want a serious muslim match?Join our club and start searching now!!! [email protected]	by [email protected]	0	628
copy range from one workbook to other in C# asp newbie	by asp newbie	0	2,104
excel exact command should not be case sensitive keabu	by Harlan Grove	2	457
Is there anybody who can hlp in the function making!!! rony4icab	by rony4icab	3	372
Search array and return element No Ron	by Biff	7	602
MS Excel 2003 lanz	by Norman Jones	1	361
Not sure how to ask JariH	by JariH	2	307
How do I create a running total (balance) in a pivot table? Jackie @ TRL	by Fred Smith	1	913
Setting up dates Jo	by Peo Sjoblom	1	437
Changing relative to absolute for a column John K	by davesexcel	6	892
Divide numbers and distribute evenly. rhon101	by rhon101	0	1,810
Find duplicate entries within mulitple worksheets, then listing th Gayla	by Biff	1	436
VLOOKUP from closed file using INDIRECT function Ben	by travisc	3	3,637
formula chedd via OfficeKB.com	by Pete_UK	3	443
open a query automatically BryanJ	by BryanJ	2	379
I put in 19 the formula is ok but if i put in a566 it returns #N/A Steved	by Steved	4	293
finding last row in a fixed section then sort toolman	by Kevin Vaughn	5	412
I want to place a "x" in a cell and give it a value of 1 (Excel) jpe	by davesexcel	1	590
Help extract numerous text files and how to use avg formula [email protected]	by [email protected]	0	501
sumif and then regular equation to non selected cells mike	by Kevin Vaughn	6	574
min and max in a sequence bill gras	by Domenic	11	786
Will the COUNTIF function work with auto-filtering? RC	by Bob Phillips	10	1,511
Slow Calculation JavyD	by Niek Otten	2	521
Formala to find the best/latest signal Eskimo	by Eskimo	14	838
Columns A - BY and 336 rows.Too much to filter&sort?Lose info. greenlawn06	by Kevin M	1	604
how to maintain hyperlink between worksheets after sorting Gallatin	by Gallatin	2	682
how to set number of characteres on a cell WIlson	by David McRitchie	1	371
Vlookup problem Blade2304	by Kevin Vaughn	3	553
3D formulas ToniB	by Peo Sjoblom	1	708
Protection of identical cells on multiple worksheets shawnlacey	by shawnlacey	6	644
OnTime VB [email protected]	by Dave Peterson	2	651
Assign number to every value in a data range??? the dude	by HEK	1	531
Worksheet Command Button will not work willpwr	by willpwr	0	582
How do I set up a spreadsheet where it will automatically update? Rhoda	by Paul B	1	648
NVL type function Jonathan	by Jonathan	5	1,222
How do I countif the criteria is a nonblank? Todd	by Gary''s Student	3	573
Can Excel add working days to a date to result in another date? cwalrus	by Mark Lincoln	1	1,545
Locating First and Last Cell Containing a Specific Value [email protected]	by Gary''s Student	1	916
Correlation Matrix katie	by Rothman	5	2,706
Columns A - BY and 336 rows.Too much to filter&sort?Lose info. greenlawn06	by Peo Sjoblom	2	673
data validation bruno1	by bruno1	2	309
Formulas chedd via OfficeKB.com	by Max	3	339
ifsum function question Robthemanbob	by Robthemanbob	2	467