Excel Worksheet Functions - Page 811

Thread / Thread Starter	Last Post	Replies	Views
Flagging constants [email protected]	by nmd030583	2	570
Conditional Formating carl	by Max	1	397
Vary column to sum in SumIf Steph	by Max	2	437
convert number to time JR	by Dave Peterson	7	720
Comparison result changes font color GScott	by SteveG	2	479
Newbie problem need formula help toddbob	by Bob Phillips	3	434
Sorting names in Name box Duke Carey	by Duke Carey	0	508
incremental counter cynthiabryant	by Duke Carey	4	643
how do I put 'c' in () in excel & not get copyright symbol Tania	by Tania	2	3,756
Formula help scott	by pdberger	1	449
how do i have beginning balance take away an amount auto total mlopez728	by Duke Carey	1	687
Date format problem Vass	by Sloth	7	697
Date formula that adds 7 days to a cell when sheet is copied dkent	by Bernard Liengme	1	1,010
IF statement including BETWEEN simmerdown	by Pete_UK	17	1,466
SEARCH function jcastellano	by Pete_UK	5	459
Advance function of excel to get sorted data Charlie	by Bob Phillips	1	592
Create a Formula to display the sheet name. Worksheet Formula	by Vass	1	447
Retrieving values from a specified sheet of a different file. Anift	by Anift	2	625
Adding Tax in excel Humph	by Humph	4	2,454
How do I do a sumif function not including hidden rows? Verlaesslichkeit	by CarlosAntenna	4	1,421
trivial problem PH NEWS	by PH NEWS	2	401
linking a cell with a specific letter value to a cell with a formu tommo64	by EdMac	4	787
how to convert julian date to general date arkprabha	by Gary''s Student	1	792
OFFSET to include blank cells GMCN	by GMCN	2	1,273
Function Help silverflameca	by Bob Phillips	1	445
GETPIVOTDATA Bug SthOzNewbie	by SthOzNewbie	1	701
Microsoft Visual Basic: Compile error: Sum or Function not defined Dmitry	by Dmitry	12	2,081
LARGE and INDEX functions bob	by Harlan Grove	5	644
is number between values chuckwagon2031	by Harlan Grove	2	495
Does anyone have a weekly schedule that computes total hours work Guillermo	by Guillermo	0	930
Links error if referenced file not opened supergalaxygirl	by Harlan Grove	2	558
Is it possible to automatically change color of cell by keying off the date? ChuckF	by [email protected]	1	802
Updates Problem Param	by Tom Ogilvy	1	465
Updating LINKS when opening a workbook Dragon120	by Tom Ogilvy	1	882
summing problem!!!!!! boufant	by JMB	1	437
How can I use dcount to total the number of columns with entries? GDannyboy	by Peo Sjoblom	1	593
No duplicate names in a range (A2:A200) JorgeAE	by Biff	2	487
Searching Columns and Rows Cliff	by Cliff	3	578
not sure how to proceed inoexcel	by inoexcel	4	475
Input range and link a cell Jane	by Sandy Mann	1	856
Fill cells with times annep	by annep	2	447
Array sum for negative match Gooseman	by Bob Phillips	3	620
How do I set cell colors based on if query Wullie	by Sandy Mann	3	540
check marks in excel cells using your mouse loco	by Paul B	2	2,129
change cell value greater than another cell value using formulas Unsure?	by Bill Kuunders	2	1,100
Help Requested on Formula Rich Rosier	by Ron Rosenfeld	4	723
Is there a way to return records? rayteach	by Biff	7	471
Status Changes NL	by NL	2	780
Have column of nums, need qty of each? samckitt	by Arvi Laanemets	3	419
Calculate from time formatted cell David	by Ardus Petus	1	438
Return an Alpha based on number position in a word Don Anderson	by Don Anderson	11	1,064
rate of return A.R.T.	by Fred Smith	4	436
how to substitute a value for calculation with a column of values Peiru	by Pete_UK	1	432
freezing formulas junoon	by Gilles Desjardins	4	839
Deducting a % Wizard	by Niek Otten	2	377
Summing every nth row value based upon variable Lram	by Bob Phillips	4	706
problem with blank cell chiuinggum	by Ardus Petus	1	415
If the cell contains..., do something (2) 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	6	492
how do i add numbers in nonadjacent cells? Bob	by Peo Sjoblom	1	679
How do I delete <br or <b that appears in text? AtTheMall-24-7	by Ron Rosenfeld	2	471
IF and MAX statements bob	by bob	5	513
Date entries Sal Iaccarino	by Sean	2	314
How to enter pre-decimal pounds shillings pence in Excel workshee Richard	by Richard	5	1,374
sorting data by a certain attribute ebt	by Herbert Seidenberg	2	445
dates chusky	by Debra Dalgleish	1	297
Identify number of items with characterisitics from two columns [email protected]	by Pete_UK	5	567
Referencing a range of columns and rows with the IF function Cliff	by Cliff	7	437
condition formating chiuinggum	by Debra Dalgleish	2	426
Deleting contents of cells in non contiguous ranges Richard Buttrey	by Richard Buttrey	9	636
Upper case to Lower case Louise	by Gord Dibben	7	610
Why would a pasted formula not calculate the new cell refs? Alison	by Alison	2	496
HELP with dreaded formulas... Brian	by Kletcho	5	393
Summarizing totals of all worksheets to one worksheet? Pastor Cliff	by Pete_UK	1	770
I am trying to "mirror" a row in excel, help?? Shasta2k2	by Don Guillett	3	951
If And Or mateo107	by daddylonglegs	4	371