Excel Worksheet Functions - Page 501

Thread / Thread Starter	Last Post	Replies	Views
Copy Sum formula to different row but use same column data jefe96	by Max	3	2,909
Populate an array that is a subset of a larger array? Jeff	by Pete_UK	1	796
If Statement / Array JEFF	by T. Valko	6	558
Combining Numerous Columns Jeff	by Pete_UK	3	424
Calendar resizes when workbook is closed jeff	by jeff	0	411
formula references two embedded excel objects in Word doc Jeff	by Barb Reinhardt	1	1,093
Can you create a new array based on the value in a column? Jeff	by Spiky	3	432
extract data from one worksheet to another worksheet Jeff	by Teethless mama	5	2,084
Adding random #s in a range to equal a specific # Jeff	by Jeff	4	436
Counting Combo Drop Down Box Selections Jeff	by Brad Vogt	1	533
Inputed Interest / Present Value JEFF	by JEFF	7	537
Searching for records with multiple criteria Jeff	by Jeff	7	569
IRR Trouble jeff	by Ron Rosenfeld	1	462
Reference cell in one TAB from another using two criteria Jeff	by Max	4	1,222
Linking Data for Proposal Jeff	by Debra Dalgleish	6	523
'COUNTIF' and 'AND" Jeff	by bj	3	479
How do I send multi-sheet documents from Excel via Outlook? Jeff	by Gord Dibben	2	463
Indirect with COLUMN JEFF	by Ragdyer	9	1,239
how do you create a floating row? Jeff	by Fred Smith	1	2,596
Data Form Jeff	by mikebres	3	311
long printing on a plotter Jeff	by Luke M[_4_]	1	1,809
Is there a way to conditionally hide rows in Excel? Jeff	by Dave Peterson	1	1,037
Sumifs (I think) Jeff	by Jeff	5	453
Calculated Pivot Table Columns Jeff	by Ashish Mathur[_2_]	1	374
Replacing special characters in Excel 2007 Jeff	by Sean Timmons	3	2,851
Showing the function in the active cell Jeff	by Pete_UK	5	587
=SUMPRODUCT((C481:C507<"")/COUNTIF(C481:C507,C481:C507&"")) Jeff	by Eduardo	3	360
Use Sum() with variable range Jeff	by Jeff	4	926
Combining data from different cells and more... Jeff	by Elkar	2	430
Math Question JEFF	by JEFF	3	345
Return to Home Row Jeff	by Jeff	4	1,105
ideas needed please Jeff	by Bernie Deitrick	1	400
Security/Protection/Hiding WorkSheets Jeff	by Jeff	3	530
Home cell Jeff	by Gord Dibben	3	283
Macros/Security Jeff	by Gord Dibben	3	407
Stuck! Please help Jeff	by Jeff	11	1,044
Data Valadation Jeff	by Gord Dibben	4	445
Get rid of DIV/0 error message Jeff	by Pete_UK	4	3,168
Identify the contents of column in a filtered range Jeff	by Jeff	6	611
how do I find prime factors of a number Jeff	by Ron Rosenfeld	16	3,203
Extract Unique entries in a column Jeff	by Aladin Akyurek	4	814
Capture and list data from a column or row Jeff	by Jeff	2	537
Can a macro erase it's self after a set criteria? Jeff	by Richard Buttrey	3	416
Formula to capture data on a date and preserve it Jeff	by Jeff	0	639
remove text that pops up with combo box Jeff	by Rowan	1	490
Multiple Substitutes Jeff	by Aladin Akyurek	2	339
How do I select on two variables in a range of data in excel Jeff	by Biff	7	818
How can I copy and paste the text of a formula? Jeff	by Duke Carey	1	671
Update a cell with a specific value related to a date. Jeff	by Jeff	5	1,128
Indirect, Concatenate, & ? JEFF	by JEFF	7	775
functions do not calculate Jeff	by Gary's Student	2	357
Macro for autofilter using variables declared in worksheet Jeff	by Jeff	2	1,323
Counting within a filtered range Jeff	by Jeff	2	531
How do I copy Page Setups from one Sheet to Another sheet? Jeff	by Dave Peterson	1	658
linking worksheets Jeff	by Dave Peterson	2	674
cannot group columns - get "cannot shift objects off sheet" help! jeff	by jeff	0	791
If statement Jeff	by Peo Sjoblom	1	433
formula for parenthesis round negative money values in excel jeff	by Peo Sjoblom	1	1,053
color Banding using visual basic Jeff	by JLatham	1	494
Populate a table with a dynamic range Jeff	by Arvi Laanemets	3	1,533
create a dymamic range for printing Jeff	by Don Guillett	6	633
Variable Range to be used in a chart Jeff	by Herbert Seidenberg	1	408
IRR / MIRR and Perpetuity Jeff	by ExcelBanter AI	8	12,712
common entry reporting Jeff	by Bernard Liengme	1	381
Multiple entries in column Jeff	by Jeff	0	401
multiple entries-sums to different cells Jeff	by Jeff	0	461
recalculate cells Jeff	by Mohamed Shafiee	3	422
naming tabs Jeff	by Paul B	8	513
Mortgage calculations Jeff	by Morrigan	2	499
Sum rows if two columns = specific criteria. Jeff	by Ashish Mathur	2	1,015
Countif - Buying Frequency JEFF	by JEFF	2	596
how to limit amount of numbers in cells in excel Jeff	by Spiky	6	849
how do I find my old questions Jeff	by Chip Pearson	1	362
Value returned from Formula changes with the Date Jeff	by Max	6	612
how to copy cells data in every 7th row? Jeff	by David Billigmeier	3	1,042