Excel Worksheet Functions - Page 1065

Thread / Thread Starter	Last Post	Replies	Views
any idea?? NF	by David McRitchie	1	559
Is there a keyboard shortcut to center data in a cell? Phil_K	by David McRitchie	1	1,123
entering rates five % higher hop 4	by happy4	5	293
Concantenate Text with numbers with fixed form sunslight	by sunslight	2	764
Adding numbers in a column that have 3 decimal places KimberlyC	by Peo Sjoblom	4	803
The reference changes when I insert a row?!?! Help ntscott	by Ken Wright	3	436
Want VLookup to Return the row above JoOwl0	by Ron Rosenfeld	8	1,327
Why is coditional formatting not accessable? dgams	by Gord Dibben	3	469
I want to use the MATCH function with the AVERAGE function but I . Miguel	by Miguel	2	1,091
Selecting ALL names when using Insert/Names/Apply Mike	by Gord Dibben	3	655
Is the a better way than LOOKUP? John	by John	3	375
Help with using a cell in function mario	by Gord Dibben	3	398
.pdf hyperlink Robert Osuna Baez	by Roberto Osuna Baez	2	370
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,221
Not summing a columns? Nicole	by David McRitchie	2	762
Function to set borders of cell Des	by David McRitchie	1	610
Creating fixture lists Frazer Snowdon	by Frazer Snowdon	11	1,864
Sorting a portion of a range gbeard	by Gary Brown	1	477
Sum of dates Tanya	by Gary Brown	1	417
selecting days of week using a formula in spreadsheets Terry	by Terry	6	795
How to get difference in hours Akhilesh Dalia	by Peo Sjoblom	6	807
Need to switch 2 columns with each other...please help Buckwheat	by Biff	2	382
HELP SVP- EIYHER OR ENTRY OR LOOKUP Ronald Cayne	by Biff	1	411
How to remove duplicates from a list and copy new list to new colu Chance	by Max	2	1,696
Time Calculations Paul T	by Biff	1	554
How can I get automatic row height for merged cells with text wra. ConfusedLady	by RagDyer	1	694
need help with a simple time formula wize	by Ron Coderre	2	484
Open dialog box size Buddy_in_San_Diego	by Gord Dibben	5	932
Date Defaulting Heather	by Bob Phillips	2	585
Sum only last X cells Nacho	by Bob Phillips	4	958
Replacing MCONCAT with CONCAT_RANGE (UDF) carl	by Bernie Deitrick	8	745
VLOOKUP - results do not appear in cell denvertique	by CLR	1	853
Accumulation Paul	by JE McGimpsey	1	803
Calculates Qty Received Andri	by LanceB	10	976
function does not work properly lukiedukie	by Gord Dibben	3	696
function does not recalculate sum lukiedukie	by Gord Dibben	1	397
Using Excel converts number to english text Lionel Lim (Malaysia)	by Gord Dibben	1	1,502
Default to beginning of month Heather	by Heather	4	603
Autofill data in specific blank cells Mr. G.	by Mr. G.	0	762
Allow (validation) except mfebinger	by Debra Dalgleish	1	383
Protected Worksheets Nikki Patel	by Nikki Patel	0	465
Copy cells into range of cells until cell change mdeanda	by bj	1	1,601
SUMIF or SUMNPRODUCT Help LOU	by Bob Phillips	4	620
IF function Tuesfutu	by bj	1	433
vlookup for multiple columns [email protected]	by [email protected]	0	504
The UNPROTECT option Unprotect option inactive	by PCLIVE	3	706
compare the first column and concatenate the second column smb2000user100	by smb2000user100	0	467
looping a calculation until workbook closes tjb	by tjb	0	514
decimal place and merging to word doc. elmurado	by JE McGimpsey	3	653
Inserting/Deleting Spaces carl	by JulieD	4	474
Add two cell values, retain it, and add another value Jay	by Jay	7	544
If function Rainy	by Rainy	0	401
Formatting issue adin	by adin	10	986
countif question Tuc	by Tuc	1	499
Formula for button name Adam	by Otto Moehrbach	1	438
Help with OR statement MrMike	by Duke Carey	2	332
comare and copy smb2000user100	by smb2000user100	3	314
Display Format with Text & Formula StephanieH	by JulieD	3	624
i am unable to link between two files in Excel, why? ExcelUser	by JulieD	1	978
Stripping out imbedded spaces in a cell/row Tom	by Tom	8	1,108
How can I make a checkbox create a value? cookin_dad	by PCLIVE	3	642
HOW DO I COPY A CONDITIONAL SUM (sumif) AND EDIT IT? (THE SUM NEV. ailsa.fraser	by ailsa.fraser	5	816
Cells not updating Shaggyjh	by Shaggyjh	4	772
Autofilter hangup Fred Harrington	by Fred Harrington	0	449
Replace a ; with a , and a space Jo	by SpudHutton	1	447
Print Rows to repeat at the bottom RAJEEV CHADHA	by RAJEEV CHADHA	0	930
Same cell added to master summary sheet Bruce Fry	by Bruce Fry	0	819
CONVERTING NUMBER TO TEXT RAJEEV CHADHA	by RAJEEV CHADHA	3	420
Excel2000 A working formula has {braces} which disappear. Why? SpudHutton	by Bob Phillips	3	715
Can someone please help? JerryCLT	by Duke Carey	3	331
Divide by Zero rocky	by Duke Carey	3	1,100
Pivot ranges and INDIRECT daveydave60	by Debra Dalgleish	1	1,096
How to lookup a value from a ramge of data. Eg Column C Row D? ST	by Ron Rosenfeld	4	522
Need to have multiple worksheets use a single worksheet storm5527	by Duke Carey	1	842