Excel Worksheet Functions - Page 616

Thread / Thread Starter	Last Post	Replies	Views
Multiple conditional formula LeslieO via OfficeKB.com	by Teethless mama	4	439
Value or formula? Eric	by JMB	3	352
match two items to table for result Annette	by T. Valko	2	356
background color Tommy	by Tommy	4	472
SUMIF MULTIPLE ARRAY CRITERIA Santa-D	by T. Valko	1	782
Lookup using multiple sheets and multiple criteria, sorry if 2 pos kjguillermo	by Max	4	1,275
SUBSTITUTE patterns? [email protected]	by Gary''s Student	3	1,380
Another data across multiple worksheets question (ugh..) Rasman007	by Martin Fishlock	2	558
Can you link index keys between sheets for purchase/sales purpsose SmalleyP	by Rupert	1	499
sort & match Rae	by Martin Fishlock	1	463
formula to convert raw data from several sources into relative tot Yancy	by Rupert	2	2,078
Excel soccermama	by Gord Dibben	2	399
Expand and Collaps Groups while Protected blue	by blue	0	506
Grouping Geoffrey Allen	by Roger Govier	1	496
calculating cells hangs when filtering ranges in a sheet WiFiMike2006	by Pete_UK	1	977
Adding something to a column August	by August	5	694
counting occurrences in another sheet based on several criteria WiFiMike2006	by T. Valko	16	1,558
Synconizing Worksheets itten	by itten	4	405
if or statements to get three possible outcomes Dorothy A	by driller	4	1,363
HOW DO I CREATE A SUMMARY LIST FROM 200 SPREADSHEETS? Marcia	by Marcia	0	528
Last value in row GMW	by Epinn	6	959
How to sum data from another sheet using date ranges? Heeder07	by TimD	3	1,553
Converting Excel Columns pweseman	by pweseman	0	462
Multiple Selection of Non-Continuous Data [email protected]	by vezerid	3	1,384
If Function? KATYDID	by Sandy Mann	5	394
Excel-Match 1st text character in a string to a known character? bushlite	by Ron Coderre	2	2,751
how to auto fill information from a table to another sheet cmaki1975	by bda75	1	1,984
comparing worksheet and Marking the difference klafert	by klafert	2	744
Transpose from Col to row Smiley	by Bill Ridgeway	4	627
Rows to Columns on reference excelmad	by excelmad	4	531
conditional Formatting based on cell formatting Totom	by Totom	0	1,638
Formula Help LeslieO	by LeslieO via OfficeKB.com	6	446
Only calculate data table Rupert	by Rupert	0	769
reference and replace data from one sheet to another christoff13	by vezerid	1	634
work out compound intrest payments JAF	by JAF	3	637
Pivot Table Source MLK	by MLK	2	403
formula susan8541	by susan8541	7	498
Another "combine list" question SK	by SK	4	484
how to read the data from Excel sheet Manmohan Singh	by Manmohan Singh	0	478
Using information in one excel file in another Andrew Pickles	by Andrew Pickles	0	422
Convert XLS to XML without XLS Properties M$User	by M$User	0	531
Data Validation with IF and Max. Possible? Corey	by John Bundy	1	454
All cells shud contain a unique ref how do i check 4 duplicates? charlie777	by RichardSchollar	2	523
define nonblank in a formula anand	by RichardSchollar	1	946
Prefacing a Copy/Paste Special formula with text Bob Smith	by Joerg	1	820
Adding only positive numbers Eric	by FSt1	2	525
Can you find the cubed root on excel Me	by Teethless mama	2	426
Find Max Value in WorkSheet Corey	by Corey	11	1,048
how do I insert a variable amount of blank spaces in a formula? Lucy4484	by Dave Peterson	1	2,765
Drop TB into Financial Statements formula? Ang	by Ang	2	982
Excell convert formula row to formula column Danny	by Chip Pearson	1	819
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made rhhince	by JMB	1	940
Drop down list with different values. Honey	by JLatham	3	1,680
mental block Lost in excel	by Lost in excel	3	592
Number of DDE links sonicscooter	by sonicscooter	0	432
Conditional Formats for formulae and values GrahamB	by Gary''s Student	5	704
date + working days Jose	by Martin Fishlock	2	560
using IF function with AND/OR Ian R	by David Biddulph	4	394
dates opn6	by David Biddulph	2	322
Counting numbers with a letter attached in excel pano	by pano	13	967
referencing active cell works in a sub but not in a custom function RITCHI	by RITCHI	2	532
how do I insert a picture using a formula? AJ	by Ken Johnson	6	5,042
?formula EOB	by T. Valko	1	454
Extract Rows for UNIQUE and MAX Justin	by Ron Rosenfeld	1	503
referencing active cell works in a sub but not in a custom function RITCHI	by JLatham	1	554
IF and or function EOB	by EOB	3	411
Conditional Formatting: Excel 2003 vs. 2007 JP	by Chip Pearson	3	1,353
FORMULA THAT LIMITS WHAT IT CALCULATES VS WHATS ACTUAL Zigball	by Don Guillett	10	808
How can I create list of degrees,minutes,seconds Old Keith	by driller	5	646
COUNTIF in between rows Vasilis Tergen	by Vasilis Tergen	20	2,375
FIND, CLEAN, REPLACE question SCrowley	by SCrowley	2	494
Count how many Rows ago a particular number was hit rhhince	by Sandy Mann	1	571
how to combine formulas to......... gmisi	by Ken Johnson	5	893
Counting how many rows since a new value was made rhhince	by Sandy Mann	1	400
Formula to stop adding at a positive number nkhelp	by driller	7	547