Excel Worksheet Functions - Page 396

Thread / Thread Starter	Last Post	Replies	Views
IF function - If false argument query Twishlist	by Max	5	680
date and time [skipping weekends] rhhince[_2_]	by rhhince[_2_]	8	621
Manipulating data in Multible worksheets Jason Cottrell	by Jason Cottrell	2	448
shortcut key for selecting the inactive cells surrounding a range Michele	by Héctor Miguel	1	433
VLookup and cell shading Sherry	by mvk	2	967
Date Range Conditional Formatting Lynn	by T. Valko	13	1,250
VLOOKUP Clay_TX	by Pete_UK	4	504
Zero Values robzrob	by robzrob	2	389
Cumulative days roll-over John MacAllister	by John MacAllister[_2_]	7	544
Table feature in Data Menu Katie	by Max	6	515
Conditional formatting II Mac	by Mac	4	374
Is there a limit to the number of formulas in an Excel worksheet? Del[_2_]	by JP[_4_]	3	568
pulling data from 2 columns MJJ	by Pete_UK	3	385
Duplicate rows into new rows based on row value Tom	by ryguy7272	5	680
Conditional formatting Mac	by Mac	3	334
trying to consolidate info into one sheet cabirdy	by Herbert Seidenberg	1	426
PageSetup Macro Julian Glass	by Stan Brown	1	593
help on sumproduct() - sum by searching for a common sub string in Eddy Stan	by Bob Phillips	12	987
Search and replace function RichardR	by Pete_UK	1	420
Generating a new list based on cell criteria JerryS	by Max	1	399
Need Formula to Find a Match and Then Insert Some Characters Toria	by Pete_UK	4	498
Pasting Borders TigerLady	by Ken Johnson	2	410
Excel Formula to concatenate record from 2 tables Negda	by Herbert Seidenberg	3	535
Conditional Calculations with Calculated Results Koneko	by Pete_UK	1	582
Conditional Format Based on Age, but not if blank. Gregory Day	by Pete_UK	7	2,720
Count Days more than 180 days prior to today Gregory Day	by Gregory Day	4	3,412
Linking values within an Excel workbook Jerry M.	by ryguy7272	1	559
How to concatenate cell & text in a text box? Jimbo213	by ryguy7272	3	690
#n/a result for vlookup adimar	by adimar	5	762
How to force data entry with error messages CindyB	by CindyB	1	1,324
Sumproduct Offset with an If Steve[_4_]	by [email protected]	2	550
Copying formulas [email protected]	by Pete_UK	1	369
Need formula in excel for filtering large database Sharkies	by Sharkies[_2_]	2	791
Change a 1,2,3 or 4 digit number to a 6 character text string Steve D	by Pete_UK	3	1,238
Is there a function that will email a spreadsheet if changed? jivejimmy	by ryguy7272	1	482
adding time behind the counter person[_2_]	by Mike H	2	404
Sumif with multiple columns in sum_range dza7	by Ron Coderre	17	1,217
in excel how to pull only used information to another sheet kathysperdie04	by Pete_UK	1	442
Shading rows MichaelZ	by MichaelZ	2	451
Count if cetain text is in another column, same row. bhammer	by Lars-Åke Aspelin[_2_]	6	1,011
Is there a way to make a ratio alterable? Dcblock701231	by Dcblock701231	0	445
VLOOKUP DATA sumif and[_2_]	by Lars-Åke Aspelin[_2_]	1	417
Horizontal merging of cells [email protected]	by Gord Dibben	1	1,171
Variable reference in countif Libby	by T. Valko	2	549
formula to count occurrences Libby	by Libby	5	418
Blank Date NotGood@All	by NotGood@All	4	411
Countif with date range criteria luisi	by Pete_UK	5	1,562
lookup needed for names in varying order alicatnj	by Billy Liddel	2	531
Alternative to IF Dave P[_2_]	by Pete_UK	7	649
VLookup in Excel 2003 Loyer	by ryguy7272	4	453
IF and Vlookup Jamki	by Wehrmacher	1	378
Transforming table's content/display noa	by Dave Peterson	4	397
Formula to Populate Cells Bob	by Bob	3	648
Excel user defined functioned [email protected]	by ryguy7272	2	364
Sum the values of cells based on fontcolor [email protected]	by ryguy7272	1	1,142
VLOOKUP PULLING WRONG DATA DKPHELP	by Dave Peterson	6	2,353
Kendall's tau wdhluck	by Pete_UK	1	1,970
Error in if condition Christopher Naveen[_2_]	by Bernie Deitrick	1	376
HOW DO I INSERT A MULTICHOICE SELECTOR IN EXCEL? ROBBIE1962	by Gary''s Student	1	2,695
Daily data to weekly data conversion in Excel? Poorak Kashyap	by Gary''s Student	2	994
How to know a cell contain the formula Andri	by Andri	4	374
How do I test a specific color in 2003? Sp3ct4tor	by Gary''s Student	1	366
Excel 2002... Carlo	by Carlo	3	306
Calculating percentage of Shaded Cells in a row BrettPotts	by Gary''s Student	1	609
Update link without openning the source/destination files jwang036	by jwang036	2	690
Need more than 7 formulas in one cell Askew in help	by BOONER	2	654
Highest 3 in 10 Consecutive Numbers Dan	by Harlan Grove[_2_]	17	2,395
Moving within the worksheet ordnance1	by Gord Dibben	3	364
Lookup to Show Empty Cell RoadKill	by Pete_UK	5	801
Inserting comments milt	by Gord Dibben	3	441
93245 - descr-ip24tion: Q-how do i only extract 93245? ChrisV[_2_]	by Gord Dibben	4	387
How do I delete a page in excel need help	by Gord Dibben	3	576
Get error message about copying cells with more than 255 characte. mghntlh	by Gord Dibben	2	912
Help - Just started using Excel 2007 and need help finding an Add- Village1800	by Gord Dibben	2	516
Sum per row and Average per column from a second sheet. Gregory Day	by akphidelt	6	649