Excel Worksheet Functions - Page 1065

Thread / Thread Starter	Last Post	Replies	Views
any idea?? NF	by David McRitchie	1	527
Is there a keyboard shortcut to center data in a cell? Phil_K	by David McRitchie	1	1,102
entering rates five % higher hop 4	by happy4	5	284
Concantenate Text with numbers with fixed form sunslight	by sunslight	2	726
Adding numbers in a column that have 3 decimal places KimberlyC	by Peo Sjoblom	4	772
The reference changes when I insert a row?!?! Help ntscott	by Ken Wright	3	425
Want VLookup to Return the row above JoOwl0	by Ron Rosenfeld	8	1,304
Why is coditional formatting not accessable? dgams	by Gord Dibben	3	450
I want to use the MATCH function with the AVERAGE function but I . Miguel	by Miguel	2	1,038
Selecting ALL names when using Insert/Names/Apply Mike	by Gord Dibben	3	622
Is the a better way than LOOKUP? John	by John	3	326
Help with using a cell in function mario	by Gord Dibben	3	382
.pdf hyperlink Robert Osuna Baez	by Roberto Osuna Baez	2	362
Change the font case of all cells in the worksheet to uppercase? S. Avila	by JulieD	4	836
Insert rows, keep a formula? tb	by David McRitchie	1	2,190
Not summing a columns? Nicole	by David McRitchie	2	749
Function to set borders of cell Des	by David McRitchie	1	576
Creating fixture lists Frazer Snowdon	by Frazer Snowdon	11	1,798
Sorting a portion of a range gbeard	by Gary Brown	1	456
Sum of dates Tanya	by Gary Brown	1	396
selecting days of week using a formula in spreadsheets Terry	by Terry	6	764
How to get difference in hours Akhilesh Dalia	by Peo Sjoblom	6	761
Need to switch 2 columns with each other...please help Buckwheat	by Biff	2	375
HELP SVP- EIYHER OR ENTRY OR LOOKUP Ronald Cayne	by Biff	1	393
How to remove duplicates from a list and copy new list to new colu Chance	by Max	2	1,629
Time Calculations Paul T	by Biff	1	546
How can I get automatic row height for merged cells with text wra. ConfusedLady	by RagDyer	1	664
need help with a simple time formula wize	by Ron Coderre	2	453
Open dialog box size Buddy_in_San_Diego	by Gord Dibben	5	903
Date Defaulting Heather	by Bob Phillips	2	566
Sum only last X cells Nacho	by Bob Phillips	4	935
Replacing MCONCAT with CONCAT_RANGE (UDF) carl	by Bernie Deitrick	8	734
VLOOKUP - results do not appear in cell denvertique	by CLR	1	813
Accumulation Paul	by JE McGimpsey	1	754
Calculates Qty Received Andri	by LanceB	10	952
function does not work properly lukiedukie	by Gord Dibben	3	665
function does not recalculate sum lukiedukie	by Gord Dibben	1	383
Using Excel converts number to english text Lionel Lim (Malaysia)	by Gord Dibben	1	1,463
Default to beginning of month Heather	by Heather	4	576
Autofill data in specific blank cells Mr. G.	by Mr. G.	0	719
Allow (validation) except mfebinger	by Debra Dalgleish	1	375
Protected Worksheets Nikki Patel	by Nikki Patel	0	450
Copy cells into range of cells until cell change mdeanda	by bj	1	1,557
SUMIF or SUMNPRODUCT Help LOU	by Bob Phillips	4	567
IF function Tuesfutu	by bj	1	426
vlookup for multiple columns [email protected]	by [email protected]	0	478
The UNPROTECT option Unprotect option inactive	by PCLIVE	3	695
compare the first column and concatenate the second column smb2000user100	by smb2000user100	0	447
looping a calculation until workbook closes tjb	by tjb	0	477
decimal place and merging to word doc. elmurado	by JE McGimpsey	3	636
Inserting/Deleting Spaces carl	by JulieD	4	457
Add two cell values, retain it, and add another value Jay	by Jay	7	531
If function Rainy	by Rainy	0	388
Formatting issue adin	by adin	10	950
countif question Tuc	by Tuc	1	478
Formula for button name Adam	by Otto Moehrbach	1	428
Help with OR statement MrMike	by Duke Carey	2	327
comare and copy smb2000user100	by smb2000user100	3	305
Display Format with Text & Formula StephanieH	by JulieD	3	599
i am unable to link between two files in Excel, why? ExcelUser	by JulieD	1	961
Stripping out imbedded spaces in a cell/row Tom	by Tom	8	1,092
How can I make a checkbox create a value? cookin_dad	by PCLIVE	3	625
HOW DO I COPY A CONDITIONAL SUM (sumif) AND EDIT IT? (THE SUM NEV. ailsa.fraser	by ailsa.fraser	5	769
Cells not updating Shaggyjh	by Shaggyjh	4	749
Autofilter hangup Fred Harrington	by Fred Harrington	0	432
Replace a ; with a , and a space Jo	by SpudHutton	1	424
Print Rows to repeat at the bottom RAJEEV CHADHA	by RAJEEV CHADHA	0	906
Same cell added to master summary sheet Bruce Fry	by Bruce Fry	0	758
CONVERTING NUMBER TO TEXT RAJEEV CHADHA	by RAJEEV CHADHA	3	407
Excel2000 A working formula has {braces} which disappear. Why? SpudHutton	by Bob Phillips	3	690
Can someone please help? JerryCLT	by Duke Carey	3	326
Divide by Zero rocky	by Duke Carey	3	1,075
Pivot ranges and INDIRECT daveydave60	by Debra Dalgleish	1	1,087
How to lookup a value from a ramge of data. Eg Column C Row D? ST	by Ron Rosenfeld	4	496
Need to have multiple worksheets use a single worksheet storm5527	by Duke Carey	1	806