Excel Worksheet Functions - Page 194

Thread / Thread Starter	Last Post	Replies	Views
Can't stop recalc [email protected]	by [email protected]	2	531
Accumulator BadBoy	by BadBoy	2	462
conditional formating if and And ROPL	by Jacob Skaria	2	348
COLUMN() problem with array formula ejack	by ejack	0	510
array formulas counting substrings across rows Christi	by Jacob Skaria	6	396
How do I get text to speech to work in XP? MotorCityRock	by comcdp	3	618
Formula Help for Counting categories in a column Patti	by Fred Smith[_4_]	3	611
Format text in formula line mge	by Teethless mama	6	979
Getting wrong answer with Match Function CB1215	by Dave Peterson	3	1,858
Returning multiple values that are NOT in a single column or row crispino	by crispino	8	734
Average by Multiple Criteria. RoadKill	by T. Valko	3	749
Variable Symbol Kashyap	by Jacob Skaria	1	854
Custom date fields for pivot tables Amijab	by Herbert Seidenberg	4	3,198
comparing columns to find dup's stacey	by stacey	2	515
Consolidate 3 lists with duplicates into one list Re	by PJFry	1	795
Row increments - Janelle	by T. Valko	7	476
RAND() Charles W	by T. Valko	9	689
Transpose columns into continuous rows PattiP	by PattiP	1	744
index and match on 2 criteria Picman	by Picman	7	573
SUMPRODUCT - Creating a weighted score in column with subtotals DP	by Bernie Deitrick	3	1,705
Top 25 List of Times thscc1659	by thscc1659	1	382
Lookup Question Harlan	by Harlan	1	351
RANK ABSOLUTE NUMBER AND WITHOUT GAP M&M[_3_]	by Harlan Grove[_2_]	3	3,473
If formula Terrie Vargas	by Terrie Vargas	0	396
Duplex Printing Macro [email protected]	by [email protected]	0	1,195
Data Sort header row inungh	by Sheeloo	1	409
Problem with Vlookup Confused	by Jacob Skaria	10	677
conditional formula with lots of conditions sarajane82	by Glenn	8	394
If - Then statement Neall	by Neall	3	349
first and last occurance Darius	by Darius	7	589
Transfer Information Lois	by Ron de Bruin	4	615
Average function Harriet	by Jacob Skaria	5	390
Multiple formulas in a single cell referencing a drop down box. Sylvan06	by Sylvan06	3	843
Formula for Multiple Variables. Sri Harsha[_2_]	by macropod[_2_]	1	389
SUMIF, wrong result, strange behaviour Werner Rohrmoser	by Dave Peterson	5	3,012
Converting decimals to Time Gringarlow	by Gringarlow	4	504
Look Ups and Matches, Sorry if current thread exists- Clueless ABA	by ABA	5	361
per centages and sums error DebC	by David Biddulph[_2_]	5	491
search data and display colunm headers c_diver	by T. Valko	5	382
Vlookup Different tabs based on Dates andy	by T. Valko	5	808
Counting rows that meet multiple criteria sabow71	by T. Valko	5	955
Nesting IF to correct #VALUE! Error Message JennE	by JennE	2	586
Nesting IF funtions loweightes	by loweightes	2	370
How to sum cells based on conditions tjd59	by tjd59	2	513
Dependant drop down list with more than two words in the options Jock	by Jock	0	628
bug in excel 2007 for sorting function? javamama	by Ron Rosenfeld	3	570
2007/macros not working hughesdm	by Ron de Bruin	1	317
Sumif based on value in cell Jane	by Fred Smith[_4_]	4	1,441
Date open file with date saved Rita	by Rita	3	507
Find and replace * Kashyap	by Gary''s Student	1	302
Check Box Lois	by Gary''s Student	1	395
How to consolidate 580 file's data in 1 sheet without oppening all Amit Mahar	by Eduardo	1	516
create a automatice invoice from a data extract s2m[_2_]	by s2m[_2_]	0	438
Conditional Formatting ROPL	by Jarek Kujawa[_2_]	2	420
Automatically insert a line aeddave	by JLatham	5	785
Want a trace a same values exist in two different sheet Mukesh	by Mukesh	2	1,264
Matching & adding text in the respective column ashutosh	by Jarek Kujawa[_2_]	1	360
Conditional formula with multi tasks BadBoy	by BadBoy	1	485
formulas do not work Baracuda	by Baracuda	2	529
Formula behind functions VolkerB	by VolkerB	3	1,248
Concatencation and formatting Bengt[_3_]	by Ron Rosenfeld	17	963
Using V or H lookup katiapro93	by Pete_UK	3	297
Converting time to number, i.e. 2:32 to 2.32 Kokomojo	by Pete_UK	7	591
How to get text which is inside the brackets in excel sheet arun	by David Biddulph[_2_]	2	3,340
compare two or more ranges tywlam	by Stefi	3	446
List Box and IF function Jenny Beech	by Joerg Mochikun	1	2,064
conditional formatting based on different cells with more conditio sarajane82	by JBeaucaire[_90_]	1	368
linked data nidabland	by nidabland	0	313
Define cell value in a matrix to add up 2 constraints value gila_cokelat	by gila_cokelat	0	634
Compare ranges tywlam	by tywlam	0	444
Cleaning a list in Excel Shawnt	by Shawnt	1	458
display first or second match instead of #REF in INDEX ROW formula seapilot	by T. Valko	9	407
Custom Number Format TeddyTash	by Dave Peterson	2	379
create table of selected rows TBA	by TBA	1	393
Conditional Function Lisa H	by JLatham	4	515