Excel Worksheet Functions - Page 1039

Thread / Thread Starter	Last Post	Replies	Views
Stoping users pasting formulas into cells confused	by confused	0	708
how to set up Bowls league 12 teams points and shot difference Mel	by Mel	0	547
Cut links between worksheets in same workbook Houndstooth	by cscorp	1	895
jump to hyperlink, extract value at specific destination in file Philip	by cscorp	1	900
excel rurubi	by cscorp	1	466
How do I set up a workbook so changing Sheet1 changes all sheets? rach1027	by cscorp	1	533
formula Spsuston	by cscorp	1	377
Auto Calculating Time Sheet Durocdog	by cscorp	1	1,190
Split PN and Price Andri	by xlbo	2	380
How do I refer a Range to a Cell Mal	by Mal	6	1,048
How to reference a cell in MS Excel that already has a SUM value? AlyG	by Tim Otero	1	383
Sum of ranks Tim Otero	by Tim Otero	11	1,421
Worksheet Name solotoo	by solotoo	6	422
Adding up Sums AlyG	by mangesh_yadav	3	478
Autocalculate does not work mdeanda	by excelthoughts	1	415
Formula preceded by + sign Roland H.	by JMB	3	683
sumif Q Mark Dvorkin	by Peo Sjoblom	1	377
What worksheet function will formatlessly copy cell contents? MargueriteL	by Biff	1	638
index random questions mcmil	by RagDyer	6	373
How do I Concatenate these Dynamic Rows AwkSed2Excel	by AwkSed2Excel	7	851
HOW DO I CONVERT ANGLES TO DECIMAL DEGREES LTHSATT	by JE McGimpsey	1	1,262
Problem with XIRR function returning #NUM! Francois_Provost	by Myrna Larson	3	1,707
how do I remove empty spaces trailing a text string? Need_Help	by CLR	2	1,248
Formula help! KimberlyC	by JE McGimpsey	2	360
Time scheduling Geoff	by Geoff	0	423
Sumproduct with Date column JerryS	by Don Guillett	2	612
Insert comment in protected worksheet The Tuner	by Dave Peterson	2	1,316
SUNPRODUCT and COUNTIF JerryS	by Vasant Nanavati	2	496
Copy 1 Sheet to Another Dar	by CLR	3	826
Using sumproduct to count number by date JerryS	by JerryS	2	862
how do i set up an expiry date in an Excel worksheet AR Voice	by Andy Wiggins	2	1,397
Excel help betok	by Nick Hodge	1	392
Drop down list with an if statement khelton	by Andy Wiggins	2	759
Assign a color to a cell Junkyard Engineer	by Chip Pearson	1	662
I wish to have multiple column widths for a the same column. Gary Dikin	by RagDyer	4	787
MAX formula with Associated DATE Patrick White	by Aladin Akyurek	8	348
Columns creation Hacos	by Bob Umlas	1	373
VlLOOKUP function with MATCH Amnon Wilensky	by FxM	2	583
vlook up and if formula Stuart	by Leo Heuser	5	644
COUNTIF Q John	by Leo Heuser	4	418
Statistically Confident Tim Hagedorn	by Tim Hagedorn	0	436
Formula checking multiple worksheets sonic-the-mouse	by Biff	1	561
Macro Filldown Hirsch	by Hirsch	4	522
Formatting a cell BKT Hopeful	by Alan	1	332
VBA Conditional Formatting has mind of it's own! Yogi_Bear_79	by Yogi_Bear_79	0	480
Frequently used file suddenly becomes 'not a valid file name' Dirk Bordet	by Dirk Bordet	0	476
Unhiding worksheets Nic7602	by Rob	2	440
How do I do a conditional format for numbers bowada	by bowada	2	650
Conditional Formatting Alastair Brannen	by JE McGimpsey	1	498
Recurring annual events using a specific date as a trigger date Bamboozled	by Duke Carey	1	1,696
If statement using multiple conditions SCOOBYDOO	by Duke Carey	1	834
need function to sum top ranking items in list QuantumPion	by QuantumPion	13	1,167
chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005 Jonny1975	by Mangesh Yadav	1	558
The 'Recently used file list' does not show up under the 'File' menu. David F	by Bob Raines	4	896
How do I specify cells to return a result in a quadratic? Aerozona	by Mangesh Yadav	3	503
Further Question about Transpose Florence	by Max	3	495
how to subtract time cards in minutes in excel excelsior	by Biff	1	774
Cannot save external links? KRAMER	by KRAMER	0	539
How can I return a thank you note Cactus	by Max	1	839
random number results mcmil	by Ragdyer	5	548
If function that returns value in a cell. rayteach	by Ragdyer	4	831
sort data in cells in a row Cactus	by Max	3	622
Calculating Profit and Loss in one column Dismal	by Dismal	0	739
extracting text data in a cell gareth1983	by gareth1983	2	657
I know what I need but dont know how to do it solar_eclipse2	by solar_eclipse2	5	502
is there a 'format painter' hotkey? david	by Peo Sjoblom	1	870
Why do we start the formula with + or - Jim333	by Myrna Larson	7	693
Printing sheets. Dabber	by David McRitchie	2	559
Formula checking multiple worksheets sonic-the-mouse	by Domenic	2	3,568
FIND David Eastham	by David McRitchie	2	433
using wizard and conditional sum lloyd8156	by Ragdyer	1	535
SORTING DATA Ali	by Ali	2	388
How to do more then one vlookup? WTG	by Max	3	326
VB script help..please !! Anthony	by David McRitchie	2	539
Returning with cell on right/left of a reference Hellion	by Ron de Bruin	1	497