Excel Worksheet Functions - Page 1039

Thread / Thread Starter	Last Post	Replies	Views
Stoping users pasting formulas into cells confused	by confused	0	663
how to set up Bowls league 12 teams points and shot difference Mel	by Mel	0	533
Cut links between worksheets in same workbook Houndstooth	by cscorp	1	819
jump to hyperlink, extract value at specific destination in file Philip	by cscorp	1	868
excel rurubi	by cscorp	1	447
How do I set up a workbook so changing Sheet1 changes all sheets? rach1027	by cscorp	1	518
formula Spsuston	by cscorp	1	366
Auto Calculating Time Sheet Durocdog	by cscorp	1	1,162
Split PN and Price Andri	by xlbo	2	371
How do I refer a Range to a Cell Mal	by Mal	6	1,028
How to reference a cell in MS Excel that already has a SUM value? AlyG	by Tim Otero	1	372
Sum of ranks Tim Otero	by Tim Otero	11	1,378
Worksheet Name solotoo	by solotoo	6	413
Adding up Sums AlyG	by mangesh_yadav	3	465
Autocalculate does not work mdeanda	by excelthoughts	1	407
Formula preceded by + sign Roland H.	by JMB	3	621
sumif Q Mark Dvorkin	by Peo Sjoblom	1	368
What worksheet function will formatlessly copy cell contents? MargueriteL	by Biff	1	617
index random questions mcmil	by RagDyer	6	361
How do I Concatenate these Dynamic Rows AwkSed2Excel	by AwkSed2Excel	7	834
HOW DO I CONVERT ANGLES TO DECIMAL DEGREES LTHSATT	by JE McGimpsey	1	1,246
Problem with XIRR function returning #NUM! Francois_Provost	by Myrna Larson	3	1,681
how do I remove empty spaces trailing a text string? Need_Help	by CLR	2	1,221
Formula help! KimberlyC	by JE McGimpsey	2	350
Time scheduling Geoff	by Geoff	0	412
Sumproduct with Date column JerryS	by Don Guillett	2	594
Insert comment in protected worksheet The Tuner	by Dave Peterson	2	1,273
SUNPRODUCT and COUNTIF JerryS	by Vasant Nanavati	2	480
Copy 1 Sheet to Another Dar	by CLR	3	800
Using sumproduct to count number by date JerryS	by JerryS	2	835
how do i set up an expiry date in an Excel worksheet AR Voice	by Andy Wiggins	2	1,352
Excel help betok	by Nick Hodge	1	381
Drop down list with an if statement khelton	by Andy Wiggins	2	719
Assign a color to a cell Junkyard Engineer	by Chip Pearson	1	639
I wish to have multiple column widths for a the same column. Gary Dikin	by RagDyer	4	771
MAX formula with Associated DATE Patrick White	by Aladin Akyurek	8	343
Columns creation Hacos	by Bob Umlas	1	364
VlLOOKUP function with MATCH Amnon Wilensky	by FxM	2	568
vlook up and if formula Stuart	by Leo Heuser	5	626
COUNTIF Q John	by Leo Heuser	4	406
Statistically Confident Tim Hagedorn	by Tim Hagedorn	0	428
Formula checking multiple worksheets sonic-the-mouse	by Biff	1	543
Macro Filldown Hirsch	by Hirsch	4	506
Formatting a cell BKT Hopeful	by Alan	1	328
VBA Conditional Formatting has mind of it's own! Yogi_Bear_79	by Yogi_Bear_79	0	469
Frequently used file suddenly becomes 'not a valid file name' Dirk Bordet	by Dirk Bordet	0	455
Unhiding worksheets Nic7602	by Rob	2	429
How do I do a conditional format for numbers bowada	by bowada	2	609
Conditional Formatting Alastair Brannen	by JE McGimpsey	1	490
Recurring annual events using a specific date as a trigger date Bamboozled	by Duke Carey	1	1,653
If statement using multiple conditions SCOOBYDOO	by Duke Carey	1	817
need function to sum top ranking items in list QuantumPion	by QuantumPion	13	1,149
chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005 Jonny1975	by Mangesh Yadav	1	545
The 'Recently used file list' does not show up under the 'File' menu. David F	by Bob Raines	4	865
How do I specify cells to return a result in a quadratic? Aerozona	by Mangesh Yadav	3	481
Further Question about Transpose Florence	by Max	3	472
how to subtract time cards in minutes in excel excelsior	by Biff	1	748
Cannot save external links? KRAMER	by KRAMER	0	526
How can I return a thank you note Cactus	by Max	1	829
random number results mcmil	by Ragdyer	5	530
If function that returns value in a cell. rayteach	by Ragdyer	4	785
sort data in cells in a row Cactus	by Max	3	594
Calculating Profit and Loss in one column Dismal	by Dismal	0	722
extracting text data in a cell gareth1983	by gareth1983	2	626
I know what I need but dont know how to do it solar_eclipse2	by solar_eclipse2	5	493
is there a 'format painter' hotkey? david	by Peo Sjoblom	1	850
Why do we start the formula with + or - Jim333	by Myrna Larson	7	683
Printing sheets. Dabber	by David McRitchie	2	543
Formula checking multiple worksheets sonic-the-mouse	by Domenic	2	3,335
FIND David Eastham	by David McRitchie	2	424
using wizard and conditional sum lloyd8156	by Ragdyer	1	521
SORTING DATA Ali	by Ali	2	367
How to do more then one vlookup? WTG	by Max	3	318
VB script help..please !! Anthony	by David McRitchie	2	519
Returning with cell on right/left of a reference Hellion	by Ron de Bruin	1	478