Excel Worksheet Functions - Page 616

Thread / Thread Starter	Last Post	Replies	Views
Multiple conditional formula LeslieO via OfficeKB.com	by Teethless mama	4	422
Value or formula? Eric	by JMB	3	349
match two items to table for result Annette	by T. Valko	2	353
background color Tommy	by Tommy	4	469
SUMIF MULTIPLE ARRAY CRITERIA Santa-D	by T. Valko	1	770
Lookup using multiple sheets and multiple criteria, sorry if 2 pos kjguillermo	by Max	4	1,259
SUBSTITUTE patterns? [email protected]	by Gary''s Student	3	1,372
Another data across multiple worksheets question (ugh..) Rasman007	by Martin Fishlock	2	551
Can you link index keys between sheets for purchase/sales purpsose SmalleyP	by Rupert	1	497
sort & match Rae	by Martin Fishlock	1	449
formula to convert raw data from several sources into relative tot Yancy	by Rupert	2	2,064
Excel soccermama	by Gord Dibben	2	390
Expand and Collaps Groups while Protected blue	by blue	0	492
Grouping Geoffrey Allen	by Roger Govier	1	487
calculating cells hangs when filtering ranges in a sheet WiFiMike2006	by Pete_UK	1	961
Adding something to a column August	by August	5	680
counting occurrences in another sheet based on several criteria WiFiMike2006	by T. Valko	16	1,551
Synconizing Worksheets itten	by itten	4	403
if or statements to get three possible outcomes Dorothy A	by driller	4	1,352
HOW DO I CREATE A SUMMARY LIST FROM 200 SPREADSHEETS? Marcia	by Marcia	0	518
Last value in row GMW	by Epinn	6	942
How to sum data from another sheet using date ranges? Heeder07	by TimD	3	1,542
Converting Excel Columns pweseman	by pweseman	0	448
Multiple Selection of Non-Continuous Data [email protected]	by vezerid	3	1,369
If Function? KATYDID	by Sandy Mann	5	382
Excel-Match 1st text character in a string to a known character? bushlite	by Ron Coderre	2	2,646
how to auto fill information from a table to another sheet cmaki1975	by bda75	1	1,936
comparing worksheet and Marking the difference klafert	by klafert	2	738
Transpose from Col to row Smiley	by Bill Ridgeway	4	618
Rows to Columns on reference excelmad	by excelmad	4	519
conditional Formatting based on cell formatting Totom	by Totom	0	1,588
Formula Help LeslieO	by LeslieO via OfficeKB.com	6	440
Only calculate data table Rupert	by Rupert	0	758
reference and replace data from one sheet to another christoff13	by vezerid	1	624
work out compound intrest payments JAF	by JAF	3	632
Pivot Table Source MLK	by MLK	2	400
formula susan8541	by susan8541	7	496
Another "combine list" question SK	by SK	4	470
how to read the data from Excel sheet Manmohan Singh	by Manmohan Singh	0	464
Using information in one excel file in another Andrew Pickles	by Andrew Pickles	0	408
Convert XLS to XML without XLS Properties M$User	by M$User	0	518
Data Validation with IF and Max. Possible? Corey	by John Bundy	1	435
All cells shud contain a unique ref how do i check 4 duplicates? charlie777	by RichardSchollar	2	517
define nonblank in a formula anand	by RichardSchollar	1	935
Prefacing a Copy/Paste Special formula with text Bob Smith	by Joerg	1	744
Adding only positive numbers Eric	by FSt1	2	518
Can you find the cubed root on excel Me	by Teethless mama	2	414
Find Max Value in WorkSheet Corey	by Corey	11	1,047
how do I insert a variable amount of blank spaces in a formula? Lucy4484	by Dave Peterson	1	2,750
Drop TB into Financial Statements formula? Ang	by Ang	2	976
Excell convert formula row to formula column Danny	by Chip Pearson	1	801
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made rhhince	by JMB	1	899
Drop down list with different values. Honey	by JLatham	3	1,664
mental block Lost in excel	by Lost in excel	3	590
Number of DDE links sonicscooter	by sonicscooter	0	420
Conditional Formats for formulae and values GrahamB	by Gary''s Student	5	689
date + working days Jose	by Martin Fishlock	2	547
using IF function with AND/OR Ian R	by David Biddulph	4	382
dates opn6	by David Biddulph	2	308
Counting numbers with a letter attached in excel pano	by pano	13	954
referencing active cell works in a sub but not in a custom function RITCHI	by RITCHI	2	519
how do I insert a picture using a formula? AJ	by Ken Johnson	6	5,029
?formula EOB	by T. Valko	1	450
Extract Rows for UNIQUE and MAX Justin	by Ron Rosenfeld	1	488
referencing active cell works in a sub but not in a custom function RITCHI	by JLatham	1	542
IF and or function EOB	by EOB	3	397
Conditional Formatting: Excel 2003 vs. 2007 JP	by Chip Pearson	3	1,347
FORMULA THAT LIMITS WHAT IT CALCULATES VS WHATS ACTUAL Zigball	by Don Guillett	10	805
How can I create list of degrees,minutes,seconds Old Keith	by driller	5	625
COUNTIF in between rows Vasilis Tergen	by Vasilis Tergen	20	2,353
FIND, CLEAN, REPLACE question SCrowley	by SCrowley	2	483
Count how many Rows ago a particular number was hit rhhince	by Sandy Mann	1	562
how to combine formulas to......... gmisi	by Ken Johnson	5	809
Counting how many rows since a new value was made rhhince	by Sandy Mann	1	386
Formula to stop adding at a positive number nkhelp	by driller	7	530