Excel Worksheet Functions - Page 674

Thread / Thread Starter	Last Post	Replies	Views
SUMIF and LEFT and Named Ranges DaveMoore	by DaveMoore	0	684
Comparing Data from two excel sheets! Killer	by Stefi	4	657
display 1 line of multiple worksheets into multiple lines on 1 wks Golf Nut	by Max	1	754
Conditional format if cell match found in another range of cells Nolene	by Biff	2	5,561
Is there a formula that can find the cell corresponding to a trans beecher	by Ken Johnson	6	516
Can you use CountA to add multiple items within one cell? Teacher in a quandry	by Teethless mama	4	801
subtotals Carla	by JMB	1	306
vlookup, match? what do I use? Sojo	by PapaDos	2	384
if=0 then n/a if<0 leave the value in the cell Hoofnagle	by Teethless mama	2	3,909
Sorting by Sections Problem Freshman	by Max	7	469
Auto data fill in Slashman	by Slashman	3	326
Auto cell move Slashman	by Slashman	2	370
Automatic update of date once, then remains static mfdc_frank	by Gord Dibben	5	1,008
drop-down calendar lizbeff	by Carolan	4	582
I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31 Curtis	by Bob Phillips	3	341
formulas KC	by Don Guillett	1	337
formula to roundup to the nearest 9 susiegirl	by Epinn	8	3,091
Running total within a cell bob2525	by Gord Dibben	3	702
How do I use a linking formula in cell with many words? tmvigil95	by tmvigil95	2	344
How do I not show certain Letters in a range of cells in excel? Taryn McGregor	by Jim Cone	2	627
Control Sheet Cedrun	by Cedrun	2	378
Min Max What's Wrong? shep	by shep	4	498
convert dollars to pounds using a lookup formula cuffie	by cuffie	4	2,096
Shortcut toggle between worksheets in the same workbook? Chris	by Marcelo	3	1,444
How do I hide a row in excel if a certain other cell is populated Teresa Hoffman	by Carim	1	550
copying workbooks Nadji	by Marcelo	3	359
seperate a value in a text string T Miller	by Ron Rosenfeld	10	718
COMPARE TWO COLUMNS AND GET THE VALUE IN THIRD COLUMN clau	by Bernard Liengme	1	1,052
What formula do I use to add totals between workbooks? Jodi @ Tehachapi Unified	by Jodi @ Tehachapi Unified	0	699
VDB Depreciation Question KRP	by KRP	0	516
Match function problem [email protected]	by Jim Thomlinson	3	577
sort alpa descending 'cell size' error clubfisher	by David Biddulph	4	395
Lookup returns blank if no match Nolene	by Nolene	9	1,655
Need help with LEN? function Ron	by Ron	4	359
Creating a Warning window PCStechnical	by PCStechnical	2	414
How do I make the 1st column constant in viewing a wide spreadshee Greg	by Greg	4	1,360
How do I convert from Euros to USDollars? It's not in EUROCONVERT EurosDollars	by Dave F	1	1,157
dependent drop down - repeat values mcmanusb	by mcmanusb	5	798
Reference a list to perform a function in Excel matt ashley	by Bill Pfister	1	565
Two questions, how do I disable ver 4 macros and how do I make radial buttons like this? Kelvin Beaton	by Kelvin Beaton	4	705
Spreading 1 large number evenly into several cells Dos Equis	by Dos Equis	0	1,042
Creating a formula which multiplies by two seperate %'s Dos Equis	by Dos Equis	11	658
Copying a region in excel results in the entire worksheet being pa THT	by THT	0	523
cell format question Todd	by David Billigmeier	1	403
How do you set up range names, name formulas DonF	by DonF	0	508
Help! How do I copy/paste formulas without automatic progression? Ed	by Ed	2	1,261
Ability to arrange tabs in a worksheet in chronological order Amanda	by David Biddulph	2	980
URGENT HELP PLEASE triffidbook	by SteveW	3	428
Find a Value by interpolation from a table of x and y values BuickGN87	by vezerid	3	1,083
View formula result instead of formula tina	by Nat	4	442
How do I model a Paretian Distribution in Excel? NickPadgett	by Jerry W. Lewis	4	1,278
adding like items from different sheets RPW	by RPW	0	671
Moving to Previous Worksheet Zootie	by PCLIVE	1	612
Using INDEX function to return array row. RBI	by vezerid	1	1,210
moving filtered data between worksheets automatically dweezy	by dweezy	3	718
embedded presentation graphs in excel don't update, tables do sid	by sid	0	574
Vlookup/Match/Index/Small - I think The Novice	by Dave F	1	859
view value instead of formula tina	by SteveW	1	390
dash showtunegirl	by SteveW	3	515
Weakness in the Drag Function of Excel 2007 (Beta) Mr. Low	by Mr. Low	0	874
Reverse NETWORKDAYS function? [email protected]	by [email protected]	4	2,380
Need to condense my formula summing many values over many sheets Andy777	by CLR	5	649
Scales Nymand	by SteveW	1	486
help needed urgently wardah	by Stefi	2	447
Formula help Anthony	by Anthony	6	457
Median array formula Ciara	by Ciara	1	1,399
How do I permanently remove Template Help? Mary H	by Horrgakx	1	549
Automating Polynomial Order Selection in Linest Nick Flyger	by [email protected]	3	1,852
Reporting using PivotTable [email protected]	by Roger Govier	1	524
moving source cell in excel k9kapers	by Alok	5	1,357
MOD J.H.	by Dana	15	1,436
How do I delete an excel list? Office-novice	by Dave Peterson	1	323
if in conditional formatting DKY	by Dave Peterson	6	498
Cross referencing sb1920alk	by Max	1	664
Address block carriage returns not correct Bill	by Max	3	660