Excel Worksheet Functions - Page 616

Thread / Thread Starter	Last Post	Replies	Views
Multiple conditional formula LeslieO via OfficeKB.com	by Teethless mama	4	413
Value or formula? Eric	by JMB	3	342
match two items to table for result Annette	by T. Valko	2	331
background color Tommy	by Tommy	4	454
SUMIF MULTIPLE ARRAY CRITERIA Santa-D	by T. Valko	1	757
Lookup using multiple sheets and multiple criteria, sorry if 2 pos kjguillermo	by Max	4	1,236
SUBSTITUTE patterns? [email protected]	by Gary''s Student	3	1,360
Another data across multiple worksheets question (ugh..) Rasman007	by Martin Fishlock	2	531
Can you link index keys between sheets for purchase/sales purpsose SmalleyP	by Rupert	1	491
sort & match Rae	by Martin Fishlock	1	437
formula to convert raw data from several sources into relative tot Yancy	by Rupert	2	2,045
Excel soccermama	by Gord Dibben	2	342
Expand and Collaps Groups while Protected blue	by blue	0	481
Grouping Geoffrey Allen	by Roger Govier	1	477
calculating cells hangs when filtering ranges in a sheet WiFiMike2006	by Pete_UK	1	948
Adding something to a column August	by August	5	677
counting occurrences in another sheet based on several criteria WiFiMike2006	by T. Valko	16	1,528
Synconizing Worksheets itten	by itten	4	392
if or statements to get three possible outcomes Dorothy A	by driller	4	1,337
HOW DO I CREATE A SUMMARY LIST FROM 200 SPREADSHEETS? Marcia	by Marcia	0	504
Last value in row GMW	by Epinn	6	907
How to sum data from another sheet using date ranges? Heeder07	by TimD	3	1,526
Converting Excel Columns pweseman	by pweseman	0	438
Multiple Selection of Non-Continuous Data [email protected]	by vezerid	3	1,356
If Function? KATYDID	by Sandy Mann	5	375
Excel-Match 1st text character in a string to a known character? bushlite	by Ron Coderre	2	2,555
how to auto fill information from a table to another sheet cmaki1975	by bda75	1	1,914
comparing worksheet and Marking the difference klafert	by klafert	2	726
Transpose from Col to row Smiley	by Bill Ridgeway	4	586
Rows to Columns on reference excelmad	by excelmad	4	503
conditional Formatting based on cell formatting Totom	by Totom	0	1,561
Formula Help LeslieO	by LeslieO via OfficeKB.com	6	427
Only calculate data table Rupert	by Rupert	0	750
reference and replace data from one sheet to another christoff13	by vezerid	1	617
work out compound intrest payments JAF	by JAF	3	624
Pivot Table Source MLK	by MLK	2	390
formula susan8541	by susan8541	7	486
Another "combine list" question SK	by SK	4	458
how to read the data from Excel sheet Manmohan Singh	by Manmohan Singh	0	456
Using information in one excel file in another Andrew Pickles	by Andrew Pickles	0	395
Convert XLS to XML without XLS Properties M$User	by M$User	0	510
Data Validation with IF and Max. Possible? Corey	by John Bundy	1	425
All cells shud contain a unique ref how do i check 4 duplicates? charlie777	by RichardSchollar	2	504
define nonblank in a formula anand	by RichardSchollar	1	921
Prefacing a Copy/Paste Special formula with text Bob Smith	by Joerg	1	710
Adding only positive numbers Eric	by FSt1	2	513
Can you find the cubed root on excel Me	by Teethless mama	2	409
Find Max Value in WorkSheet Corey	by Corey	11	1,023
how do I insert a variable amount of blank spaces in a formula? Lucy4484	by Dave Peterson	1	2,735
Drop TB into Financial Statements formula? Ang	by Ang	2	958
Excell convert formula row to formula column Danny	by Chip Pearson	1	787
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made rhhince	by JMB	1	880
Drop down list with different values. Honey	by JLatham	3	1,652
mental block Lost in excel	by Lost in excel	3	579
Number of DDE links sonicscooter	by sonicscooter	0	410
Conditional Formats for formulae and values GrahamB	by Gary''s Student	5	678
date + working days Jose	by Martin Fishlock	2	537
using IF function with AND/OR Ian R	by David Biddulph	4	370
dates opn6	by David Biddulph	2	298
Counting numbers with a letter attached in excel pano	by pano	13	944
referencing active cell works in a sub but not in a custom function RITCHI	by RITCHI	2	497
how do I insert a picture using a formula? AJ	by Ken Johnson	6	4,996
?formula EOB	by T. Valko	1	437
Extract Rows for UNIQUE and MAX Justin	by Ron Rosenfeld	1	479
referencing active cell works in a sub but not in a custom function RITCHI	by JLatham	1	514
IF and or function EOB	by EOB	3	387
Conditional Formatting: Excel 2003 vs. 2007 JP	by Chip Pearson	3	1,326
FORMULA THAT LIMITS WHAT IT CALCULATES VS WHATS ACTUAL Zigball	by Don Guillett	10	761
How can I create list of degrees,minutes,seconds Old Keith	by driller	5	559
COUNTIF in between rows Vasilis Tergen	by Vasilis Tergen	20	2,318
FIND, CLEAN, REPLACE question SCrowley	by SCrowley	2	468
Count how many Rows ago a particular number was hit rhhince	by Sandy Mann	1	547
how to combine formulas to......... gmisi	by Ken Johnson	5	779
Counting how many rows since a new value was made rhhince	by Sandy Mann	1	372
Formula to stop adding at a positive number nkhelp	by driller	7	521