Excel Worksheet Functions - Page 1041

Thread / Thread Starter	Last Post	Replies	Views
Total Working hours If Tia[_3_]	by Tia[_3_]	2	536
Attendance formula for payroll please help Tia[_3_]	by Tia[_3_]	0	677
Attendance formula for payroll please help Tia[_3_]	by Tia[_3_]	0	824
Sending Fax Using Fax Numbers in Excel Spreadsheet FredK	by FredK	0	1,281
Drop down list - color coding Sue	by Gord Dibben	1	2,507
How do I turn on Paste Special for linked data? dlps	by Gord Dibben	1	575
Inserting pictures into unprotected range in a protected worksheet Fernando Reyes	by Dave Peterson	1	725
Pivot Table Calculate Field Brad Autry	by Dave Peterson	1	625
calculated fields in pivot tables Brad Autry	by Dave Peterson	1	462
sun total of one column using criteria in another column Ben	by T. Valko	5	868
Matching dates to cells Donna[_2_]	by Max	8	560
SUMIF with "OR" criteria SwtHapa8	by T. Valko	2	549
will a function do this for me? quailwood	by Max	1	443
Conditional Formatting Error marwildfw	by marwildfw	3	725
How to change text/font colour, using formula Maulwy	by T. Valko	2	3,421
how to use the number format newbie101[_2_]	by Lars-Åke Aspelin[_2_]	3	556
calculating months between dates wendy	by wendy	5	862
Nght shift allowance Maresa	by Maresa	6	2,644
Return the text before a \| in a text string ArcticWolf	by ArcticWolf	5	605
Matching 2 columns Lynda	by Lynda	3	687
Partial background Kash	by Pete_UK	3	722
Row protection ab3d4u[_30_]	by Max	1	610
Ignoring #VALUE! errors and MORE!!!!! Romileyrunner1	by Romileyrunner1	3	737
Need benefit budget projections template renee	by Suzanne Sarah Mcallen	3	1,602
Anyone developed a template for employee span of control? NuBee	by Suzanne Sarah Mcallen	2	6,136
If C2 = East AND D2 < 20,000.00 then multiply D2 by 8% trip_to_tokyo[_2_]	by trip_to_tokyo[_2_]	4	752
Vlookup - Update Path Clyde Dickson[_2_]	by Dave Peterson	3	1,426
avoid Descending Sort putting error cells uppermost in collumn Romileyrunner1	by Romileyrunner1	3	669
Rounding in the Same Cell Johnnie[_2_]	by Johnnie[_2_]	2	558
sum cells based upon color of text Jessop	by Eduardo	1	1,006
vlookup by the lengh Shairal	by Shairal	3	663
Create a new sheet dependant on values edwgolz	by Bernie Deitrick	1	604
How do I merge all sheets in workbook to one document Excel Workbook Merge-Clgolden	by Excel Workbook Merge-Clgolden	0	625
Conditional formating Walley	by Herbert Seidenberg	1	591
Straight line depreciation Ian	by Pete_UK	4	754
SUMIF question RedDixieCup	by Jacob Skaria	2	610
Sundays Maresa	by T. Valko	5	658
Subtracting an absolute value NOAAlw	by NOAAlw	2	4,444
vlookup cells thAT are `NOT EQUAL` to a value / text Romileyrunner1	by Romileyrunner1	4	4,494
Ouch! Inconsistent TEXT("hh:mm") rounding JoeU2004	by JoeU2004	0	757
Averaging Hookette	by JoeU2004	6	641
Conditionally Formatting Cells based on Values in a Range (2007) sreid64	by sreid64	3	1,276
Function shows repeating decimal? Doug	by JP Ronse	3	1,617
count the # of times "name" is in E and "x" in F are in the same r Nielly	by Shane Devenshire[_2_]	2	583
Inserting curly brackets within a formula Romileyrunner1	by Romileyrunner1	4	2,678
CountIf Formula Redi	by Sean Timmons	1	690
vlookup with multiple values David	by T. Valko	3	688
Need Excel count of 1 word if found in multi-word cells of column Function_Challenged	by T. Valko	1	2,495
Excel Template naming option..... Turbine Mechanic	by Gord Dibben	1	911
Cell Referencing Kris W[_2_]	by Charabeuh[_4_]	5	669
Converting Text into Values Terry Bennett	by T. Valko	6	803
Rolling date looking 30 Days past Chris	by Max	2	1,543
Help with Excel VBA Howard	by Howard	2	654
coefficient of determination Jene	by Mike Middleton[_2_]	2	3,258
Go to cell below last entry in column and total Donna[_2_]	by Jacob Skaria	1	805
SUM IF question (daily rainfall totals) RedDixieCup	by Fred Smith[_4_]	9	1,151
Count with two criteria in a second worksheet bec	by T. Valko	1	616
Search a named range rhhince[_2_]	by Lars-Åke Aspelin[_2_]	1	731
cells are automatically dividing each # I put in by 10!!! Romileyrunner1	by T. Valko	5	799
Countif multiple items Romileyrunner1	by Romileyrunner1	2	698
Real teaser! LiAD	by LiAD	4	578
CountA or DcountA, that is the question?? Niqui	by Sam Wilson	1	562
Display formula on the cell journey	by macropod[_2_]	2	595
Excel is crashing when making a pdf of my workbook Jewell	by Jewell	0	692
conditional formatting Jules	by Jules	0	481
To return a blank cell rather than 0% in a vlookup. Romileyrunner1	by Max	9	1,147
Simple? View named range from sheet1 on sheet2 susiew32	by Pete_UK	1	855
Worksheet compatability Jewell	by Gord Dibben	1	532
How do I export a row of data into its own workbook LMM_0809	by Luke M	1	675
I can not create an external link between two Excel 2007 workbooks Bill R	by Gord Dibben	1	1,778
Display text automatically OKY	by Niek Otten	3	566
Pivot table column help Mr CheeZe	by Mr CheeZe	2	494
How to find and move a value based on multiple criteria JeffZ88	by JeffZ88	0	621
ordering a column by incidence colensa	by Don Guillett	1	570
#DIV/0! KelD	by Luke M	1	581