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,856
Count weekend days with criteria koob	by T. Valko	2	853
look up value in a table joe	by joe	2	695
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,031
Delete row if blank in a column Outlook, eh?	by Ron de Bruin	5	518
Euro Millions JF[_2_]	by FSt1	2	1,132
Excel Autocomplete Len	by Gary''s Student	1	517
Write Holidays between two dates? Nilay Excel 2003	by Nilay Excel 2003	6	774
Inserting an Item into cells with text Dolfan13net	by pseudo_pro	2	537
Formulas Derf	by Pete_UK	2	296
#N/A Error on VLOOKUP roxiemayfield	by Pete_UK	7	454
Creating a production schedule Kees Vos[_2_]	by Kees Vos[_2_]	0	1,091
Sorting issue Linda Broyles	by Linda Broyles	2	479
Can't copy data from one worksheet to another in excel 2007 smrtgrnidblnd	by smrtgrnidblnd	0	1,110
Update and Fill Links pennyb9	by Gord Dibben	1	318
Conditional formatting for rows ExcelObsessed	by Gord Dibben	7	799
using a toggle button to show or hide information in several cells hanson	by Gord Dibben	3	2,538
Sum should be 0 roxiemayfield	by T. Valko	2	492
Get section of text from cell Kees Vos[_2_]	by Luke M	6	653
Creating Directory Structure from Cell Value [email protected]	by [email protected]	5	784
Lookup smooney	by T. Valko	10	728
Black and white printing jerminski73	by jerminski73	2	1,400
populate form from where the cursor is Diana Morrison	by Diana Morrison	1	416
underline too close to text MAB	by Bernard Liengme	2	1,134
how can we get unique values in match function for same match key. Xcel[_2_]	by T. Valko	11	2,456
Dynamic sum sahafi	by Pete_UK	3	428
Floating Text Box help Ty Barrett (VMC)	by Ty Barrett (VMC)[_2_]	2	882
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,062
Sum with conditions Curtis	by Luke M	1	467
FORECAST Worsheet Function Gator	by Gator	3	357
can't find function error Susan	by David Biddulph[_2_]	4	362
To get a true sum shap-er	by Pete_UK	2	508
adding sheets based upon a template sheet [email protected]	by Pogue	1	449
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	618
LOOKUP or IF?? ABC Seamless Wayne	by RagDyeR	5	336
#DIV/0! error Curtis	by Pete_UK	7	435
Changing Folders! Philip J Smith	by Philip J Smith	0	389
Calculate Number of years Needs Help	by Bob Phillips	4	1,033
vlookup lloyd	by Jeff Gordon	10	744
Embeded IF Statement Rob M	by Teethless mama	2	372
Search number within a database Montu	by Teethless mama	2	463
Tabs with different names Rrsc	by Bernie Deitrick	1	384
remove unwanted spaces? Nige Danton	by Fred Smith	5	1,217
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	884
How can update keep an updated balance on a spreadsheet bug28	by Stephen[_2_]	1	375
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	334
How to generate random numbers from a range of cells? fruitchunk	by fruitchunk	3	1,669
Highlight Like Values Brandon G.	by Teethless mama	1	523
VLOOKUP? smooney	by Teethless mama	2	290
=if(vlookup for non-unique values Javier Benavides	by T. Valko	1	1,287
array formula to provide all values associated with a given value tschaeffer	by tschaeffer	0	392
if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!!! techwiz101	by techwiz101	2	479
How do you get information from an Excel Web Query into Access? DoveArrow	by CLR	3	486
What formula to use? katrina[_2_]	by Pete_UK	3	378
Opening Excel workbooks Brian G	by Brian G	2	459
vlookup Curtis	by Pete_UK	1	418
Lookup function (i think) Scott R	by Scott R	4	439
Allow Sheets to be Connected by Rows or by Columns miroslj	by Pete_UK	1	734
Summarize information on another sheet stocktsi	by Max	8	528
getting XL to recognize lower from upper case in IF formula stef	by stef	9	946
conditional statement using validation cell kfarley537	by kfarley537	2	469
Vlookup Help Curtis	by PCLIVE	4	353
Excel Hyperlinks [email protected]	by [email protected]	0	310
Find all same values from defined range Jeff Gordon	by Jeff Gordon	5	432
Gift Exchange Help! Marina B	by T. Valko	1	1,653
if statements jrt	by RagDyer	3	456
Counting unique values in a list generated with the OFFSET functio mikelee101	by T. Valko	3	835
Two columns only take one name for both email address Outlook, eh?	by Outlook, eh?	2	541