Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
OfficeArticlesForumsFAQs
Excel
Word
Powerpoint
Outlook
Publisher
Money

MicrosoftArticlesForumsFAQs
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml / Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

WebArticlesForumsFAQs
JavaScript
ASP
ASP.NET
WCF

DatabasesArticlesForumsFAQs
SQL Server
Access
Oracle
MySQL
Other Databases

Non-MicrosoftArticlesForumsFAQs
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

Operating SysArticlesForumsFAQs
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsFAQs
BizTalk
Site Server
Exhange Server
IIS

Graphic DesignArticlesForumsFAQs
Macromedia Flash
Adobe PhotoShop
Expression Blend
Expression Design
Expression Web

OtherArticlesForumsFAQs
Lounge
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Product Reviews
Search Engines
Resumes

 
  
Conditional Formatting
I'm using Excel 2007 and I want to shade values in column AB if they are less than values in column W in their corresponding rows. I can do this with Conditional Formatting of course, but I would hav...
(3 replies / 30 Views)  Asked By Daron Shiflet in the Microsoft Excel forum on Friday, November 20, 2009 12:29:13 PM
value error
I am getting a value error when I try and use the expression based on the code below: expression =SumByCriteria(A1:A21,"cat",C1:C21,"furry",E1:E21,"fluffy",G1:G21,"persian",I1:I21) cod...
(1 reply / 15 Views)  Asked By michael williams in the Microsoft Excel forum on Thursday, November 19, 2009 11:30:31 PM
If all cells in the range are #N/A, how do I get the cell to be blank?
I can get the formula to ignore the cells that have #N/A, but if ALL the cells have #N/A, how do I get the formula to return a blank cell?   =SUMIF(Y17:AD17,"<>#N/A")
(2 replies / 18 Views)  Asked By Michael Evans in the Microsoft Excel forum on Thursday, November 19, 2009 10:27:02 PM
Converting Text within a cell to multiplier
Hi all,I have numbers mixed in with a letter which I would like to eliminate and replace with a certain multiplier. To give an example, I start off with the following in the cell: "100K". I'd like to...
(3 replies / 62 Views)  Asked By Tom P in the Microsoft Excel forum on Wednesday, November 18, 2009 8:21:52 PM
Using CDO in Excel
HiMany thanks for the great help with emailing from Excel.But how does Excel know CDO exists? Ron's examples work without registering cdosys.dll or setting a reference or a declaration......? Marcus
(0 replies / 20 Views)  Asked By Mark Lochore in the Microsoft Excel forum on Wednesday, November 18, 2009 2:29:15 PM
grouping and summing formula help
Column A      Column B 123                  $3 123    &nb...
(2 replies / 25 Views)  Asked By Fai Ng in the Microsoft Excel forum on Wednesday, November 18, 2009 12:18:04 PM

1234567891011121314151617181920NextLast