Excel Worksheet Functions - Page 1065

Thread / Thread Starter	Last Post	Replies	Views
any idea?? NF	by David McRitchie	1	568
Is there a keyboard shortcut to center data in a cell? Phil_K	by David McRitchie	1	1,129
entering rates five % higher hop 4	by happy4	5	296
Concantenate Text with numbers with fixed form sunslight	by sunslight	2	775
Adding numbers in a column that have 3 decimal places KimberlyC	by Peo Sjoblom	4	812
The reference changes when I insert a row?!?! Help ntscott	by Ken Wright	3	450
Want VLookup to Return the row above JoOwl0	by Ron Rosenfeld	8	1,338
Why is coditional formatting not accessable? dgams	by Gord Dibben	3	479
I want to use the MATCH function with the AVERAGE function but I . Miguel	by Miguel	2	1,095
Selecting ALL names when using Insert/Names/Apply Mike	by Gord Dibben	3	666
Is the a better way than LOOKUP? John	by John	3	388
Help with using a cell in function mario	by Gord Dibben	3	412
.pdf hyperlink Robert Osuna Baez	by Roberto Osuna Baez	2	380
Change the font case of all cells in the worksheet to uppercase? S. Avila	by JulieD	4	851
Insert rows, keep a formula? tb	by David McRitchie	1	2,232
Not summing a columns? Nicole	by David McRitchie	2	765
Function to set borders of cell Des	by David McRitchie	1	621
Creating fixture lists Frazer Snowdon	by Frazer Snowdon	11	1,867
Sorting a portion of a range gbeard	by Gary Brown	1	484
Sum of dates Tanya	by Gary Brown	1	429
selecting days of week using a formula in spreadsheets Terry	by Terry	6	799
How to get difference in hours Akhilesh Dalia	by Peo Sjoblom	6	809
Need to switch 2 columns with each other...please help Buckwheat	by Biff	2	394
HELP SVP- EIYHER OR ENTRY OR LOOKUP Ronald Cayne	by Biff	1	412
How to remove duplicates from a list and copy new list to new colu Chance	by Max	2	1,710
Time Calculations Paul T	by Biff	1	565
How can I get automatic row height for merged cells with text wra. ConfusedLady	by RagDyer	1	707
need help with a simple time formula wize	by Ron Coderre	2	494
Open dialog box size Buddy_in_San_Diego	by Gord Dibben	5	942
Date Defaulting Heather	by Bob Phillips	2	599
Sum only last X cells Nacho	by Bob Phillips	4	972
Replacing MCONCAT with CONCAT_RANGE (UDF) carl	by Bernie Deitrick	8	757
VLOOKUP - results do not appear in cell denvertique	by CLR	1	862
Accumulation Paul	by JE McGimpsey	1	812
Calculates Qty Received Andri	by LanceB	10	985
function does not work properly lukiedukie	by Gord Dibben	3	708
function does not recalculate sum lukiedukie	by Gord Dibben	1	409
Using Excel converts number to english text Lionel Lim (Malaysia)	by Gord Dibben	1	1,506
Default to beginning of month Heather	by Heather	4	610
Autofill data in specific blank cells Mr. G.	by Mr. G.	0	774
Allow (validation) except mfebinger	by Debra Dalgleish	1	398
Protected Worksheets Nikki Patel	by Nikki Patel	0	465
Copy cells into range of cells until cell change mdeanda	by bj	1	1,607
SUMIF or SUMNPRODUCT Help LOU	by Bob Phillips	4	623
IF function Tuesfutu	by bj	1	445
vlookup for multiple columns [email protected]	by [email protected]	0	506
The UNPROTECT option Unprotect option inactive	by PCLIVE	3	710
compare the first column and concatenate the second column smb2000user100	by smb2000user100	0	469
looping a calculation until workbook closes tjb	by tjb	0	520
decimal place and merging to word doc. elmurado	by JE McGimpsey	3	657
Inserting/Deleting Spaces carl	by JulieD	4	490
Add two cell values, retain it, and add another value Jay	by Jay	7	556
If function Rainy	by Rainy	0	410
Formatting issue adin	by adin	10	988
countif question Tuc	by Tuc	1	511
Formula for button name Adam	by Otto Moehrbach	1	451
Help with OR statement MrMike	by Duke Carey	2	342
comare and copy smb2000user100	by smb2000user100	3	325
Display Format with Text & Formula StephanieH	by JulieD	3	626
i am unable to link between two files in Excel, why? ExcelUser	by JulieD	1	989
Stripping out imbedded spaces in a cell/row Tom	by Tom	8	1,119
How can I make a checkbox create a value? cookin_dad	by PCLIVE	3	650
HOW DO I COPY A CONDITIONAL SUM (sumif) AND EDIT IT? (THE SUM NEV. ailsa.fraser	by ailsa.fraser	5	822
Cells not updating Shaggyjh	by Shaggyjh	4	782
Autofilter hangup Fred Harrington	by Fred Harrington	0	450
Replace a ; with a , and a space Jo	by SpudHutton	1	459
Print Rows to repeat at the bottom RAJEEV CHADHA	by RAJEEV CHADHA	0	938
Same cell added to master summary sheet Bruce Fry	by Bruce Fry	0	828
CONVERTING NUMBER TO TEXT RAJEEV CHADHA	by RAJEEV CHADHA	3	430
Excel2000 A working formula has {braces} which disappear. Why? SpudHutton	by Bob Phillips	3	723
Can someone please help? JerryCLT	by Duke Carey	3	338
Divide by Zero rocky	by Duke Carey	3	1,107
Pivot ranges and INDIRECT daveydave60	by Debra Dalgleish	1	1,107
How to lookup a value from a ramge of data. Eg Column C Row D? ST	by Ron Rosenfeld	4	533
Need to have multiple worksheets use a single worksheet storm5527	by Duke Carey	1	850