Excel Worksheet Functions - Page 642

Thread / Thread Starter	Last Post	Replies	Views
How do I get a txt file to go to excel and have the columns work? Michele	by Eva	1	455
Conditional formatting to exclude weekend and Bank Holidays Paul	by Ron Rosenfeld	12	2,583
Lookup formula?? or other Klee	by Dave Peterson	7	473
Vlookup & hlookup Aitchy	by T. Valko	3	999
AND OR SEARCH together [email protected]	by Al Tariq06	7	465
Random Placement whilst fitting constraints realmfighter	by Rick Rothstein \(MVP - VB\)	2	539
Conditional Formatting Freshman	by Nick Hodge	3	446
How do I create a worksheet using a drop down list? TodiHawk	by Bob Phillips	2	515
Insert range of cells with a function firsttimer	by Joerg	2	884
how do i extract records karen	by Roger Govier	4	524
Consolidate formula Atul Jadhav[_2_]	by Shailesh Shah	1	879
Pivot limitations? SG	by Max	4	582
Closing dates bollard	by bollard	6	361
vlooup formula and if(),isna etc Claudia	by Pete_UK	3	601
Display Elapsed Time Nigel	by Nigel	2	530
Excel - """" MG	by Rick Rothstein \(MVP - VB\)	5	336
Deleting a row if closing date elapsed bollard	by Max	4	437
Pop up message on 1 in 5 entries tuk16664	by Roger Govier	1	336
vlookup sum()? Claudia	by new_121	4	474
How do you format an auto update to delete rows with expired date Rneedshelp	by Rneedshelp	0	596
How do I set up a custom cell format category? slk	by JE McGimpsey	7	814
my TEXT function won't work Roger[_2_]	by Dave Peterson	2	762
Pivot Table: Limited nr of Calculated fields to show? SG	by SG	0	768
vlookup average() new_121	by Dave Peterson	2	1,412
How to concatenate a value in cell ub	by bj	4	460
Sorting data in rows LT_childrens	by Gord Dibben	3	375
Offset code for dynamic row# & multiple columns in LINEST function RJ	by T. Valko	3	3,544
my TEXT function won't work Roger[_2_]	by Roger[_2_]	10	900
COUNTIF for single word in text jewelybrook	by jewelybrook	3	499
Conditional Formatting to Exclude Weekends 2manypuppies	by 2manypuppies	4	831
excel range formulas kennedy.matt	by Teethless mama	1	413
Tadays date Kevin	by bj	5	472
Complex Formula marwildfw	by marwildfw	6	686
Error message in my Excel sheet ub	by FSt1	2	476
Befuddled by Count blank cells Formula! [email protected]	by [email protected]	2	392
Easiest way to extract characters in a cell LEFT or RIGHT of a sym Training Goddess	by Niek Otten	2	2,490
Vlookup bug? David G.	by David G.	6	873
How do I custom calculate within a PivotTable? Learning	by Peo Sjoblom	1	502
Last Name Talladega	by T. Valko	7	469
I need a formula with rounding up & rounding down to the nearest . Tony Kay	by pshepard	3	1,790
SUMIF(NOT) Kigol	by Don Guillett	4	3,453
Help Drop Down List lordjeffj	by Ragdyer	1	387
Why can't I enter a valid number in a cell with data validation wildes06241	by Gord Dibben	4	1,520
prevent big white screen [email protected]	by Gord Dibben	1	1,874
Linked Spreadsheet rows lnorswo	by Gord Dibben	3	440
set value in column based on value in ajoining column Docmidnite	by Gord Dibben	2	358
BIG Dilemma.....HELP!! Amber	by Roger Govier	5	569
### in row & won't "auto fit" - how do I show all text? lorrainef	by Gord Dibben	2	518
Compare City and State to Master List Not Excelerated[_2_]	by pshepard	2	780
Excel formula help Duckyspawn	by OssieMac	1	348
Date Calculation LeapYear	by Ron Rosenfeld	5	398
sumif/sumproduct formula help Robert	by Robert	2	462
HOW DO I SET UP A PRECEDENCE DIAGRAM? G Heard	by ShaneDevenshire	1	4,550
Advanced Filter to another location Jman	by Jman	4	928
How to create a macro to help with lookup. Jman	by Jman	3	492
Comparing worksheets enna49	by enna49	2	607
COUNTIF oddity Phil C	by Mike H	1	335
Worksheet formulas Thomas	by Bob Phillips	3	309
how to call the event of other worksheet chad	by Bob Phillips	1	441
autofill @ intervals jejkskpj	by jejkskpj	2	755
vlookup problem when value absent new_121	by new_121	2	380
building list from a column of data driller	by driller	3	453
File Calculation tj	by tj	4	336
how to extend the column limit on a worksheet Jackie	by Duke Carey	1	541
Coomplete the formula marwildfw	by Duke Carey	1	387
How do i add a new entry to an existing drop-down list in Excel? ABD	by Peo Sjoblom	2	2,036
return N/A when no first match but do nothing if no second match CathyH	by CathyH	2	468
moving items within the page Alan	by vezerid	1	394
Tabbing to cells artgrl8163	by Peo Sjoblom	2	497
Returning other cells with the same value in a column, but different row. [email protected]	by PCLIVE	1	403
HLOOKUP second column Kelly	by DazzaData	7	666
count not working in pivot table erick-flores	by erick-flores	0	400
Setting up a database in excel Shay[_2_]	by MH[_2_]	7	463
SUMIF with dates RHfactor	by T. Valko	2	418
For Danielle FC	by Mike H	1	402