Excel Worksheet Functions - Page 1039

Thread / Thread Starter	Last Post	Replies	Views
Stoping users pasting formulas into cells confused	by confused	0	670
how to set up Bowls league 12 teams points and shot difference Mel	by Mel	0	534
Cut links between worksheets in same workbook Houndstooth	by cscorp	1	823
jump to hyperlink, extract value at specific destination in file Philip	by cscorp	1	868
excel rurubi	by cscorp	1	449
How do I set up a workbook so changing Sheet1 changes all sheets? rach1027	by cscorp	1	520
formula Spsuston	by cscorp	1	366
Auto Calculating Time Sheet Durocdog	by cscorp	1	1,165
Split PN and Price Andri	by xlbo	2	375
How do I refer a Range to a Cell Mal	by Mal	6	1,032
How to reference a cell in MS Excel that already has a SUM value? AlyG	by Tim Otero	1	373
Sum of ranks Tim Otero	by Tim Otero	11	1,380
Worksheet Name solotoo	by solotoo	6	415
Adding up Sums AlyG	by mangesh_yadav	3	469
Autocalculate does not work mdeanda	by excelthoughts	1	407
Formula preceded by + sign Roland H.	by JMB	3	647
sumif Q Mark Dvorkin	by Peo Sjoblom	1	368
What worksheet function will formatlessly copy cell contents? MargueriteL	by Biff	1	621
index random questions mcmil	by RagDyer	6	370
How do I Concatenate these Dynamic Rows AwkSed2Excel	by AwkSed2Excel	7	839
HOW DO I CONVERT ANGLES TO DECIMAL DEGREES LTHSATT	by JE McGimpsey	1	1,250
Problem with XIRR function returning #NUM! Francois_Provost	by Myrna Larson	3	1,683
how do I remove empty spaces trailing a text string? Need_Help	by CLR	2	1,223
Formula help! KimberlyC	by JE McGimpsey	2	353
Time scheduling Geoff	by Geoff	0	412
Sumproduct with Date column JerryS	by Don Guillett	2	598
Insert comment in protected worksheet The Tuner	by Dave Peterson	2	1,274
SUNPRODUCT and COUNTIF JerryS	by Vasant Nanavati	2	481
Copy 1 Sheet to Another Dar	by CLR	3	804
Using sumproduct to count number by date JerryS	by JerryS	2	843
how do i set up an expiry date in an Excel worksheet AR Voice	by Andy Wiggins	2	1,355
Excel help betok	by Nick Hodge	1	389
Drop down list with an if statement khelton	by Andy Wiggins	2	720
Assign a color to a cell Junkyard Engineer	by Chip Pearson	1	640
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	630
COUNTIF Q John	by Leo Heuser	4	410
Statistically Confident Tim Hagedorn	by Tim Hagedorn	0	432
Formula checking multiple worksheets sonic-the-mouse	by Biff	1	546
Macro Filldown Hirsch	by Hirsch	4	510
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	461
Unhiding worksheets Nic7602	by Rob	2	429
How do I do a conditional format for numbers bowada	by bowada	2	614
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,660
If statement using multiple conditions SCOOBYDOO	by Duke Carey	1	819
need function to sum top ranking items in list QuantumPion	by QuantumPion	13	1,151
chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005 Jonny1975	by Mangesh Yadav	1	546
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	482
Further Question about Transpose Florence	by Max	3	477
how to subtract time cards in minutes in excel excelsior	by Biff	1	753
Cannot save external links? KRAMER	by KRAMER	0	528
How can I return a thank you note Cactus	by Max	1	831
random number results mcmil	by Ragdyer	5	531
If function that returns value in a cell. rayteach	by Ragdyer	4	795
sort data in cells in a row Cactus	by Max	3	597
Calculating Profit and Loss in one column Dismal	by Dismal	0	726
extracting text data in a cell gareth1983	by gareth1983	2	629
I know what I need but dont know how to do it solar_eclipse2	by solar_eclipse2	5	494
is there a 'format painter' hotkey? david	by Peo Sjoblom	1	856
Why do we start the formula with + or - Jim333	by Myrna Larson	7	685
Printing sheets. Dabber	by David McRitchie	2	548
Formula checking multiple worksheets sonic-the-mouse	by Domenic	2	3,359
FIND David Eastham	by David McRitchie	2	425
using wizard and conditional sum lloyd8156	by Ragdyer	1	521
SORTING DATA Ali	by Ali	2	372
How to do more then one vlookup? WTG	by Max	3	319
VB script help..please !! Anthony	by David McRitchie	2	525
Returning with cell on right/left of a reference Hellion	by Ron de Bruin	1	480