The discussions

Adding data from one column using another


Hello, I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together t...

2 replies Last reply on 27 Aug 2009 by

Countif formula


Hello, I have one excel file in that Colom "B" has the "pending or Closed" Status and Colom "C" has "Sevirity 1, Sevirity 2 and Sevirity 3" I wa...

2 replies Last reply on 21 Aug 2009 by

To retrieve the particular cell value


Hello, Can you please provide me with a macro VBA code In "Sheet1" i have values in 'A' and 'B' columns. Sheet1: A B 1 Name ...

5 replies Last reply on 19 Aug 2009 by

Clear cell contents based on color


Hello, I have a range of cells (E7:AI18) which I want to delete the contents of, if the color is white, gray-25% or gray-80%. So if cell E7 has ...

7 replies Last reply on 17 Aug 2009 by

Vlookup - find value 3,4,5 etc..


Hello, I can use a vlookup to find the first and second value using True or False after the formula. However i would like to able to find more valu...

3 replies Last reply on 30 Jul 2009 by

Hiding a cell if value equals x


Hello, I want to do the following in EXCEL. I have a formula which works out the cost of one item at $35 plus adds $3.8 per item thereafter. Tf ...

4 replies Last reply on 22 Jul 2009 by

Vba underscore trouble


Hello, I wrote a simple VBA code which is pretty long, so I want to use a underscore to continue on the next line. Here is an example of the cod...

4 replies Last reply on 21 Jul 2009 by

Access database restarts computer


Hello, I have an Access 2003 split database that I have been working on for some time now and today when I go to open it my computer does a restart, ...

Last reply on 19 Jul 2009 by

“false” result not working on if formula


Hello, This is the formula: =IF(Z2>=TIME(11|59|0)|"Afternoon"|"Morning") The contents in cell Z2 is 10:31:30. I was hoping my formula result w...

4 replies Last reply on 17 Jul 2009 by

Vba: error 9; subscript is out of reach


Hello, Depending on the value of a specific cell (sheet "gegevensblad" cell L10), I would like to hide 1 out of 2 sheets (Either Overzichtsgrafieke...

4 replies Last reply on 16 Jul 2009 by

List month from any given year in excel


Hello, i 0got a spreadsheet (data) as below date status 1-jan-1975 approved 1-feb-1980 suspended 5-mar-1985 rejected 10...

6 replies Last reply on 13 Jul 2009 by

Activating macro


Hello, I have made a calender which I want to prepare for next year with the press of a button. Here is the file:

3 replies Last reply on 9 Jul 2009 by

Require help in excel


Hello, Pls help me by suggesting any formula or function for selecting two minimum values from range of numbers in excel spreadsheet. For exampl...

2 replies Last reply on 8 Jul 2009 by

Trouble activating macro


Hello, I've got a macro which runs on 12 worksheets. When the result of a formula changes I want the macro to do his job. What I do now is manu...

3 replies Last reply on 6 Jul 2009 by

Conditional formating for entire rows


Hello, First I would like to thank Aquarelle for her kind words, regarding asking questions. I'm working on a calender where each day has a diff...

9 replies Last reply on 30 Jun 2009 by

Install ms office 2003


Hello, My name Am from Cambodia. I'm studying the Information of Technology of year 2 at a private university in Siem Reap-Angkor. I wonder"how can I...

1 reply Last reply on 29 Jun 2009 by

Excel worksheet help


Hello, So i've tried like hell to figure this out but have no programming skills at all. I have basic excel experience most of it self taugh or what...

1 reply Last reply on 26 Jun 2009 by

Excel 2007 timeline, help please


Hello, timeline, help please im looking for a formula to fill in a cell with either s,p,v or h depending on data taken from sheet 2. the data...

1 reply Last reply on 22 Jun 2009 by

Possible to extract partial data in excel?


Hello, I have an Excel spreadsheet that contains around 1500 html links. All the addresses start out common... i.e. W...

2 replies Last reply on 20 Jun 2009 by

Excel formular problem


Hello, =IF(B2=1,"Entertainment","") I have this formular which when i type a value into one colume it will display text in another and the end o...

2 replies Last reply on 19 Jun 2009 by
mubashir aziz

Macro to find last blank cell in column


Hello, Can anyone help me with this please? I want a macro to run in Excel to do the following: 1. Go to a column and working from the top down fin...

3 replies Last reply on 13 Jun 2009 by

Excel total range of values


Hello, I'm trying to get a range of values totalled. I have one set of columns, lets say column A1 to A200, ranging from -30 up to 1000 and another ...

5 replies Last reply on 5 Jun 2009 by
mubashir aziz

Calculate the sum of rows using macro


Hello, I need some help with the folowing problem. I have a table with changing length of rows and columns. I need to calculate the sums of the rows ...

Last reply on 3 Jun 2009 by

My replies are not appearing


Hello, I"m giving replies in Office Software Section but my replies are not appearing. May be some problem in Site???????? -- Never ashamed to...

1 reply Last reply on 28 May 2009 by

Above cell


I get a large database every week in which I have to insert a row every row different than the one above, it is a tedeous task that takes me hours, I'...

6 replies Last reply on 23 Apr 2009 by

Excel column sort


Hello, i have a list of numbers/letters titles written like: 1KFLS921 there are around 2000 of these listed down column A. i have the same l...

2 replies Last reply on 20 Apr 2009 by

Microsoft office ?


Hello, Does Microsoft Office work on Windows Vista ?

3 replies Last reply on 17 Apr 2009 by

Excel - reset / replace seconds to zero


Hello, i have an Excel 2007 file which has in sheet1 the time people enter to the system with the format ex. 11:55:31 AM and i need to reset all the ...

2 replies Last reply on 16 Apr 2009 by

Send value of cell to target


Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value chang...

16 replies Last reply on 26 Mar 2009 by

Excell macro help required


Hello, I have 3 Excell Workbooks, i need to create a master sheet, but when ever i update the master sheet the data updated shouls reflect in all t...

2 replies Last reply on 24 Mar 2009 by

Need help in excel macro


Hello Ivan, Ive' been reading a lot of your answers and i'm quite facinated of your skill. I need to create a macro for one of my project and it i...

6 replies Last reply on 20 Mar 2009 by

Excel help


Hello, Ok am not that experienced with excel, so if any one can helo would be great. I have a huge spreadsheet and i am constantly updating it. ...

5 replies Last reply on 17 Mar 2009 by

Having excel if formulas print text and calc


Hello, I am trying to get Excel IF formulas to print text and calculation based on true/false. Such as, if I have some dates, and I don't need to s...

2 replies Last reply on 6 Mar 2009 by

Need for dfd


Hello, i am devendra mishra i am working on project hospital management i am not getting the dfd(data flow diagram) of the project so pl...

1 reply Last reply on 2 Mar 2009 by

What is my email server address?


Hello, just trying to set up outlook express for the first time. i bought an iphone and the only way (im told) to save / sync my contacts information...

2 replies Last reply on 22 Feb 2009 by

Ms-word asks for converter


Hello, I have some Ms-word files of 2003..But every time upload the system with Vista i cannot read my saved word continusely asks f...

1 reply Last reply on 18 Feb 2009 by

Count and summarise records in excel 2003


Hello, Sorry to bother you but I have a minor problem with a spreadsheet and I don't know how to resolve the issue or whether it is possible u...

2 replies Last reply on 17 Feb 2009 by

Create msg/popup to notify in excel vba


Hello, I need a Excel VB script to notify/popup a message when the number of the letter U on a calendar exceeds 6, 8, 12 etc. It will have to check...

4 replies Last reply on 11 Feb 2009 by
Siebel SME

Converting date format in excel sheet


Hello, I have a cell which contains date in the format dd/mm/yyyy, but i need to convert to mm/dd/yyyy in excel how can i do this?

1 reply Last reply on 10 Feb 2009 by

Help to find


Hello, can any one tell me how to find my outlook express on my computer so i can get a email thats in it.thank.

6 replies Last reply on 9 Feb 2009 by

Excel 2003 please help with concat dilemma


Hello, I need one column to show the following text: prxyz,(Data1 here),0699,ABCD(Data2 here),xxx Data1 is in Column A and Data2 is in Column B....

2 replies Last reply on 8 Feb 2009 by

Excel x-reference


Hi there friends, I have a excel spread sheet that i am using to keep track of sales. What i need is a formula or function that will check a lis...

3 replies Last reply on 30 Jan 2009 by

Count number of cells matching to criteria


Hello, I have two column lists (one value in each cell) the first { 1 2 3 1 2 2 2 1 1 1 } and the second {A B C C C B B A A C } and I am attempting...

1 reply Last reply on 16 Jan 2009 by

Offset property


Hello, I am trying to create a Macro that sizes itself up using the adjacent column and the paste it. Simply to use it for a Pivot table for exampl...

1 reply Last reply on 26 Dec 2008 by

If then and statement help


Hello Everyone, I am trying to make a formula work and I'm having a headache from it. Here it is: =IF(AND($B$2

33 replies Last reply on 15 Dec 2008 by

Windows file-explorer working slowly


Hi to all! I've had several problems with my Windows Explorer. The opening or saving a file through several software is not working fast or sometime...

3 replies Last reply on 7 Nov 2008 by

Product code


Hello, i am trying 2 activate my word settings. my comp kleeps asking me for a product key, when i enter the from underneath my comp it keeps sayin...

1 reply Last reply on 6 Nov 2008 by

Burrotech office mail and outlook 2007


Hello all, I believe this is what caused my problem. I recently installed Burrotech Office Mail, a stand-alone email server, on my USB drive to do s...

1 reply Last reply on 28 Oct 2008 by

Can't make two loops work


Hello, here's my problem. I've got codes in column D that may show up more than once. On column A I've got a list of all available codes, and in colum...

2 replies Last reply on 1 Oct 2008 by

Copy field to end of another field


Hello, I would need a macro that would help me copy caracters in colomn A to the end of what is in colomn B. Can anyone help me please? Ex: ...

2 replies Last reply on 1 Oct 2008 by
Results 2551 - 2600 out of a total of 2,608