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	945
Replace SUMIF with SUMPRODUCT torooo	by Ragdyer	14	1,820
Count weekend days with criteria koob	by T. Valko	2	842
look up value in a table joe	by joe	2	676
How to get Holidays in cell/s? (Find explaination in details) Nilay Excel 2003	by T. Valko	3	573
row number question in an array SD	by Bob Phillips	10	997
Delete row if blank in a column Outlook, eh?	by Ron de Bruin	5	490
Euro Millions JF[_2_]	by FSt1	2	1,111
Excel Autocomplete Len	by Gary''s Student	1	505
Write Holidays between two dates? Nilay Excel 2003	by Nilay Excel 2003	6	750
Inserting an Item into cells with text Dolfan13net	by pseudo_pro	2	511
Formulas Derf	by Pete_UK	2	282
#N/A Error on VLOOKUP roxiemayfield	by Pete_UK	7	437
Creating a production schedule Kees Vos[_2_]	by Kees Vos[_2_]	0	1,069
Sorting issue Linda Broyles	by Linda Broyles	2	455
Can't copy data from one worksheet to another in excel 2007 smrtgrnidblnd	by smrtgrnidblnd	0	1,084
Update and Fill Links pennyb9	by Gord Dibben	1	306
Conditional formatting for rows ExcelObsessed	by Gord Dibben	7	759
using a toggle button to show or hide information in several cells hanson	by Gord Dibben	3	2,501
Sum should be 0 roxiemayfield	by T. Valko	2	473
Get section of text from cell Kees Vos[_2_]	by Luke M	6	619
Creating Directory Structure from Cell Value [email protected]	by [email protected]	5	722
Lookup smooney	by T. Valko	10	718
Black and white printing jerminski73	by jerminski73	2	1,329
populate form from where the cursor is Diana Morrison	by Diana Morrison	1	395
underline too close to text MAB	by Bernard Liengme	2	1,080
how can we get unique values in match function for same match key. Xcel[_2_]	by T. Valko	11	2,417
Dynamic sum sahafi	by Pete_UK	3	403
Floating Text Box help Ty Barrett (VMC)	by Ty Barrett (VMC)[_2_]	2	854
Can I click on a cell and bring up an information box? Terry	by Terry	4	591
finding # of occurrences of information between two dates JPLong	by Luke M	3	1,033
Sum with conditions Curtis	by Luke M	1	454
FORECAST Worsheet Function Gator	by Gator	3	339
can't find function error Susan	by David Biddulph[_2_]	4	348
To get a true sum shap-er	by Pete_UK	2	489
adding sheets based upon a template sheet [email protected]	by Pogue	1	429
Showing duplicates in pivot tables pickytweety	by pickytweety	2	526
Formula numbers and text Trying to pull a random sampling Not the expert	by Luke M	1	588
LOOKUP or IF?? ABC Seamless Wayne	by RagDyeR	5	304
#DIV/0! error Curtis	by Pete_UK	7	409
Changing Folders! Philip J Smith	by Philip J Smith	0	373
Calculate Number of years Needs Help	by Bob Phillips	4	999
vlookup lloyd	by Jeff Gordon	10	730
Embeded IF Statement Rob M	by Teethless mama	2	358
Search number within a database Montu	by Teethless mama	2	425
Tabs with different names Rrsc	by Bernie Deitrick	1	373
remove unwanted spaces? Nige Danton	by Fred Smith	5	1,197
List on different worksheet Lisa	by Lisa	2	279
Macros pulling info from other worksheets [email protected]	by Dave Peterson	3	392
VLookup is not returning the first match data Pogue	by Dave Peterson	6	842
How can update keep an updated balance on a spreadsheet bug28	by Stephen[_2_]	1	359
Get Holidays in cell/s between star & End dates? Nilay Excel 2003	by Nilay Excel 2003	0	518
array formula to provide all values associated with a given value tschaeffer	by T. Valko	2	310
How to generate random numbers from a range of cells? fruitchunk	by fruitchunk	3	1,635
Highlight Like Values Brandon G.	by Teethless mama	1	496
VLOOKUP? smooney	by Teethless mama	2	281
=if(vlookup for non-unique values Javier Benavides	by T. Valko	1	1,261
array formula to provide all values associated with a given value tschaeffer	by tschaeffer	0	377
if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!!! techwiz101	by techwiz101	2	467
How do you get information from an Excel Web Query into Access? DoveArrow	by CLR	3	463
What formula to use? katrina[_2_]	by Pete_UK	3	370
Opening Excel workbooks Brian G	by Brian G	2	444
vlookup Curtis	by Pete_UK	1	393
Lookup function (i think) Scott R	by Scott R	4	422
Allow Sheets to be Connected by Rows or by Columns miroslj	by Pete_UK	1	703
Summarize information on another sheet stocktsi	by Max	8	509
getting XL to recognize lower from upper case in IF formula stef	by stef	9	931
conditional statement using validation cell kfarley537	by kfarley537	2	436
Vlookup Help Curtis	by PCLIVE	4	340
Excel Hyperlinks [email protected]	by [email protected]	0	295
Find all same values from defined range Jeff Gordon	by Jeff Gordon	5	405
Gift Exchange Help! Marina B	by T. Valko	1	1,638
if statements jrt	by RagDyer	3	429
Counting unique values in a list generated with the OFFSET functio mikelee101	by T. Valko	3	817
Two columns only take one name for both email address Outlook, eh?	by Outlook, eh?	2	508