Excel Worksheet Functions - Page 102

Thread / Thread Starter	Last Post	Replies	Views
Gap check formula? LSSR	by Max	7	3,167
Check 3 cells, only one of the cells my be filled Peter Jonkers	by Peter Jonkers	7	697
Creating child worksheet from parent Vibeke	by Shane Devenshire[_2_]	7	1,435
Copy Worksheet wont copy objects. Lincoln De Kalb	by Lincoln De Kalb	7	806
How to read workbook (not worksheet) properties with OLEDB 4everDad	by Bob Barrows [MVP]	7	736
OR in IF T2net	by T2net	7	635
array and countif help! jcorle	by PCLIVE	7	656
HOW DO I POPULATE AN EXCEL TEMPLATE USING DATABASE trent	by Otto Moehrbach[_2_]	7	1,320
Help with Possible Array or Sumproduct Formula Steph	by Bernd P	7	603
Dynamic summation of column prasanth	by RagDyeR	7	533
Count based on single number in string Basenji	by T. Valko	7	586
Copying certain values from one column into another column Eddie Morris	by Max	7	2,271
Need formula to STAY Needs Help	by RagDyeR	7	680
Help with Time Function Chris	by Ron Rosenfeld	7	469
Express 'Joined up' IF's Q Sean	by Sean	7	449
Deriving an earlier date based on a later date Bob	by Ron Rosenfeld	7	545
Time for IFERROR? PAL	by Bob Phillips	7	832
SumProduct making things work slow Adam Graham	by Charles Williams	7	656
Split 2 names within a cell in excel LBristow	by Don Guillett	7	1,050
IF column contains certain text return value of corresponding row Daly	by Shane Devenshire[_2_]	7	3,508
Formula help Meejung	by Meejung	7	771
Formula in CF dlamarche	by Dana DeLouis[_3_]	7	466
Counting unique numbers Juan Marin	by Bernd P	7	557
Merging excel tables & more, countif, macro line insert etc Cheekyaardvark	by Ashish Mathur[_2_]	7	704
use a function for filtered data debl	by T. Valko	7	708
Changing part of cell reference in INDEX - MATCH formula HebbeLille	by Max	7	749
Conditional Formatting RMartin	by T. Valko	7	670
Another Greater Than Less Than onditional problem. Scott Dann	by Dana DeLouis[_3_]	7	643
formula mon732	by T. Valko	7	424
Re Change 5 week days to 7 days in this formula pano	by Bob Phillips	7	1,110
Validation Sum Stacy C[_2_]	by T. Valko	7	485
Count function Ranjith Kurian[_2_]	by T. Valko	7	521
Function returning unexpected value Paul	by JoeU2004	7	485
Named Array KC Excel Qns	by Dana DeLouis[_3_]	7	466
VLOOKUP or MATCH and/or INDEX to extract value on a given date Don Kline[_2_]	by Max	7	1,007
Help with formula Josh W	by JoeU2004	7	507
Saving sheet data to another sheet automatically John Aikin	by Per Jessen	7	607
If, VLookup, Index, or a combination of all of them? LisaM	by T. Valko	7	634
date/time stamp Jan	by DKY	7	1,369
Returning the last modified date to a cell in excel 2003 Dunc	by Rick Rothstein	7	1,938
commissions by range abryan	by JE McGimpsey	7	542
Please help me with a formula Smeeg	by Smeeg	7	397
Calculations from date and time values kp	by Ron Rosenfeld	7	732
Auto color-shading of rows Fitz	by Adrian	7	423
Totalling formulas Steved	by Steved	7	392
perform calculation only if current time is after 10 am julieskennels	by Sandy Mann	7	1,005
highlighting a change in value ellebelle	by ellebelle	7	281
Linking worksheet event codes Mr. G.	by Kassie	7	607
Search array and return element No Ron	by Biff	7	575
Filtering ? Tarjei Lundarvollen	by Dominic	7	680
HELP....Is there a way to automate copy/paste special/transpose - Mel	by Max	7	1,645
Look up of data in a different Sheet Pester	by Pester	7	640
Function/macro to relocate RxC to CxR? J.Kearney	by Don Cameron	7	407
Simplify Vlookup function in Excel Budman	by Ernst Guckel	7	1,886
Formula Trouble JS	by JulieD	7	632
ACCRINT formula yields incorrect result Onurali_k	by Onurali_k	7	967
Wildcards with SumProduct pomalley	by pomalley	7	1,025
Running total question Mike Hyndman	by Mike Hyndman	7	642
Multiple If (Lookup?) Statement Teri	by Teri	7	790
Automatically copy formulas/functions to inserted rows. Barbara	by Gord Dibben	7	1,214
copying formula without scrolling 9000 rows chiechka	by Harlan Grove	7	946
Dates for month in cell a1 downwards pano	by Dave Peterson	7	427
if/and formulas Chuckee	by Pete_UK	7	444
If Date Null Show Nothing Ardy	by Ardy	7	2,071
How to determine if a cell has a value, then copy it to a new loca Shelly	by Dave Peterson	7	1,782
Pick which sheet to put a wordart stamp on pano	by Gord Dibben	7	487
Conditional Formating - not in table GregR	by GregR	7	543
Formula problems Lago2004	by Gord Dibben	7	864
Summing all cells containing the letter K Jan T.	by Brent	7	947
question about offset function OTS	by JLatham	7	417
countif using a range gerryR	by Ardus Petus	7	530
Selecting alternate cells Jackie D	by Carlos Antenna	7	1,279
if then function Pam	by Pete_UK	7	329
Sumproduct with #N/A in range Deeds	by Deeds	7	1,415
Lookup using more than one criteria Beccy	by Pete_UK	7	500