Excel Worksheet Functions - Page 194

Thread / Thread Starter	Last Post	Replies	Views
Can't stop recalc [email protected]	by [email protected]	2	552
Accumulator BadBoy	by BadBoy	2	487
conditional formating if and And ROPL	by Jacob Skaria	2	385
COLUMN() problem with array formula ejack	by ejack	0	526
array formulas counting substrings across rows Christi	by Jacob Skaria	6	438
How do I get text to speech to work in XP? MotorCityRock	by comcdp	3	644
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	994
Getting wrong answer with Match Function CB1215	by Dave Peterson	3	1,880
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	773
Variable Symbol Kashyap	by Jacob Skaria	1	869
Custom date fields for pivot tables Amijab	by Herbert Seidenberg	4	3,218
comparing columns to find dup's stacey	by stacey	2	524
Consolidate 3 lists with duplicates into one list Re	by PJFry	1	819
Row increments - Janelle	by T. Valko	7	479
RAND() Charles W	by T. Valko	9	743
Transpose columns into continuous rows PattiP	by PattiP	1	800
index and match on 2 criteria Picman	by Picman	7	607
SUMPRODUCT - Creating a weighted score in column with subtotals DP	by Bernie Deitrick	3	1,736
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,221
Data Sort header row inungh	by Sheeloo	1	420
Problem with Vlookup Confused	by Jacob Skaria	10	712
conditional formula with lots of conditions sarajane82	by Glenn	8	401
If - Then statement Neall	by Neall	3	355
first and last occurance Darius	by Darius	7	621
Transfer Information Lois	by Ron de Bruin	4	637
Average function Harriet	by Jacob Skaria	5	412
Multiple formulas in a single cell referencing a drop down box. Sylvan06	by Sylvan06	3	856
Formula for Multiple Variables. Sri Harsha[_2_]	by macropod[_2_]	1	420
SUMIF, wrong result, strange behaviour Werner Rohrmoser	by Dave Peterson	5	3,034
Converting decimals to Time Gringarlow	by Gringarlow	4	514
Look Ups and Matches, Sorry if current thread exists- Clueless ABA	by ABA	5	371
per centages and sums error DebC	by David Biddulph[_2_]	5	512
search data and display colunm headers c_diver	by T. Valko	5	392
Vlookup Different tabs based on Dates andy	by T. Valko	5	852
Counting rows that meet multiple criteria sabow71	by T. Valko	5	976
Nesting IF to correct #VALUE! Error Message JennE	by JennE	2	612
Nesting IF funtions loweightes	by loweightes	2	390
How to sum cells based on conditions tjd59	by tjd59	2	534
Dependant drop down list with more than two words in the options Jock	by Jock	0	645
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,463
Date open file with date saved Rita	by Rita	3	523
Find and replace * Kashyap	by Gary''s Student	1	312
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	548
create a automatice invoice from a data extract s2m[_2_]	by s2m[_2_]	0	477
Conditional Formatting ROPL	by Jarek Kujawa[_2_]	2	432
Automatically insert a line aeddave	by JLatham	5	807
Want a trace a same values exist in two different sheet Mukesh	by Mukesh	2	1,287
Matching & adding text in the respective column ashutosh	by Jarek Kujawa[_2_]	1	389
Conditional formula with multi tasks BadBoy	by BadBoy	1	499
formulas do not work Baracuda	by Baracuda	2	540
Formula behind functions VolkerB	by VolkerB	3	1,268
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	622
How to get text which is inside the brackets in excel sheet arun	by David Biddulph[_2_]	2	3,371
compare two or more ranges tywlam	by Stefi	3	504
List Box and IF function Jenny Beech	by Joerg Mochikun	1	2,097
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	643
Compare ranges tywlam	by tywlam	0	462
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	393
create table of selected rows TBA	by TBA	1	414
Conditional Function Lisa H	by JLatham	4	537