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	469
convert number to time JR	by Dave Peterson	7	739
Comparison result changes font color GScott	by SteveG	2	492
Newbie problem need formula help toddbob	by Bob Phillips	3	447
Sorting names in Name box Duke Carey	by Duke Carey	0	529
incremental counter cynthiabryant	by Duke Carey	4	672
how do I put 'c' in () in excel & not get copyright symbol Tania	by Tania	2	3,772
Formula help scott	by pdberger	1	453
how do i have beginning balance take away an amount auto total mlopez728	by Duke Carey	1	709
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,034
IF statement including BETWEEN simmerdown	by Pete_UK	17	1,490
SEARCH function jcastellano	by Pete_UK	5	508
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	462
Retrieving values from a specified sheet of a different file. Anift	by Anift	2	646
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,448
trivial problem PH NEWS	by PH NEWS	2	411
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	808
OFFSET to include blank cells GMCN	by GMCN	2	1,291
Function Help silverflameca	by Bob Phillips	1	457
GETPIVOTDATA Bug SthOzNewbie	by SthOzNewbie	1	724
Microsoft Visual Basic: Compile error: Sum or Function not defined Dmitry	by Dmitry	12	2,175
LARGE and INDEX functions bob	by Harlan Grove	5	688
is number between values chuckwagon2031	by Harlan Grove	2	506
Does anyone have a weekly schedule that computes total hours work Guillermo	by Guillermo	0	963
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	819
Updates Problem Param	by Tom Ogilvy	1	482
Updating LINKS when opening a workbook Dragon120	by Tom Ogilvy	1	908
summing problem!!!!!! boufant	by JMB	1	447
How can I use dcount to total the number of columns with entries? GDannyboy	by Peo Sjoblom	1	625
No duplicate names in a range (A2:A200) JorgeAE	by Biff	2	491
Searching Columns and Rows Cliff	by Cliff	3	596
not sure how to proceed inoexcel	by inoexcel	4	483
Input range and link a cell Jane	by Sandy Mann	1	872
Fill cells with times annep	by annep	2	455
Array sum for negative match Gooseman	by Bob Phillips	3	675
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,174
change cell value greater than another cell value using formulas Unsure?	by Bill Kuunders	2	1,112
Help Requested on Formula Rich Rosier	by Ron Rosenfeld	4	763
Is there a way to return records? rayteach	by Biff	7	475
Status Changes NL	by NL	2	792
Have column of nums, need qty of each? samckitt	by Arvi Laanemets	3	439
Calculate from time formatted cell David	by Ardus Petus	1	447
Return an Alpha based on number position in a word Don Anderson	by Don Anderson	11	1,076
rate of return A.R.T.	by Fred Smith	4	462
how to substitute a value for calculation with a column of values Peiru	by Pete_UK	1	446
freezing formulas junoon	by Gilles Desjardins	4	848
Deducting a % Wizard	by Niek Otten	2	390
Summing every nth row value based upon variable Lram	by Bob Phillips	4	742
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	503
how do i add numbers in nonadjacent cells? Bob	by Peo Sjoblom	1	695
How do I delete <br or <b that appears in text? AtTheMall-24-7	by Ron Rosenfeld	2	530
IF and MAX statements bob	by bob	5	529
Date entries Sal Iaccarino	by Sean	2	321
How to enter pre-decimal pounds shillings pence in Excel workshee Richard	by Richard	5	1,428
sorting data by a certain attribute ebt	by Herbert Seidenberg	2	472
dates chusky	by Debra Dalgleish	1	300
Identify number of items with characterisitics from two columns [email protected]	by Pete_UK	5	584
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	517
HELP with dreaded formulas... Brian	by Kletcho	5	407
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	383