Excel Worksheet Functions - Page 248

Thread / Thread Starter	Last Post	Replies	Views
Match? [email protected]	by Pete_UK	5	372
inserting rows for month end dates.! via135	by via135	12	993
Protection dpal	by Dave Peterson	1	408
Help with dynamic array lookup based on a single reference cell .. SPStevo	by T. Valko	2	1,731
text to date format EMREMEV	by EMREMEV	3	450
automatic page breaks at every cell Staceyglow	by Staceyglow	0	677
Find all and Concatenate Rob	by Otto Moehrbach[_2_]	1	351
how do I look up a value and return more than one result? amiller	by T. Valko	2	762
nice shopping plaza [email protected]	by [email protected]	0	393
summing columns drakey	by Brotherharry	5	508
How do I count nonblanks in column A when I filter by column B RP3	by Pete_UK	5	704
equals merged cells TGags	by David Biddulph[_2_]	2	1,600
Extract a string from a cell MrLarrier	by David Biddulph[_2_]	3	414
COUNTA? Paul	by Paul	3	418
Need help comparing data from different URL's. marketingninja	by marketingninja	2	477
Can this be done? [email protected]	by Pete_UK	6	375
Count Unique accross mulitple columns Rob Drummond, Jr	by Rob Drummond, Jr	7	581
Divide by zero error Chris	by Chris	3	1,335
using a conditional suffix in text function format syntax=text(value,format_text) Brotherharry	by JE McGimpsey	1	1,861
Row extractor datamanipulator	by datamanipulator	4	492
Custom format show < +/-500 as zero not blank AnneM	by AnneM	2	612
Compare number to range; find highest positive difference RBW	by RBW	6	750
Sumproduct excluding duplicates with added condition?? Peta	by Peta	7	1,432
Hiding Rows Graham Moore[_2_]	by JBeaucaire[_85_]	5	460
database query Excel sheet password[_2_]	by Billy Liddel	1	398
Hide #N/As with Cell Indexing/Matching Rob	by Pete_UK	5	411
Formula: How do I create a "rolling" sum in excel? Rhianne	by JBeaucaire[_85_]	7	492
copy, paste and transpose formula's into work sheets Derro	by Derro	2	1,142
Help with Solver nikos_pap	by nikos_pap	0	624
margins do not fit the page error in a shared workbook MsT4eva	by MsT4eva	0	676
Calendar, if paid on date, not count prior Jake F	by Roger Govier[_3_]	2	576
Chart Format issues LiAD	by LiAD	0	520
Sumproduct with conditions - urgent help needed JANA	by David Biddulph[_2_]	3	550
Applying a \| delimiter to separate a series of Zip codes Ed[_4_]	by Ed[_4_]	7	674
Find specific value in array of array formula DzednConfsd	by Suleman Peerzade[_2_]	2	1,419
Compare value to range, return matched value TKD	by TKD	2	669
Data Sort Steven	by Debra Dalgleish	1	465
Sumif across Multiple sheets beenlosteverywhere	by beenlosteverywhere	2	1,416
Select a variable range Bluecat	by Bluecat	7	704
Link Cells drnlds	by Pete_UK	5	507
Compare data in 2 workbooks and highlight differences in red Sherry	by Gord Dibben	4	1,771
Count cells w/values in column if the data in column a matches cri mdcgpw	by mdcgpw	4	1,450
Pivot Table grouping fields by Dept Terri B	by Debra Dalgleish	1	424
dealing with time Rhydderch	by David Biddulph[_2_]	5	1,009
Which formula(s) should I use??? Questions from cold CT	by Questions from cold CT	9	600
HELP! Search rule is case sensitive!! Don	by David Biddulph[_2_]	2	402
MTD Rating reddy	by reddy	2	485
Count nonblank cells based on another column SandyB	by Elkar	1	1,823
Linking spreadsheets and returning value to "0" if no info vtrud	by vtrud	6	634
Copy Worksheet wont copy objects. Lincoln De Kalb	by Lincoln De Kalb	7	827
Sumif?? Hope	by John[_22_]	9	659
Auto Update worksheet references as new worksheets are added Rick	by Gord Dibben	1	1,504
FORMULA ERRORS CAUSED BY SPACEBAR Gator Girl	by Gator Girl	12	1,411
how do i arrange excel worksheet alphabetical order novice	by JE McGimpsey	1	835
Countif using tab range DEI	by Luke M	3	593
If statement Zack	by JBeaucaire[_85_]	1	434
Unlocking Protected Cells Biff	by Gord Dibben	1	669
problem printing to HP color printer toodi4	by toodi4	0	401
Converting a Word doc to a multi-column Excel spreadsheet DD Pgh	by DD Pgh	0	734
Count Unique with criteria condition Spencer Hutton	by T. Valko	1	641
Populate a pictture when a name is selected pmnaughton	by Bernie Deitrick	3	433
Conditional format - 3 traffic lights James	by James	2	4,119
reverse conditional formatting jwbuyer	by jwbuyer	6	1,967
Changing the value of cell George	by Sheeloo[_3_]	1	440
Finding Invalid References Philip J Smith	by Dave Peterson	1	1,476
Cell Shading [email protected]	by [email protected]	3	400
Comparing two columns of data Wayne	by Gary''s Student	2	535
SUMIF with 2 criteria ruby	by Rick Rothstein	9	937
If statement jen-chi	by jen-chi	2	382
open lotus notes pdaws	by pdaws	0	623
Excel 2003 sum function Josie	by Josie	2	518
Import of informatoin and formatting in columns Patriotic Mercenary	by Patriotic Mercenary	0	492
Cross-referencing dates in Excel gantt chart Karl	by Bob Phillips[_3_]	4	1,767
hide 0 values in quick access toolbar (Excel 2007) Jaap van der Velden	by Jaap van der Velden	0	854
Sorting Columns Values question dab	by dab	2	469