Excel Worksheet Functions - Page 427

Thread / Thread Starter	Last Post	Replies	Views
Populate order sheet with data from work sheet Veronica Johnson	by T. Valko	4	770
adjacent cells? [email protected]	by Tyro[_2_]	1	448
Combining AND, MID, and OR bquirk	by Ron Coderre	2	297
vlookup? Veronica Johnson	by T. Valko	5	415
I have a DB of auction items sold, how can I create receipt? nwtf_vol	by nwtf_vol[_2_]	2	407
How can I set up a dynamic data entry form? Eric	by ryguy7272	1	645
Data Validation 2003, Named Ranges/Formulas Lisa	by T. Valko	1	643
if a vlookup returns "#n/a" how can I make that zero? sylvesma	by David Biddulph[_2_]	4	3,082
Somewhat Complex: Allocation of Payments ryguy7272	by ryguy7272	7	616
2003/XP Macros in 2000 Bernie T	by Gord Dibben	3	340
Do I use "IF" or something else? klg	by Tyro[_2_]	10	593
Date stamp when a value is entered in a cell on another worksheet bbrant2	by Gary''s Student	1	670
dropdown list within IF statement? Jock	by ShaneDevenshire	1	1,406
Interpolate two or more data points Robert	by Lori	1	1,057
Urgent help needed Excel Helps	by Excel Helps	13	937
Can I link/lock rows so they move together in a sort? dla80	by Jock	1	3,130
Hyper link between excel worksheets JamesT	by Ron Coderre	1	448
Count of entries meeting criteria Karen McKenzie	by Karen McKenzie	2	474
How to get text Bob	by David Biddulph[_2_]	2	345
Selecting from drop down list enters multiple cell data DebbieV	by Marnie	5	1,390
Excel 2003; using a date in a formula Eucalypta	by David Biddulph[_2_]	11	917
Negative time calculations Dave East	by Ron Rosenfeld	9	781
Output of the =IF(COUNTA) Function Excel Helps	by Excel Helps	2	5,177
phone number format [email protected]	by Bob Phillips	2	700
index/large..help please Terry	by Terry	9	452
excel spreadsheet joec[_2_]	by Roger Govier[_3_]	6	452
Help with adding pages Corey	by Roger Govier[_3_]	2	416
Functions Sanjib	by David Biddulph[_2_]	1	423
Excel 2007 Problem with Filter [email protected]	by Micahel Nagy[_2_]	2	1,200
Can I convert a number(1-365) to a month and day of a year? rnc	by Shane Devenshire	4	5,262
referencing mult drop down list Eric	by FSt1	3	416
Keyboard Shortcut for Drop Down List B Baggins	by Joe_Germany	3	2,042
Disable Excel Print Scott R	by Scott R	6	391
Cond Format - C6 when G6 contains any text hollies	by Tyro[_2_]	4	471
whole price sheet change Michael Higgins	by Gord Dibben	4	546
retrieve data from worksheet Dennis	by Dennis	0	499
auto filtering? Maggie Boby	by Maggie Boby	0	444
Create a rule Maggie Boby	by Maggie Boby	0	564
Macro to Move Specific Data to Another Worksheet jeannie v	by Roger Govier[_3_]	1	650
How do I use the LOOKUP feature in Excel Elena D	by Roger Govier[_3_]	2	505
How to return a number into letters? A.El Tohamy	by A.El Tohamy	4	688
Excel Sequential Numbering of cell within worksheet Motorcar Mama	by David Biddulph[_2_]	2	950
SUMPRODUCT gives incorrect total jeannie v	by jeannie v	10	1,430
How to determine the value? Eric	by Ron Rosenfeld	1	434
how do I add a solid color fill to a photo inserted into excel Butch Walker[_2_]	by Butch Walker[_2_]	0	403
changing dates and years with less keystrokes Dick C	by Pete_UK	13	899
Economical grouping of lengths out of much longer lengths Richard (a Builder not a Mathematician)	by Mike Middleton	1	811
Regression with zero intercept TheMoth	by Jerry W. Lewis	2	3,460
Move Specific Data to Another Worksheet jeannie v	by Max	3	503
can I find the area under a plotted curve? Middlesex	by Jerry W. Lewis	3	591
How do you determine a total number of worksheet entries? The Stoat	by The Stoat	4	444
formula for pairing 60 different products into 5 price groups B Thomas	by Sandy Mann	1	651
UDF that returns a date ep	by Robert Bruce	5	595
Borders and conditional formating Patrick C. Simonds	by Patrick C. Simonds	5	529
Year to date sales Pierre	by T. Valko	3	948
Hyperlink poorboys	by poorboys	0	361
Help Vlook up returning N?A andy[_2_]	by Pete_UK	16	842
Worksheet Protection Susan	by Pete_UK	3	378
IF function question asg2307	by asg2307	4	495
If Statement krc547	by Pete_UK	7	373
Sales Commission Calculation C Thornton	by C Thornton	2	1,310
Can you use multiple SEARCH functions in one cell Soulscream	by T. Valko	4	721
Conditional Formatting help, please Veronica Johnson	by David Biddulph[_2_]	6	401
How to reference a cell depending on the value in another cell?? wb198	by T. Valko	4	451
Defined Names in Workbook Beaniecounter	by T. Valko	3	555
Excel formulas chuck	by Bernard Liengme	3	396
How can I delete all matches in a workbook? LiveUser	by LiveUser	4	430
Sumif for groups and subgroups / Excel 2003 mwear	by Pete_UK	9	1,865
how do I write the formula to find the mean in a column of number lallen	by Mike Middleton	2	469
Sum column based on text of another Looping through	by PCLIVE	2	1,057
amortization table ewtp	by FSt1	2	448
Function To Lookup Unique Records In 2 Sets Of Data James Al	by Alan Beban[_2_]	2	507
Finding the last entry in a column based on criteria DKS	by T. Valko	9	1,127
how do I lock formulas, but still allow rows to be added or delet. ericaamousseau	by Dave Peterson	3	699
Array Functions stefburgas	by Bernard Liengme	1	419