Excel Worksheet Functions - Page 167

Thread / Thread Starter	Last Post	Replies	Views
Limit or Exclude cells in Average and Sum formula dagger	by swatsp0p	3	3,081
Macro to Modify Pivot Table for Color and Bold Cheryl B.	by Bernie Deitrick	1	644
Formula given three answer choices Sally J	by Barb R.	3	373
Can I have different column widths in a worksheet? Kylie	by Kylie	0	490
Rate formula Joanne	by Joanne	0	539
Pivot Table vs. Formulas Eric	by Adam Molinaro	3	863
Multiple IF criteria Karen	by Andrew	2	425
How do I insert 2 decimal places to a number in cell? Rebecca Martinez	by Ron Rosenfeld	6	1,631
filter and delete Jordan	by Jordan	1	583
Add cells from a range based on 2 conditions from 2 other ranges Kelly	by	3	1,040
Can Excel recognize when data is entered and apply formulas? cwool4512	by Bernie Deitrick	2	1,135
hOW DO I Darrell Martin	by bj	1	400
Copying cell values once and then making them static Tsjah	by bj	5	902
Ignore Blanks in Data Validation Ricky	by Debra Dalgleish	9	2,695
Create a list in one worksheet of the other worksheets' names Kelli	by Kelli	0	631
control-tab should move between Excel sheets without a mouse. SpecialK	by Earl Kiosterud	2	721
count function problem nkidd	by bj	4	508
Consolidating sheets	by	3	864
Sound / Audible Alert in a Woksheet ? carl	by Bob Phillips	3	527
In excel, what does the esclemation point (!) in a function mean? Marsha	by Bob Phillips	2	404
evaluate data by week number Steve G	by	1	571
another language in MS office at home and another at work milazalu	by milazalu	2	459
CTRL and END function Andy787878	by Anne Troy	1	382
Cell and Sheet Reference/Return Andrew	by Barb R.	3	330
Shelf Life Percentage John	by John	3	1,372
IF function AliceNXLand	by Alok	5	367
calculate problem in excel Ohmega	by Jerry W. Lewis	5	422
Links to other worksheets KimberlyC	by ScottO	1	397
Can this be done? Anita	by Anita	3	280
can I format dates older than 1900 demangeo	by Dave Peterson	1	585
How do I make all data in the formula bar appear in the cell JDGriffey3	by Dave Peterson	1	380
in vba for access how do i get the day of the week for a date field? Daniel	by Dave Peterson	1	443
Help with countif on multiple worksheets jeremed	by jeremed	2	551
Calculate weeks cover \Kevin Carroll via OfficeKB.com\	by Kevin Carroll	2	1,048
How do I make hide detail buttons in Excel 2002? nrg	by ScottO	1	444
How do I put each member of string concatenation in its own line? DViolette	by ScottO	3	507
can it be done without vb spikk	by Tushar Mehta	3	310
Change General Format to Currency Format Freshman	by Max	3	1,296
Summarize Out of Stock List David	by David	0	483
Different quantities of a certain item... JDellenger	by agarwaldvk	1	408
force excel to run in only one process excel.exe Daniel	by Daniel	0	782
Quick formula question jjjam	by ScottO	8	530
I need a Formula, Please easybucks	by agarwaldvk	2	304
how do I use a cell value as part of a cell refereren in a formula PMG	by Max	2	735
How do I translate from 5Row/20Col to 20Row/5Col ? petergblunden	by petergblunden	5	363
Data Validation Ket	by DM Unseen	1	334
[XL] Edit Mode of formulae should be improved in legibility. L.A. Slingerland	by L.A. Slingerland	0	393
How to calculate a person's age taking into account their birthda. CPD174	by Ambrosiy	4	859
cell hililte D	by Bob Phillips	2	371
EXTRACT TEXT FROM TEXT STRING carricka	by carricka	4	740
Format to Thousands and x-foot the sum Jeanne	by Gordon	1	859
Why "datedif" function results sometimes negative numbers? Ambrosiy	by Ron Rosenfeld	1	1,656
Remove Time Element of a Date jennie	by jennie	3	1,044
running total D.J.Shaw	by Gordon	1	453
count unique with conditions \ditzman via OfficeKB.com\	by slc	8	1,343
Can I have a progressive number in the same cell when printing? Mark	by Mark	0	608
Running total D.J.Shaw	by Gordon	1	392
Nested Funtions StephanieH	by StephanieH	7	414
Named Ranges shown (or not shown) as blue means what? wdeleo	by wdeleo	0	686
Doing a grouped search in Excel. mikkellund	by Dave Peterson	1	413
calender in diary format kevin	by kevin	0	441
Tab Color - Excel 97 brenrogers7142	by Falcon	4	447
Discount calculation Kerri	by Kerri	2	513
Running Total D.J.Shaw	by Kassie	1	599
How do I copy formatting from 1 sheet to next in same workbook? Marlene K.	by Hayeso	1	702
Contents of adjacent cell from a function Nick	by RagDyeR	5	1,123
Sums according to the content of fields James1976	by bj	3	452
want blank - not #N/A sunflower	by sunflower	3	336
determine if a cell changed value Dave01	by Dave01	0	608
=sumproduct((f5:f498=(cp5:cq5))(e5:e498=(cp6:ct6) )(m5:m498)) Ruthki	by Ruthki	2	409
A Challenge Jazzer	by Harlan Grove	3	549
sumproduct between two dates chased	by chased	4	730
How to create summary of expense report? KAE1994	by KAE1994	2	849
formula that if ex. G4-G5 is less than zero = zero MAllen	by Tim C	3	421
Conditional Sum Wizard Presleytcb	by Anne Troy	1	821