Excel Worksheet Functions - Page 811

Thread / Thread Starter	Last Post	Replies	Views
Flagging constants [email protected]	by nmd030583	2	576
Conditional Formating carl	by Max	1	399
Vary column to sum in SumIf Steph	by Max	2	445
convert number to time JR	by Dave Peterson	7	721
Comparison result changes font color GScott	by SteveG	2	479
Newbie problem need formula help toddbob	by Bob Phillips	3	438
Sorting names in Name box Duke Carey	by Duke Carey	0	509
incremental counter cynthiabryant	by Duke Carey	4	650
how do I put 'c' in () in excel & not get copyright symbol Tania	by Tania	2	3,758
Formula help scott	by pdberger	1	449
how do i have beginning balance take away an amount auto total mlopez728	by Duke Carey	1	691
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,015
IF statement including BETWEEN simmerdown	by Pete_UK	17	1,467
SEARCH function jcastellano	by Pete_UK	5	474
Advance function of excel to get sorted data Charlie	by Bob Phillips	1	594
Create a Formula to display the sheet name. Worksheet Formula	by Vass	1	448
Retrieving values from a specified sheet of a different file. Anift	by Anift	2	628
Adding Tax in excel Humph	by Humph	4	2,455
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	788
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,277
Function Help silverflameca	by Bob Phillips	1	445
GETPIVOTDATA Bug SthOzNewbie	by SthOzNewbie	1	702
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	654
is number between values chuckwagon2031	by Harlan Grove	2	497
Does anyone have a weekly schedule that computes total hours work Guillermo	by Guillermo	0	934
Links error if referenced file not opened supergalaxygirl	by Harlan Grove	2	572
Is it possible to automatically change color of cell by keying off the date? ChuckF	by [email protected]	1	804
Updates Problem Param	by Tom Ogilvy	1	465
Updating LINKS when opening a workbook Dragon120	by Tom Ogilvy	1	883
summing problem!!!!!! boufant	by JMB	1	439
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	488
Searching Columns and Rows Cliff	by Cliff	3	583
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	636
How do I set cell colors based on if query Wullie	by Sandy Mann	3	541
check marks in excel cells using your mouse loco	by Paul B	2	2,140
change cell value greater than another cell value using formulas Unsure?	by Bill Kuunders	2	1,102
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	781
Have column of nums, need qty of each? samckitt	by Arvi Laanemets	3	423
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	433
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	708
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	493
how do i add numbers in nonadjacent cells? Bob	by Peo Sjoblom	1	681
How do I delete <br or <b that appears in text? AtTheMall-24-7	by Ron Rosenfeld	2	487
IF and MAX statements bob	by bob	5	514
Date entries Sal Iaccarino	by Sean	2	314
How to enter pre-decimal pounds shillings pence in Excel workshee Richard	by Richard	5	1,376
sorting data by a certain attribute ebt	by Herbert Seidenberg	2	446
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	446
Deleting contents of cells in non contiguous ranges Richard Buttrey	by Richard Buttrey	9	640
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	497
HELP with dreaded formulas... Brian	by Kletcho	5	394
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