Excel Worksheet Functions - Page 142

Thread / Thread Starter	Last Post	Replies	Views
Too many IF functions GHall	by T. Valko	3	608
Need sum of top values in a range based on criteria CSchwass	by CSchwass	5	981
excel-count a value in 1 column if a value in a 2nd is true Jim C.	by T. Valko	5	1,050
sumif with a lookup formula Chas	by T. Valko	4	1,887
How to convert imported Access Hyperlinks to Excel and KEEP the li Rudeseal	by Rudeseal	0	1,131
Excel 2003 Counting multiple number entries in a single cell watermt	by T. Valko	9	1,100
Paired Quote marks in Excel IF statement mjwskier	by Pete_UK	2	1,805
Returning the last modified date to a cell in excel 2003 Dunc	by Rick Rothstein	7	1,952
How do I apply a cell formula to an entire column? mscarolina	by YESHWANT	5	1,039
Extracting data SMD	by SMD	7	691
Calculate Average and dispaly in another worksheet Flipper	by Shane Devenshire[_2_]	2	1,573
Mid or Right bg	by Shane Devenshire[_2_]	6	667
Remove duplicates jennifer	by Shane Devenshire[_2_]	2	863
Sumproduct using wildcard for month only Princess V	by Shane Devenshire[_2_]	6	870
Isolating string combinations Demosthenes	by Demosthenes	4	641
Autofill cell reference forumula not working James D	by James D	4	2,353
Quarterly inputs Loadmaster	by Loadmaster	2	665
Return value if two data points match ptf	by Sam Wilson	3	1,125
HELP WITH EXEL ARIES	by John McCabe	3	570
Deleting (almost) duplicates in Excel Ken ya help?	by pshepard[_2_]	3	2,202
SUMPRODUCT Error Curtis	by Curtis	2	681
Color a row once a "x" is entered Nielly	by Sam Wilson	1	536
Conditional formatting Excel 2007 Atri	by Atri	4	606
Counting in Pivot Tables w/o "0" bec	by pshepard	2	503
COUNT question Gerard Sanchez	by Teethless mama	4	787
Matching two numeric values tipoo	by pogiman via OfficeKB.com	1	536
formula help - avtive early j5b9721	by j5b9721	0	573
Which is better? LOOKUP or INDEX? PYO1012	by T. Valko	1	594
Calculating the difference between 2 percentages (Ratios) Stilltrader47	by JoeU2004	1	2,915
Data Validation With Date Range DShaver	by Teethless mama	2	1,102
Multiple value if function using dates latsyrc57	by latsyrc57	2	840
How to properly cross-post Demosthenes	by JoeU2004	1	796
List comparisons and ISNA Dyvotion	by pogiman	2	2,022
FORMULAR TO INSERT DATA FROM ONE CELL TO ANOTHER Kanmi	by Dave Peterson	1	1,009
display a value from Sheet1-A1:A10 in Sheet2-B1 sam	by Rajesh Mehmi	2	2,290
Automatically insert lines Gordon[_2_]	by Pete_UK	1	658
Automatically adding lines Gordon[_2_]	by Pete_UK	1	594
Combining sumIF statements with other functions? Hopeless in Cincy	by Pete_UK	2	1,240
how to check for days of the week Gary	by Rajesh Mehmi	7	1,055
INDEX function (array type) Sean[_3_]	by Sean[_4_]	4	660
Two Criteria = 1 Jazz	by Jazz	7	534
Formular Kanmi	by Kanmi	0	527
formulas to count dates Brian	by Shane Devenshire[_2_]	2	710
Conditional Formatting color doesn't show up: 90% Stu	by Shane Devenshire[_2_]	7	734
FULL SCREEN WITH TOOLBAR ACCESIBILITY Roberta	by Sean Timmons	1	621
How to reverse data of a single column? Denish D	by [email protected]	5	698
How do I average cells that contain #DIV/01? Pullge	by Pullge	2	2,385
How do I write formula to check a range of cells? Tayo	by Luke M	5	953
Need help with sumproduct formula Nielly	by T. Valko	1	536
conditional if or lookup Redi	by Redi	0	596
#DIV/0! KelD	by Luke M	1	588
ordering a column by incidence colensa	by Don Guillett	1	580
How to find and move a value based on multiple criteria JeffZ88	by JeffZ88	0	629
Pivot table column help Mr CheeZe	by Mr CheeZe	2	496
Display text automatically OKY	by Niek Otten	3	569
I can not create an external link between two Excel 2007 workbooks Bill R	by Gord Dibben	1	1,784
How do I export a row of data into its own workbook LMM_0809	by Luke M	1	685
Worksheet compatability Jewell	by Gord Dibben	1	538
Simple? View named range from sheet1 on sheet2 susiew32	by Pete_UK	1	868
To return a blank cell rather than 0% in a vlookup. Romileyrunner1	by Max	9	1,151
conditional formatting Jules	by Jules	0	486
Excel is crashing when making a pdf of my workbook Jewell	by Jewell	0	705
Display formula on the cell journey	by macropod[_2_]	2	625
CountA or DcountA, that is the question?? Niqui	by Sam Wilson	1	572
Real teaser! LiAD	by LiAD	4	587
Countif multiple items Romileyrunner1	by Romileyrunner1	2	702
cells are automatically dividing each # I put in by 10!!! Romileyrunner1	by T. Valko	5	811
Search a named range rhhince[_2_]	by Lars-Åke Aspelin[_2_]	1	733
Count with two criteria in a second worksheet bec	by T. Valko	1	624
SUM IF question (daily rainfall totals) RedDixieCup	by Fred Smith[_4_]	9	1,160
Go to cell below last entry in column and total Donna[_2_]	by Jacob Skaria	1	809
coefficient of determination Jene	by Mike Middleton[_2_]	2	3,268
Rolling date looking 30 Days past Chris	by Max	2	1,566
Help with Excel VBA Howard	by Howard	2	656
Converting Text into Values Terry Bennett	by T. Valko	6	817