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	756
How do I convert time? N. Roheda	by David Biddulph[_2_]	3	328
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,171
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	1,999
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,057
Find the Longest Run. dlbeiler	by T. Valko	7	809
fromatting not possible on the cells vgneo	by Gord Dibben	1	386
Sum, Steve[_4_]	by Max	1	332
Matrix cjgrossley	by Alan Beban[_2_]	4	1,433
Split surname from end of name data Serena	by Serena	4	819
#VALUE! error dim	by dim	3	377
finding, sorting, put only part of a cell Debilee	by Debilee	4	514
percentage ekkeindoha	by ekkeindoha	9	546
Sorting a Pivot Table Column that is not the first column... [email protected]	by Debra Dalgleish	1	2,874
Randomly sorting an Excel spreadsheet tcufrogdawn	by Peo Sjoblom	1	412
Counts for Excel 2003 using multiple criteria [email protected]	by Peo Sjoblom	6	598
justify text into multiple rows DAB	by DAB	0	924
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	334
IF formula bmo	by vezerid	2	342
Create graph if value is greater that zero musicgirl	by vezerid	1	468
IF Formula bmo	by Teethless mama	4	424
carrying previous totals from one worksheet to another. Yvesdouce	by JW[_2_]	1	650
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	808
Using Text to Columns with a function Arlene	by Pete_UK	6	481
Excel equation explanation Colin4	by Colin4	4	676
Error message Chris Pesesky	by Chris Pesesky	0	345
OR & IF functions ExcelKillsMe	by ExcelKillsMe	6	447
How to format a date as text? Fiona	by Rick Rothstein \(MVP - VB\)	4	351
Date Formula Karen	by Karen	13	694
"Sumif" on multiple values Tim Green	by Tim Green	6	460
Lookup Multiple Criteria build	by build	4	477
display a range of cells editible cells based on matching date Miki	by Miki	0	1,246
IF Function Endugu	by JE McGimpsey	2	394
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	735
Find Smallest and Largest. dlbeiler	by Don Guillett	5	1,010
"Conditional" sum davor	by davor	3	348
How I prevent a "0" when a linked cell is empty? Mickyg	by papou[_2_]	1	598
Summerising data Emma	by Max	1	304
Worksheet name [email protected]	by JE McGimpsey	4	339
Max Values THFish	by Pete_UK	6	305
COUNT formula help GeorgeG	by Rick Rothstein \(MVP - VB\)	9	468
Change Font/formatting for EXCEL Drop-Down List selector... Rob Poretti	by Roger Govier[_3_]	8	1,308
"Too many arguements for this function"....ohh noooo.... dim	by David Biddulph[_2_]	3	358
Display top rankings THFish	by THFish	3	501
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	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	523
Excel 2007 calculation bug fix T. Valko	by T. Valko	0	417
Needing to rank values THFish	by THFish	2	352
need Excell to display something other than what I type Kristopher Woods	by Teethless mama	1	368
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,931
Sumproduct Coley	by Pete_UK	4	415
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	358
Add text to meet criteria Keyrookie	by Keyrookie	3	794
Sumif Steve[_4_]	by T. Valko	11	722
Time formulas Blazingsaddles	by T. Valko	15	974
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,688
Combining 2 IF statements to make one formula. Rip1877	by Rip1877	2	550
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	698
Is it possible in Excel to have a file auto delete on a given dat. Van	by Gord Dibben	6	3,020