Excel Worksheet Functions - Page 85

Thread / Thread Starter	Last Post	Replies	Views
difference of 2 cells from 2 sheets to appear on sheet 3? wzkm123	by trip_to_tokyo[_3_]	2	378
VBLookup - need help Syed Rizvi	by Syed Rizvi	2	475
Switch lookup function to another sheet New2Macros	by Arvi Laanemets	2	672
Opening multiple templets in two monitors Morgan	by Gord Dibben	3	662
How to get SUMPRODUCT on filtered cells Sam.D[_2_]	by Gary''s Student	1	866
Summarizing with multiple conditions - Formula solution needed Daniel	by Max	2	418
Need Formula to solve my problem romen	by Stefi	1	429
Excel date intervals look up adam smith	by Jacob Skaria	1	711
Find value in a Range of Cells and perform Conditional Formatting Kamlesh	by Kamlesh	6	657
USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY) Tina	by Rick Rothstein	6	4,810
Excel 2002 always rounds up automatically Kent	by Kent	3	560
Sum J Walia	by Jacob Skaria	2	471
Deleting worksheets in a macro Donna[_2_]	by Jacob Skaria	2	608
help with Conditional formatting pairs of cells Parish Pete	by Ando	1	582
Date Functions & Formatting goskerz	by Ron Rosenfeld	9	486
Vlookup, sumproduct, if, sumif... erggg! Serendipity	by Don Guillett[_2_]	1	587
Import external data into Excel 2007 so I can subtotal it Denise	by Ashish Mathur[_2_]	2	2,994
How to add time from multiple cells & date Cells & machine type c Peter Gonzalez[_2_]	by Ashish Mathur[_2_]	3	1,316
NEED FORMULA HELP brushtec	by Lars-Åke Aspelin[_2_]	1	396
Function for odd even numbers petedacook	by Rick Rothstein	4	2,078
Max number of consectutive blanks in a range Steve	by T. Valko	7	607
reference sheet number not name Al	by Gary''s Student	1	3,117
Calculated Item in Pivot table Yogesh Gupta	by Debra Dalgleish	1	1,251
Calculate total metric based on sum of metric over specific time f StaceyB	by Bernard Liengme[_2_]	1	692
I have a file that is 4mb. Cleared all formating...still big JDH	by Gord Dibben	4	677
Why doesn't "Replace" function find value I know exists? UHAAdminAsst	by Gord Dibben	4	1,551
move a row of data from one work sheet to another using a formula Need formula help, Excel 2007, Thanks	by Don Guillett[_2_]	1	1,320
SEARCH DaveMoore	by Don Guillett[_2_]	1	345
Find last cell in a column, Delete its contents and make it active George	by Don Guillett[_2_]	5	534
Find last cell in a column, Delete its contents and make it ac Don Guillett[_2_]	by George	1	626
Usage of Data Validation with If Condition Mujeeb ur Rehman, FBL-GRW-PK	by Ashish Mathur[_2_]	4	1,613
Use if functions with dates glitterbug99	by Dave Peterson	1	497
Pivot Table Fields not showing Fritz	by Roger Govier[_3_]	2	6,338
How do I reference a worksheet name through a formula? pv6901	by Mike H	3	419
protect cells in excel, but also allow a search in those cells? LindaAlex	by LindaAlex	2	634
Can I invert a matrix in Excel 2007? Roger Hn	by Dave Peterson	2	2,108
formatting excel date list rslc[_3_]	by Pete_UK	5	511
Need help to change a cell color based on conditions Ken	by shail	1	536
Creating Visual Excel Cell Alerts alchemist	by CellShocked	5	880
cannot change datasource of pivotchart Nikki	by Nikki	0	842
Preventing double entry formula Yoli	by Ashish Mathur[_2_]	4	950
Assigning a macro to a button hberg	by Chip Pearson	1	480
HOW CAN I IMPLEMENT SUMIF(D1:D6,"AVERAGE(D1:D6)") Bill Friedman	by bapeltzer	1	385
Time Calculation and formulas needed (2 questions) --Viewpoint	by Teethless mama	1	567
Combo List in Excel Renee	by Gord Dibben	1	610
Summing Data rfhorn	by rfhorn	3	414
MATCH search with text and numbers Patryk	by Teethless mama	1	446
Error message needed if incorrect Date Of Birth (DOB) entered Craig	by Craig	5	769
exclude certain cells from series fill Doug	by Gord Dibben	1	826
remove contain from rows B thur J bill boch	by Eduardo	2	434
bitwise functions vbano	by Joe User[_2_]	3	4,754
if & And condition shajizz[_3_]	by shajizz[_4_]	3	501
command to move to different sheet hberg	by Eduardo	1	639
FIND text within text then sum Dhazmo	by Dhazmo	4	629
LOOKUP problem Lisa Cowan	by Eduardo	8	460
Auto Calculate Monthly Time Pace HeatherJ	by Eduardo	2	949
Reversing a column Don Kline[_2_]	by Don Kline[_2_]	2	351
how do I sumif on a font color in excel 2007? edk	by Teethless mama	1	1,940
Conditional formatting based upon due dates Tracey G	by Jacob Skaria	2	4,995
Matching data in 2 different work sheets Curtis	by Eduardo	3	643
sumif to aggregate month to quarter renegade	by Stefi	16	3,078
Copying a cell if dates match glitterbug99	by Jacob Skaria	2	506
automatic insertion of row renegade	by renegade	3	523
SUM Fuction Suzan Boyle	by Jacob Skaria	2	410
Month wise Sum hsg	by Jacob Skaria	4	1,238
countif with time NEHicks	by Chelsea[_2_]	3	485
some kind of Conditional format? - Baffled :( Dave[_13_]	by &rew	5	382
COUNTIF with adjacent columns Custard Tart	by Ashish Mathur[_2_]	4	1,162
time delay refresh on random number Bertrand[_2_]	by Bernie Deitrick	2	1,273
repeatedly extract a field to create a new list in another file? nut behind the computer	by Bernie Deitrick	1	398
vlookup jude	by jude	3	447
Spreadsheet - Deleting Duplicate Records - Self Checking APV-onlyownerknowinganyIT	by Max	1	447
Limitations on Sumif Calculation TaraD[_2_]	by T. Valko	3	6,007
Is it possible to count the no. of characters in a cell in Excel? karbrown12	by Teethless mama	2	427
Conditional Formula Help Please! CharlieGirl	by CLR	4	385