Excel Worksheet Functions - Page 616

Thread / Thread Starter	Last Post	Replies	Views
Multiple conditional formula LeslieO via OfficeKB.com	by Teethless mama	4	417
Value or formula? Eric	by JMB	3	344
match two items to table for result Annette	by T. Valko	2	334
background color Tommy	by Tommy	4	457
SUMIF MULTIPLE ARRAY CRITERIA Santa-D	by T. Valko	1	759
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,362
Another data across multiple worksheets question (ugh..) Rasman007	by Martin Fishlock	2	533
Can you link index keys between sheets for purchase/sales purpsose SmalleyP	by Rupert	1	492
sort & match Rae	by Martin Fishlock	1	439
formula to convert raw data from several sources into relative tot Yancy	by Rupert	2	2,046
Excel soccermama	by Gord Dibben	2	362
Expand and Collaps Groups while Protected blue	by blue	0	483
Grouping Geoffrey Allen	by Roger Govier	1	479
calculating cells hangs when filtering ranges in a sheet WiFiMike2006	by Pete_UK	1	951
Adding something to a column August	by August	5	679
counting occurrences in another sheet based on several criteria WiFiMike2006	by T. Valko	16	1,529
Synconizing Worksheets itten	by itten	4	394
if or statements to get three possible outcomes Dorothy A	by driller	4	1,339
HOW DO I CREATE A SUMMARY LIST FROM 200 SPREADSHEETS? Marcia	by Marcia	0	506
Last value in row GMW	by Epinn	6	909
How to sum data from another sheet using date ranges? Heeder07	by TimD	3	1,527
Converting Excel Columns pweseman	by pweseman	0	441
Multiple Selection of Non-Continuous Data [email protected]	by vezerid	3	1,361
If Function? KATYDID	by Sandy Mann	5	378
Excel-Match 1st text character in a string to a known character? bushlite	by Ron Coderre	2	2,582
how to auto fill information from a table to another sheet cmaki1975	by bda75	1	1,919
comparing worksheet and Marking the difference klafert	by klafert	2	727
Transpose from Col to row Smiley	by Bill Ridgeway	4	596
Rows to Columns on reference excelmad	by excelmad	4	506
conditional Formatting based on cell formatting Totom	by Totom	0	1,561
Formula Help LeslieO	by LeslieO via OfficeKB.com	6	429
Only calculate data table Rupert	by Rupert	0	752
reference and replace data from one sheet to another christoff13	by vezerid	1	618
work out compound intrest payments JAF	by JAF	3	626
Pivot Table Source MLK	by MLK	2	393
formula susan8541	by susan8541	7	488
Another "combine list" question SK	by SK	4	460
how to read the data from Excel sheet Manmohan Singh	by Manmohan Singh	0	458
Using information in one excel file in another Andrew Pickles	by Andrew Pickles	0	397
Convert XLS to XML without XLS Properties M$User	by M$User	0	512
Data Validation with IF and Max. Possible? Corey	by John Bundy	1	427
All cells shud contain a unique ref how do i check 4 duplicates? charlie777	by RichardSchollar	2	506
define nonblank in a formula anand	by RichardSchollar	1	922
Prefacing a Copy/Paste Special formula with text Bob Smith	by Joerg	1	716
Adding only positive numbers Eric	by FSt1	2	515
Can you find the cubed root on excel Me	by Teethless mama	2	410
Find Max Value in WorkSheet Corey	by Corey	11	1,027
how do I insert a variable amount of blank spaces in a formula? Lucy4484	by Dave Peterson	1	2,737
Drop TB into Financial Statements formula? Ang	by Ang	2	961
Excell convert formula row to formula column Danny	by Chip Pearson	1	791
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made rhhince	by JMB	1	884
Drop down list with different values. Honey	by JLatham	3	1,654
mental block Lost in excel	by Lost in excel	3	580
Number of DDE links sonicscooter	by sonicscooter	0	411
Conditional Formats for formulae and values GrahamB	by Gary''s Student	5	679
date + working days Jose	by Martin Fishlock	2	539
using IF function with AND/OR Ian R	by David Biddulph	4	373
dates opn6	by David Biddulph	2	300
Counting numbers with a letter attached in excel pano	by pano	13	947
referencing active cell works in a sub but not in a custom function RITCHI	by RITCHI	2	503
how do I insert a picture using a formula? AJ	by Ken Johnson	6	5,000
?formula EOB	by T. Valko	1	439
Extract Rows for UNIQUE and MAX Justin	by Ron Rosenfeld	1	481
referencing active cell works in a sub but not in a custom function RITCHI	by JLatham	1	520
IF and or function EOB	by EOB	3	390
Conditional Formatting: Excel 2003 vs. 2007 JP	by Chip Pearson	3	1,327
FORMULA THAT LIMITS WHAT IT CALCULATES VS WHATS ACTUAL Zigball	by Don Guillett	10	780
How can I create list of degrees,minutes,seconds Old Keith	by driller	5	578
COUNTIF in between rows Vasilis Tergen	by Vasilis Tergen	20	2,339
FIND, CLEAN, REPLACE question SCrowley	by SCrowley	2	470
Count how many Rows ago a particular number was hit rhhince	by Sandy Mann	1	549
how to combine formulas to......... gmisi	by Ken Johnson	5	781
Counting how many rows since a new value was made rhhince	by Sandy Mann	1	374
Formula to stop adding at a positive number nkhelp	by driller	7	522