Excel Worksheet Functions - Page 674

Thread / Thread Starter	Last Post	Replies	Views
SUMIF and LEFT and Named Ranges DaveMoore	by DaveMoore	0	711
Comparing Data from two excel sheets! Killer	by Stefi	4	686
display 1 line of multiple worksheets into multiple lines on 1 wks Golf Nut	by Max	1	773
Conditional format if cell match found in another range of cells Nolene	by Biff	2	5,626
Is there a formula that can find the cell corresponding to a trans beecher	by Ken Johnson	6	523
Can you use CountA to add multiple items within one cell? Teacher in a quandry	by Teethless mama	4	815
subtotals Carla	by JMB	1	314
vlookup, match? what do I use? Sojo	by PapaDos	2	401
if=0 then n/a if<0 leave the value in the cell Hoofnagle	by Teethless mama	2	3,930
Sorting by Sections Problem Freshman	by Max	7	489
Auto data fill in Slashman	by Slashman	3	340
Auto cell move Slashman	by Slashman	2	377
Automatic update of date once, then remains static mfdc_frank	by Gord Dibben	5	1,030
drop-down calendar lizbeff	by Carolan	4	589
I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31 Curtis	by Bob Phillips	3	353
formulas KC	by Don Guillett	1	347
formula to roundup to the nearest 9 susiegirl	by Epinn	8	3,175
Running total within a cell bob2525	by Gord Dibben	3	730
How do I use a linking formula in cell with many words? tmvigil95	by tmvigil95	2	354
How do I not show certain Letters in a range of cells in excel? Taryn McGregor	by Jim Cone	2	646
Control Sheet Cedrun	by Cedrun	2	390
Min Max What's Wrong? shep	by shep	4	517
convert dollars to pounds using a lookup formula cuffie	by cuffie	4	2,107
Shortcut toggle between worksheets in the same workbook? Chris	by Marcelo	3	1,482
How do I hide a row in excel if a certain other cell is populated Teresa Hoffman	by Carim	1	565
copying workbooks Nadji	by Marcelo	3	373
seperate a value in a text string T Miller	by Ron Rosenfeld	10	726
COMPARE TWO COLUMNS AND GET THE VALUE IN THIRD COLUMN clau	by Bernard Liengme	1	1,065
What formula do I use to add totals between workbooks? Jodi @ Tehachapi Unified	by Jodi @ Tehachapi Unified	0	712
VDB Depreciation Question KRP	by KRP	0	525
Match function problem [email protected]	by Jim Thomlinson	3	598
sort alpa descending 'cell size' error clubfisher	by David Biddulph	4	408
Lookup returns blank if no match Nolene	by Nolene	9	1,700
Need help with LEN? function Ron	by Ron	4	368
Creating a Warning window PCStechnical	by PCStechnical	2	431
How do I make the 1st column constant in viewing a wide spreadshee Greg	by Greg	4	1,382
How do I convert from Euros to USDollars? It's not in EUROCONVERT EurosDollars	by Dave F	1	1,183
dependent drop down - repeat values mcmanusb	by mcmanusb	5	811
Reference a list to perform a function in Excel matt ashley	by Bill Pfister	1	574
Two questions, how do I disable ver 4 macros and how do I make radial buttons like this? Kelvin Beaton	by Kelvin Beaton	4	726
Spreading 1 large number evenly into several cells Dos Equis	by Dos Equis	0	1,063
Creating a formula which multiplies by two seperate %'s Dos Equis	by Dos Equis	11	679
Copying a region in excel results in the entire worksheet being pa THT	by THT	0	543
cell format question Todd	by David Billigmeier	1	423
How do you set up range names, name formulas DonF	by DonF	0	528
Help! How do I copy/paste formulas without automatic progression? Ed	by Ed	2	1,281
Ability to arrange tabs in a worksheet in chronological order Amanda	by David Biddulph	2	1,015
URGENT HELP PLEASE triffidbook	by SteveW	3	437
Find a Value by interpolation from a table of x and y values BuickGN87	by vezerid	3	1,096
View formula result instead of formula tina	by Nat	4	449
How do I model a Paretian Distribution in Excel? NickPadgett	by Jerry W. Lewis	4	1,297
adding like items from different sheets RPW	by RPW	0	685
Moving to Previous Worksheet Zootie	by PCLIVE	1	626
Using INDEX function to return array row. RBI	by vezerid	1	1,245
moving filtered data between worksheets automatically dweezy	by dweezy	3	753
embedded presentation graphs in excel don't update, tables do sid	by sid	0	600
Vlookup/Match/Index/Small - I think The Novice	by Dave F	1	877
view value instead of formula tina	by SteveW	1	400
dash showtunegirl	by SteveW	3	558
Weakness in the Drag Function of Excel 2007 (Beta) Mr. Low	by Mr. Low	0	929
Reverse NETWORKDAYS function? [email protected]	by [email protected]	4	2,406
Need to condense my formula summing many values over many sheets Andy777	by CLR	5	664
Scales Nymand	by SteveW	1	494
help needed urgently wardah	by Stefi	2	469
Formula help Anthony	by Anthony	6	461
Median array formula Ciara	by Ciara	1	1,421
How do I permanently remove Template Help? Mary H	by Horrgakx	1	561
Automating Polynomial Order Selection in Linest Nick Flyger	by [email protected]	3	1,872
Reporting using PivotTable [email protected]	by Roger Govier	1	548
moving source cell in excel k9kapers	by Alok	5	1,364
MOD J.H.	by Dana	15	1,445
How do I delete an excel list? Office-novice	by Dave Peterson	1	331
if in conditional formatting DKY	by Dave Peterson	6	505
Cross referencing sb1920alk	by Max	1	677
Address block carriage returns not correct Bill	by Max	3	677