Excel Worksheet Functions - Page 248

Thread / Thread Starter	Last Post	Replies	Views
Match? [email protected]	by Pete_UK	5	370
inserting rows for month end dates.! via135	by via135	12	985
Protection dpal	by Dave Peterson	1	406
Help with dynamic array lookup based on a single reference cell .. SPStevo	by T. Valko	2	1,721
text to date format EMREMEV	by EMREMEV	3	439
automatic page breaks at every cell Staceyglow	by Staceyglow	0	672
Find all and Concatenate Rob	by Otto Moehrbach[_2_]	1	341
how do I look up a value and return more than one result? amiller	by T. Valko	2	759
nice shopping plaza [email protected]	by [email protected]	0	393
summing columns drakey	by Brotherharry	5	507
How do I count nonblanks in column A when I filter by column B RP3	by Pete_UK	5	695
equals merged cells TGags	by David Biddulph[_2_]	2	1,599
Extract a string from a cell MrLarrier	by David Biddulph[_2_]	3	404
COUNTA? Paul	by Paul	3	415
Need help comparing data from different URL's. marketingninja	by marketingninja	2	477
Can this be done? [email protected]	by Pete_UK	6	372
Count Unique accross mulitple columns Rob Drummond, Jr	by Rob Drummond, Jr	7	571
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	486
Custom format show < +/-500 as zero not blank AnneM	by AnneM	2	611
Compare number to range; find highest positive difference RBW	by RBW	6	749
Sumproduct excluding duplicates with added condition?? Peta	by Peta	7	1,427
Hiding Rows Graham Moore[_2_]	by JBeaucaire[_85_]	5	453
database query Excel sheet password[_2_]	by Billy Liddel	1	388
Hide #N/As with Cell Indexing/Matching Rob	by Pete_UK	5	401
Formula: How do I create a "rolling" sum in excel? Rhianne	by JBeaucaire[_85_]	7	482
copy, paste and transpose formula's into work sheets Derro	by Derro	2	1,132
Help with Solver nikos_pap	by nikos_pap	0	618
margins do not fit the page error in a shared workbook MsT4eva	by MsT4eva	0	675
Calendar, if paid on date, not count prior Jake F	by Roger Govier[_3_]	2	565
Chart Format issues LiAD	by LiAD	0	510
Sumproduct with conditions - urgent help needed JANA	by David Biddulph[_2_]	3	547
Applying a \| delimiter to separate a series of Zip codes Ed[_4_]	by Ed[_4_]	7	662
Find specific value in array of array formula DzednConfsd	by Suleman Peerzade[_2_]	2	1,418
Compare value to range, return matched value TKD	by TKD	2	663
Data Sort Steven	by Debra Dalgleish	1	455
Sumif across Multiple sheets beenlosteverywhere	by beenlosteverywhere	2	1,405
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,766
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	414
dealing with time Rhydderch	by David Biddulph[_2_]	5	1,006
Which formula(s) should I use??? Questions from cold CT	by Questions from cold CT	9	595
HELP! Search rule is case sensitive!! Don	by David Biddulph[_2_]	2	402
MTD Rating reddy	by reddy	2	484
Count nonblank cells based on another column SandyB	by Elkar	1	1,817
Linking spreadsheets and returning value to "0" if no info vtrud	by vtrud	6	625
Copy Worksheet wont copy objects. Lincoln De Kalb	by Lincoln De Kalb	7	826
Sumif?? Hope	by John[_22_]	9	649
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,410
how do i arrange excel worksheet alphabetical order novice	by JE McGimpsey	1	834
Countif using tab range DEI	by Luke M	3	588
If statement Zack	by JBeaucaire[_85_]	1	423
Unlocking Protected Cells Biff	by Gord Dibben	1	669
problem printing to HP color printer toodi4	by toodi4	0	400
Converting a Word doc to a multi-column Excel spreadsheet DD Pgh	by DD Pgh	0	728
Count Unique with criteria condition Spencer Hutton	by T. Valko	1	640
Populate a pictture when a name is selected pmnaughton	by Bernie Deitrick	3	428
Conditional format - 3 traffic lights James	by James	2	4,109
reverse conditional formatting jwbuyer	by jwbuyer	6	1,960
Changing the value of cell George	by Sheeloo[_3_]	1	433
Finding Invalid References Philip J Smith	by Dave Peterson	1	1,465
Cell Shading [email protected]	by [email protected]	3	397
Comparing two columns of data Wayne	by Gary''s Student	2	524
SUMIF with 2 criteria ruby	by Rick Rothstein	9	934
If statement jen-chi	by jen-chi	2	372
open lotus notes pdaws	by pdaws	0	622
Excel 2003 sum function Josie	by Josie	2	518
Import of informatoin and formatting in columns Patriotic Mercenary	by Patriotic Mercenary	0	482
Cross-referencing dates in Excel gantt chart Karl	by Bob Phillips[_3_]	4	1,758
hide 0 values in quick access toolbar (Excel 2007) Jaap van der Velden	by Jaap van der Velden	0	844
Sorting Columns Values question dab	by dab	2	459