Excel Worksheet Functions - Page 474

Thread / Thread Starter	Last Post	Replies	Views
Counting a range to see if it encompasses a given date Quovardis	by Max	6	749
How do I convert time? N. Roheda	by David Biddulph[_2_]	3	321
Trying to SUM cells with links. Labman1366	by David Biddulph[_2_]	2	394
Variables in formulas build	by kmmg72	9	784
how do I increase the length of a drop down list? Swill_Vermin	by Roger Govier[_3_]	1	1,571
Adding button to worksheet to refresh pivot table data Ron	by Roger Govier[_3_]	1	1,169
Office 2007-How do I copy a worksheet from one workbook to another Millie	by Ron de Bruin	1	756
Formula that will record the time and date when an entry is made on a sheet [email protected]	by [email protected]	3	1,996
IF statement - multiple scenarios Laz	by Rick Rothstein \(MVP - VB\)	4	5,249
HOW DO I COPY ALL DATA (INC COMMENTS)FROM 1 WORKBOOK TO ANOTHER BGA	by Gord Dibben	3	1,056
Find the Longest Run. dlbeiler	by T. Valko	7	809
fromatting not possible on the cells vgneo	by Gord Dibben	1	385
Sum, Steve[_4_]	by Max	1	330
Matrix cjgrossley	by Alan Beban[_2_]	4	1,432
Split surname from end of name data Serena	by Serena	4	817
#VALUE! error dim	by dim	3	376
finding, sorting, put only part of a cell Debilee	by Debilee	4	513
percentage ekkeindoha	by ekkeindoha	9	545
Sorting a Pivot Table Column that is not the first column... [email protected]	by Debra Dalgleish	1	2,779
Randomly sorting an Excel spreadsheet tcufrogdawn	by Peo Sjoblom	1	411
Counts for Excel 2003 using multiple criteria [email protected]	by Peo Sjoblom	6	595
justify text into multiple rows DAB	by DAB	0	923
PH Stat skrpnking3	by Mike Middleton	1	476
Rankings THFish	by Rick Rothstein \(MVP - VB\)	7	683
IF statement to long, an easier way? OxonLad	by vezerid	3	332
IF formula bmo	by vezerid	2	342
Create graph if value is greater that zero musicgirl	by vezerid	1	467
IF Formula bmo	by Teethless mama	4	424
carrying previous totals from one worksheet to another. Yvesdouce	by JW[_2_]	1	647
insert another page into an existing one Rachael	by JW[_2_]	1	325
Complex Summing probably using Match at some point... George	by George	2	776
Using Text to Columns with a function Arlene	by Pete_UK	6	478
Excel equation explanation Colin4	by Colin4	4	676
Error message Chris Pesesky	by Chris Pesesky	0	343
OR & IF functions ExcelKillsMe	by ExcelKillsMe	6	447
How to format a date as text? Fiona	by Rick Rothstein \(MVP - VB\)	4	350
Date Formula Karen	by Karen	13	693
"Sumif" on multiple values Tim Green	by Tim Green	6	459
Lookup Multiple Criteria build	by build	4	477
display a range of cells editible cells based on matching date Miki	by Miki	0	1,238
IF Function Endugu	by JE McGimpsey	2	392
Trying to display the number between two numbers closest to another value [email protected]	by Teethless mama	2	1,072
Need to IMPORT a Worksheet From another WorkBook Krefty	by Dave Peterson	2	734
Find Smallest and Largest. dlbeiler	by Don Guillett	5	1,007
"Conditional" sum davor	by davor	3	348
How I prevent a "0" when a linked cell is empty? Mickyg	by papou[_2_]	1	597
Summerising data Emma	by Max	1	304
Worksheet name [email protected]	by JE McGimpsey	4	337
Max Values THFish	by Pete_UK	6	305
COUNT formula help GeorgeG	by Rick Rothstein \(MVP - VB\)	9	467
Change Font/formatting for EXCEL Drop-Down List selector... Rob Poretti	by Roger Govier[_3_]	8	1,306
"Too many arguements for this function"....ohh noooo.... dim	by David Biddulph[_2_]	3	344
Display top rankings THFish	by THFish	3	499
How do I do IF C5=y, then L5*.06 ? pegdog	by Gord Dibben	1	466
What is the correct formula for IF C5 = Y, then L5 *.06? pegdog	by pegdog	4	451
How to display running-down numbers with total count? Tetsuya Oguma	by T. Valko	1	608
Subtotals of repeating set of data Blue Bunny	by Blue Bunny	2	517
Excel 2007 calculation bug fix T. Valko	by T. Valko	0	414
Needing to rank values THFish	by THFish	2	351
need Excell to display something other than what I type Kristopher Woods	by Teethless mama	1	366
IF formula help.. Scott R	by T. Valko	3	366
I want to double click a box and have an X inserted there? JLM	by Gord Dibben	3	585
I can't insert a worksheet into my current spreadsheet file John Falkenstine	by Gord Dibben	3	1,926
Sumproduct Coley	by Pete_UK	4	413
Excel2003 use fnct/conditnl fmt, copy color&Val from ref cell TJH	by TJH	0	352
Excel2003 use fnct/conditnl fmt, hw cpy clr frm anthr source text TJH	by TJH	2	358
Add text to meet criteria Keyrookie	by Keyrookie	3	787
Sumif Steve[_4_]	by T. Valko	11	722
Time formulas Blazingsaddles	by T. Valko	15	973
Sum-if-product Steve[_4_]	by Steve[_4_]	2	942
how do i set up an income and expenditure account in excel? Novice24	by Novice24	0	4,684
Combining 2 IF statements to make one formula. Rip1877	by Rip1877	2	548
How can I compare data between two different sheets for changes? vortec802	by vortec802	0	769
how do I extend sub-columns into one long row? Brenda	by Gord Dibben	4	697
Is it possible in Excel to have a file auto delete on a given dat. Van	by Gord Dibben	6	3,010