Excel Worksheet Functions - Page 616

Thread / Thread Starter	Last Post	Replies	Views
Multiple conditional formula LeslieO via OfficeKB.com	by Teethless mama	4	425
Value or formula? Eric	by JMB	3	350
match two items to table for result Annette	by T. Valko	2	354
background color Tommy	by Tommy	4	469
SUMIF MULTIPLE ARRAY CRITERIA Santa-D	by T. Valko	1	772
Lookup using multiple sheets and multiple criteria, sorry if 2 pos kjguillermo	by Max	4	1,263
SUBSTITUTE patterns? [email protected]	by Gary''s Student	3	1,374
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	498
sort & match Rae	by Martin Fishlock	1	451
formula to convert raw data from several sources into relative tot Yancy	by Rupert	2	2,072
Excel soccermama	by Gord Dibben	2	391
Expand and Collaps Groups while Protected blue	by blue	0	494
Grouping Geoffrey Allen	by Roger Govier	1	488
calculating cells hangs when filtering ranges in a sheet WiFiMike2006	by Pete_UK	1	964
Adding something to a column August	by August	5	681
counting occurrences in another sheet based on several criteria WiFiMike2006	by T. Valko	16	1,552
Synconizing Worksheets itten	by itten	4	404
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	522
Last value in row GMW	by Epinn	6	943
How to sum data from another sheet using date ranges? Heeder07	by TimD	3	1,544
Converting Excel Columns pweseman	by pweseman	0	450
Multiple Selection of Non-Continuous Data [email protected]	by vezerid	3	1,370
If Function? KATYDID	by Sandy Mann	5	383
Excel-Match 1st text character in a string to a known character? bushlite	by Ron Coderre	2	2,733
how to auto fill information from a table to another sheet cmaki1975	by bda75	1	1,979
comparing worksheet and Marking the difference klafert	by klafert	2	739
Transpose from Col to row Smiley	by Bill Ridgeway	4	620
Rows to Columns on reference excelmad	by excelmad	4	520
conditional Formatting based on cell formatting Totom	by Totom	0	1,635
Formula Help LeslieO	by LeslieO via OfficeKB.com	6	446
Only calculate data table Rupert	by Rupert	0	759
reference and replace data from one sheet to another christoff13	by vezerid	1	626
work out compound intrest payments JAF	by JAF	3	636
Pivot Table Source MLK	by MLK	2	402
formula susan8541	by susan8541	7	497
Another "combine list" question SK	by SK	4	471
how to read the data from Excel sheet Manmohan Singh	by Manmohan Singh	0	466
Using information in one excel file in another Andrew Pickles	by Andrew Pickles	0	411
Convert XLS to XML without XLS Properties M$User	by M$User	0	520
Data Validation with IF and Max. Possible? Corey	by John Bundy	1	438
All cells shud contain a unique ref how do i check 4 duplicates? charlie777	by RichardSchollar	2	518
define nonblank in a formula anand	by RichardSchollar	1	939
Prefacing a Copy/Paste Special formula with text Bob Smith	by Joerg	1	819
Adding only positive numbers Eric	by FSt1	2	519
Can you find the cubed root on excel Me	by Teethless mama	2	415
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,752
Drop TB into Financial Statements formula? Ang	by Ang	2	979
Excell convert formula row to formula column Danny	by Chip Pearson	1	809
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made rhhince	by JMB	1	930
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	421
Conditional Formats for formulae and values GrahamB	by Gary''s Student	5	690
date + working days Jose	by Martin Fishlock	2	548
using IF function with AND/OR Ian R	by David Biddulph	4	383
dates opn6	by David Biddulph	2	309
Counting numbers with a letter attached in excel pano	by pano	13	956
referencing active cell works in a sub but not in a custom function RITCHI	by RITCHI	2	521
how do I insert a picture using a formula? AJ	by Ken Johnson	6	5,032
?formula EOB	by T. Valko	1	451
Extract Rows for UNIQUE and MAX Justin	by Ron Rosenfeld	1	489
referencing active cell works in a sub but not in a custom function RITCHI	by JLatham	1	543
IF and or function EOB	by EOB	3	398
Conditional Formatting: Excel 2003 vs. 2007 JP	by Chip Pearson	3	1,352
FORMULA THAT LIMITS WHAT IT CALCULATES VS WHATS ACTUAL Zigball	by Don Guillett	10	807
How can I create list of degrees,minutes,seconds Old Keith	by driller	5	626
COUNTIF in between rows Vasilis Tergen	by Vasilis Tergen	20	2,363
FIND, CLEAN, REPLACE question SCrowley	by SCrowley	2	484
Count how many Rows ago a particular number was hit rhhince	by Sandy Mann	1	563
how to combine formulas to......... gmisi	by Ken Johnson	5	879
Counting how many rows since a new value was made rhhince	by Sandy Mann	1	387
Formula to stop adding at a positive number nkhelp	by driller	7	531