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	764
adjacent cells? [email protected]	by Tyro[_2_]	1	437
Combining AND, MID, and OR bquirk	by Ron Coderre	2	287
vlookup? Veronica Johnson	by T. Valko	5	405
I have a DB of auction items sold, how can I create receipt? nwtf_vol	by nwtf_vol[_2_]	2	398
How can I set up a dynamic data entry form? Eric	by ryguy7272	1	642
Data Validation 2003, Named Ranges/Formulas Lisa	by T. Valko	1	629
if a vlookup returns "#n/a" how can I make that zero? sylvesma	by David Biddulph[_2_]	4	3,063
Somewhat Complex: Allocation of Payments ryguy7272	by ryguy7272	7	609
2003/XP Macros in 2000 Bernie T	by Gord Dibben	3	339
Do I use "IF" or something else? klg	by Tyro[_2_]	10	580
Date stamp when a value is entered in a cell on another worksheet bbrant2	by Gary''s Student	1	669
dropdown list within IF statement? Jock	by ShaneDevenshire	1	1,392
Interpolate two or more data points Robert	by Lori	1	1,043
Urgent help needed Excel Helps	by Excel Helps	13	933
Can I link/lock rows so they move together in a sort? dla80	by Jock	1	3,119
Hyper link between excel worksheets JamesT	by Ron Coderre	1	437
Count of entries meeting criteria Karen McKenzie	by Karen McKenzie	2	474
How to get text Bob	by David Biddulph[_2_]	2	335
Selecting from drop down list enters multiple cell data DebbieV	by Marnie	5	1,388
Excel 2003; using a date in a formula Eucalypta	by David Biddulph[_2_]	11	907
Negative time calculations Dave East	by Ron Rosenfeld	9	769
Output of the =IF(COUNTA) Function Excel Helps	by Excel Helps	2	5,173
phone number format [email protected]	by Bob Phillips	2	694
index/large..help please Terry	by Terry	9	440
excel spreadsheet joec[_2_]	by Roger Govier[_3_]	6	442
Help with adding pages Corey	by Roger Govier[_3_]	2	404
Functions Sanjib	by David Biddulph[_2_]	1	410
Excel 2007 Problem with Filter [email protected]	by Micahel Nagy[_2_]	2	1,190
Can I convert a number(1-365) to a month and day of a year? rnc	by Shane Devenshire	4	5,261
referencing mult drop down list Eric	by FSt1	3	405
Keyboard Shortcut for Drop Down List B Baggins	by Joe_Germany	3	2,038
Disable Excel Print Scott R	by Scott R	6	391
Cond Format - C6 when G6 contains any text hollies	by Tyro[_2_]	4	461
whole price sheet change Michael Higgins	by Gord Dibben	4	543
retrieve data from worksheet Dennis	by Dennis	0	490
auto filtering? Maggie Boby	by Maggie Boby	0	438
Create a rule Maggie Boby	by Maggie Boby	0	556
Macro to Move Specific Data to Another Worksheet jeannie v	by Roger Govier[_3_]	1	643
How do I use the LOOKUP feature in Excel Elena D	by Roger Govier[_3_]	2	492
How to return a number into letters? A.El Tohamy	by A.El Tohamy	4	676
Excel Sequential Numbering of cell within worksheet Motorcar Mama	by David Biddulph[_2_]	2	940
SUMPRODUCT gives incorrect total jeannie v	by jeannie v	10	1,427
How to determine the value? Eric	by Ron Rosenfeld	1	421
how do I add a solid color fill to a photo inserted into excel Butch Walker[_2_]	by Butch Walker[_2_]	0	392
changing dates and years with less keystrokes Dick C	by Pete_UK	13	887
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,447
Move Specific Data to Another Worksheet jeannie v	by Max	3	495
can I find the area under a plotted curve? Middlesex	by Jerry W. Lewis	3	588
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	647
UDF that returns a date ep	by Robert Bruce	5	581
Borders and conditional formating Patrick C. Simonds	by Patrick C. Simonds	5	528
Year to date sales Pierre	by T. Valko	3	945
Hyperlink poorboys	by poorboys	0	355
Help Vlook up returning N?A andy[_2_]	by Pete_UK	16	833
Worksheet Protection Susan	by Pete_UK	3	375
IF function question asg2307	by asg2307	4	486
If Statement krc547	by Pete_UK	7	365
Sales Commission Calculation C Thornton	by C Thornton	2	1,307
Can you use multiple SEARCH functions in one cell Soulscream	by T. Valko	4	710
Conditional Formatting help, please Veronica Johnson	by David Biddulph[_2_]	6	388
How to reference a cell depending on the value in another cell?? wb198	by T. Valko	4	438
Defined Names in Workbook Beaniecounter	by T. Valko	3	546
Excel formulas chuck	by Bernard Liengme	3	386
How can I delete all matches in a workbook? LiveUser	by LiveUser	4	429
Sumif for groups and subgroups / Excel 2003 mwear	by Pete_UK	9	1,854
how do I write the formula to find the mean in a column of number lallen	by Mike Middleton	2	454
Sum column based on text of another Looping through	by PCLIVE	2	1,045
amortization table ewtp	by FSt1	2	442
Function To Lookup Unique Records In 2 Sets Of Data James Al	by Alan Beban[_2_]	2	501
Finding the last entry in a column based on criteria DKS	by T. Valko	9	1,116
how do I lock formulas, but still allow rows to be added or delet. ericaamousseau	by Dave Peterson	3	691
Array Functions stefburgas	by Bernard Liengme	1	415