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	719
adjacent cells? [email protected]	by Tyro[_2_]	1	417
Combining AND, MID, and OR bquirk	by Ron Coderre	2	279
vlookup? Veronica Johnson	by T. Valko	5	399
I have a DB of auction items sold, how can I create receipt? nwtf_vol	by nwtf_vol[_2_]	2	379
How can I set up a dynamic data entry form? Eric	by ryguy7272	1	630
Data Validation 2003, Named Ranges/Formulas Lisa	by T. Valko	1	612
if a vlookup returns "#n/a" how can I make that zero? sylvesma	by David Biddulph[_2_]	4	3,031
Somewhat Complex: Allocation of Payments ryguy7272	by ryguy7272	7	596
2003/XP Macros in 2000 Bernie T	by Gord Dibben	3	331
Do I use "IF" or something else? klg	by Tyro[_2_]	10	571
Date stamp when a value is entered in a cell on another worksheet bbrant2	by Gary''s Student	1	646
dropdown list within IF statement? Jock	by ShaneDevenshire	1	1,380
Interpolate two or more data points Robert	by Lori	1	1,038
Urgent help needed Excel Helps	by Excel Helps	13	919
Can I link/lock rows so they move together in a sort? dla80	by Jock	1	3,094
Hyper link between excel worksheets JamesT	by Ron Coderre	1	433
Count of entries meeting criteria Karen McKenzie	by Karen McKenzie	2	457
How to get text Bob	by David Biddulph[_2_]	2	308
Selecting from drop down list enters multiple cell data DebbieV	by Marnie	5	1,373
Excel 2003; using a date in a formula Eucalypta	by David Biddulph[_2_]	11	896
Negative time calculations Dave East	by Ron Rosenfeld	9	755
Output of the =IF(COUNTA) Function Excel Helps	by Excel Helps	2	5,160
phone number format [email protected]	by Bob Phillips	2	670
index/large..help please Terry	by Terry	9	425
excel spreadsheet joec[_2_]	by Roger Govier[_3_]	6	438
Help with adding pages Corey	by Roger Govier[_3_]	2	398
Functions Sanjib	by David Biddulph[_2_]	1	400
Excel 2007 Problem with Filter [email protected]	by Micahel Nagy[_2_]	2	1,120
Can I convert a number(1-365) to a month and day of a year? rnc	by Shane Devenshire	4	5,210
referencing mult drop down list Eric	by FSt1	3	397
Keyboard Shortcut for Drop Down List B Baggins	by Joe_Germany	3	2,022
Disable Excel Print Scott R	by Scott R	6	391
Cond Format - C6 when G6 contains any text hollies	by Tyro[_2_]	4	453
whole price sheet change Michael Higgins	by Gord Dibben	4	504
retrieve data from worksheet Dennis	by Dennis	0	479
auto filtering? Maggie Boby	by Maggie Boby	0	425
Create a rule Maggie Boby	by Maggie Boby	0	540
Macro to Move Specific Data to Another Worksheet jeannie v	by Roger Govier[_3_]	1	619
How do I use the LOOKUP feature in Excel Elena D	by Roger Govier[_3_]	2	477
How to return a number into letters? A.El Tohamy	by A.El Tohamy	4	662
Excel Sequential Numbering of cell within worksheet Motorcar Mama	by David Biddulph[_2_]	2	928
SUMPRODUCT gives incorrect total jeannie v	by jeannie v	10	1,410
How to determine the value? Eric	by Ron Rosenfeld	1	392
how do I add a solid color fill to a photo inserted into excel Butch Walker[_2_]	by Butch Walker[_2_]	0	384
changing dates and years with less keystrokes Dick C	by Pete_UK	13	870
Economical grouping of lengths out of much longer lengths Richard (a Builder not a Mathematician)	by Mike Middleton	1	789
Regression with zero intercept TheMoth	by Jerry W. Lewis	2	3,423
Move Specific Data to Another Worksheet jeannie v	by Max	3	469
can I find the area under a plotted curve? Middlesex	by Jerry W. Lewis	3	581
How do you determine a total number of worksheet entries? The Stoat	by The Stoat	4	438
formula for pairing 60 different products into 5 price groups B Thomas	by Sandy Mann	1	627
UDF that returns a date ep	by Robert Bruce	5	559
Borders and conditional formating Patrick C. Simonds	by Patrick C. Simonds	5	498
Year to date sales Pierre	by T. Valko	3	931
Hyperlink poorboys	by poorboys	0	347
Help Vlook up returning N?A andy[_2_]	by Pete_UK	16	823
Worksheet Protection Susan	by Pete_UK	3	362
IF function question asg2307	by asg2307	4	470
If Statement krc547	by Pete_UK	7	357
Sales Commission Calculation C Thornton	by C Thornton	2	1,297
Can you use multiple SEARCH functions in one cell Soulscream	by T. Valko	4	694
Conditional Formatting help, please Veronica Johnson	by David Biddulph[_2_]	6	378
How to reference a cell depending on the value in another cell?? wb198	by T. Valko	4	430
Defined Names in Workbook Beaniecounter	by T. Valko	3	527
Excel formulas chuck	by Bernard Liengme	3	380
How can I delete all matches in a workbook? LiveUser	by LiveUser	4	423
Sumif for groups and subgroups / Excel 2003 mwear	by Pete_UK	9	1,844
how do I write the formula to find the mean in a column of number lallen	by Mike Middleton	2	443
Sum column based on text of another Looping through	by PCLIVE	2	1,024
amortization table ewtp	by FSt1	2	432
Function To Lookup Unique Records In 2 Sets Of Data James Al	by Alan Beban[_2_]	2	477
Finding the last entry in a column based on criteria DKS	by T. Valko	9	1,076
how do I lock formulas, but still allow rows to be added or delet. ericaamousseau	by Dave Peterson	3	670
Array Functions stefburgas	by Bernard Liengme	1	396