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

 
  
pulling daily data from one workbook to another different cells
Hi there, I have got a 3rd party stats program to pull data daily for me either to txt or xls formats. I have attached a image as I am not sure how clear my description is . Essentially i need ...
(0 replies / 20 Views)  Asked By Izzy Izzy in the Microsoft Excel forum on Saturday, November 21, 2009 12:16:35 AM
Excel Data Extraction or Mail Merge and Email in Excel
I apologize in advance if this is a question you have already answered, but I could not find anything like this on the discussions. I have a spreadhseet in Excel that has list of individuals and the...
(2 replies / 31 Views)  Asked By Ivan Woyno in the Microsoft Excel forum on Friday, November 20, 2009 5:38:56 PM
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 / 35 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...
(3 replies / 17 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 / 19 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 / 63 Views)  Asked By Tom P in the Microsoft Excel forum on Wednesday, November 18, 2009 8:21:52 PM