Excel Worksheet Functions - Page 7

Thread / Thread Starter	Last Post	Replies	Views
Calculating Average Values Using Arithmetic Equations ryangruhn	by Bernard Liengme	2	1,082
Double-Click a Hyperlink speedking1621	by Frank Kabel	1	1,430
#REF error Christen	by Frank Kabel	5	1,730
need a formula for cumulative grade deliliah	by Don Guillett	1	861
Activating the Send As Attachment option Becky	by Don Guillett	8	1,161
Calculating Average Values Using Arithmetic Equations ryangruhn	by ryangruhn	0	900
Count distinct Debbie t	by mzehr	2	1,011
Use of Exact(or other) function for alternate rows? yusee_ygs	by N Harkawat	2	988
What's wrong with this? drvortex	by drvortex	0	566
no repeats in a column repeat	by mzehr	2	877
Sorting merged cellsHow do I sort merged cells not identically siz Laval	by Paul Corrado	1	1,823
How can I use count function in excel where I have several criter. Princess V	by hgrove	14	2,427
Need help on Select Case Susan Hayes	by Don Guillett	1	1,077
How do you delete one cell from a range of protected cells Cgbilliar	by Cgbilliar	2	1,315
Need to learn about formulas ForSale	by ForSale	0	666
Need to learn about formulas ForSale	by Gord Dibben	5	709
unrecognized fuctions evapp etc Lee	by hgrove	2	1,355
Sorting problem Chris	by Myrna Larson	1	866
Help-IF Function Girish Punjabi	by Domenic	2	484
Copying Rows when hiding other rows Neutron1871	by Don Guillett	2	1,229
Pivot table, how do you exclude counting cells with formulas as a Greg Bobak	by Greg Bobak	4	4,191
Navigating between worksheets. shazza	by ForSale	1	690
How can I format a cell to accept feet and inches and add them Jack	by Gord Dibben	4	1,460
How do I reference multiple rows Awetronics	by Gord Dibben	1	1,154
Combining Defined Names to New Name For Validation TheSpankster22	by TheSpankster22	0	892
What is the easiest way to learn math functions in excel . Harold1955	by Gord Dibben	2	1,022
How do I limit the number of rows in an Excel worksheet. laforge27	by Gord Dibben	1	2,317
Archive John Hunt	by Hammer	4	691
remote data query and sum not working Sara	by Sara	0	954
Using Cell references in VLookUp JonWilson631	by Max	1	1,456
Create a total based on multiple conditions is not giving correct. Jacob	by Biff	2	1,409
how do I 'count' the number of cells with a text in red or black? Anjin Topeng	by Anjin Topeng	2	1,835
Hlookups + Vlookups kaushil	by Myrna Larson	1	785
Drop Down List not Appearing John	by John	3	1,089
Comment associated with a cell doncam65	by doncam65	0	736
Countif Problem Alicia	by Govind	3	829
convert numeric to text sahas	by Harald Staff	2	1,439
Conditional Formatting for dates spacerocket	by Arun Philip	2	1,600
Look up or Index? WendyMc	by Govind	1	622
Summing Formula Steve W	by ivano	4	786
how to count the nr of occurrences of a text string in a cell rang eagerbuyer	by Ron Rosenfeld	1	1,315
TRANSPOSE() bill_morgan_3333	by bill_morgan_3333	4	1,202
Averaging cells which contain #DIV/0! maryj	by maryj	4	771
format numbers into feet / inches rebar	by K.S.Warrier	3	1,648
Not quite the same lookup? Chris Mitchell	by Chris Mitchell	0	518
GradeBook WannaKooky	by Arvi Laanemets	1	1,203
Count data entries and date problem Gef	by K.S.Warrier	5	1,277
How do I delete duplicate entries? Chris Mitchell	by Govind	3	1,070
Vlookups and multiple returns (again!) Domenic	by Domenic	0	823
Linking an entire worksheet from a restricted drive? mkichar	by mkichar	0	692
unique records Pyotr	by Domenic	1	783
differentiating between "and"/"or" in a formula Shooter	by Shooter	6	617
Why does Excel freeze and have to close when I hold Alt down and . KDRNeutron	by KDRNeutron	0	1,334
Excel Function Chandrashekhar	by K.S.Warrier	1	482
Average Column, but Skip Null and 0? JT	by JT	1	933
Average/Min column of numbers, but skip 0's and Null's in the form JT	by JT	1	1,152
< and > functions aren"t working for me Dock Buddy	by K.S.Warrier	6	754
can I merge two different workbooks, with the same format, just d. NancyE	by JulieD	1	739
If's and Isna's and stuff Hexabah	by JulieD	1	609
If statement needed Patsy	by JulieD	1	1,150
Using Workday syntax PaulaC	by JulieD	1	3,005
Parsing text in Excel Jack Edwards	by K.S.Warrier	3	953
consoildate all the worksheet(example sheet1,sheet2 and sheet3 etc officeboy	by Ron de Bruin	1	702
Count Comments Mr Anthony Griffiths	by Ron de Bruin	1	1,054
Adding column data stge	by Bernie Deitrick	1	1,012
"Is Between" function? Cindi	by Domenic	4	1,018
Importing Data Into Formula Based Cells Heyna	by Harlan Grove	1	1,530
Can Excel be pre-formatted to apply "double quotes" to data enter. RV	by RV	0	1,338
Find AVG/MIN of a Column, excluding 0's and NULL's? JT	by Harlan Grove	3	3,163
getpivotdata() by position choop	by Alex Delamain	3	2,183
can i colour a cell on basis of results of a formula e.g clour bl. K	by Alan	3	1,586
Linking an entire worksheet from a restricted drive? mkichar	by Harlan Grove	1	1,057
Extract date from cell Eric	by Ron Rosenfeld	3	1,221
Needing to know how to use a "and" in a formula.... Eric	by	1	634
2-Dim Lookup Jeff Spiccoli	by Jeff Spiccoli	6	818