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	769
How do I convert time? N. Roheda	by David Biddulph[_2_]	3	341
Trying to SUM cells with links. Labman1366	by David Biddulph[_2_]	2	403
Variables in formulas build	by kmmg72	9	798
how do I increase the length of a drop down list? Swill_Vermin	by Roger Govier[_3_]	1	1,583
Adding button to worksheet to refresh pivot table data Ron	by Roger Govier[_3_]	1	1,183
Office 2007-How do I copy a worksheet from one workbook to another Millie	by Ron de Bruin	1	757
Formula that will record the time and date when an entry is made on a sheet [email protected]	by [email protected]	3	2,002
IF statement - multiple scenarios Laz	by Rick Rothstein \(MVP - VB\)	4	5,256
HOW DO I COPY ALL DATA (INC COMMENTS)FROM 1 WORKBOOK TO ANOTHER BGA	by Gord Dibben	3	1,062
Find the Longest Run. dlbeiler	by T. Valko	7	814
fromatting not possible on the cells vgneo	by Gord Dibben	1	396
Sum, Steve[_4_]	by Max	1	336
Matrix cjgrossley	by Alan Beban[_2_]	4	1,438
Split surname from end of name data Serena	by Serena	4	826
#VALUE! error dim	by dim	3	387
finding, sorting, put only part of a cell Debilee	by Debilee	4	527
percentage ekkeindoha	by ekkeindoha	9	547
Sorting a Pivot Table Column that is not the first column... [email protected]	by Debra Dalgleish	1	2,885
Randomly sorting an Excel spreadsheet tcufrogdawn	by Peo Sjoblom	1	427
Counts for Excel 2003 using multiple criteria [email protected]	by Peo Sjoblom	6	608
justify text into multiple rows DAB	by DAB	0	933
PH Stat skrpnking3	by Mike Middleton	1	477
Rankings THFish	by Rick Rothstein \(MVP - VB\)	7	690
IF statement to long, an easier way? OxonLad	by vezerid	3	346
IF formula bmo	by vezerid	2	350
Create graph if value is greater that zero musicgirl	by vezerid	1	473
IF Formula bmo	by Teethless mama	4	433
carrying previous totals from one worksheet to another. Yvesdouce	by JW[_2_]	1	652
insert another page into an existing one Rachael	by JW[_2_]	1	331
Complex Summing probably using Match at some point... George	by George	2	816
Using Text to Columns with a function Arlene	by Pete_UK	6	491
Excel equation explanation Colin4	by Colin4	4	685
Error message Chris Pesesky	by Chris Pesesky	0	355
OR & IF functions ExcelKillsMe	by ExcelKillsMe	6	459
How to format a date as text? Fiona	by Rick Rothstein \(MVP - VB\)	4	361
Date Formula Karen	by Karen	13	701
"Sumif" on multiple values Tim Green	by Tim Green	6	467
Lookup Multiple Criteria build	by build	4	478
display a range of cells editible cells based on matching date Miki	by Miki	0	1,254
IF Function Endugu	by JE McGimpsey	2	404
Trying to display the number between two numbers closest to another value [email protected]	by Teethless mama	2	1,081
Need to IMPORT a Worksheet From another WorkBook Krefty	by Dave Peterson	2	736
Find Smallest and Largest. dlbeiler	by Don Guillett	5	1,018
"Conditional" sum davor	by davor	3	358
How I prevent a "0" when a linked cell is empty? Mickyg	by papou[_2_]	1	609
Summerising data Emma	by Max	1	307
Worksheet name [email protected]	by JE McGimpsey	4	340
Max Values THFish	by Pete_UK	6	316
COUNT formula help GeorgeG	by Rick Rothstein \(MVP - VB\)	9	477
Change Font/formatting for EXCEL Drop-Down List selector... Rob Poretti	by Roger Govier[_3_]	8	1,320
"Too many arguements for this function"....ohh noooo.... dim	by David Biddulph[_2_]	3	361
Display top rankings THFish	by THFish	3	503
How do I do IF C5=y, then L5*.06 ? pegdog	by Gord Dibben	1	468
What is the correct formula for IF C5 = Y, then L5 *.06? pegdog	by pegdog	4	452
How to display running-down numbers with total count? Tetsuya Oguma	by T. Valko	1	620
Subtotals of repeating set of data Blue Bunny	by Blue Bunny	2	533
Excel 2007 calculation bug fix T. Valko	by T. Valko	0	427
Needing to rank values THFish	by THFish	2	365
need Excell to display something other than what I type Kristopher Woods	by Teethless mama	1	378
IF formula help.. Scott R	by T. Valko	3	370
I want to double click a box and have an X inserted there? JLM	by Gord Dibben	3	590
I can't insert a worksheet into my current spreadsheet file John Falkenstine	by Gord Dibben	3	1,936
Sumproduct Coley	by Pete_UK	4	417
Excel2003 use fnct/conditnl fmt, copy color&Val from ref cell TJH	by TJH	0	355
Excel2003 use fnct/conditnl fmt, hw cpy clr frm anthr source text TJH	by TJH	2	371
Add text to meet criteria Keyrookie	by Keyrookie	3	799
Sumif Steve[_4_]	by T. Valko	11	727
Time formulas Blazingsaddles	by T. Valko	15	979
Sum-if-product Steve[_4_]	by Steve[_4_]	2	955
how do i set up an income and expenditure account in excel? Novice24	by Novice24	0	4,690
Combining 2 IF statements to make one formula. Rip1877	by Rip1877	2	564
How can I compare data between two different sheets for changes? vortec802	by vortec802	0	782
how do I extend sub-columns into one long row? Brenda	by Gord Dibben	4	711
Is it possible in Excel to have a file auto delete on a given dat. Van	by Gord Dibben	6	3,036