Excel Worksheet Functions - Page 509

Thread / Thread Starter	Last Post	Replies	Views
Vlookup with Hyperlink Problem JICDB	by JICDB	0	438
Embedded Dec2hex help needed mogulboy	by David Biddulph[_2_]	2	512
need help with row headers Jen	by Gord Dibben	1	343
Validation and If Function Problems mmd206	by Rick Rothstein \(MVP - VB\)	1	465
how do I set TAB key to move to next cell Sergio Cortes	by Sergio Cortes[_2_]	2	1,719
########### error tre	by Dynamite	3	509
Pull a Sample from a Population dzd&confused	by squenson via OfficeKB.com	3	1,686
How do I make labels from an Excel spreadsheet?? jill	by John Bundy	3	407
spreadsheet locked - for no reason ? andy duncan	by JICDB	3	857
Source Data in Pivot Tables cqc	by linda	7	1,118
Ignore text but not numerics on SUM() function KLZA	by squenson via OfficeKB.com	1	1,483
Find lowest 3 values and sum AussieBec	by AussieBec	6	1,507
calculating a formula for a service level Andy B	by Mike H[_3_]	1	5,742
Date Formulas & format Manos	by Manos	3	418
VLOOKUP Function bglee31	by Pete_UK	5	335
USING IF AND PROBLEM Amanda	by Amanda	2	340
calculating a formula for a service level Andy B	by David Biddulph[_2_]	1	1,069
"Trend" Function andy duncan	by Bernd P	4	345
At least two males Matti Koski	by Bob Phillips	1	302
Xtrapolation of Data Andy	by andy duncan	2	436
Formula needed to show the second to last figure in range of cells Sarah (OGI)	by Harlan Grove[_2_]	3	666
sorting and copying Stan Halls	by Stan Halls	3	367
Selecting Column with three variablesand lookup Jeff[_6_]	by T. Valko	3	368
Formula confusion harry buggy	by Harlan Grove[_2_]	4	500
nested if Gary Wessle	by Harlan Grove[_2_]	6	478
Tunrover Formula Heyda D.	by Fred Smith	1	414
Contains vs = Mottyb	by BriSwy	5	381
How can I find percentages of a number Finding percentages	by Stan Brown	3	310
What is the formula for dividing-I have the total Susan	by Pete_UK	1	452
Feeding data from one spreadsheet to another. Jeffa	by Jeffa	5	1,739
Copy cells based on conditions to another workbook fLiPMoD£	by fLiPMoD£	0	486
How do I use "if statements" when working with dates? Statesman	by T. Valko	3	454
How do I put a delete button on excel that will clear the fields? Dave	by Gord Dibben	3	890
Mouse controlled auto sum feature lost Lost is Allentown	by Gord Dibben	6	1,081
How can I name Worksheet Tabs based on some king of reference? Gord Dibben	by Gord Dibben	4	573
Copied formula won't calculate Lisar.	by Gord Dibben	3	735
Average with 2 criteria including month RS	by RS	8	547
getting rid of "#N/A" in columns JC	by T. Valko	9	378
Date formatting Sandy	by [email protected]	2	515
=IF(C1=""," ","ImportID-01") Outlook, eh?	by Harlan Grove	16	723
What is the syntax for function text parameters in VBA (Excel 07) Jocken	by Niek Otten	4	1,071
Countif Function Stephanie	by Toppers	1	425
How do I subtract/add a known number of days/months from a date? Alf Andersen	by T. Valko	2	1,364
How do I make a formula calculating all cells after a certain date Mottyb	by Paul B	3	397
Copy cells based on conditions in one workbook to another workbook fLiPMoD£	by fLiPMoD£	0	584
Will Conditional Formatting work? jennjenn	by JE McGimpsey	2	445
summing cells with different colors or fonts hinman48	by JE McGimpsey	1	375
Extract numeric part of alphanumeric cell Sarah (OGI)	by CLR	3	2,184
overtime calculation alli	by alli	3	888
Lookup Scott W	by andy duncan	3	369
Reporting by month and year [email protected]	by [email protected]	3	316
Minimum Value Alex	by Toppers	2	586
How do you mirror data and formatting in Excel '03 Jorg	by bj	1	1,491
Identifying the last visit Sarah (OGI)	by Sarah (OGI)	2	346
Matching down a column Tsunami3169	by Max	3	353
paste greyed out Cresta	by Cresta	7	1,216
Macro - a way of recording the date Sarah (OGI)	by Toppers	3	474
Greater of Two Cells Simon y Glog	by Simon y Glog	0	2,672
SUMIF geebee	by squenson via OfficeKB.com	2	409
employee schedule with hours Dawn P	by Toppers	3	654
Sum if the column heading is in the past? Kirstie Adam	by squenson via OfficeKB.com	1	454
Excel could not save all the data and formatting you recently added Amedee Van Gasse	by Amedee Van Gasse	0	762
Hyperlink to Word Doc JICDB	by JICDB	3	533
Calculation of working days between two dates Andy B	by Bernie Deitrick	1	632
Matching Cells in different files to sum. 1gr8tigerfan	by 1gr8tigerfan	2	704
Using Rank function, how to show value as 'N/A' IF O Alex	by Alex	2	343
Find the number of days in a month catrrmg	by catrrmg	2	513
VLookup v 7 nested IF functions Zakynthos	by Zakynthos	4	649
Matching between spreadsheets? Dan the Man[_2_]	by Dan the Man[_2_]	2	414
Identifying top scores soph	by Max	2	423
Compare text string of a cell in Column A VS another cell in Colum Tan	by Max	1	895
Formula for Doctor T	by Harlan Grove[_2_]	5	431
Vlookup reference the row below jtoy	by Harlan Grove[_2_]	5	696
Sums from different worksheets Botts	by Botts	0	413
Lookup for smallest number? JICDB	by Bernd P	8	457