Excel Worksheet Functions - Page 811

Thread / Thread Starter	Last Post	Replies	Views
Flagging constants [email protected]	by nmd030583	2	592
Conditional Formating carl	by Max	1	422
Vary column to sum in SumIf Steph	by Max	2	473
convert number to time JR	by Dave Peterson	7	741
Comparison result changes font color GScott	by SteveG	2	496
Newbie problem need formula help toddbob	by Bob Phillips	3	447
Sorting names in Name box Duke Carey	by Duke Carey	0	537
incremental counter cynthiabryant	by Duke Carey	4	674
how do I put 'c' in () in excel & not get copyright symbol Tania	by Tania	2	3,782
Formula help scott	by pdberger	1	456
how do i have beginning balance take away an amount auto total mlopez728	by Duke Carey	1	710
Date format problem Vass	by Sloth	7	713
Date formula that adds 7 days to a cell when sheet is copied dkent	by Bernard Liengme	1	1,037
IF statement including BETWEEN simmerdown	by Pete_UK	17	1,490
SEARCH function jcastellano	by Pete_UK	5	518
Advance function of excel to get sorted data Charlie	by Bob Phillips	1	604
Create a Formula to display the sheet name. Worksheet Formula	by Vass	1	466
Retrieving values from a specified sheet of a different file. Anift	by Anift	2	654
Adding Tax in excel Humph	by Humph	4	2,479
How do I do a sumif function not including hidden rows? Verlaesslichkeit	by CarlosAntenna	4	1,455
trivial problem PH NEWS	by PH NEWS	2	415
linking a cell with a specific letter value to a cell with a formu tommo64	by EdMac	4	820
how to convert julian date to general date arkprabha	by Gary''s Student	1	810
OFFSET to include blank cells GMCN	by GMCN	2	1,291
Function Help silverflameca	by Bob Phillips	1	464
GETPIVOTDATA Bug SthOzNewbie	by SthOzNewbie	1	731
Microsoft Visual Basic: Compile error: Sum or Function not defined Dmitry	by Dmitry	12	2,177
LARGE and INDEX functions bob	by Harlan Grove	5	697
is number between values chuckwagon2031	by Harlan Grove	2	512
Does anyone have a weekly schedule that computes total hours work Guillermo	by Guillermo	0	965
Links error if referenced file not opened supergalaxygirl	by Harlan Grove	2	607
Is it possible to automatically change color of cell by keying off the date? ChuckF	by [email protected]	1	828
Updates Problem Param	by Tom Ogilvy	1	490
Updating LINKS when opening a workbook Dragon120	by Tom Ogilvy	1	914
summing problem!!!!!! boufant	by JMB	1	452
How can I use dcount to total the number of columns with entries? GDannyboy	by Peo Sjoblom	1	626
No duplicate names in a range (A2:A200) JorgeAE	by Biff	2	499
Searching Columns and Rows Cliff	by Cliff	3	606
not sure how to proceed inoexcel	by inoexcel	4	488
Input range and link a cell Jane	by Sandy Mann	1	881
Fill cells with times annep	by annep	2	455
Array sum for negative match Gooseman	by Bob Phillips	3	678
How do I set cell colors based on if query Wullie	by Sandy Mann	3	575
check marks in excel cells using your mouse loco	by Paul B	2	2,184
change cell value greater than another cell value using formulas Unsure?	by Bill Kuunders	2	1,113
Help Requested on Formula Rich Rosier	by Ron Rosenfeld	4	764
Is there a way to return records? rayteach	by Biff	7	485
Status Changes NL	by NL	2	792
Have column of nums, need qty of each? samckitt	by Arvi Laanemets	3	440
Calculate from time formatted cell David	by Ardus Petus	1	451
Return an Alpha based on number position in a word Don Anderson	by Don Anderson	11	1,085
rate of return A.R.T.	by Fred Smith	4	463
how to substitute a value for calculation with a column of values Peiru	by Pete_UK	1	456
freezing formulas junoon	by Gilles Desjardins	4	853
Deducting a % Wizard	by Niek Otten	2	391
Summing every nth row value based upon variable Lram	by Bob Phillips	4	744
problem with blank cell chiuinggum	by Ardus Petus	1	429
If the cell contains..., do something (2) 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	6	507
how do i add numbers in nonadjacent cells? Bob	by Peo Sjoblom	1	700
How do I delete <br or <b that appears in text? AtTheMall-24-7	by Ron Rosenfeld	2	536
IF and MAX statements bob	by bob	5	534
Date entries Sal Iaccarino	by Sean	2	324
How to enter pre-decimal pounds shillings pence in Excel workshee Richard	by Richard	5	1,429
sorting data by a certain attribute ebt	by Herbert Seidenberg	2	472
dates chusky	by Debra Dalgleish	1	306
Identify number of items with characterisitics from two columns [email protected]	by Pete_UK	5	585
Referencing a range of columns and rows with the IF function Cliff	by Cliff	7	452
condition formating chiuinggum	by Debra Dalgleish	2	485
Deleting contents of cells in non contiguous ranges Richard Buttrey	by Richard Buttrey	9	676
Upper case to Lower case Louise	by Gord Dibben	7	621
Why would a pasted formula not calculate the new cell refs? Alison	by Alison	2	520
HELP with dreaded formulas... Brian	by Kletcho	5	415
Summarizing totals of all worksheets to one worksheet? Pastor Cliff	by Pete_UK	1	782
I am trying to "mirror" a row in excel, help?? Shasta2k2	by Don Guillett	3	965
If And Or mateo107	by daddylonglegs	4	391