Excel Worksheet Functions - Page 493

Thread / Thread Starter	Last Post	Replies	Views
how to sum cells from multiple work sheets jb2006	by Domenic	1	466
'TABLE' array function JB2010	by ExcelBanter AI	5	12,548
change cell contents when pull down menu choices change jb21	by Shane Devenshire[_2_]	3	1,180
Problem with Sum of Sums in Excel JB227	by JulieD	1	2,145
Wrong output returned during IF function jb333	by T. Valko	3	488
Problem with using INDIRECT with SUMPRODUCT and ROW() JB99	by RagDyeR	11	1,439
Making a column of numbers created from a formula permanent. jba919	by jba919	2	851
Filter zeros from two columns, maybe on different rows Jbaccinv	by Ashish Mathur[_2_]	2	1,277
How to sort protected worksheet in Excel 07? Doesn't work. jbachaud	by JLatham	1	1,228
Integrity problems with pivot tables jbaijet	by Sabine	5	871
cell that only a certain number may be entered jbailey	by Gord Dibben	7	540
How do I set up an If statement to look beyond the previous cell . jbaker	by GaryDK	3	379
Highest Date based on a number of criteria jball	by Teethless mama	3	532
Auto Date with Manual Entry Protection JBallance	by paul	1	845
Default a specific worksheet to be in forefront when open excel? jbankert	by Bernie Deitrick	1	608
Multiple If Statements in the same cell JBarsema	by ryguy7272	2	863
getting data from another worksheet jbart	by jbart	4	349
?set up a print range to cover multiple pages in excel JBC	by Dave Peterson	3	979
How to setup autoconnection between matching cells in 2 dif WSs jbdahl1	by Pete_UK	1	507
Excel formula using non-literal values jbdmom	by ShaneDevenshire	3	1,434
How do I retrieve data (specific cells) from multiple worksheets on a shared drive jbean	by Frank Kabel	1	1,510
combining worksheets into one sheet JBeaucaire[_90_]	by JBeaucaire[_90_]	0	385
Converting Values to Columns?? JBeaucaire[_90_]	by JBeaucaire[_90_]	0	319
Format of CSV file not preserved when edited in Excel 2007 JBeckett	by Dave Peterson	1	498
Function IF or COUNTIF JBee	by Pete_UK	3	353
how do I count only lower case "x" and exclude upper case "X" jbeletz	by Alan Beban	3	883
Calculating over multiple tabs jbelles	by jbelles	0	403
Date jbergsli	by Gord Dibben	4	396
Special functions in Excel jberlin	by jberlin	3	557
Have a Pivot Table Include a "% of an item" [email protected]	by Debra Dalgleish	1	710
Difference between Averages in a Pivot Table [email protected]	by Myrna Larson	3	1,197
add a column to a pivot table that would show the difference between 2 other Columns [email protected]	by Debra Dalgleish	7	2,355
How to scroll simultaneosly through two excel spreadsheets jbethel	by Debra Dalgleish	1	1,264
jbf frylock jbf frylock	by Pete	4	344
Range of numbers in a formula...PLEASE HELP!!! jbf frylock	by jbf frylock	9	1,197
Combine 2 cells without using the CONCATENATE function JBG	by JBG	2	834
ranking? JBG	by ryguy7272	8	619
Reverse ranking JBG	by T. Valko	1	859
Can I put color into a If...Then question? JBG	by Gaurav[_2_]	1	532
Maybe I need a if/then statement JBG	by Pete_UK	2	400
How do you use a If/then statement? JBG	by Pete_UK	7	544
HLookUp function Jbig	by Jacob Skaria	2	652
Pivot Tables & Conditional Formatting jbird	by Debra Dalgleish	2	749
Add asterisk to excel cell jblack35	by Bob Tarburton	1	1,797
how do I write a vlookup function within an iserror function so t. JBLeeds	by Bob Phillips	2	1,139
IF and VLOOKUP by date overwrite problem JBMcD	by JBMcD	0	611
finding like values in multiple excel spreadsheets [email protected]	by [email protected]	0	567
turning a string of cells into a work shift (eg. 9am-7pm) jbmjbj	by jbmjbj	0	464
Excel help jbneedanswer	by Sheeloo	3	582
2 formulas reference same worksheet, one an array jbo	by jbo	0	432
match multiple criteria in both rows and columns jbo	by jbo	2	945
Sumproduct with multiple criteria using indirect formula jbo	by Max	4	1,499
insert refreshable stock price no longer an option jbo	by Almogavar	1	1,714
Help with function involving if then else? jbobzien	by jbobzien	2	325
Simple Function question? jboss73	by Arvi Laanemets	3	483
How to perform logistic regression in Excel 2003 jbottg	by jbottg	2	3,390
trace dependents JBoulton	by JBoulton	2	1,749
Is there a function for this? JBoulton	by JBoulton	2	393
find top 25 codes JBoulton	by JBoulton	23	2,518
text and numbers JBoulton	by Glenn	16	838
complex count question JBoulton	by Ron Rosenfeld	13	1,339
date from sheet name JBoulton	by T. Valko	21	1,631
daily average JBoulton	by JBoulton	12	1,417
function to find which cells add up to a given total? jbourgui	by jbourgui	6	1,668
Can I use character masks within a function? jbouwhuis	by Dave Peterson	1	520
How doe I protect user defined functions in VB Editor jbowering	by jbowering	2	459
Condition for worksheet reference JBoyer	by JBoyer	5	608
MIN JBoyer	by T. Valko	2	523
MIN JBoyer	by JBoyer	0	362
SUMIF with 2 conditions JBoyer	by T. Valko	22	1,750
SUMIF with two condition from two ranges JBoyer	by JBoyer	3	614
Help with changing a formula JBoyer	by JBoyer	4	366
SUMIF JBoyer	by JBoyer	4	367
IF and SUMIF JBoyer	by Sandy Mann	9	532
Dragging Down a Formula JBoyer	by Bernie Deitrick	4	791