The discussions

Adding data from one column using another

 Solved

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
saltod

Countif formula

 Solved

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
Vijay

To retrieve the particular cell value

 Solved

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
kaiyasit

Clear cell contents based on color

 Solved

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
Trowa

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

 Solved

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
venkat1926

Hiding a cell if value equals x

 Solved

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
Aimee

Vba underscore trouble

 Solved

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
Trowa

Access database restarts computer

 Solved/Closed

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
dbdesperate

“false” result not working on if formula

 Solved

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
aquarelle

Vba: error 9; subscript is out of reach

 Solved

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
Dean

List month from any given year in excel

 Solved

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
ani

Activating macro

 Solved

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

3 replies Last reply on 9 Jul 2009 by
Trowa

Require help in excel

 Solved

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
Anakin

Trouble activating macro

 Solved

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
Trowa

Conditional formating for entire rows

 Solved

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
Trowa

Install ms office 2003

 Solved

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
aquarelle

Excel worksheet help

 Solved

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
venkat1926

Excel 2007 timeline, help please

 Solved

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
Orkt

Possible to extract partial data in excel?

 Solved

Hello, I have an Excel spreadsheet that contains around 1500 html links. All the addresses start out common... i.e. http://www.frogs.com/. W...

2 replies Last reply on 20 Jun 2009 by
DarkDMize

Excel formular problem

 Solved

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

 Solved

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
LesE

Excel total range of values

 Solved

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

 Solved/Closed

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
Manhamanha

My replies are not appearing

 Solved

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
afterhere

Above cell

 Solved

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
motorsito

Excel column sort

 Solved

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
ZaQ

Microsoft office ?

 Solved

Hello, Does Microsoft Office work on Windows Vista ?

3 replies Last reply on 17 Apr 2009 by
anonymous

Excel - reset / replace seconds to zero

 Solved

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
safy_al_nya

Send value of cell to target

 Solved

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
Paul

Excell macro help required

 Solved

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
sarbel.vilo

Need help in excel macro

 Solved

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
Jnani

Excel help

 Solved

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
Amber1984

Having excel if formulas print text and calc

 Solved

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
martinwuff

Need for dfd

 Solved

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
worldhelp

What is my email server address?

 Solved

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
mandymoo

Ms-word asks for converter

 Solved

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

1 reply Last reply on 18 Feb 2009 by
xpcman

Count and summarise records in excel 2003

 Solved

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
GRA

Create msg/popup to notify in excel vba

 Solved

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

 Solved

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
daywish

Help to find

 Solved

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
delpha

Excel 2003 please help with concat dilemma

 Solved

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
excelgamine

Excel x-reference

 Solved

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
sam

Count number of cells matching to criteria

 Solved

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
aquarelle

Offset property

 Solved

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
Mithun

If then and statement help

 Solved

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
ralphl

Windows file-explorer working slowly

 Solved

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
Devaraj

Product code

 Solved

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
xpcman

Burrotech office mail and outlook 2007

 Solved

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
oopsalot

Can't make two loops work

 Solved

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
FRA

Copy field to end of another field

 Solved

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
Marc
Results 2551 - 2600 out of a total of 2,608