Excel Worksheet Functions - Page 856

Thread / Thread Starter	Last Post	Replies	Views
update workbook MAANI	by Gary''s Student	1	413
Get vaçues in multiple sheets Carpe Diem	by Carpe Diem	0	318
Replacing cell reference on multiple sheets in one go.... neilcarden	by neilcarden	3	329
return 4 lots of data when a corresponding number is entered shrek5000	by Pete_UK	3	378
How do I create a formula to add to a cell value, up to a set maxi JWmadrid	by Glenn	3	447
Lookup or...? Lene	by Bob Phillips	1	374
formula drag down when using filter in 2007 CAM	by CAM	0	1,574
Sort of subsheet Pyrite	by Pete_UK	3	979
Multiple Vlookup Iriemon	by Iriemon	3	355
Finding a value or the one next to it in a range NOT array advanced novice	by Pete_UK	3	466
sort when using VLOOKUP Kathie	by Fred Smith[_4_]	1	680
How do i get Excel not to drop my 1st zero (02360) Yaesu Man	by Fred Smith[_4_]	5	3,457
password protects different worksheets n upload on the web Kanika	by JP[_4_]	1	468
Copy custom footer across multiple sheets Clark	by Pete_UK	3	3,633
Using lookup formula [email protected]	by [email protected]	2	376
Cross-sheet formula and sort data smuggy	by smuggy	0	710
Can Tab name in worksheet change automatically by referencing a ce Alvyn	by Alvyn	2	553
Excel 2003 lindle101	by lindle101	4	326
column subtotal Mel	by Mel	0	471
How do I increase the font size when creating a drop down list? DATA VALIDATION LIST	by Peo Sjoblom[_2_]	1	673
SUMIF Mike	by Teethless mama	1	345
precentage formula Dphel	by John C[_2_]	3	485
Extracting Data from another worksheet based on user input Alvyn	by Sandy Mann	14	1,119
IF Statement Libby	by Peo Sjoblom[_2_]	6	519
Compare data from two worksheets and display difference into 3rd s auntiespyke	by Pete_UK	4	1,401
convert yyyy-ww date to actual date Pierre	by Pierre	2	3,500
Adding Day to find a next weekday Dolt	by gafern	12	1,263
adding function to an existing formula chickenita	by Glenn	2	480
reference a closed filed from a cell and formula in an open file dh13134	by Peo Sjoblom[_2_]	15	1,266
Formula Error roxiemayfield	by Mike H	3	460
remove duplicate rows from specific data in a column; excel 2007 DS	by Mike H	1	1,161
Keep Dependent Value While Deleting Precedents Atilla	by Atilla	3	463
How to keep a set range in a Search function Connie	by Glenn	1	410
Formulas/References Josh	by Lars-Åke Aspelin[_2_]	3	349
transfering data in another column entering more sorted data Kevin - Corporate Services	by Kevin - Corporate Services	0	632
copy down robzrob	by robzrob	4	346
Counting numbers in an array BRob	by Ron Rosenfeld	4	373
Counting colored cells Joebeone	by Chip Pearson	3	456
How do I reference a cell to another in the preceding worksheet karl.sonja	by Gord Dibben	8	547
Vlookup not returning correct value Drebdog	by Drebdog	4	964
Simple Worksheet Protection James8309	by James8309	2	448
problem: "You entered too many arguments for this function" Sam Giddy	by Pete_UK	1	1,822
Filtering totals - Reps per Province jvbelg	by Teethless mama	6	559
INCREASE COST COLUMN BY A PERCENTAGE bill z	by T. Valko	3	791
Error: Undefined or non-rectangular name Conan Kelly	by Conan Kelly	0	2,585
Need help creating formula to sum tables Darren Ingram	by Piotr (Peter)[_2_]	4	596
Display Zero only in Selected Cells using a formula Steved	by Max	8	1,134
Using two formulae Kirsty_H	by Kirsty_H[_2_]	3	414
validation data KE	by Stefi	1	353
Working with Functions on French Computer Cazzy123	by Niek Otten	3	777
How to delete a hundred range names at once? Dima	by Dima	4	702
How do I switch form annual events list to my orginal calender Kirk Polson	by David Biddulph[_2_]	1	390
Conditional Format based on value of another cell [email protected]	by Bob Phillips[_3_]	5	585
how do i create a scroll option presenting a changeable figure? VK	by M Kan	1	531
Address of last nonzero value in a range Ron Coderre	by Ron Coderre	0	948
VLOOKUP lindle101	by John C[_2_]	5	2,534
look for missing element SteveDB1	by SteveDB1	1	467
return values in the table with multiple conditions cprao	by cprao	3	473
Address of last nonzero value Wigi	by Wigi	0	855
automatically show modified date? Tacrier	by Tacrier	2	809
Add different values that equal 1 on a row Add sum of different values	by Sandy Mann	2	506
Multiple pivot tables, based on same source data tab; disable refreshon 1st tab? Pierre	by Pierre	0	1,179
Keeping linked sheets relative... help! Gaijintendo	by Spiky	2	443
Excel 3-D Reference FirstVette52	by Peo Sjoblom[_2_]	3	335
Subtotal Function is Inconsistent TKS_Mark	by TKS_Mark	4	633
Automatic Selection of Multiple Rows Emmlie	by Peo Sjoblom[_2_]	3	1,209
If Function With A Time Donna	by Donna	5	444
stop macro if cell does not equal zero BIGBOY1974AA	by Duke Carey	1	1,317
Formula for x & y calculation K. Carter	by Bernie Deitrick	5	978
Calculating towards a target number Mary	by Mary	2	433
Returning multiple cells bmcgill	by Lars-Åke Aspelin[_2_]	1	423
link to a cell in an external spreedsheet Terry	by Pierre	3	411
Which function? Connie Martin	by Mike H	3	298
SUM PRODUCT FUNCTION Sue NY	by Reitanos	5	336
extract numbers from a string Dave	by Otto Moehrbach[_2_]	3	524