Excel Worksheet Functions - Page 396

Thread / Thread Starter	Last Post	Replies	Views
IF function - If false argument query Twishlist	by Max	5	700
date and time [skipping weekends] rhhince[_2_]	by rhhince[_2_]	8	634
Manipulating data in Multible worksheets Jason Cottrell	by Jason Cottrell	2	460
shortcut key for selecting the inactive cells surrounding a range Michele	by Héctor Miguel	1	456
VLookup and cell shading Sherry	by mvk	2	986
Date Range Conditional Formatting Lynn	by T. Valko	13	1,262
VLOOKUP Clay_TX	by Pete_UK	4	510
Zero Values robzrob	by robzrob	2	391
Cumulative days roll-over John MacAllister	by John MacAllister[_2_]	7	547
Table feature in Data Menu Katie	by Max	6	521
Conditional formatting II Mac	by Mac	4	378
Is there a limit to the number of formulas in an Excel worksheet? Del[_2_]	by JP[_4_]	3	581
pulling data from 2 columns MJJ	by Pete_UK	3	399
Duplicate rows into new rows based on row value Tom	by ryguy7272	5	696
Conditional formatting Mac	by Mac	3	380
trying to consolidate info into one sheet cabirdy	by Herbert Seidenberg	1	435
PageSetup Macro Julian Glass	by Stan Brown	1	613
help on sumproduct() - sum by searching for a common sub string in Eddy Stan	by Bob Phillips	12	1,009
Search and replace function RichardR	by Pete_UK	1	427
Generating a new list based on cell criteria JerryS	by Max	1	413
Need Formula to Find a Match and Then Insert Some Characters Toria	by Pete_UK	4	508
Pasting Borders TigerLady	by Ken Johnson	2	421
Excel Formula to concatenate record from 2 tables Negda	by Herbert Seidenberg	3	543
Conditional Calculations with Calculated Results Koneko	by Pete_UK	1	598
Conditional Format Based on Age, but not if blank. Gregory Day	by Pete_UK	7	2,730
Count Days more than 180 days prior to today Gregory Day	by Gregory Day	4	3,459
Linking values within an Excel workbook Jerry M.	by ryguy7272	1	564
How to concatenate cell & text in a text box? Jimbo213	by ryguy7272	3	697
#n/a result for vlookup adimar	by adimar	5	770
How to force data entry with error messages CindyB	by CindyB	1	1,329
Sumproduct Offset with an If Steve[_4_]	by [email protected]	2	561
Copying formulas [email protected]	by Pete_UK	1	378
Need formula in excel for filtering large database Sharkies	by Sharkies[_2_]	2	806
Change a 1,2,3 or 4 digit number to a 6 character text string Steve D	by Pete_UK	3	1,248
Is there a function that will email a spreadsheet if changed? jivejimmy	by ryguy7272	1	489
adding time behind the counter person[_2_]	by Mike H	2	415
Sumif with multiple columns in sum_range dza7	by Ron Coderre	17	1,230
in excel how to pull only used information to another sheet kathysperdie04	by Pete_UK	1	452
Shading rows MichaelZ	by MichaelZ	2	457
Count if cetain text is in another column, same row. bhammer	by Lars-Åke Aspelin[_2_]	6	1,016
Is there a way to make a ratio alterable? Dcblock701231	by Dcblock701231	0	449
VLOOKUP DATA sumif and[_2_]	by Lars-Åke Aspelin[_2_]	1	433
Horizontal merging of cells [email protected]	by Gord Dibben	1	1,174
Variable reference in countif Libby	by T. Valko	2	564
formula to count occurrences Libby	by Libby	5	429
Blank Date NotGood@All	by NotGood@All	4	416
Countif with date range criteria luisi	by Pete_UK	5	1,588
lookup needed for names in varying order alicatnj	by Billy Liddel	2	540
Alternative to IF Dave P[_2_]	by Pete_UK	7	677
VLookup in Excel 2003 Loyer	by ryguy7272	4	465
IF and Vlookup Jamki	by Wehrmacher	1	391
Transforming table's content/display noa	by Dave Peterson	4	404
Formula to Populate Cells Bob	by Bob	3	654
Excel user defined functioned [email protected]	by ryguy7272	2	401
Sum the values of cells based on fontcolor [email protected]	by ryguy7272	1	1,159
VLOOKUP PULLING WRONG DATA DKPHELP	by Dave Peterson	6	2,405
Kendall's tau wdhluck	by Pete_UK	1	1,975
Error in if condition Christopher Naveen[_2_]	by Bernie Deitrick	1	389
HOW DO I INSERT A MULTICHOICE SELECTOR IN EXCEL? ROBBIE1962	by Gary''s Student	1	2,726
Daily data to weekly data conversion in Excel? Poorak Kashyap	by Gary''s Student	2	1,016
How to know a cell contain the formula Andri	by Andri	4	382
How do I test a specific color in 2003? Sp3ct4tor	by Gary''s Student	1	377
Excel 2002... Carlo	by Carlo	3	308
Calculating percentage of Shaded Cells in a row BrettPotts	by Gary''s Student	1	623
Update link without openning the source/destination files jwang036	by jwang036	2	706
Need more than 7 formulas in one cell Askew in help	by BOONER	2	660
Highest 3 in 10 Consecutive Numbers Dan	by Harlan Grove[_2_]	17	2,469
Moving within the worksheet ordnance1	by Gord Dibben	3	368
Lookup to Show Empty Cell RoadKill	by Pete_UK	5	820
Inserting comments milt	by Gord Dibben	3	502
93245 - descr-ip24tion: Q-how do i only extract 93245? ChrisV[_2_]	by Gord Dibben	4	390
How do I delete a page in excel need help	by Gord Dibben	3	608
Get error message about copying cells with more than 255 characte. mghntlh	by Gord Dibben	2	925
Help - Just started using Excel 2007 and need help finding an Add- Village1800	by Gord Dibben	2	528
Sum per row and Average per column from a second sheet. Gregory Day	by akphidelt	6	653