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	389
VBLookup - need help Syed Rizvi	by Syed Rizvi	2	491
Switch lookup function to another sheet New2Macros	by Arvi Laanemets	2	680
Opening multiple templets in two monitors Morgan	by Gord Dibben	3	677
How to get SUMPRODUCT on filtered cells Sam.D[_2_]	by Gary''s Student	1	872
Summarizing with multiple conditions - Formula solution needed Daniel	by Max	2	434
Need Formula to solve my problem romen	by Stefi	1	439
Excel date intervals look up adam smith	by Jacob Skaria	1	723
Find value in a Range of Cells and perform Conditional Formatting Kamlesh	by Kamlesh	6	666
USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY) Tina	by Rick Rothstein	6	4,923
Excel 2002 always rounds up automatically Kent	by Kent	3	570
Sum J Walia	by Jacob Skaria	2	480
Deleting worksheets in a macro Donna[_2_]	by Jacob Skaria	2	628
help with Conditional formatting pairs of cells Parish Pete	by Ando	1	598
Date Functions & Formatting goskerz	by Ron Rosenfeld	9	490
Vlookup, sumproduct, if, sumif... erggg! Serendipity	by Don Guillett[_2_]	1	602
Import external data into Excel 2007 so I can subtotal it Denise	by Ashish Mathur[_2_]	2	3,010
How to add time from multiple cells & date Cells & machine type c Peter Gonzalez[_2_]	by Ashish Mathur[_2_]	3	1,326
NEED FORMULA HELP brushtec	by Lars-Åke Aspelin[_2_]	1	414
Function for odd even numbers petedacook	by Rick Rothstein	4	2,111
Max number of consectutive blanks in a range Steve	by T. Valko	7	616
reference sheet number not name Al	by Gary''s Student	1	3,127
Calculated Item in Pivot table Yogesh Gupta	by Debra Dalgleish	1	1,263
Calculate total metric based on sum of metric over specific time f StaceyB	by Bernard Liengme[_2_]	1	700
I have a file that is 4mb. Cleared all formating...still big JDH	by Gord Dibben	4	685
Why doesn't "Replace" function find value I know exists? UHAAdminAsst	by Gord Dibben	4	1,559
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,334
SEARCH DaveMoore	by Don Guillett[_2_]	1	350
Find last cell in a column, Delete its contents and make it active George	by Don Guillett[_2_]	5	547
Find last cell in a column, Delete its contents and make it ac Don Guillett[_2_]	by George	1	639
Usage of Data Validation with If Condition Mujeeb ur Rehman, FBL-GRW-PK	by Ashish Mathur[_2_]	4	1,638
Use if functions with dates glitterbug99	by Dave Peterson	1	510
Pivot Table Fields not showing Fritz	by Roger Govier[_3_]	2	6,352
How do I reference a worksheet name through a formula? pv6901	by Mike H	3	430
protect cells in excel, but also allow a search in those cells? LindaAlex	by LindaAlex	2	658
Can I invert a matrix in Excel 2007? Roger Hn	by Dave Peterson	2	2,117
formatting excel date list rslc[_3_]	by Pete_UK	5	530
Need help to change a cell color based on conditions Ken	by shail	1	548
Creating Visual Excel Cell Alerts alchemist	by CellShocked	5	892
cannot change datasource of pivotchart Nikki	by Nikki	0	850
Preventing double entry formula Yoli	by Ashish Mathur[_2_]	4	958
Assigning a macro to a button hberg	by Chip Pearson	1	500
HOW CAN I IMPLEMENT SUMIF(D1:D6,"AVERAGE(D1:D6)") Bill Friedman	by bapeltzer	1	394
Time Calculation and formulas needed (2 questions) --Viewpoint	by Teethless mama	1	578
Combo List in Excel Renee	by Gord Dibben	1	625
Summing Data rfhorn	by rfhorn	3	455
MATCH search with text and numbers Patryk	by Teethless mama	1	467
Error message needed if incorrect Date Of Birth (DOB) entered Craig	by Craig	5	780
exclude certain cells from series fill Doug	by Gord Dibben	1	832
remove contain from rows B thur J bill boch	by Eduardo	2	438
bitwise functions vbano	by Joe User[_2_]	3	4,769
if & And condition shajizz[_3_]	by shajizz[_4_]	3	510
command to move to different sheet hberg	by Eduardo	1	653
FIND text within text then sum Dhazmo	by Dhazmo	4	635
LOOKUP problem Lisa Cowan	by Eduardo	8	467
Auto Calculate Monthly Time Pace HeatherJ	by Eduardo	2	960
Reversing a column Don Kline[_2_]	by Don Kline[_2_]	2	358
how do I sumif on a font color in excel 2007? edk	by Teethless mama	1	1,953
Conditional formatting based upon due dates Tracey G	by Jacob Skaria	2	5,019
Matching data in 2 different work sheets Curtis	by Eduardo	3	659
sumif to aggregate month to quarter renegade	by Stefi	16	3,097
Copying a cell if dates match glitterbug99	by Jacob Skaria	2	519
automatic insertion of row renegade	by renegade	3	536
SUM Fuction Suzan Boyle	by Jacob Skaria	2	422
Month wise Sum hsg	by Jacob Skaria	4	1,252
countif with time NEHicks	by Chelsea[_2_]	3	489
some kind of Conditional format? - Baffled :( Dave[_13_]	by &rew	5	392
COUNTIF with adjacent columns Custard Tart	by Ashish Mathur[_2_]	4	1,173
time delay refresh on random number Bertrand[_2_]	by Bernie Deitrick	2	1,289
repeatedly extract a field to create a new list in another file? nut behind the computer	by Bernie Deitrick	1	407
vlookup jude	by jude	3	458
Spreadsheet - Deleting Duplicate Records - Self Checking APV-onlyownerknowinganyIT	by Max	1	460
Limitations on Sumif Calculation TaraD[_2_]	by T. Valko	3	6,053
Is it possible to count the no. of characters in a cell in Excel? karbrown12	by Teethless mama	2	439
Conditional Formula Help Please! CharlieGirl	by CLR	4	399