Excel Worksheet Functions - Page 445

Thread / Thread Starter	Last Post	Replies	Views
How do I subtract 20% from a column of prices? mlhank	by Ron Coderre	2	982
Replace SUMIF with SUMPRODUCT torooo	by Ragdyer	14	1,851
Count weekend days with criteria koob	by T. Valko	2	853
look up value in a table joe	by joe	2	689
How to get Holidays in cell/s? (Find explaination in details) Nilay Excel 2003	by T. Valko	3	592
row number question in an array SD	by Bob Phillips	10	1,016
Delete row if blank in a column Outlook, eh?	by Ron de Bruin	5	508
Euro Millions JF[_2_]	by FSt1	2	1,132
Excel Autocomplete Len	by Gary''s Student	1	515
Write Holidays between two dates? Nilay Excel 2003	by Nilay Excel 2003	6	764
Inserting an Item into cells with text Dolfan13net	by pseudo_pro	2	534
Formulas Derf	by Pete_UK	2	289
#N/A Error on VLOOKUP roxiemayfield	by Pete_UK	7	453
Creating a production schedule Kees Vos[_2_]	by Kees Vos[_2_]	0	1,081
Sorting issue Linda Broyles	by Linda Broyles	2	471
Can't copy data from one worksheet to another in excel 2007 smrtgrnidblnd	by smrtgrnidblnd	0	1,101
Update and Fill Links pennyb9	by Gord Dibben	1	316
Conditional formatting for rows ExcelObsessed	by Gord Dibben	7	788
using a toggle button to show or hide information in several cells hanson	by Gord Dibben	3	2,528
Sum should be 0 roxiemayfield	by T. Valko	2	491
Get section of text from cell Kees Vos[_2_]	by Luke M	6	646
Creating Directory Structure from Cell Value [email protected]	by [email protected]	5	776
Lookup smooney	by T. Valko	10	728
Black and white printing jerminski73	by jerminski73	2	1,399
populate form from where the cursor is Diana Morrison	by Diana Morrison	1	404
underline too close to text MAB	by Bernard Liengme	2	1,130
how can we get unique values in match function for same match key. Xcel[_2_]	by T. Valko	11	2,445
Dynamic sum sahafi	by Pete_UK	3	419
Floating Text Box help Ty Barrett (VMC)	by Ty Barrett (VMC)[_2_]	2	871
Can I click on a cell and bring up an information box? Terry	by Terry	4	606
finding # of occurrences of information between two dates JPLong	by Luke M	3	1,053
Sum with conditions Curtis	by Luke M	1	466
FORECAST Worsheet Function Gator	by Gator	3	347
can't find function error Susan	by David Biddulph[_2_]	4	361
To get a true sum shap-er	by Pete_UK	2	508
adding sheets based upon a template sheet [email protected]	by Pogue	1	441
Showing duplicates in pivot tables pickytweety	by pickytweety	2	547
Formula numbers and text Trying to pull a random sampling Not the expert	by Luke M	1	611
LOOKUP or IF?? ABC Seamless Wayne	by RagDyeR	5	326
#DIV/0! error Curtis	by Pete_UK	7	422
Changing Folders! Philip J Smith	by Philip J Smith	0	388
Calculate Number of years Needs Help	by Bob Phillips	4	1,028
vlookup lloyd	by Jeff Gordon	10	744
Embeded IF Statement Rob M	by Teethless mama	2	367
Search number within a database Montu	by Teethless mama	2	451
Tabs with different names Rrsc	by Bernie Deitrick	1	383
remove unwanted spaces? Nige Danton	by Fred Smith	5	1,212
List on different worksheet Lisa	by Lisa	2	287
Macros pulling info from other worksheets [email protected]	by Dave Peterson	3	406
VLookup is not returning the first match data Pogue	by Dave Peterson	6	868
How can update keep an updated balance on a spreadsheet bug28	by Stephen[_2_]	1	373
Get Holidays in cell/s between star & End dates? Nilay Excel 2003	by Nilay Excel 2003	0	536
array formula to provide all values associated with a given value tschaeffer	by T. Valko	2	321
How to generate random numbers from a range of cells? fruitchunk	by fruitchunk	3	1,666
Highlight Like Values Brandon G.	by Teethless mama	1	511
VLOOKUP? smooney	by Teethless mama	2	290
=if(vlookup for non-unique values Javier Benavides	by T. Valko	1	1,275
array formula to provide all values associated with a given value tschaeffer	by tschaeffer	0	391
if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!!! techwiz101	by techwiz101	2	476
How do you get information from an Excel Web Query into Access? DoveArrow	by CLR	3	485
What formula to use? katrina[_2_]	by Pete_UK	3	378
Opening Excel workbooks Brian G	by Brian G	2	454
vlookup Curtis	by Pete_UK	1	418
Lookup function (i think) Scott R	by Scott R	4	432
Allow Sheets to be Connected by Rows or by Columns miroslj	by Pete_UK	1	723
Summarize information on another sheet stocktsi	by Max	8	520
getting XL to recognize lower from upper case in IF formula stef	by stef	9	941
conditional statement using validation cell kfarley537	by kfarley537	2	458
Vlookup Help Curtis	by PCLIVE	4	352
Excel Hyperlinks [email protected]	by [email protected]	0	303
Find all same values from defined range Jeff Gordon	by Jeff Gordon	5	422
Gift Exchange Help! Marina B	by T. Valko	1	1,652
if statements jrt	by RagDyer	3	446
Counting unique values in a list generated with the OFFSET functio mikelee101	by T. Valko	3	832
Two columns only take one name for both email address Outlook, eh?	by Outlook, eh?	2	527