Excel Worksheet Functions - Page 396

Thread / Thread Starter	Last Post	Replies	Views
IF function - If false argument query Twishlist	by Max	5	703
date and time [skipping weekends] rhhince[_2_]	by rhhince[_2_]	8	635
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	460
VLookup and cell shading Sherry	by mvk	2	988
Date Range Conditional Formatting Lynn	by T. Valko	13	1,269
VLOOKUP Clay_TX	by Pete_UK	4	511
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	522
Conditional formatting II Mac	by Mac	4	379
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	400
Duplicate rows into new rows based on row value Tom	by ryguy7272	5	697
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	616
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	429
Generating a new list based on cell criteria JerryS	by Max	1	414
Need Formula to Find a Match and Then Insert Some Characters Toria	by Pete_UK	4	510
Pasting Borders TigerLady	by Ken Johnson	2	422
Excel Formula to concatenate record from 2 tables Negda	by Herbert Seidenberg	3	544
Conditional Calculations with Calculated Results Koneko	by Pete_UK	1	599
Conditional Format Based on Age, but not if blank. Gregory Day	by Pete_UK	7	2,732
Count Days more than 180 days prior to today Gregory Day	by Gregory Day	4	3,495
Linking values within an Excel workbook Jerry M.	by ryguy7272	1	566
How to concatenate cell & text in a text box? Jimbo213	by ryguy7272	3	698
#n/a result for vlookup adimar	by adimar	5	771
How to force data entry with error messages CindyB	by CindyB	1	1,330
Sumproduct Offset with an If Steve[_4_]	by [email protected]	2	562
Copying formulas [email protected]	by Pete_UK	1	378
Need formula in excel for filtering large database Sharkies	by Sharkies[_2_]	2	809
Change a 1,2,3 or 4 digit number to a 6 character text string Steve D	by Pete_UK	3	1,249
Is there a function that will email a spreadsheet if changed? jivejimmy	by ryguy7272	1	491
adding time behind the counter person[_2_]	by Mike H	2	417
Sumif with multiple columns in sum_range dza7	by Ron Coderre	17	1,233
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,017
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	434
Horizontal merging of cells [email protected]	by Gord Dibben	1	1,174
Variable reference in countif Libby	by T. Valko	2	566
formula to count occurrences Libby	by Libby	5	430
Blank Date NotGood@All	by NotGood@All	4	421
Countif with date range criteria luisi	by Pete_UK	5	1,589
lookup needed for names in varying order alicatnj	by Billy Liddel	2	540
Alternative to IF Dave P[_2_]	by Pete_UK	7	686
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	406
Sum the values of cells based on fontcolor [email protected]	by ryguy7272	1	1,161
VLOOKUP PULLING WRONG DATA DKPHELP	by Dave Peterson	6	2,413
Kendall's tau wdhluck	by Pete_UK	1	1,975
Error in if condition Christopher Naveen[_2_]	by Bernie Deitrick	1	392
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,022
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	309
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	711
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,474
Moving within the worksheet ordnance1	by Gord Dibben	3	368
Lookup to Show Empty Cell RoadKill	by Pete_UK	5	822
Inserting comments milt	by Gord Dibben	3	504
93245 - descr-ip24tion: Q-how do i only extract 93245? ChrisV[_2_]	by Gord Dibben	4	394
How do I delete a page in excel need help	by Gord Dibben	3	624
Get error message about copying cells with more than 255 characte. mghntlh	by Gord Dibben	2	926
Help - Just started using Excel 2007 and need help finding an Add- Village1800	by Gord Dibben	2	529
Sum per row and Average per column from a second sheet. Gregory Day	by akphidelt	6	653