Excel Worksheet Functions - Page 674

Thread / Thread Starter	Last Post	Replies	Views
SUMIF and LEFT and Named Ranges DaveMoore	by DaveMoore	0	720
Comparing Data from two excel sheets! Killer	by Stefi	4	697
display 1 line of multiple worksheets into multiple lines on 1 wks Golf Nut	by Max	1	788
Conditional format if cell match found in another range of cells Nolene	by Biff	2	5,638
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	825
subtotals Carla	by JMB	1	319
vlookup, match? what do I use? Sojo	by PapaDos	2	403
if=0 then n/a if<0 leave the value in the cell Hoofnagle	by Teethless mama	2	3,931
Sorting by Sections Problem Freshman	by Max	7	500
Auto data fill in Slashman	by Slashman	3	349
Auto cell move Slashman	by Slashman	2	378
Automatic update of date once, then remains static mfdc_frank	by Gord Dibben	5	1,033
drop-down calendar lizbeff	by Carolan	4	590
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	356
formula to roundup to the nearest 9 susiegirl	by Epinn	8	3,178
Running total within a cell bob2525	by Gord Dibben	3	740
How do I use a linking formula in cell with many words? tmvigil95	by tmvigil95	2	356
How do I not show certain Letters in a range of cells in excel? Taryn McGregor	by Jim Cone	2	658
Control Sheet Cedrun	by Cedrun	2	397
Min Max What's Wrong? shep	by shep	4	527
convert dollars to pounds using a lookup formula cuffie	by cuffie	4	2,108
Shortcut toggle between worksheets in the same workbook? Chris	by Marcelo	3	1,488
How do I hide a row in excel if a certain other cell is populated Teresa Hoffman	by Carim	1	576
copying workbooks Nadji	by Marcelo	3	373
seperate a value in a text string T Miller	by Ron Rosenfeld	10	736
COMPARE TWO COLUMNS AND GET THE VALUE IN THIRD COLUMN clau	by Bernard Liengme	1	1,072
What formula do I use to add totals between workbooks? Jodi @ Tehachapi Unified	by Jodi @ Tehachapi Unified	0	714
VDB Depreciation Question KRP	by KRP	0	530
Match function problem [email protected]	by Jim Thomlinson	3	615
sort alpa descending 'cell size' error clubfisher	by David Biddulph	4	420
Lookup returns blank if no match Nolene	by Nolene	9	1,709
Need help with LEN? function Ron	by Ron	4	381
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,388
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	821
Reference a list to perform a function in Excel matt ashley	by Bill Pfister	1	581
Two questions, how do I disable ver 4 macros and how do I make radial buttons like this? Kelvin Beaton	by Kelvin Beaton	4	729
Spreading 1 large number evenly into several cells Dos Equis	by Dos Equis	0	1,074
Creating a formula which multiplies by two seperate %'s Dos Equis	by Dos Equis	11	683
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	431
How do you set up range names, name formulas DonF	by DonF	0	539
Help! How do I copy/paste formulas without automatic progression? Ed	by Ed	2	1,291
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,108
View formula result instead of formula tina	by Nat	4	462
How do I model a Paretian Distribution in Excel? NickPadgett	by Jerry W. Lewis	4	1,302
adding like items from different sheets RPW	by RPW	0	698
Moving to Previous Worksheet Zootie	by PCLIVE	1	626
Using INDEX function to return array row. RBI	by vezerid	1	1,256
moving filtered data between worksheets automatically dweezy	by dweezy	3	757
embedded presentation graphs in excel don't update, tables do sid	by sid	0	602
Vlookup/Match/Index/Small - I think The Novice	by Dave F	1	880
view value instead of formula tina	by SteveW	1	409
dash showtunegirl	by SteveW	3	559
Weakness in the Drag Function of Excel 2007 (Beta) Mr. Low	by Mr. Low	0	939
Reverse NETWORKDAYS function? [email protected]	by [email protected]	4	2,416
Need to condense my formula summing many values over many sheets Andy777	by CLR	5	676
Scales Nymand	by SteveW	1	496
help needed urgently wardah	by Stefi	2	469
Formula help Anthony	by Anthony	6	462
Median array formula Ciara	by Ciara	1	1,433
How do I permanently remove Template Help? Mary H	by Horrgakx	1	562
Automating Polynomial Order Selection in Linest Nick Flyger	by [email protected]	3	1,883
Reporting using PivotTable [email protected]	by Roger Govier	1	560
moving source cell in excel k9kapers	by Alok	5	1,379
MOD J.H.	by Dana	15	1,451
How do I delete an excel list? Office-novice	by Dave Peterson	1	343
if in conditional formatting DKY	by Dave Peterson	6	516
Cross referencing sb1920alk	by Max	1	677
Address block carriage returns not correct Bill	by Max	3	682