Excel Worksheet Functions - Page 80

Thread / Thread Starter	Last Post	Replies	Views
How do you add one date to another? I type in 1/31/05 in A1 and I. JPreeshl	by CLR	2	414
iF STATEMENTS WITHIN CONDITIONAL FORMATS E Halliday	by Max	4	885
Converting time figures into 24-hour format & sorting them... Clint Johnson	by Fred Smith	1	1,863
drop down menu length James	by Debra Dalgleish	5	489
How do I turn off ALL autoformat in Excel ? (I can't even type "J. Dave a.k.a. Technophobe	by Myrna Larson	2	1,037
Pivot table refresh Excel GuRu	by Excel GuRu	2	969
Remove complete row containing a single word Kanga 85	by Kanga 85	4	394
Sort Function Rahul	by Rahul	5	550
Excel Function DSS	by ww	2	369
can excel calculate a letter kristi _ 71	by Biff	7	756
Pivot table copy and paste yllee70	by yllee70	0	810
Formula Help...I tried but failed! flyguykorea	by flyguykorea	3	539
Compare ranges different size markx	by markx	3	875
Colors as text Dan	by Bob Phillips	3	430
How do I enter a formula in a cell so that letters= a number i.e.. Alex	by Jason Morin	1	611
Calendar philstandish	by Bob Phillips	1	409
How do I join a filename and a cellreference, by just filling in . RenÃ©	by Fredrik Wahlgren	1	547
vlookup & conditional formatting Emma	by Emma	5	1,217
Straighten Me Out Please Phillip Crum	by Dana DeLouis	3	432
Auto number w/ different letter-number combos in same column Colleen B	by Colleen B	2	874
create menus in excel worksheet Anthony	by JulieD	1	1,122
Checking excel for errors/inconsistencies markx	by JulieD	1	687
list values equal in 2 worksheets? NEVA LOCKETT	by NL	2	714
Portion of concatenate formula to have different color and font fo Colleen B	by Peo Sjoblom	1	717
excel sorting Baba	by JulieD	7	713
dynamic range / offset Jeff	by Jeff	2	668
formula to set up dynamic range in names Jeff	by Jeff	0	962
What function do I use to convert "time" to minutes? petek	by Peo Sjoblom	1	650
Is there a way to calculate business working days between dates i. hjyoungii	by Bob Phillips	2	1,048
IF function help needed jmcclain	by Jeff	2	606
how do i sort excel worksheets by alphabetical order? Birichica	by Bernie Deitrick	4	909
Avearging columns with less than (<) text entries KIM	by KIM	14	1,043
Is there a standard deviation calculation in Excel? panducci	by Jason Morin	2	1,205
Sorting data by last to digits Brian	by Brian	2	500
Auto Protect workbook with password upon opening Brian	by Brian	0	1,308
How to make a chart in excel help	by help	0	504
colors in excel formulas??? cari	by Jason Morin	1	557
insert from previous worksheets melzki	by melzki	2	407
purchase order counter in excel purchase order template Brandy@baoco	by Brandy@baoco	0	1,721
SUMIF question CarlosAntenna	by CarlosAntenna	2	581
How do I automatically (using a formula like =SHEET1!A$1) referen. Rynardt	by Per Erik Midtrød	1	570
If function clarification jmcclain	by BobT	5	541
creating a formula Pamela	by Pamela	3	461
Sort or Filter option? Mcobra41	by BobT	3	1,651
Data Table michelle	by michelle	0	453
What is invisible in a cell?l Kanga 85	by Myrna Larson	4	677
need to develop a table to count in binary, etc. using excel xp waynebosz	by waynebosz	0	734
need to develop a table to count in binary using excel xp waynebosz	by waynebosz	0	600
I need to develop a table to count in binary using excel xp waynebosz	by waynebosz	0	694
Rank fx - Fill Down? Steve B	by Jason Morin	1	877
conditional formatting-shading Shooter	by Jason Morin	2	512
I want to print out the sheet tabs (sheet names) Sundus	by Gord Dibben	3	1,131
In Excel what can I use for the XINDEX function from Lotus 123? Val from ICB	by Ken Wright	2	843
I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS FORMULA	by FORMULA	4	1,022
Summing part of an Alpha Numeric String Arturo	by Arturo	2	692
Winnowing a list NL	by NL	6	356
Counting... Patrick G	by Steve	3	663
Convert 20050118 to a working date field Jessica	by Ken Wright	7	759
Need Formula to display pivot table source data Don S	by Debra Dalgleish	3	2,212
How do i transfer certain lines from one list to another matt_hull1979	by Max	3	421
Have a Pivot Table Include a "% of an item" [email protected]	by Debra Dalgleish	1	710
Complex(?) Edit Kanga 85	by Kanga 85	3	347
Can I increase row capacity beyond 65536 rows Trish	by Harlan Grove	2	845
function needed David Harrison	by [email protected]	1	590
Calculate Years of Service Jerry	by Gilles Desjardins	5	1,846
Ref to Tab Name briank	by Harlan Grove	3	425
Formula doesnt work Kevin	by Kevin	2	596
How to have multiple columns in pivot table data area? mitch1962	by Debra Dalgleish	1	1,350
Bringing additional information in with combo box selection JD	by Debra Dalgleish	1	464
Vlook up or index match jerry	by Curt	1	529
Pesky VLookup !!! Lacklustre	by Curt	4	619
Is there a way to automatically add columns as the data updates? Eric D.	by Eric D.	1	624
find data from other sheet Jaladino	by Biff	1	707
Using COUNTIF with 2 criteria - SUMPRODUCT? Mike R.	by Mike R.	2	846
every nth cell by columns not rows.... Sampson	by Biff	1	594