Any one please help me.......? After inserting row how can I go back to the row I selected for inserting, instead for going to A1 Sub...

Hello, I have a simple table: header row is clients, 1st column are employees. Each employee is assigned a primary client and 1 or more secondary clients....

Any body pls help me.....? Sheet1 A B C Name Rank Company Romeo Painter PWD Patrick Carpenter ABC Sheet2

I have list of Names for e.g. Antony, John - 30022275 David, Joan - 30022277 When I used "Text to Columns" function I am able to saparate Names in different...

Hi I've searched the group and found 'Validation and filters with sub scrolls' but didn't see a solution. Using Excel 2003 I have a column with a List...

Isn't there an 'Excel Option' that allows you to enter value (Free Text... IE N/A) when you get a #/div error? I know that pivot tables have that option, but...

I have a single column of data that is sparse, in that many of the entries are blank. Since this data is imported from another source, I want to operate on...

I have been tasked with creating an inventory of all my wireless devices. I have a master started, but I get the monthly data on a spreadsheet from multiple...

I have a spreadsheet I am trying to build that has 3 tabs. The first are my employees and thier statistics by week. What I want is on my second tab to be...

How can I use as a criteria dates between a start and end dates in sumif function. I wand to sum B cells if dates in A are between 1/1/2009 and 31/3/2009.

I have a list of thousands of employees with a security clearance number between 1 to 20. I now need to substitute that number with a position or title. ...

I'm trying to use the same random number twice in the same cell formula: I entered "=TEXT(RANDBETWEEN(1,255),"000 ")&CHAR(RANDBETWEEN(1,255))" to display both...

I have an IF Statement to give me a number based on sum of another cell. It looks like this: =IF($B$54000000, "0",...

I entered two conditional formats into cell A1. I want the formats to apply to every cell in column A. I selected cell A1, clicked on format painter, and...

I want to use a IF fuction for greater than or less than IF A1 is greater than 3000, but less than 4000, than I want C1 to be a "X" how do i do this Thanks

I have a range of cells that hold 4 possible entries and another range that holds 3 possible entries. Is it possible to COUNTIF/SUMPRODUCT if you for more...

+Hi- I have set up a rank using a standard ranking formula. I have a total of 156 items that I am ranking. The values of the rank range from -660 to 756. ...

In a worksheet that I inherited, I will select a cell and it highlights it as usually. When I start to type, the cell above is then 'covered' and I cant see...

This formula is working fine, except that my data is imported from MS Access and Excel seems not to recognize the correct data type. I have two data sets...

I have to import hundreds of .csv files into Excel 2003 spreadsheets. The MSN MoneyCentral files in the My Data Sources file are of no use to me and are in...