Excel Worksheet Functions - Page 814

Thread / Thread Starter	Last Post	Replies	Views
Building Non-Contiguous Arrays For Use With Linest Marston	by Domenic[_2_]	4	3,298
NPV & IRR FA	by Fred Smith[_4_]	4	436
purging empty excel files Kayestar	by Spiky	1	636
Separating text into seperate fields vanced	by David Biddulph[_2_]	3	487
Combinng functions to lookup data DP	by Max	2	376
Format cell so number entered will show only one way Frustrated in AZ	by T. Valko	3	875
Sumif on pulling out data from dates Eagleryder	by T. Valko	3	435
Counting cells in a range per multiple criteria . . . Dano	by T. Valko	9	664
Formulas in my Workbook Spiky	by Spiky	0	365
shorten IF Statements Flanno	by Flanno	3	674
creating a combo box that shows multiple entries. Burke	by ryguy7272	1	672
Condtional formatting on 2 separate dates mfoster	by mfoster	2	365
Excel - Formula/Programming Ezra[_2_]	by Otto Moehrbach[_2_]	1	466
cells don't recognize formula Chris D	by Chris D	0	574
Indentify Shift number in 24 hour period mikebres	by mikebres	5	691
Match 3 columns to one cell Matching 3 columns to 1 cell	by ryguy7272	5	361
Can I create a button for a formula? Kristi_ut[_2_]	by Susan	1	288
Cell reference question blumonkey	by T. Valko	4	342
Formulas and counting David	by T. Valko	9	437
HELP Pfizer Gal	by David Biddulph[_2_]	3	380
How do I enter the formula to show the current day of the week ? Simple, but I don't know	by David Biddulph[_2_]	4	733
Is it possible to dedupe two excel lists? LSchroeter, HRW	by Pete_UK	1	675
Concatenation ATHER	by David Biddulph[_2_]	2	445
"Find" in multiple sheets!!*********Urgent James8309	by James8309	0	326
Search for duplicates across three worksheets Sarah_Lund	by Dave Peterson	1	1,320
Can Excel warn me if a cell already contains entered information? Can Excel warn me if a cell already cont	by Gord Dibben	2	447
pivot tables - add columns Renata	by Debra Dalgleish	1	464
Conditional formatting of entire workbook computhom	by Dave	3	5,405
I am looking for help with a check box formular Buzz Local#30	by Buzz Local#30	6	483
Pivot Table missing data item acss	by Debra Dalgleish	1	562
Counting Criteria in Cells in Multiple Ranges WalterK	by T. Valko	4	635
dates for on time delivery calc. Xfree	by Fred Smith[_4_]	3	3,965
sorting columns when cell results based on other cells Dawn	by Fred Smith[_4_]	1	657
Index & Match Function [email protected]	by T. Valko	1	366
Source for DropDown in another workbook alexis_anne3799	by alexis_anne3799[_2_]	3	643
SMALL function Wally3178	by Bob Phillips	7	424
Countif depending on the conditions across multiple columns san	by vsoler	1	412
Sum with Array Formula Gary''s Student	by Max	7	440
Invisible sheets emilh	by ryguy7272	2	600
Referencing a worksheet name to a cell... QuietMan	by QuietMan	10	915
Cubevalue Robin Krupp	by Robin Krupp	0	722
Displaying Data Sue	by Sue	6	352
Count Colors in 2003 Whois Clinton	by Whois Clinton	3	428
Number of rows with a non blank cell vsoler	by vsoler	3	546
filtering dates Dawn	by David Biddulph[_2_]	4	397
NUMBERS RUN IN ONE CELL SANDIND	by Rick Rothstein \(MVP - VB\)[_482_]	10	881
Questions about copying a Formula Boblink	by Boblink	9	369
Show just middle info of a cell zeilski	by Reitanos	5	366
SOMASE erra cÃ¡lculo Tomas SJCampos	by vezerid	1	498
on your main page click on the worksheet name and be taken to it chiefrockeruk	by Gord Dibben	2	403
Connect Two Cells Freshman	by T. Valko	3	1,042
Count times that are more than 5 minutes in a range from a newworksheet Lenchik	by T. Valko	1	662
Summarizing data into different worksheet Liztd	by vezerid	1	581
How to truncate digits? Robert Blass	by Robert Blass	6	1,008
HOW DO i SET UP A REPORT USING INFO FROM A WORKSHEET LIS MickeyMouse	by David Biddulph[_2_]	2	384
Extracting values from formulas servboss02	by T. Valko	3	413
Subtotal variable range JDaywalt	by vezerid	1	746
Excell is not allowing me to click onto a single cell. WHY? typeover	by Gord Dibben	1	701
Control tab Fairfax	by Gord Dibben	1	426
Sum If with two ranges and condition Nuno JÃ¡come	by RobinMass	6	822
IF-more than 7 arguments in Carolina	by Carolina	2	438
Table_Array arg for VLOOKUP TMac71	by ShaneDevenshire	1	370
Formula to place the same value in a specific number of cells flarunner	by flarunner	4	517
Excel 2003 vs Excel 2007 AuntGal	by AuntGal	0	277
XIRR Problem Dkline	by Dkline	8	1,136
linking workbooks Phillip2419	by Phillip2419	0	293
vlookup TAK	by Pete_UK	8	589
Thanks Pete_UK & T. Valko... robzrob	by Pete_UK	1	479
Finding the Value of a range in another column and showing resulti TXDalessandros	by Bernard Liengme	1	389
Picking a value from a table using Column and Row ranges? James Dalton[_2_]	by James Dalton[_2_]	2	766
Named Ranges in Array Formulas jfitzpat	by jfitzpat	2	813
multiple Hyperlinks one Excel cell? Jody	by Dave Peterson	4	3,506
Office web component . Ermias	by Ermias	0	615
Compare text in 2 separate spreadsheets, when match found display cocoblue	by cocoblue	3	560
Steps to performing R2 function with excel ICP Jon	by Jim Cone[_2_]	3	1,491