Excel Worksheet Functions - Page 145

Thread / Thread Starter	Last Post	Replies	Views
Recurring annual events using a specific date as a trigger date Bamboozled	by Duke Carey	1	1,652
Conditional Formatting Alastair Brannen	by JE McGimpsey	1	490
How do I do a conditional format for numbers bowada	by bowada	2	609
Unhiding worksheets Nic7602	by Rob	2	429
Frequently used file suddenly becomes 'not a valid file name' Dirk Bordet	by Dirk Bordet	0	455
VBA Conditional Formatting has mind of it's own! Yogi_Bear_79	by Yogi_Bear_79	0	469
Formatting a cell BKT Hopeful	by Alan	1	328
Macro Filldown Hirsch	by Hirsch	4	506
Formula checking multiple worksheets sonic-the-mouse	by Biff	1	543
Statistically Confident Tim Hagedorn	by Tim Hagedorn	0	428
COUNTIF Q John	by Leo Heuser	4	406
vlook up and if formula Stuart	by Leo Heuser	5	626
VlLOOKUP function with MATCH Amnon Wilensky	by FxM	2	568
Columns creation Hacos	by Bob Umlas	1	364
MAX formula with Associated DATE Patrick White	by Aladin Akyurek	8	343
I wish to have multiple column widths for a the same column. Gary Dikin	by RagDyer	4	770
Assign a color to a cell Junkyard Engineer	by Chip Pearson	1	639
Drop down list with an if statement khelton	by Andy Wiggins	2	719
Excel help betok	by Nick Hodge	1	381
how do i set up an expiry date in an Excel worksheet AR Voice	by Andy Wiggins	2	1,352
Using sumproduct to count number by date JerryS	by JerryS	2	835
Copy 1 Sheet to Another Dar	by CLR	3	800
SUNPRODUCT and COUNTIF JerryS	by Vasant Nanavati	2	480
Insert comment in protected worksheet The Tuner	by Dave Peterson	2	1,273
Sumproduct with Date column JerryS	by Don Guillett	2	594
Time scheduling Geoff	by Geoff	0	410
Formula help! KimberlyC	by JE McGimpsey	2	350
how do I remove empty spaces trailing a text string? Need_Help	by CLR	2	1,221
Problem with XIRR function returning #NUM! Francois_Provost	by Myrna Larson	3	1,679
HOW DO I CONVERT ANGLES TO DECIMAL DEGREES LTHSATT	by JE McGimpsey	1	1,246
How do I Concatenate these Dynamic Rows AwkSed2Excel	by AwkSed2Excel	7	834
index random questions mcmil	by RagDyer	6	361
What worksheet function will formatlessly copy cell contents? MargueriteL	by Biff	1	617
sumif Q Mark Dvorkin	by Peo Sjoblom	1	364
Formula preceded by + sign Roland H.	by JMB	3	620
Autocalculate does not work mdeanda	by excelthoughts	1	407
Adding up Sums AlyG	by mangesh_yadav	3	465
Worksheet Name solotoo	by solotoo	6	413
Sum of ranks Tim Otero	by Tim Otero	11	1,378
How to reference a cell in MS Excel that already has a SUM value? AlyG	by Tim Otero	1	372
How do I refer a Range to a Cell Mal	by Mal	6	1,028
Split PN and Price Andri	by xlbo	2	371
Auto Calculating Time Sheet Durocdog	by cscorp	1	1,162
formula Spsuston	by cscorp	1	366
How do I set up a workbook so changing Sheet1 changes all sheets? rach1027	by cscorp	1	518
excel rurubi	by cscorp	1	447
jump to hyperlink, extract value at specific destination in file Philip	by cscorp	1	868
Cut links between worksheets in same workbook Houndstooth	by cscorp	1	819
how to set up Bowls league 12 teams points and shot difference Mel	by Mel	0	533
Stoping users pasting formulas into cells confused	by confused	0	663
Lost password Microsoft	by JE McGimpsey	3	380
SUMPRODUCT JerryS	by Duke Carey	4	494
Lookup Value is Between Range 1 and Range 2 Corissa	by cscorp	1	571
VLookup Steve B	by Dave Peterson	1	369
Calculate the CAGR Bruce	by Niek Otten	6	1,154
minimize problem dave	by dave	0	564
yearly invoice Rave	by Rave	0	415
Average Array Formula Rachael	by Rachael	3	648
making one workbook out of two grantr	by grantr	0	348
3D Named Ranges David	by David	0	500
Fibonacci function/command in excel?...tia sal	by JE McGimpsey	1	688
How do I Double Conditional vlookup for 3 columns? engilo	by engilo	4	601
time sheet calc by time in and out JenMo	by Gary Brown	1	838
Fibonacci function/command in excel?...tia sal	by Gary Brown	4	932
How do I use the MOD formula to do the same action to a column? ali55	by Duke Carey	1	381
macro used to change colors Brian in FT W.	by JE McGimpsey	12	1,152
Control for Worksheet static coal_miner	by bj	1	340
Formulas Janelle	by SVC	2	362
Array Formula Karen	by Duke Carey	2	775
Formula HELP! Karen	by bj	3	314
REMOTE CELL FUNCTION Dan	by bj	1	461
using SUBTOTAL() on rows that have been hidden doco	by Dave Peterson	2	547
"if" formula to sum several cells... Massimo	by Massimo	3	450
Formula Help Combing two AND statements Yogi_Bear_79	by Yogi_Bear_79	1	471
using offset with array formulas QuantumPion	by Biff	1	536