Office Software Forum - solved topics

Ask a question
Results 2301 - 2350 of about 2,650
  • Solved
  • Excel find a value <>2#'s &get a value beside Solved/Closed

    Hi All, I want to enter a number in cell A1 (Sheet 1) and have a formula which gets excel to go to sheet 2 column A finds the two numbers the e...

    g | Excel | Latest reply: g Apr 28, 2010
    2 replies

    Hello, I need a simple formaul for finding the percentage of Total number of members: answer in column A392 Total number of members who have prov...

    LOLA | Excel | Latest reply: nancy0123 Apr 27, 2010
    2 replies
  • unlock memory card password Solved/Closed

    hey i forgot my memory card password n cudnt find ny file manager optin in my nikia 7210.pls help!!! Configuration: Windows 7 / Internet Explorer 8.0

    poo | Word | Latest reply: closeup22 Apr 26, 2010
    1 reply
  • IF statement thats Adds Solved/Closed

    Dear All, I would like to create an If statement which returns a 1 if a cell is greater than 0, then look at the next cell and do the same. Then ad...

  • conditional hide rows in multiple sheets Solved/Closed

    It didn't solved yet. I have one excel file with multiple sheets, and all of them with the same columns and rows . I need to hide specific rows in ...

    issa | Excel | Latest reply: rizvisa1 Apr 25, 2010
    1 reply
  • how to copy entire row (URGENT) Solved/Closed

    Hi people. i am doing on some assignment for school. I have created a userform with a search button embedded on one worksheet, lets call it SE...

    Starissm | Office Software | Latest reply: Starissm Apr 25, 2010
    9 replies
  • How to display formula in excel? Solved/Closed

    hi everyone, for example i have A1=H and A2=G, and A3=A1+A2 how do i make A3 show a final result of "H+G",display text instead of calculating the form...

    Daniel | Excel | Latest reply: Daniel Apr 24, 2010
    2 replies
  • Excel Skipping a cell when calculating a tota Solved/Closed

    i have a series of codes back and forth it seems a bit insane. but what im wanting is for cell b1 c1 d1 e1 and etc to add together wich i have the fo...

    starhawk85 | Excel | Latest reply: rizvisa1 Apr 23, 2010
    1 reply
  • PPS ATTACHMENTS Solved/Closed

    Hello, I tried finding the place under tool/options to untick but I didn't find it. I have OUTLOOK EXPRESS 6 and recently had to reformat computer. ...

    twin90s | PowerPoint | Latest reply: crazy Apr 23, 2010
    21 replies
  • tabs dont show Solved/Closed

    Hiya, some of the tabs are missing from my microsoft word e.g. view, format, dunno what to do. HELP

  • Compare cell against multiple columns Solved/Closed

    Configuration: Windows XP / Safari 532.5 Hopefully I can explain this as simply as possible. First here is what my spreadsheet looks like I have sepe...

    ExcelHelpless | Excel | Latest reply: ExcelHelpless Apr 21, 2010
    8 replies
  • Excel - Run Macro on Cell Change Solved/Closed

    I am trying to have 1 of 8 different macro's run depending on the value of a specific cell. If I enter 1 in cell A3, I would like macro1 to run. If I...

    ja6924 | Excel | Latest reply: aquarelle Apr 20, 2010
    1 reply
  • VBA Code For Excel .......................... Solved/Closed

    Dear Expert, Below written VBA code is being used by me to insert jpg picture in the excel file against the code number and its working very well a...

    Santosh | Excel | Latest reply: Santosh Apr 20, 2010
    2 replies
  • PLEASE HELP ME!!!! IF Formula [Solved] Solved/Closed

    Correct -- Asked -- For Upload 0 -- 0 -- ...

    DCecil07 | Office Software | Latest reply: DCecil07 Apr 20, 2010
    6 replies
  • validate Solved/Closed

    Configuration: Windows XP / Firefox 3.5.9 Hey frnds I almost have a same problem: I need to validate columns for alphanumeric and email forma...

  • helo data extrating Solved/Closed

    Hello. I have a File which contains 3 colums Mobile No , Name And Address in Sheet one. Each file contains approx 500000 data. in sheet 2 i h...

  • macro to delete blank rows? Solved/Closed

    I have a spreadsheet where I would like to 'record new macro' to delete all rows that are blank. If I filter on blank rows and delete....the macro wi...

    ap | Excel | Latest reply: ap Apr 19, 2010
    4 replies
  • Why won't this work?: update graph's year VBA Solved/Closed

    Hi, My graph has a timeline of one year. After that year the timeline needs to be updated. To get the current year I have used the functions TODAY...

    Trowa | Excel | Latest reply: Trowa Apr 19, 2010
    4 replies
  • Conditional formatting problem Solved/Closed

    Ok I hope someone can help, I have a spreadsheet set up so that it flags up to me if two certain codes match by turning the cell yellow. I also have i...

    King_Of_Hear... | Office Software | Latest reply: King_Of_Hearts13 Apr 19, 2010
    43 replies
  • Moving specific data into separate worksheets Solved/Closed

    Hello, I have a list in a column as follows: DAY TYPE PHASE 1 ...

    Steve | Excel | Latest reply: Steve Apr 19, 2010
    7 replies
  • bios password Solved/Closed

    i have dell inspiron i forget bios bassword i cant open it its end of 59b Configuration: Windows XP / Internet Explorer 8.0

    dave | Word | Latest reply: dave Apr 18, 2010
    1 reply
  • Hyperlink Macro Solved/Closed

    Hi Have a customer profile sheet that has a new customer number each time it is opened. Details are filled in for the customer then a post button is...

    SLKG | Excel | Latest reply: SLKG Apr 18, 2010
    2 replies
  • Macro to copy and paste values Solved/Closed

    Hi I am a complete novice when it comes to macros. What I am looking for is a macro that when run looks in Cell Q7 on Sheet 1 to see what number is...

    SLKG | Excel | Latest reply: rizvisa1 Apr 17, 2010
    8 replies
  • Please help macro or formula excel Solved/Closed

    I've 4 columns and 10000 rows like this : Month Plant Area Budget Jan ........ A1 ........01 ........ 1000 Jan ........ ...

    talkwutty | Excel | Latest reply: talkwutty Apr 16, 2010
    2 replies
  • multiple tabs set row count based on sheet 1 Solved/Closed

    Hi Sheet 1 contains > 1000 rows of populated data. I need to create x number of tabs each containg the next 25 rows from the sheet1 data. ie 1000...

    oli | Excel | Latest reply: rizvisa1 Apr 16, 2010
    6 replies
  • Extract specific data and convert to a date Solved/Closed

    Hello, I have a column full of cells that all have the same string with a few different numbers. Here is an example from cell K319: 53T044 11/...

    Frustrated@work | Office Software | Latest reply: jk Apr 16, 2010
    2 replies
  • Copy text from cell below based on condition Solved/Closed

    Hi, I'm looking for a macro that will copy the text from the cell below to replace the cell above where the cell above meets a certain criteria. ...

  • vba inserting row and keep range membership Solved/Closed

    In VBA, how do I copy/insert (in place) a row and ensure that if the source row intersected a column range, that the new row would also be in the rang...

    jbean | Excel | Latest reply: venkat1926 Apr 15, 2010
    3 replies
  • Count number of trips when duplicate entries Solved/Closed

    I have list of all the prescriptions we got for the year. A new row is created for each medication. Col A shows the date, Col B shows Pharmacy Name...

    Keith | Office Software | Latest reply: venkat1926 Apr 14, 2010
    4 replies
  • Sum Searched Criteria Solved/Closed

    This code works great at searching based on the userform criteria and then in the message it states the count of the rows pasted into the spreadsheet....

  • I need to get a sum from multiple 'IF' cells Solved/Closed

    I have a spreadsheet with the following formula: =IF(ISNUMBER(E5), "20.00","") If data is entered in cell E5, the cell below it will have 20.00....

    Hmmm.... | Excel | Latest reply: Hmmm.... Apr 13, 2010
    1 reply
  • One week color Solved/Closed

    Hi, Is there any formula to make my one week date in to color red then next week in to color blue? I just want 2 colors interval each ever week of the...

    Camarlengo | Office Software | Latest reply: Camarlengo Apr 12, 2010
    2 replies
  • match with conditional format in excel 2003 Solved/Closed

    Hello Internet, I am in a bind here as I have exhausted my excel knowledge on this problem. I am looking for a way to highlight (in red) a cell wh...

    ConfusedPeop... | Excel | Latest reply: rizvisa1 Apr 12, 2010
    11 replies
  • Excel 2007: Reading data from sheet to sheet Solved/Closed

    I am trying to read data from sheet "a" cell to cell on sheet "b". I entered function "=sum('sheeta'!f20) in destination cell, but all I am getting ...

    Stephen | Excel | Latest reply: rizvisa1 Apr 12, 2010
    1 reply
  • Images don't print when printing selected pag Solved/Closed

    Hello, I am using Word 2008 for mac. Some images don't print when I print selected pages, although these same images appear when I print the entire...

  • Excel VLOOKUP Macro Solved/Closed

    Hello, I am working on a project to create a simple VLOOKUP. I have created the macro and it works well, but now I am looking for some advise on ...

    froggy6703 | Excel | Latest reply: froggy6703 Apr 9, 2010
    8 replies
  • How to romove 512 mb micro sd card password Solved/Closed

    Hi i m using nokia 6300 mobile & 512mb micro sd memary card & this memary card is locked i forgot the password plz tell me how to unlock memary card p...

    Amit | Word | Latest reply: suff954 Apr 9, 2010
    1 reply
  • Interesting Question For Excel Champions Solved/Closed

    Hello, Interesting Question Guys: Suppose Sheet 1 Is "Data" Sheet And There Are Too Many Rows... Like A3 Is S.No B3 Is Supplier Name C3 I...

    Game Start Now | Excel | Latest reply: rizvisa1 Apr 9, 2010
    25 replies
  • VLOOKUP column number searching. Solved/Closed

    Dear All, I'm currently using a VLOOKUP to populate an information table im creating however im still adding columns to the sheet which holds the i...

  • coping rank for whole dataset in excel Solved/Closed

    Hi i want to work out the ranks for my whole data set, if i type in the formula for the first line then drag it for the rest instead of working out ...

    hols | Excel | Latest reply: hols Apr 9, 2010
    2 replies
  • Automation of running excel macros Solved/Closed

    Hello, I have a macro in excel which needs to be run once a day and i dont even want to open the excel sheet. How can i make this process automatic...

    aml | Excel | Latest reply: rizvisa1 Apr 8, 2010
    3 replies
  • Formula Help Solved/Closed

    I'm trying to create a formula to look at the values in a complete row and if 3 of those values in a row are pass then it will fill in the cell with Y...

  • Growing list of chart data Solved/Closed

    Hello, Column K contains dates, column L contains amounts. I want to create a chart out of this data. The issue is that the list of data is growin...

  • Creating IF statement to filter and ADD. Solved/Closed

    HI, i am trying to create an IF statement to filter a row and then add the numbers in another row on those filters. so for example AA ...

    saqib786 | Office Software | Latest reply: saqib786 Apr 8, 2010
    4 replies
  • how to align all common list in excel? Solved/Closed

    i have 4 columns. the first two (A & B) columns are list of cheques i issued. then the other two (C & D) columns are list of cheques encashed from Ban...

    ehlblackstar | Excel | Latest reply: rizvisa1 Apr 8, 2010
    3 replies
  • Copy filtered data and paste values Solved/Closed

    Hi, I found this code in this forum. It selects data based on the filtered rows of data and then it pastes it in another sheet based under the name o...

  • Coping Cells With A Loop Solved/Closed

    Hello, I am stumped on what should be a very simple macro. I am running a macro that is using a look-up table to compare the values in column G. ...

    froggy6703 | Excel | Latest reply: venkat1926 Apr 7, 2010
    1 reply
  • Changing a value using a look-up table Solved/Closed

    Hello, I am looking for help on writing a macro that will perform a VLOOKUP formula that will compare the value in G2 on Sheet1, to the value in A...

    froggy6703 | Office Software | Latest reply: rizvisa1 Apr 6, 2010
    1 reply
  • copying % formula Solved/Closed

    Hi, I regularly calculate a series of number as a percentage of a sum that remains constant (expense item as a percentage of total expenses, for eg.) ...

  • Help on Excel Formula Solved/Closed

    I need to create a formula to give me with value and not TRUE/FALSE information. I did use the IF function, but it results in TRUE/FALSE and I need a...

    teeco | Excel | Latest reply: venkat1926 Apr 6, 2010
    1 reply