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	977
Replace SUMIF with SUMPRODUCT torooo	by Ragdyer	14	1,846
Count weekend days with criteria koob	by T. Valko	2	852
look up value in a table joe	by joe	2	687
How to get Holidays in cell/s? (Find explaination in details) Nilay Excel 2003	by T. Valko	3	589
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	507
Euro Millions JF[_2_]	by FSt1	2	1,131
Excel Autocomplete Len	by Gary''s Student	1	512
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	533
Formulas Derf	by Pete_UK	2	289
#N/A Error on VLOOKUP roxiemayfield	by Pete_UK	7	452
Creating a production schedule Kees Vos[_2_]	by Kees Vos[_2_]	0	1,081
Sorting issue Linda Broyles	by Linda Broyles	2	469
Can't copy data from one worksheet to another in excel 2007 smrtgrnidblnd	by smrtgrnidblnd	0	1,099
Update and Fill Links pennyb9	by Gord Dibben	1	313
Conditional formatting for rows ExcelObsessed	by Gord Dibben	7	784
using a toggle button to show or hide information in several cells hanson	by Gord Dibben	3	2,517
Sum should be 0 roxiemayfield	by T. Valko	2	490
Get section of text from cell Kees Vos[_2_]	by Luke M	6	639
Creating Directory Structure from Cell Value [email protected]	by [email protected]	5	737
Lookup smooney	by T. Valko	10	727
Black and white printing jerminski73	by jerminski73	2	1,345
populate form from where the cursor is Diana Morrison	by Diana Morrison	1	402
underline too close to text MAB	by Bernard Liengme	2	1,126
how can we get unique values in match function for same match key. Xcel[_2_]	by T. Valko	11	2,432
Dynamic sum sahafi	by Pete_UK	3	414
Floating Text Box help Ty Barrett (VMC)	by Ty Barrett (VMC)[_2_]	2	868
Can I click on a cell and bring up an information box? Terry	by Terry	4	602
finding # of occurrences of information between two dates JPLong	by Luke M	3	1,052
Sum with conditions Curtis	by Luke M	1	464
FORECAST Worsheet Function Gator	by Gator	3	347
can't find function error Susan	by David Biddulph[_2_]	4	358
To get a true sum shap-er	by Pete_UK	2	506
adding sheets based upon a template sheet [email protected]	by Pogue	1	438
Showing duplicates in pivot tables pickytweety	by pickytweety	2	546
Formula numbers and text Trying to pull a random sampling Not the expert	by Luke M	1	610
LOOKUP or IF?? ABC Seamless Wayne	by RagDyeR	5	324
#DIV/0! error Curtis	by Pete_UK	7	421
Changing Folders! Philip J Smith	by Philip J Smith	0	387
Calculate Number of years Needs Help	by Bob Phillips	4	1,028
vlookup lloyd	by Jeff Gordon	10	742
Embeded IF Statement Rob M	by Teethless mama	2	364
Search number within a database Montu	by Teethless mama	2	447
Tabs with different names Rrsc	by Bernie Deitrick	1	379
remove unwanted spaces? Nige Danton	by Fred Smith	5	1,210
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	861
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	535
array formula to provide all values associated with a given value tschaeffer	by T. Valko	2	320
How to generate random numbers from a range of cells? fruitchunk	by fruitchunk	3	1,660
Highlight Like Values Brandon G.	by Teethless mama	1	508
VLOOKUP? smooney	by Teethless mama	2	287
=if(vlookup for non-unique values Javier Benavides	by T. Valko	1	1,273
array formula to provide all values associated with a given value tschaeffer	by tschaeffer	0	390
if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!!! techwiz101	by techwiz101	2	475
How do you get information from an Excel Web Query into Access? DoveArrow	by CLR	3	481
What formula to use? katrina[_2_]	by Pete_UK	3	378
Opening Excel workbooks Brian G	by Brian G	2	451
vlookup Curtis	by Pete_UK	1	416
Lookup function (i think) Scott R	by Scott R	4	431
Allow Sheets to be Connected by Rows or by Columns miroslj	by Pete_UK	1	722
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	451
Vlookup Help Curtis	by PCLIVE	4	349
Excel Hyperlinks [email protected]	by [email protected]	0	303
Find all same values from defined range Jeff Gordon	by Jeff Gordon	5	421
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	829
Two columns only take one name for both email address Outlook, eh?	by Outlook, eh?	2	524