Excel Worksheet Functions - Page 788

Thread / Thread Starter	Last Post	Replies	Views
VLookup in Excel 2003 Loyer	by ryguy7272	4	458
Alternative to IF Dave P[_2_]	by Pete_UK	7	650
lookup needed for names in varying order alicatnj	by Billy Liddel	2	535
Countif with date range criteria luisi	by Pete_UK	5	1,566
Blank Date NotGood@All	by NotGood@All	4	411
formula to count occurrences Libby	by Libby	5	419
Variable reference in countif Libby	by T. Valko	2	554
Horizontal merging of cells [email protected]	by Gord Dibben	1	1,171
VLOOKUP DATA sumif and[_2_]	by Lars-Åke Aspelin[_2_]	1	418
Is there a way to make a ratio alterable? Dcblock701231	by Dcblock701231	0	446
Count if cetain text is in another column, same row. bhammer	by Lars-Åke Aspelin[_2_]	6	1,012
Shading rows MichaelZ	by MichaelZ	2	451
in excel how to pull only used information to another sheet kathysperdie04	by Pete_UK	1	444
Sumif with multiple columns in sum_range dza7	by Ron Coderre	17	1,220
adding time behind the counter person[_2_]	by Mike H	2	408
Is there a function that will email a spreadsheet if changed? jivejimmy	by ryguy7272	1	483
Change a 1,2,3 or 4 digit number to a 6 character text string Steve D	by Pete_UK	3	1,243
Need formula in excel for filtering large database Sharkies	by Sharkies[_2_]	2	792
Copying formulas [email protected]	by Pete_UK	1	369
Sumproduct Offset with an If Steve[_4_]	by [email protected]	2	555
How to force data entry with error messages CindyB	by CindyB	1	1,326
#n/a result for vlookup adimar	by adimar	5	764
How to concatenate cell & text in a text box? Jimbo213	by ryguy7272	3	691
Linking values within an Excel workbook Jerry M.	by ryguy7272	1	560
Count Days more than 180 days prior to today Gregory Day	by Gregory Day	4	3,421
Conditional Format Based on Age, but not if blank. Gregory Day	by Pete_UK	7	2,723
Conditional Calculations with Calculated Results Koneko	by Pete_UK	1	583
Excel Formula to concatenate record from 2 tables Negda	by Herbert Seidenberg	3	536
Pasting Borders TigerLady	by Ken Johnson	2	410
Need Formula to Find a Match and Then Insert Some Characters Toria	by Pete_UK	4	499
Generating a new list based on cell criteria JerryS	by Max	1	404
Search and replace function RichardR	by Pete_UK	1	420
help on sumproduct() - sum by searching for a common sub string in Eddy Stan	by Bob Phillips	12	995
PageSetup Macro Julian Glass	by Stan Brown	1	597
trying to consolidate info into one sheet cabirdy	by Herbert Seidenberg	1	430
Conditional formatting Mac	by Mac	3	366
Duplicate rows into new rows based on row value Tom	by ryguy7272	5	685
pulling data from 2 columns MJJ	by Pete_UK	3	388
Is there a limit to the number of formulas in an Excel worksheet? Del[_2_]	by JP[_4_]	3	572
Conditional formatting II Mac	by Mac	4	374
Table feature in Data Menu Katie	by Max	6	515
Cumulative days roll-over John MacAllister	by John MacAllister[_2_]	7	545
Zero Values robzrob	by robzrob	2	389
VLOOKUP Clay_TX	by Pete_UK	4	505
Date Range Conditional Formatting Lynn	by T. Valko	13	1,252
VLookup and cell shading Sherry	by mvk	2	970
shortcut key for selecting the inactive cells surrounding a range Michele	by Héctor Miguel	1	439
Manipulating data in Multible worksheets Jason Cottrell	by Jason Cottrell	2	454
date and time [skipping weekends] rhhince[_2_]	by rhhince[_2_]	8	622
IF function - If false argument query Twishlist	by Max	5	686
help with code in a mack Richard	by Dave Peterson	5	337
separating linked wrkbooks robzrob	by JLatham	5	318
Adding fileds in a list based on a lookup Gregory Day	by sahafi	5	414
calculating by month Jake	by Bob Phillips	1	364
Text to Numbers Batshon	by Gord Dibben	4	353
How do I vlookup multiple rows with same reference? Kathie C	by Herbert Seidenberg	2	1,571
Drop Down Menu autofilling Aaron	by Gord Dibben	6	402
Using Solver [email protected]	by Dana DeLouis[_2_]	2	542
converting files to excel jes	by volelo	3	436
Returning matches from mutiple rows Sunshine	by T. Valko	4	631
make a positive number to negative D	by Stan Brown	3	1,389
How do I change the name on comments inserted in Excel Kit	by Bob Phillips	1	749
Averaging set of data based on the time voyager1	by voyager1	2	445
Concatenate many rows quickly [email protected]	by T. Valko	5	2,071
Reverse Index and Match Functions karl	by Max	9	766
VLookup Enhancement Alan Perkins	by Alan Beban[_2_]	3	483
Annual return formula spaceage	by msnews.microsoft.com[_4_]	11	3,379
How Do I Tie Worksheets to one Work book? Bettine S Cavanaugh	by Bettine S Cavanaugh[_2_]	2	589
Adding from several columns if ... TV	by T. Valko	1	470
Delete options for AutoFilter? Jojjjo	by Jojjjo	2	439
I need help on which function to use please !! Zee	by Zee	3	367
sumup question kingkingking	by Bob Phillips	5	541
Cell selection highlight colour Avril S	by AS	4	803
Keeping lead zeros in excel text format when saving as CSV file Richard James	by David Biddulph[_2_]	1	2,052
save excel 2007 spreadsheet as a .wk1 file? Fris	by Roger Govier[_3_]	1	1,663