Excel Worksheet Functions - Page 194

Thread / Thread Starter	Last Post	Replies	Views
Can't stop recalc [email protected]	by [email protected]	2	550
Accumulator BadBoy	by BadBoy	2	479
conditional formating if and And ROPL	by Jacob Skaria	2	379
COLUMN() problem with array formula ejack	by ejack	0	519
array formulas counting substrings across rows Christi	by Jacob Skaria	6	430
How do I get text to speech to work in XP? MotorCityRock	by comcdp	3	643
Formula Help for Counting categories in a column Patti	by Fred Smith[_4_]	3	622
Format text in formula line mge	by Teethless mama	6	986
Getting wrong answer with Match Function CB1215	by Dave Peterson	3	1,874
Returning multiple values that are NOT in a single column or row crispino	by crispino	8	755
Average by Multiple Criteria. RoadKill	by T. Valko	3	763
Variable Symbol Kashyap	by Jacob Skaria	1	859
Custom date fields for pivot tables Amijab	by Herbert Seidenberg	4	3,211
comparing columns to find dup's stacey	by stacey	2	524
Consolidate 3 lists with duplicates into one list Re	by PJFry	1	809
Row increments - Janelle	by T. Valko	7	479
RAND() Charles W	by T. Valko	9	742
Transpose columns into continuous rows PattiP	by PattiP	1	783
index and match on 2 criteria Picman	by Picman	7	602
SUMPRODUCT - Creating a weighted score in column with subtotals DP	by Bernie Deitrick	3	1,733
Top 25 List of Times thscc1659	by thscc1659	1	391
Lookup Question Harlan	by Harlan	1	359
RANK ABSOLUTE NUMBER AND WITHOUT GAP M&M[_3_]	by Harlan Grove[_2_]	3	3,486
If formula Terrie Vargas	by Terrie Vargas	0	406
Duplex Printing Macro [email protected]	by [email protected]	0	1,215
Data Sort header row inungh	by Sheeloo	1	420
Problem with Vlookup Confused	by Jacob Skaria	10	701
conditional formula with lots of conditions sarajane82	by Glenn	8	401
If - Then statement Neall	by Neall	3	354
first and last occurance Darius	by Darius	7	615
Transfer Information Lois	by Ron de Bruin	4	634
Average function Harriet	by Jacob Skaria	5	402
Multiple formulas in a single cell referencing a drop down box. Sylvan06	by Sylvan06	3	855
Formula for Multiple Variables. Sri Harsha[_2_]	by macropod[_2_]	1	419
SUMIF, wrong result, strange behaviour Werner Rohrmoser	by Dave Peterson	5	3,029
Converting decimals to Time Gringarlow	by Gringarlow	4	514
Look Ups and Matches, Sorry if current thread exists- Clueless ABA	by ABA	5	370
per centages and sums error DebC	by David Biddulph[_2_]	5	511
search data and display colunm headers c_diver	by T. Valko	5	392
Vlookup Different tabs based on Dates andy	by T. Valko	5	846
Counting rows that meet multiple criteria sabow71	by T. Valko	5	966
Nesting IF to correct #VALUE! Error Message JennE	by JennE	2	602
Nesting IF funtions loweightes	by loweightes	2	389
How to sum cells based on conditions tjd59	by tjd59	2	527
Dependant drop down list with more than two words in the options Jock	by Jock	0	639
bug in excel 2007 for sorting function? javamama	by Ron Rosenfeld	3	588
2007/macros not working hughesdm	by Ron de Bruin	1	328
Sumif based on value in cell Jane	by Fred Smith[_4_]	4	1,456
Date open file with date saved Rita	by Rita	3	523
Find and replace * Kashyap	by Gary''s Student	1	310
Check Box Lois	by Gary''s Student	1	402
How to consolidate 580 file's data in 1 sheet without oppening all Amit Mahar	by Eduardo	1	547
create a automatice invoice from a data extract s2m[_2_]	by s2m[_2_]	0	470
Conditional Formatting ROPL	by Jarek Kujawa[_2_]	2	431
Automatically insert a line aeddave	by JLatham	5	797
Want a trace a same values exist in two different sheet Mukesh	by Mukesh	2	1,280
Matching & adding text in the respective column ashutosh	by Jarek Kujawa[_2_]	1	379
Conditional formula with multi tasks BadBoy	by BadBoy	1	498
formulas do not work Baracuda	by Baracuda	2	540
Formula behind functions VolkerB	by VolkerB	3	1,262
Concatencation and formatting Bengt[_3_]	by Ron Rosenfeld	17	977
Using V or H lookup katiapro93	by Pete_UK	3	305
Converting time to number, i.e. 2:32 to 2.32 Kokomojo	by Pete_UK	7	613
How to get text which is inside the brackets in excel sheet arun	by David Biddulph[_2_]	2	3,363
compare two or more ranges tywlam	by Stefi	3	496
List Box and IF function Jenny Beech	by Joerg Mochikun	1	2,087
conditional formatting based on different cells with more conditio sarajane82	by JBeaucaire[_90_]	1	378
linked data nidabland	by nidabland	0	335
Define cell value in a matrix to add up 2 constraints value gila_cokelat	by gila_cokelat	0	641
Compare ranges tywlam	by tywlam	0	453
Cleaning a list in Excel Shawnt	by Shawnt	1	464
display first or second match instead of #REF in INDEX ROW formula seapilot	by T. Valko	9	419
Custom Number Format TeddyTash	by Dave Peterson	2	384
create table of selected rows TBA	by TBA	1	404
Conditional Function Lisa H	by JLatham	4	529