General

take name from the spreadsheet cell and get address from outlook
hi team Can some one advice wether using a as refernce to a cell which contain name of the person, can pull out the address from MS Outlook. Thanks Jithesh ... 10 May 2010 12:06

Conditional Formatting and Formulas
Hi. I want to set up some conditional formatting (in Excel 2003). I want to turn certain cells either red (if any text appears) or green (if the cell appears blank). However, the cells have formulas in them to display information if it is available in other cells. I cannot, however, make the conditional f... 10 May 2010 04:27

Lookup reference help
Hi Folks, I have a sheet, where the contents of cell A1 is a result of other criteria being met. For the purpose of this example, the result in A1 is "Oral Health" In cells B1 thru to W1 are column headers, one of which will match the result in A1 (Oral Health is E1, Population Health is K1, etc). Under each... 10 May 2010 01:14

table lookup
Let's say i have a table. I can use MATCH() to know that I want to look in column 13 for a certain value. Now I just need to figure out what row a certain value is. For instance: 1810. Somewhere in Column 13 is the value "1810"....I would like to find out what ROW it's in. How can I tell Excel to look in Colu... 9 May 2010 16:31

excel separation
Question Here is a problem I have: 123456789 134567890 135678901 1456789012 157890123 this group of numbers is in my Sheet and each line is in a row by itself and they are in 9 different columns. for brevity I just used 9 numbers for each line. I need to know if there is a way to auto insert a row between e... 8 May 2010 22:11

FIND ERROR PROBLEM
hi, I have pieces of formula's that might help to figure out how to find where an error is located (by column & row). thanks in advance. examples include: a - find exact character "X" row number (friendly name in hyperlink) b - hyperlink to that row.. column c - formula to detect error in a range d - item tr... 8 May 2010 13:25

date
Hi, I have a table if several columns. One of them is Invoice Date. I am using Pivot Table to compile the data. I am trying to find out how many invoices were issued in a particular month. First I convert the mm/dd/yy into mm/yy, but the Pivot Table gave me the result as mm/dd/yy. Then I copied the mm/yy ... 8 May 2010 14:31

compare 2 columns and select the lowest
Hi I have simple question I have 2 coumns A and B A1 is text and B1 is numbers and so on.. depending of B columns numbers , i want colums C to show alway lowest numbers on top, but also text like if A1,B1 is Mike 29 then A2,B2 is Josh 34, then column C shows Mike 29 but on top, not as a secon row.. ... 8 May 2010 14:31

I would like to extract email addresses from an Excel document
I have a spreadsheet of names and addresses. I would like to extract the email addresses to put in an email to send out to all. Can this be done ... 8 May 2010 05:48

Update - Microsoft Responds to the Evolution of Community
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As you may know, newsgroups have existed for many years now; however, the traffic in the Microsoft newsgroups has been steadily decreasing for the past sever... 10 May 2010 15:27