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	594
How to Limit Cell Values to Multiple of 10? [email protected]	by Bernard Liengme	3	661
Summing range that contains text quailc	by quailc	2	538
To XIRR or Not To XIRR Jonathan	by Jonathan	3	923
Lookup Question Barb Reinhardt	by Bob Phillips	1	426
Can I get Excel to calculate hours:minutes when sum exceeds 24? nickq2	by nickq2	5	1,401
prepaid/depreciation formulas markx	by Marcelo	1	499
Excel Dates Leon	by Leon	4	358
vlookup returning a #N/A value Ian	by Dave Peterson	5	1,001
Need a shaded row in Excel that doesn't move as data changes czr	by Ken Johnson	1	500
Lookup Funtion Don - Mundane Government Worker	by Marcelo	3	416
nested IF w/ LEN and ROUNDUP?? LTUser54	by LTUser54	5	933
Average MLShef	by Marcelo	2	356
keeping cell format with formula JAB	by JAB	2	3,783
calling up cells from a table. tanner	by Pete_UK	5	440
Help with Formula Dave G	by Pete_UK	2	393
multi column of sumif birdsting	by Don Guillett	3	490
insert formula [email protected]	by [email protected]	0	438
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,707
Sumproduct question? wahur	by Bob Phillips	1	375
Complicated formulas XCESIV	by Niek Otten	6	447
Combining formula and cell reference Drew	by Drew	3	692
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,070
Offset Function jagbabbra	by jagbabbra	0	627
Formated Print Area in WEB page. Tissy	by Tissy	0	474
compare adjacent cells and calculate averages Marquismarce	by MM	5	1,004
Refusal to calculate Daniel Bonallack	by Charles Williams	2	511
Help please! Blade2304	by Bondi	3	317
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	627
copy range from one workbook to other in C# asp newbie	by asp newbie	0	2,099
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	593
MS Excel 2003 lanz	by Norman Jones	1	351
Not sure how to ask JariH	by JariH	2	297
How do I create a running total (balance) in a pivot table? Jackie @ TRL	by Fred Smith	1	911
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,808
Find duplicate entries within mulitple worksheets, then listing th Gayla	by Biff	1	435
VLOOKUP from closed file using INDIRECT function Ben	by travisc	3	3,636
formula chedd via OfficeKB.com	by Pete_UK	3	442
open a query automatically BryanJ	by BryanJ	2	375
I put in 19 the formula is ok but if i put in a566 it returns #N/A Steved	by Steved	4	290
finding last row in a fixed section then sort toolman	by Kevin Vaughn	5	401
I want to place a "x" in a cell and give it a value of 1 (Excel) jpe	by davesexcel	1	583
Help extract numerous text files and how to use avg formula [email protected]	by [email protected]	0	500
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	516
Formala to find the best/latest signal Eskimo	by Eskimo	14	837
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	544
3D formulas ToniB	by Peo Sjoblom	1	698
Protection of identical cells on multiple worksheets shawnlacey	by shawnlacey	6	634
OnTime VB [email protected]	by Dave Peterson	2	649
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	572
How do I set up a spreadsheet where it will automatically update? Rhoda	by Paul B	1	643
NVL type function Jonathan	by Jonathan	5	1,212
How do I countif the criteria is a nonblank? Todd	by Gary''s Student	3	565
Can Excel add working days to a date to result in another date? cwalrus	by Mark Lincoln	1	1,536
Locating First and Last Cell Containing a Specific Value [email protected]	by Gary''s Student	1	916
Correlation Matrix katie	by Rothman	5	2,697
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	299
Formulas chedd via OfficeKB.com	by Max	3	329
ifsum function question Robthemanbob	by Robthemanbob	2	462