Office Software Forum - solved topics

Ask a question
Results 2551 - 2600 of about 2,650
  • Solved
  • Excel Formula for Conditional Formatting Solved/Closed

    Hello, I'm trying to find a formula and instructions for shading date values in a column on a worksheet based on the month relative to today's date. ...

    Scott | Excel | Latest reply: venkat1926 Sep 29, 2009
    3 replies
  • set password in mozila firefox Solved/Closed

    Hello, i want to know how can i set pass word in mozila firefox which is ask me when i start or open firefox. please repy or answer in my email addr...

    soyab | Word | Latest reply: Asten M Sep 25, 2009
    2 replies
  • Highlight one cell based on date in a range Solved/Closed

    Hello, Using conditional formatting I wanted to highlight one cell based on a range. I wanted for example a1 text to be highlighted when one cell or...

  • Excel Date formatting problem Solved/Closed

    So here's my problem. I have multipe dates all in one column on one tab/worksheet of an excel workbook. When I try to link to that date on another tab...

    chow70 | Excel | Latest reply: chow70 Sep 22, 2009
    2 replies
  • count a text string if criteria is found Solved/Closed

    Hello, I have a problem and is that I want to count a text string from a range of cells, if the criteria is found correct, for example, jamshedpu...

    love2garv | Office Software | Latest reply: venkat1926 Sep 17, 2009
    1 reply
  • please help with my spreadsheet Solved/Closed

    Hello, I am having a hard time trying to figure out how to format my spreadsheet so that i can make it a template that i can use in future, this is w...

    chicky | Excel | Latest reply: chicky Sep 15, 2009
    2 replies

    Hello, I am trying to figure out how to count the number of cells that contain a certain text. For example: Column A 2007 Entry Draft ...

    drummo87 | Excel | Latest reply: deepbreathe Sep 6, 2009
    3 replies
  • Simple function or formula I think Solved/Closed

    Hello, I want to set up a formula or function to display a number from another cell only if a different cell is greater then 0. Example: data in Cel...

  • excel 2003 question Solved/Closed

    Microsoft Office Excel 2003 I am trying to put in todays date along with text. How would i do this? in box A43 i have: =Q1&R1&S1 in Q1 i h...

    TrinityIPB | Excel | Latest reply: sadgurl Sep 2, 2009
    3 replies
  • Excel: Copy active range to bottom of list Solved/Closed

    Hello, On multiple sheets I have lists of peoples names. When I add a few new names on one sheet, I want a macro to copy-paste these names to the o...

    Trowa | Excel | Latest reply: Trowa Aug 27, 2009
    13 replies
  • Adding data from one column using another Solved/Closed

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

  • COUNTIF Formula Solved/Closed

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

  • To retrieve the particular cell value Solved/Closed

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

  • Clear cell contents based on color Solved/Closed

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

  • Vlookup - find value 3,4,5 etc.. Solved/Closed

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

  • Hiding a cell if value equals X Solved/Closed

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

  • VBA underscore trouble Solved/Closed

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

    Trowa | Excel | Latest reply: Trowa Jul 21, 2009
    4 replies
  • 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, ...

    dbdesperate | Office Software | Latest reply: dbdesperate Jul 19, 2009
    2 replies
  • “False” result not working on IF formula Solved/Closed

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

  • VBA: Error 9; subscript is out of reach Solved/Closed

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

    Trowa | Excel | Latest reply: Dean Jul 16, 2009
    4 replies
  • list month from any given year in excel Solved/Closed

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

    smd | Excel | Latest reply: ani Jul 13, 2009
    6 replies
  • Activating Macro Solved/Closed

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

    Trowa | Excel | Latest reply: Trowa Jul 9, 2009
    3 replies
  • Require help in excel Solved/Closed

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

    Anakin | Excel | Latest reply: Anakin Jul 8, 2009
    2 replies
  • Trouble activating macro Solved/Closed

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

    Trowa | Excel | Latest reply: Trowa Jul 6, 2009
    3 replies
  • Conditional formating for entire rows Solved/Closed

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

    Trowa | Excel | Latest reply: Trowa Jun 30, 2009
    9 replies
  • install ms office 2003 Solved/Closed

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

  • Excel worksheet help Solved/Closed

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

    Shams | Excel | Latest reply: venkat1926 Jun 26, 2009
    1 reply
  • excel 2007 timeline, help please Solved/Closed

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

    Orkt | Excel | Latest reply: Orkt Jun 22, 2009
    1 reply
  • Possible to extract partial data in Excel? Solved/Closed

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

    DarkDMize | Excel | Latest reply: DarkDMize Jun 20, 2009
    2 replies
  • Excel Formular Problem Solved/Closed

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

    Funky Town | Excel | Latest reply: mubashir aziz Jun 19, 2009
    2 replies
  • Macro to find last blank cell in column Solved/Closed

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

    LesE | Excel | Latest reply: LesE Jun 13, 2009
    3 replies
  • Excel Total Range of Values Solved/Closed

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

    MATTHEWRAD | Office Software | Latest reply: mubashir aziz Jun 5, 2009
    5 replies
  • 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 ...

    Manhamanha | Excel | Latest reply: Manhamanha Jun 3, 2009
    2 replies
  • My Replies are not appearing Solved/Closed

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

    mubashir aziz | Office Software | Latest reply: afterhere May 28, 2009
    1 reply
  • above cell Solved/Closed

    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'...

    motorsito | Office Software | Latest reply: motorsito Apr 23, 2009
    6 replies
  • Excel Column Sort Solved/Closed

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

    ZaQ | Excel | Latest reply: ZaQ Apr 20, 2009
    2 replies
  • Microsoft Office ? Solved/Closed

    Hello, Does Microsoft Office work on Windows Vista ?

    question_girl | Office Software | Latest reply: anonymous Apr 17, 2009
    3 replies
  • Excel - reset / replace seconds to zero Solved/Closed

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

    safy_al_nya | Excel | Latest reply: safy_al_nya Apr 16, 2009
    2 replies
  • Send value of cell to target Solved/Closed

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

  • excell Macro Help Required Solved/Closed

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

    Crackinhunk | Excel | Latest reply: sarbel.vilo Mar 24, 2009
    2 replies
  • Need help in Excel Macro Solved/Closed

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

    zeromaim | Excel | Latest reply: Jnani Mar 20, 2009
    6 replies
  • Excel Help Solved/Closed

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

    Amber1984 | Excel | Latest reply: Amber1984 Mar 17, 2009
    5 replies
  • Having Excel IF formulas print text and calc Solved/Closed

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

    martinwuff | Excel | Latest reply: martinwuff Mar 6, 2009
    2 replies
  • need for dfd Solved/Closed

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

  • what is my email server address? Solved/Closed

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

    greggie pooh | Office Software | Latest reply: mandymoo Feb 22, 2009
    2 replies
  • Ms-word asks for converter Solved/Closed

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

    vicky | Word | Latest reply: xpcman Feb 18, 2009
    1 reply
  • Count and summarise records in Excel 2003 Solved/Closed

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

    GRA | Excel | Latest reply: GRA Feb 17, 2009
    2 replies
  • Create Msg/Popup to notify in Excel VBA Solved/Closed

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

    Siebel SME | Excel | Latest reply: Siebel SME Feb 11, 2009
    4 replies
  • converting date format in excel sheet Solved/Closed

    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?

    suni | Excel | Latest reply: daywish Feb 10, 2009
    1 reply
  • help to find Solved/Closed

    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.