Excel Worksheet Functions - Page 7

Thread / Thread Starter	Last Post	Replies	Views
Calculating Average Values Using Arithmetic Equations ryangruhn	by Bernard Liengme	2	1,029
Double-Click a Hyperlink speedking1621	by Frank Kabel	1	1,386
#REF error Christen	by Frank Kabel	5	1,607
need a formula for cumulative grade deliliah	by Don Guillett	1	829
Activating the Send As Attachment option Becky	by Don Guillett	8	1,116
Calculating Average Values Using Arithmetic Equations ryangruhn	by ryangruhn	0	850
Count distinct Debbie t	by mzehr	2	960
Use of Exact(or other) function for alternate rows? yusee_ygs	by N Harkawat	2	932
What's wrong with this? drvortex	by drvortex	0	527
no repeats in a column repeat	by mzehr	2	822
Sorting merged cellsHow do I sort merged cells not identically siz Laval	by Paul Corrado	1	1,690
How can I use count function in excel where I have several criter. Princess V	by hgrove	14	2,359
Need help on Select Case Susan Hayes	by Don Guillett	1	1,029
How do you delete one cell from a range of protected cells Cgbilliar	by Cgbilliar	2	1,255
Need to learn about formulas ForSale	by ForSale	0	634
Need to learn about formulas ForSale	by Gord Dibben	5	661
unrecognized fuctions evapp etc Lee	by hgrove	2	1,318
Sorting problem Chris	by Myrna Larson	1	823
Help-IF Function Girish Punjabi	by Domenic	2	439
Copying Rows when hiding other rows Neutron1871	by Don Guillett	2	1,167
Pivot table, how do you exclude counting cells with formulas as a Greg Bobak	by Greg Bobak	4	4,111
Navigating between worksheets. shazza	by ForSale	1	655
How can I format a cell to accept feet and inches and add them Jack	by Gord Dibben	4	1,413
How do I reference multiple rows Awetronics	by Gord Dibben	1	1,083
Combining Defined Names to New Name For Validation TheSpankster22	by TheSpankster22	0	825
What is the easiest way to learn math functions in excel . Harold1955	by Gord Dibben	2	966
How do I limit the number of rows in an Excel worksheet. laforge27	by Gord Dibben	1	2,240
Archive John Hunt	by Hammer	4	642
remote data query and sum not working Sara	by Sara	0	912
Using Cell references in VLookUp JonWilson631	by Max	1	1,401
Create a total based on multiple conditions is not giving correct. Jacob	by Biff	2	1,340
how do I 'count' the number of cells with a text in red or black? Anjin Topeng	by Anjin Topeng	2	1,754
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,349
Conditional Formatting for dates spacerocket	by Arun Philip	2	1,508
Look up or Index? WendyMc	by Govind	1	593
Summing Formula Steve W	by ivano	4	724
how to count the nr of occurrences of a text string in a cell rang eagerbuyer	by Ron Rosenfeld	1	1,267
TRANSPOSE() bill_morgan_3333	by bill_morgan_3333	4	1,141
Averaging cells which contain #DIV/0! maryj	by maryj	4	731
format numbers into feet / inches rebar	by K.S.Warrier	3	1,606
Not quite the same lookup? Chris Mitchell	by Chris Mitchell	0	492
GradeBook WannaKooky	by Arvi Laanemets	1	1,166
Count data entries and date problem Gef	by K.S.Warrier	5	1,225
How do I delete duplicate entries? Chris Mitchell	by Govind	3	1,029
Vlookups and multiple returns (again!) Domenic	by Domenic	0	784
Linking an entire worksheet from a restricted drive? mkichar	by mkichar	0	654
unique records Pyotr	by Domenic	1	751
differentiating between "and"/"or" in a formula Shooter	by Shooter	6	580
Why does Excel freeze and have to close when I hold Alt down and . KDRNeutron	by KDRNeutron	0	1,303
Excel Function Chandrashekhar	by K.S.Warrier	1	441
Average Column, but Skip Null and 0? JT	by JT	1	895
Average/Min column of numbers, but skip 0's and Null's in the form JT	by JT	1	1,078
< and > functions aren"t working for me Dock Buddy	by K.S.Warrier	6	729
can I merge two different workbooks, with the same format, just d. NancyE	by JulieD	1	710
If's and Isna's and stuff Hexabah	by JulieD	1	568
If statement needed Patsy	by JulieD	1	1,110
Using Workday syntax PaulaC	by JulieD	1	2,971
Parsing text in Excel Jack Edwards	by K.S.Warrier	3	907
consoildate all the worksheet(example sheet1,sheet2 and sheet3 etc officeboy	by Ron de Bruin	1	640
Count Comments Mr Anthony Griffiths	by Ron de Bruin	1	1,016
Adding column data stge	by Bernie Deitrick	1	982
"Is Between" function? Cindi	by Domenic	4	972
Importing Data Into Formula Based Cells Heyna	by Harlan Grove	1	1,498
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,098
getpivotdata() by position choop	by Alex Delamain	3	2,151
can i colour a cell on basis of results of a formula e.g clour bl. K	by Alan	3	1,519
Linking an entire worksheet from a restricted drive? mkichar	by Harlan Grove	1	1,017
Extract date from cell Eric	by Ron Rosenfeld	3	1,178
Needing to know how to use a "and" in a formula.... Eric	by	1	599
2-Dim Lookup Jeff Spiccoli	by Jeff Spiccoli	6	786