Excel Worksheet Functions - Page 248

Thread / Thread Starter	Last Post	Replies	Views
Match? [email protected]	by Pete_UK	5	364
inserting rows for month end dates.! via135	by via135	12	969
Protection dpal	by Dave Peterson	1	388
Help with dynamic array lookup based on a single reference cell .. SPStevo	by T. Valko	2	1,706
text to date format EMREMEV	by EMREMEV	3	430
automatic page breaks at every cell Staceyglow	by Staceyglow	0	654
Find all and Concatenate Rob	by Otto Moehrbach[_2_]	1	337
how do I look up a value and return more than one result? amiller	by T. Valko	2	753
nice shopping plaza [email protected]	by [email protected]	0	382
summing columns drakey	by Brotherharry	5	487
How do I count nonblanks in column A when I filter by column B RP3	by Pete_UK	5	617
equals merged cells TGags	by David Biddulph[_2_]	2	1,594
Extract a string from a cell MrLarrier	by David Biddulph[_2_]	3	388
COUNTA? Paul	by Paul	3	401
Need help comparing data from different URL's. marketingninja	by marketingninja	2	457
Can this be done? [email protected]	by Pete_UK	6	366
Count Unique accross mulitple columns Rob Drummond, Jr	by Rob Drummond, Jr	7	564
Divide by zero error Chris	by Chris	3	1,307
using a conditional suffix in text function format syntax=text(value,format_text) Brotherharry	by JE McGimpsey	1	1,843
Row extractor datamanipulator	by datamanipulator	4	480
Custom format show < +/-500 as zero not blank AnneM	by AnneM	2	601
Compare number to range; find highest positive difference RBW	by RBW	6	738
Sumproduct excluding duplicates with added condition?? Peta	by Peta	7	1,417
Hiding Rows Graham Moore[_2_]	by JBeaucaire[_85_]	5	446
database query Excel sheet password[_2_]	by Billy Liddel	1	384
Hide #N/As with Cell Indexing/Matching Rob	by Pete_UK	5	392
Formula: How do I create a "rolling" sum in excel? Rhianne	by JBeaucaire[_85_]	7	468
copy, paste and transpose formula's into work sheets Derro	by Derro	2	1,091
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	655
Calendar, if paid on date, not count prior Jake F	by Roger Govier[_3_]	2	554
Chart Format issues LiAD	by LiAD	0	497
Sumproduct with conditions - urgent help needed JANA	by David Biddulph[_2_]	3	532
Applying a \| delimiter to separate a series of Zip codes Ed[_4_]	by Ed[_4_]	7	647
Find specific value in array of array formula DzednConfsd	by Suleman Peerzade[_2_]	2	1,387
Compare value to range, return matched value TKD	by TKD	2	637
Data Sort Steven	by Debra Dalgleish	1	448
Sumif across Multiple sheets beenlosteverywhere	by beenlosteverywhere	2	1,384
Select a variable range Bluecat	by Bluecat	7	678
Link Cells drnlds	by Pete_UK	5	499
Compare data in 2 workbooks and highlight differences in red Sherry	by Gord Dibben	4	1,749
Count cells w/values in column if the data in column a matches cri mdcgpw	by mdcgpw	4	1,415
Pivot Table grouping fields by Dept Terri B	by Debra Dalgleish	1	401
dealing with time Rhydderch	by David Biddulph[_2_]	5	993
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	386
MTD Rating reddy	by reddy	2	469
Count nonblank cells based on another column SandyB	by Elkar	1	1,805
Linking spreadsheets and returning value to "0" if no info vtrud	by vtrud	6	565
Copy Worksheet wont copy objects. Lincoln De Kalb	by Lincoln De Kalb	7	805
Sumif?? Hope	by John[_22_]	9	638
Auto Update worksheet references as new worksheets are added Rick	by Gord Dibben	1	1,487
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	820
Countif using tab range DEI	by Luke M	3	573
If statement Zack	by JBeaucaire[_85_]	1	410
Unlocking Protected Cells Biff	by Gord Dibben	1	652
problem printing to HP color printer toodi4	by toodi4	0	392
Converting a Word doc to a multi-column Excel spreadsheet DD Pgh	by DD Pgh	0	710
Count Unique with criteria condition Spencer Hutton	by T. Valko	1	624
Populate a pictture when a name is selected pmnaughton	by Bernie Deitrick	3	416
Conditional format - 3 traffic lights James	by James	2	4,036
reverse conditional formatting jwbuyer	by jwbuyer	6	1,927
Changing the value of cell George	by Sheeloo[_3_]	1	422
Finding Invalid References Philip J Smith	by Dave Peterson	1	1,438
Cell Shading [email protected]	by [email protected]	3	393
Comparing two columns of data Wayne	by Gary''s Student	2	510
SUMIF with 2 criteria ruby	by Rick Rothstein	9	920
If statement jen-chi	by jen-chi	2	367
open lotus notes pdaws	by pdaws	0	600
Excel 2003 sum function Josie	by Josie	2	483
Import of informatoin and formatting in columns Patriotic Mercenary	by Patriotic Mercenary	0	473
Cross-referencing dates in Excel gantt chart Karl	by Bob Phillips[_3_]	4	1,701
hide 0 values in quick access toolbar (Excel 2007) Jaap van der Velden	by Jaap van der Velden	0	825
Sorting Columns Values question dab	by dab	2	452