Excel Worksheet Functions - Page 561

Thread / Thread Starter	Last Post	Replies	Views
Creating a spreadsheet for my teenage daughter's grades JPCleary	by Spencer101	1	614
Merge data from xcel to word jpcontrol	by ryguy7272	3	455
Is there a way to do a vlookup to look up two columns versus one? jpd	by Bob Phillips	8	769
Working with dates jpdg12	by jpdg12	0	453
SUMPRODUCT and INDIRECT JPDS	by Bob Phillips[_4_]	3	455
Cell Protection JPDS	by JPDS	0	304
Data Validation JPDS	by JPDS	5	341
SUMPRODUCT JPDS	by T. Valko	3	495
Spin Box with Dates and Lookup JPDS	by Ashish Mathur[_2_]	5	683
SUMPRODUCT and INDIRECT JPDS	by Ashish Mathur[_2_]	7	678
Autofilter JPDS	by JPDS	0	320
Simple Count of certain cells JPDS	by JPDS	7	415
Spin Box Date and Sumproduct JPDS	by JPDS	3	613
Autofill from Data Validation JPDS	by JPDS	2	403
Search Function in Discussion Groups Home JPDS	by JPDS	0	412
I want to place a "x" in a cell and give it a value of 1 (Excel) jpe	by davesexcel	1	563
Highlighting duplicates across many sheets jpeevy	by GS[_2_]	3	1,548
Why do column widths change in Excell? JPEgan	by huntnpeck	1	618
Jumping reference cell in dependent cell formula jpeterspro	by Stephen[_2_]	1	727
How can I set up a milestone report with red/green/amber alerts JPG	by JPG	5	987
Scrubbing two excel worksheets, returning unique values from one sheet jphogan	by jphogan	0	704
Round numbers up or down and always end in an 8 jpizel	by jpizel	3	526
Formula jpizzle	by Pete_UK	5	346
conditional formulas jpj1	by Ron Coderre[_2_]	2	371
Excel 2003 view formula within pivot table jpjejmcc	by David McRitchie	3	890
can a dde link populate excel creating new rows automatically? jpk3535	by jpk3535	0	617
linking worksheets [email protected]	by ShaneDevenshire	4	506
finding # of occurrences of information between two dates JPLong	by Luke M	3	1,035
Hey Excelbanters!! jpmortician	by jpmortician	0	282
count percentages jpmurray22	by Wondering[_2_]	3	320
Removing a formula from a cell once the result is in the cell jpolzner	by David McRitchie	2	579
Automatically saving value even though the formula changes with th jpolzner	by Joel	1	337
Color Excel Spreasheet print previews in black/white. Reason? Jpope	by Nokose451	1	1,105
return a blank cell jpotts8117	by Anne Troy	5	697
Concatenate numbers and text while holding a custom number format. jpowell111	by Ashish Mathur[_2_]	9	2,528
Average Time Not Calculating JPP	by Ron Rosenfeld[_2_]	15	1,726
Summing Results Based On A Specific Date JPP	by Spencer101	5	869
Pulling Multiple Vales From Multiple Cells & Displaying them in one cell. JPP	by Gord Dibben[_2_]	4	946
Is there some kind of memory reference limit in excel? JPP	by joeu2004[_2_]	4	762
Using a CONCATENATE function with an IF function. JPP	by JPP	3	890
alphanumeric range [email protected]	by [email protected]	6	468
cell background cover [email protected]	by [email protected]	2	313
Copy a formula pattern JPreeshl	by Luke M[_4_]	1	561
How do you add one date to another? I type in 1/31/05 in A1 and I. JPreeshl	by CLR	2	415
How to add the 10 smallest numbers out of a range of 20 numbers. JPreeshl	by Martin P	3	806
lookup when there is multiple same numbers JPreeshl	by T. Valko	1	460
What does the "&" do in a function? JPreeshl	by Ragdyer	5	378
CONDITIONAL FORMATTING BASED ON RESULTS IN A CELL jpreman	by jpreman	3	865
ROWS TO REPEAT ON EACH PAGE jpreman	by Gord Dibben	4	775
Rows to repeat on each page jpreman	by jpreman	6	792
Negative number format jpriddy	by Luke M	5	427
Vlookup or If statement Help JPriest	by NaturalLogZero	7	591
Macro for changing text to Proper Case JPriest	by Gary L Brown	3	1,333
Deleting rows based on a cell value JPriest	by Ron de Bruin	3	828
vlookup help JPriest	by Domenic	7	391
Project Management Schedule JPriest	by goober	1	584
Conditional Formatting JPS	by David Biddulph[_2_]	7	335
Character Search a cell JPS	by JPS	8	469
Exterenal link JPS	by JPS	2	348
Retain font/cell color on lookup/copy JPS	by JE McGimpsey	3	2,256
Help with Search Formula JPS	by Ron Rosenfeld	2	370
Adding to an existing formula JPS	by Gary''s Student	2	1,670
Concatenation JPS	by T. Valko	3	486
Split Cell using If or other function JPS	by JPS	0	519
Is the solution Vlookup? JPS	by Pete_UK	1	295
Formula to change cell color JPS	by Don Guillett	5	981
Show a tick mark for a positive test result JPS	by bosco_yip[_2_]	9	681
Date Correction JPS	by JPS	4	383
Rev number JPS	by Gary''s Student	3	390
Shading Rows With IF Statements? JPS	by Gord Dibben	5	417
Complex Sumif JPS	by Ashish Mathur[_2_]	3	476
Count if with multiple column criteria JPS	by Max	7	645
Date Calculation in Conditional Formatting JPS	by David Biddulph[_2_]	2	591
Pivot table problem [email protected]	by Debra Dalgleish	1	360
drop down list and row extraction jpsprack	by jpsprack	3	367