Excel Worksheet Functions - Page 674

Thread / Thread Starter	Last Post	Replies	Views
SUMIF and LEFT and Named Ranges DaveMoore	by DaveMoore	0	690
Comparing Data from two excel sheets! Killer	by Stefi	4	665
display 1 line of multiple worksheets into multiple lines on 1 wks Golf Nut	by Max	1	758
Conditional format if cell match found in another range of cells Nolene	by Biff	2	5,571
Is there a formula that can find the cell corresponding to a trans beecher	by Ken Johnson	6	519
Can you use CountA to add multiple items within one cell? Teacher in a quandry	by Teethless mama	4	805
subtotals Carla	by JMB	1	309
vlookup, match? what do I use? Sojo	by PapaDos	2	388
if=0 then n/a if<0 leave the value in the cell Hoofnagle	by Teethless mama	2	3,916
Sorting by Sections Problem Freshman	by Max	7	473
Auto data fill in Slashman	by Slashman	3	326
Auto cell move Slashman	by Slashman	2	374
Automatic update of date once, then remains static mfdc_frank	by Gord Dibben	5	1,010
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	345
formulas KC	by Don Guillett	1	340
formula to roundup to the nearest 9 susiegirl	by Epinn	8	3,105
Running total within a cell bob2525	by Gord Dibben	3	710
How do I use a linking formula in cell with many words? tmvigil95	by tmvigil95	2	345
How do I not show certain Letters in a range of cells in excel? Taryn McGregor	by Jim Cone	2	633
Control Sheet Cedrun	by Cedrun	2	383
Min Max What's Wrong? shep	by shep	4	506
convert dollars to pounds using a lookup formula cuffie	by cuffie	4	2,099
Shortcut toggle between worksheets in the same workbook? Chris	by Marcelo	3	1,455
How do I hide a row in excel if a certain other cell is populated Teresa Hoffman	by Carim	1	552
copying workbooks Nadji	by Marcelo	3	361
seperate a value in a text string T Miller	by Ron Rosenfeld	10	722
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	704
VDB Depreciation Question KRP	by KRP	0	519
Match function problem [email protected]	by Jim Thomlinson	3	580
sort alpa descending 'cell size' error clubfisher	by David Biddulph	4	399
Lookup returns blank if no match Nolene	by Nolene	9	1,656
Need help with LEN? function Ron	by Ron	4	360
Creating a Warning window PCStechnical	by PCStechnical	2	419
How do I make the 1st column constant in viewing a wide spreadshee Greg	by Greg	4	1,361
How do I convert from Euros to USDollars? It's not in EUROCONVERT EurosDollars	by Dave F	1	1,162
dependent drop down - repeat values mcmanusb	by mcmanusb	5	802
Reference a list to perform a function in Excel matt ashley	by Bill Pfister	1	571
Two questions, how do I disable ver 4 macros and how do I make radial buttons like this? Kelvin Beaton	by Kelvin Beaton	4	711
Spreading 1 large number evenly into several cells Dos Equis	by Dos Equis	0	1,049
Creating a formula which multiplies by two seperate %'s Dos Equis	by Dos Equis	11	662
Copying a region in excel results in the entire worksheet being pa THT	by THT	0	531
cell format question Todd	by David Billigmeier	1	411
How do you set up range names, name formulas DonF	by DonF	0	514
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	983
URGENT HELP PLEASE triffidbook	by SteveW	3	429
Find a Value by interpolation from a table of x and y values BuickGN87	by vezerid	3	1,087
View formula result instead of formula tina	by Nat	4	443
How do I model a Paretian Distribution in Excel? NickPadgett	by Jerry W. Lewis	4	1,284
adding like items from different sheets RPW	by RPW	0	673
Moving to Previous Worksheet Zootie	by PCLIVE	1	619
Using INDEX function to return array row. RBI	by vezerid	1	1,210
moving filtered data between worksheets automatically dweezy	by dweezy	3	728
embedded presentation graphs in excel don't update, tables do sid	by sid	0	576
Vlookup/Match/Index/Small - I think The Novice	by Dave F	1	862
view value instead of formula tina	by SteveW	1	393
dash showtunegirl	by SteveW	3	547
Weakness in the Drag Function of Excel 2007 (Beta) Mr. Low	by Mr. Low	0	884
Reverse NETWORKDAYS function? [email protected]	by [email protected]	4	2,385
Need to condense my formula summing many values over many sheets Andy777	by CLR	5	658
Scales Nymand	by SteveW	1	487
help needed urgently wardah	by Stefi	2	455
Formula help Anthony	by Anthony	6	457
Median array formula Ciara	by Ciara	1	1,403
How do I permanently remove Template Help? Mary H	by Horrgakx	1	551
Automating Polynomial Order Selection in Linest Nick Flyger	by [email protected]	3	1,858
Reporting using PivotTable [email protected]	by Roger Govier	1	532
moving source cell in excel k9kapers	by Alok	5	1,357
MOD J.H.	by Dana	15	1,439
How do I delete an excel list? Office-novice	by Dave Peterson	1	323
if in conditional formatting DKY	by Dave Peterson	6	501
Cross referencing sb1920alk	by Max	1	664
Address block carriage returns not correct Bill	by Max	3	666