Excel Worksheet Functions - Page 675

Thread / Thread Starter	Last Post	Replies	Views
Lookup Scott W	by andy duncan	3	370
overtime calculation alli	by alli	3	894
Extract numeric part of alphanumeric cell Sarah (OGI)	by CLR	3	2,192
summing cells with different colors or fonts hinman48	by JE McGimpsey	1	382
Will Conditional Formatting work? jennjenn	by JE McGimpsey	2	449
Copy cells based on conditions in one workbook to another workbook fLiPMoD£	by fLiPMoD£	0	593
How do I make a formula calculating all cells after a certain date Mottyb	by Paul B	3	404
How do I subtract/add a known number of days/months from a date? Alf Andersen	by T. Valko	2	1,367
Countif Function Stephanie	by Toppers	1	431
What is the syntax for function text parameters in VBA (Excel 07) Jocken	by Niek Otten	4	1,075
=IF(C1=""," ","ImportID-01") Outlook, eh?	by Harlan Grove	16	728
Date formatting Sandy	by [email protected]	2	522
getting rid of "#N/A" in columns JC	by T. Valko	9	382
Average with 2 criteria including month RS	by RS	8	554
Copied formula won't calculate Lisar.	by Gord Dibben	3	737
How can I name Worksheet Tabs based on some king of reference? Gord Dibben	by Gord Dibben	4	581
Mouse controlled auto sum feature lost Lost is Allentown	by Gord Dibben	6	1,088
How do I put a delete button on excel that will clear the fields? Dave	by Gord Dibben	3	897
How do I use "if statements" when working with dates? Statesman	by T. Valko	3	457
Copy cells based on conditions to another workbook fLiPMoD£	by fLiPMoD£	0	498
Feeding data from one spreadsheet to another. Jeffa	by Jeffa	5	1,746
What is the formula for dividing-I have the total Susan	by Pete_UK	1	456
How can I find percentages of a number Finding percentages	by Stan Brown	3	317
Contains vs = Mottyb	by BriSwy	5	381
Tunrover Formula Heyda D.	by Fred Smith	1	419
nested if Gary Wessle	by Harlan Grove[_2_]	6	496
Formula confusion harry buggy	by Harlan Grove[_2_]	4	505
Selecting Column with three variablesand lookup Jeff[_6_]	by T. Valko	3	369
sorting and copying Stan Halls	by Stan Halls	3	375
Formula needed to show the second to last figure in range of cells Sarah (OGI)	by Harlan Grove[_2_]	3	704
Xtrapolation of Data Andy	by andy duncan	2	437
At least two males Matti Koski	by Bob Phillips	1	307
"Trend" Function andy duncan	by Bernd P	4	363
calculating a formula for a service level Andy B	by David Biddulph[_2_]	1	1,112
USING IF AND PROBLEM Amanda	by Amanda	2	344
VLOOKUP Function bglee31	by Pete_UK	5	338
Date Formulas & format Manos	by Manos	3	422
calculating a formula for a service level Andy B	by Mike H[_3_]	1	5,777
Find lowest 3 values and sum AussieBec	by AussieBec	6	1,508
Ignore text but not numerics on SUM() function KLZA	by squenson via OfficeKB.com	1	1,485
Source Data in Pivot Tables cqc	by linda	7	1,121
spreadsheet locked - for no reason ? andy duncan	by JICDB	3	864
How do I make labels from an Excel spreadsheet?? jill	by John Bundy	3	427
Pull a Sample from a Population dzd&confused	by squenson via OfficeKB.com	3	1,693
########### error tre	by Dynamite	3	510
how do I set TAB key to move to next cell Sergio Cortes	by Sergio Cortes[_2_]	2	1,746
Validation and If Function Problems mmd206	by Rick Rothstein \(MVP - VB\)	1	468
need help with row headers Jen	by Gord Dibben	1	351
Embedded Dec2hex help needed mogulboy	by David Biddulph[_2_]	2	521
Vlookup with Hyperlink Problem JICDB	by JICDB	0	448
ActiveSheet.Paste (error) Puzzled	by bj	1	625
Macros to Pull Errors to Top of the Page Daren	by bj	3	430
function to find and copy data Carpe Diem	by Harlan Grove[_2_]	1	632
Help! Totally Grey Sheet nabanco	by Harlan Grove[_2_]	2	1,167
Sumproduct on multiple "or" conditions watchtower	by watchtower	7	809
way to delete the input area on several Excel spreadsheets MarcelMarceau	by ryguy7272	2	587
show date as day of the year Brad	by Brad	2	496
Date Formatting catfish	by Gord Dibben	2	370
ALTERNATIVE TO SUMPRODUCT NEEDED Rog	by Rog	26	1,882
nth element extract RSCARLISLE	by RSCARLISLE	3	885
The XIRR function in Excel MMM	by Duke Carey	1	565
Sumproduct trouble Carlee	by [email protected]	2	371
Advancing date to the first of next month? Statesman	by Peo Sjoblom	3	461
Simple lookup problem... Haxer	by [email protected]	5	445
Sumif with multiple criteria with an extra twist Peanut	by Peanut	7	585
Counting Unique Values by Date Range [email protected]	by [email protected]	5	1,437
Excel 2003, will not let me color fill cells rick	by CommerceMary	2	1,189
Creating a count when the information from two cells is true. J. G. Skains	by J. G. Skains[_2_]	2	372
Does someone know what is the capacity of each workbook? madoarm	by T. Valko	1	509
grand total subtotals without hiding details Sherry	by Sherry	7	418
Remove first few digits from all cells in the column Magwine	by Beege	7	3,680
excel formulae Jimi	by Peo Sjoblom	7	591
freeze panes - freezes first 6 rows when only 1 required Mike	by Mike	2	2,922
Link a Master Template Excel file to different excel source files Jean	by Jean	0	1,037
List Validation and IF Function Problem mmd206	by T. Valko	2	572