Excel Worksheet Functions - Page 7

Thread / Thread Starter	Last Post	Replies	Views
Calculating Average Values Using Arithmetic Equations ryangruhn	by Bernard Liengme	2	1,021
Double-Click a Hyperlink speedking1621	by Frank Kabel	1	1,385
#REF error Christen	by Frank Kabel	5	1,604
need a formula for cumulative grade deliliah	by Don Guillett	1	828
Activating the Send As Attachment option Becky	by Don Guillett	8	1,115
Calculating Average Values Using Arithmetic Equations ryangruhn	by ryangruhn	0	849
Count distinct Debbie t	by mzehr	2	958
Use of Exact(or other) function for alternate rows? yusee_ygs	by N Harkawat	2	902
What's wrong with this? drvortex	by drvortex	0	525
no repeats in a column repeat	by mzehr	2	815
Sorting merged cellsHow do I sort merged cells not identically siz Laval	by Paul Corrado	1	1,663
How can I use count function in excel where I have several criter. Princess V	by hgrove	14	2,352
Need help on Select Case Susan Hayes	by Don Guillett	1	1,027
How do you delete one cell from a range of protected cells Cgbilliar	by Cgbilliar	2	1,250
Need to learn about formulas ForSale	by ForSale	0	632
Need to learn about formulas ForSale	by Gord Dibben	5	660
unrecognized fuctions evapp etc Lee	by hgrove	2	1,316
Sorting problem Chris	by Myrna Larson	1	817
Help-IF Function Girish Punjabi	by Domenic	2	438
Copying Rows when hiding other rows Neutron1871	by Don Guillett	2	1,163
Pivot table, how do you exclude counting cells with formulas as a Greg Bobak	by Greg Bobak	4	4,103
Navigating between worksheets. shazza	by ForSale	1	654
How can I format a cell to accept feet and inches and add them Jack	by Gord Dibben	4	1,407
How do I reference multiple rows Awetronics	by Gord Dibben	1	1,078
Combining Defined Names to New Name For Validation TheSpankster22	by TheSpankster22	0	823
What is the easiest way to learn math functions in excel . Harold1955	by Gord Dibben	2	942
How do I limit the number of rows in an Excel worksheet. laforge27	by Gord Dibben	1	2,096
Archive John Hunt	by Hammer	4	619
remote data query and sum not working Sara	by Sara	0	912
Using Cell references in VLookUp JonWilson631	by Max	1	1,400
Create a total based on multiple conditions is not giving correct. Jacob	by Biff	2	1,333
how do I 'count' the number of cells with a text in red or black? Anjin Topeng	by Anjin Topeng	2	1,746
Hlookups + Vlookups kaushil	by Myrna Larson	1	755
Drop Down List not Appearing John	by John	3	1,042
Comment associated with a cell doncam65	by doncam65	0	681
Countif Problem Alicia	by Govind	3	801
convert numeric to text sahas	by Harald Staff	2	1,346
Conditional Formatting for dates spacerocket	by Arun Philip	2	1,503
Look up or Index? WendyMc	by Govind	1	593
Summing Formula Steve W	by ivano	4	722
how to count the nr of occurrences of a text string in a cell rang eagerbuyer	by Ron Rosenfeld	1	1,263
TRANSPOSE() bill_morgan_3333	by bill_morgan_3333	4	1,140
Averaging cells which contain #DIV/0! maryj	by maryj	4	731
format numbers into feet / inches rebar	by K.S.Warrier	3	1,605
Not quite the same lookup? Chris Mitchell	by Chris Mitchell	0	491
GradeBook WannaKooky	by Arvi Laanemets	1	1,163
Count data entries and date problem Gef	by K.S.Warrier	5	1,204
How do I delete duplicate entries? Chris Mitchell	by Govind	3	1,024
Vlookups and multiple returns (again!) Domenic	by Domenic	0	779
Linking an entire worksheet from a restricted drive? mkichar	by mkichar	0	653
unique records Pyotr	by Domenic	1	749
differentiating between "and"/"or" in a formula Shooter	by Shooter	6	579
Why does Excel freeze and have to close when I hold Alt down and . KDRNeutron	by KDRNeutron	0	1,297
Excel Function Chandrashekhar	by K.S.Warrier	1	439
Average Column, but Skip Null and 0? JT	by JT	1	890
Average/Min column of numbers, but skip 0's and Null's in the form JT	by JT	1	1,073
< and > functions aren"t working for me Dock Buddy	by K.S.Warrier	6	726
can I merge two different workbooks, with the same format, just d. NancyE	by JulieD	1	709
If's and Isna's and stuff Hexabah	by JulieD	1	566
If statement needed Patsy	by JulieD	1	1,108
Using Workday syntax PaulaC	by JulieD	1	2,970
Parsing text in Excel Jack Edwards	by K.S.Warrier	3	897
consoildate all the worksheet(example sheet1,sheet2 and sheet3 etc officeboy	by Ron de Bruin	1	638
Count Comments Mr Anthony Griffiths	by Ron de Bruin	1	1,015
Adding column data stge	by Bernie Deitrick	1	977
"Is Between" function? Cindi	by Domenic	4	971
Importing Data Into Formula Based Cells Heyna	by Harlan Grove	1	1,494
Can Excel be pre-formatted to apply "double quotes" to data enter. RV	by RV	0	1,307
Find AVG/MIN of a Column, excluding 0's and NULL's? JT	by Harlan Grove	3	3,093
getpivotdata() by position choop	by Alex Delamain	3	2,150
can i colour a cell on basis of results of a formula e.g clour bl. K	by Alan	3	1,494
Linking an entire worksheet from a restricted drive? mkichar	by Harlan Grove	1	1,012
Extract date from cell Eric	by Ron Rosenfeld	3	1,176
Needing to know how to use a "and" in a formula.... Eric	by	1	598
2-Dim Lookup Jeff Spiccoli	by Jeff Spiccoli	6	785