Excel Worksheet Functions - Page 950

Thread / Thread Starter	Last Post	Replies	Views
subtracting dates leaves date/number or date Mark	by David Biddulph[_2_]	7	326
Sumproduct Help David	by Mike H	1	296
Help with time conversions WPP	by WPP	5	500
Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered pmdoherty	by pmdoherty	4	988
IF TODAY()< [email protected]	by [email protected]	3	535
Count No of days past due Mrs H	by Michael.Tarnowski	4	2,264
Locate changed cells with Worksheet_Calculate() FourLegSpider	by SaltyBall	4	1,680
Copy non merged to merged cells again [email protected]	by Pecoflyer[_115_]	2	570
Copy non merged to merged cells [email protected]	by Pecoflyer[_116_]	3	790
Conditionl format for 3 cells Skipping the center cell Mark	by Pete_UK	3	373
vlookup for same name, multiple instances... Chris_Hatch	by Pete_UK	19	2,767
newbie lena	by joeu2004	5	440
Formula please Peta[_2_]	by Roger Govier[_3_]	6	418
Calculating ratios: Is there a formula that can do this? dshadrock	by Shane Devenshire[_2_]	2	802
Count one character in a string across a range of cells? Andrea	by Rick Rothstein	3	1,370
Sum of Numbers Kshitij	by Herbert Seidenberg	5	441
Pivot Table Chart Drop Down Box Newbie	by Newbie	6	495
how do i compare two text columns sflanegin	by Shane Devenshire[_2_]	1	1,391
Date functions and #value! SafetyIntern[_2_]	by SelfTaughExcelJunkie	3	397
EXcel problem MicrosoftBob	by Shane Devenshire[_2_]	2	349
getting excel to recognise copied data as mm:ss not hh:mm Ravi B	by Shane Devenshire[_2_]	2	734
Find and replace dilemma mismose	by Rick Rothstein	8	410
Fill down without formatting macro Mike	by Bernie Deitrick	7	1,569
"go to" "blanks" after using a formula jhnnyboy247	by T. Valko	2	580
calculated celles according to more then 1 condition -yuval[_2_]	by xlmate	5	471
Function to find truncated entries? EllenM	by EllenM	4	359
Getting rid of VLOOKUP N/A WA	by WA	3	377
Partially refreshing spreadsheet Josh A	by Josh A	0	335
Fill Macro II Mike	by Mike	0	464
Option Buttons, Forms Control, Excel 2007 - 3 options Paula	by Paula	6	854
My current formulas in documents have quit working Clark	by Mike H	2	372
How can I write mm square, with 2 show up on top of mm.? Ck	by Chip Pearson	4	1,607
VB Code chrisnsmith	by Don Guillett	6	380
sum function angie	by Marcelo	3	329
dividng numbers using the sumif function tiare1021	by tiare1021	6	838
finding multiple code dates for multiple item number kmc	by Glenn	3	663
Using lookup functions with conditions and constantly changing dat (-) Ions	by Max	11	974
Double (triple?) Index Lookup thedr9wningman	by Max	6	531
Compare and then copy cell to separate worksheet Matt	by Pete_UK	1	362
Formula Help Curtis	by Paul	1	310
DIV/0 error Nicky	by Ashish Mathur[_2_]	5	389
How do I use countif like sumif ie (range,criteria,count_range) tmarie	by Ashish Mathur[_2_]	5	5,990
aging category calculation for open purchase order report in Excel Dan gibbs	by Ashish Mathur[_2_]	3	1,934
Question on which function to use [email protected]	by Ashish Mathur[_2_]	2	442
Vlookup question thedr9wningman	by thedr9wningman	0	335
How to get the number from text? Teethless mama	by Teethless mama	0	315
Referenced cell change when row is blank Teethless mama	by Teethless mama	0	391
SUMIF function Kathryn	by Elkar	7	387
Validating Date Format exceed_novice	by exceed_novice	5	446
SUMIF FUNCTION works in all cells but those related to one account Skyhawk	by T. Valko	4	583
Formula - assign a cell to show the next ash3154	by ash3154	6	419
nice shopping plaza [email protected]	by [email protected]	0	410
Error message Noepie	by Noepie	7	394
Referenced cell change when row is blank Read	by muddan madhu	1	398
how do i get a cell to fill red/blue as the outcome of a formula? Lynz1976	by Lynz1976	13	1,008
Trade Distributor and Store Merchandise Wanted Industrial Engineering	by Industrial Engineering	0	1,410
Using SUMPRODUCT, 3 variables, 2 types of data in 1 column Dana M	by Pete_UK	3	1,109
The If function Matt	by Pete_UK	4	452
userform date issue Woodi2	by Woodi2	4	858
How do I place a picture instead of words in a hidden comment box Christy81267	by xlmate	2	429
Excel 2007 vs 2003 menus. Ted Stilwell	by Shane Devenshire[_2_]	3	469
Countif(and Help with Countif(and	by T. Valko	7	693
conditional formating - dragging a cond. format over an entire col KIpp	by David Biddulph[_2_]	4	604
count with multiple critirea MANYHEADACHES[_2_]	by Shane Devenshire[_2_]	1	350
count with multiple critirea MANYHEADACHES	by Shane Devenshire[_2_]	4	391
count with multiple critirea MANYHEADACHES[_2_]	by Shane Devenshire[_2_]	2	333
Locking cells Graham	by Gord Dibben	3	423
Can i make text in cells c60@n60 bold & black if sum of C59 is gre Spartan C10	by Fred Smith[_4_]	7	500
convert day of year to numeric value format year+day in 4 digits Kaaren	by Shane Devenshire[_2_]	3	816
What number appears the most? rossmolden	by rossmolden	0	344
What number appears the most with a certain number rossmolden	by rossmolden	0	405
How to auto sum cells if letters are in cells? [email protected]	by Shane Devenshire[_2_]	2	1,670
Test 2 numbers Dave	by Shane Devenshire[_2_]	18	1,040
Vlookup question Craig	by Shane Devenshire[_2_]	3	390
How to get the number from text? JJ	by Shane Devenshire[_2_]	3	341