Excel Worksheet Functions - Page 248

Thread / Thread Starter	Last Post	Replies	Views
Match? [email protected]	by Pete_UK	5	366
inserting rows for month end dates.! via135	by via135	12	970
Protection dpal	by Dave Peterson	1	389
Help with dynamic array lookup based on a single reference cell .. SPStevo	by T. Valko	2	1,710
text to date format EMREMEV	by EMREMEV	3	431
automatic page breaks at every cell Staceyglow	by Staceyglow	0	658
Find all and Concatenate Rob	by Otto Moehrbach[_2_]	1	338
how do I look up a value and return more than one result? amiller	by T. Valko	2	755
nice shopping plaza [email protected]	by [email protected]	0	384
summing columns drakey	by Brotherharry	5	491
How do I count nonblanks in column A when I filter by column B RP3	by Pete_UK	5	645
equals merged cells TGags	by David Biddulph[_2_]	2	1,596
Extract a string from a cell MrLarrier	by David Biddulph[_2_]	3	390
COUNTA? Paul	by Paul	3	402
Need help comparing data from different URL's. marketingninja	by marketingninja	2	465
Can this be done? [email protected]	by Pete_UK	6	366
Count Unique accross mulitple columns Rob Drummond, Jr	by Rob Drummond, Jr	7	566
Divide by zero error Chris	by Chris	3	1,308
using a conditional suffix in text function format syntax=text(value,format_text) Brotherharry	by JE McGimpsey	1	1,846
Row extractor datamanipulator	by datamanipulator	4	481
Custom format show < +/-500 as zero not blank AnneM	by AnneM	2	605
Compare number to range; find highest positive difference RBW	by RBW	6	743
Sumproduct excluding duplicates with added condition?? Peta	by Peta	7	1,418
Hiding Rows Graham Moore[_2_]	by JBeaucaire[_85_]	5	447
database query Excel sheet password[_2_]	by Billy Liddel	1	385
Hide #N/As with Cell Indexing/Matching Rob	by Pete_UK	5	395
Formula: How do I create a "rolling" sum in excel? Rhianne	by JBeaucaire[_85_]	7	470
copy, paste and transpose formula's into work sheets Derro	by Derro	2	1,092
Help with Solver nikos_pap	by nikos_pap	0	559
margins do not fit the page error in a shared workbook MsT4eva	by MsT4eva	0	657
Calendar, if paid on date, not count prior Jake F	by Roger Govier[_3_]	2	556
Chart Format issues LiAD	by LiAD	0	502
Sumproduct with conditions - urgent help needed JANA	by David Biddulph[_2_]	3	534
Applying a \| delimiter to separate a series of Zip codes Ed[_4_]	by Ed[_4_]	7	648
Find specific value in array of array formula DzednConfsd	by Suleman Peerzade[_2_]	2	1,388
Compare value to range, return matched value TKD	by TKD	2	638
Data Sort Steven	by Debra Dalgleish	1	451
Sumif across Multiple sheets beenlosteverywhere	by beenlosteverywhere	2	1,384
Select a variable range Bluecat	by Bluecat	7	683
Link Cells drnlds	by Pete_UK	5	499
Compare data in 2 workbooks and highlight differences in red Sherry	by Gord Dibben	4	1,752
Count cells w/values in column if the data in column a matches cri mdcgpw	by mdcgpw	4	1,420
Pivot Table grouping fields by Dept Terri B	by Debra Dalgleish	1	402
dealing with time Rhydderch	by David Biddulph[_2_]	5	1,000
Which formula(s) should I use??? Questions from cold CT	by Questions from cold CT	9	587
HELP! Search rule is case sensitive!! Don	by David Biddulph[_2_]	2	393
MTD Rating reddy	by reddy	2	474
Count nonblank cells based on another column SandyB	by Elkar	1	1,807
Linking spreadsheets and returning value to "0" if no info vtrud	by vtrud	6	599
Copy Worksheet wont copy objects. Lincoln De Kalb	by Lincoln De Kalb	7	808
Sumif?? Hope	by John[_22_]	9	639
Auto Update worksheet references as new worksheets are added Rick	by Gord Dibben	1	1,490
FORMULA ERRORS CAUSED BY SPACEBAR Gator Girl	by Gator Girl	12	1,394
how do i arrange excel worksheet alphabetical order novice	by JE McGimpsey	1	822
Countif using tab range DEI	by Luke M	3	574
If statement Zack	by JBeaucaire[_85_]	1	412
Unlocking Protected Cells Biff	by Gord Dibben	1	655
problem printing to HP color printer toodi4	by toodi4	0	394
Converting a Word doc to a multi-column Excel spreadsheet DD Pgh	by DD Pgh	0	716
Count Unique with criteria condition Spencer Hutton	by T. Valko	1	626
Populate a pictture when a name is selected pmnaughton	by Bernie Deitrick	3	421
Conditional format - 3 traffic lights James	by James	2	4,046
reverse conditional formatting jwbuyer	by jwbuyer	6	1,929
Changing the value of cell George	by Sheeloo[_3_]	1	424
Finding Invalid References Philip J Smith	by Dave Peterson	1	1,445
Cell Shading [email protected]	by [email protected]	3	393
Comparing two columns of data Wayne	by Gary''s Student	2	514
SUMIF with 2 criteria ruby	by Rick Rothstein	9	921
If statement jen-chi	by jen-chi	2	368
open lotus notes pdaws	by pdaws	0	602
Excel 2003 sum function Josie	by Josie	2	504
Import of informatoin and formatting in columns Patriotic Mercenary	by Patriotic Mercenary	0	475
Cross-referencing dates in Excel gantt chart Karl	by Bob Phillips[_3_]	4	1,736
hide 0 values in quick access toolbar (Excel 2007) Jaap van der Velden	by Jaap van der Velden	0	827
Sorting Columns Values question dab	by dab	2	453