Office Software Forum - solved topics

Ask a question
Results 751 - 800 of about 2,640
  • Solved
  • Comparing Two Columns With other two columns in excel 2003 Solved/Closed

    Dear Sir, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20 b 30 c 30 d 40 ...

    Sana | Excel | Latest reply: TrowaD Oct 19, 2015
    5 replies
  • Excel - shortcut key for print view Solved/Closed

    Hello, I am srinu what is d short cut key in ex-cel 2003 for print viewConfiguration: Windows XP / Safari 532.5

    chitti | Excel | Latest reply: shree Oct 19, 2015
    6 replies
  • create worksheets with names from a list Solved/Closed

    Hello, I would be most grateful if you would kindly help me out. I have a long list of projects and need to create an individual worksheet for ea...

    Child@heart | Excel | Latest reply: ac3mark Oct 16, 2015
    4 replies
  • file attachment Solved/Closed

    Hello, is it possible to attach an excel file in this forum, for a better understanding of a particular posed question? Configuration: Windows ...

    j1969c | Excel | Latest reply: Mazzaropi Oct 14, 2015
    1 reply
  • check info on two different cells... Solved/Closed

    Hello, Ladies, Gentlemen, I am working with the formula below, and it WORKS GREAT =IF(Z17="PAID","",IF(F17"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD...

    j1969c | Excel | Latest reply: Mazzaropi Oct 14, 2015
    3 replies
  • Allow rules wizard to work without Exchange Server? Solved/Closed

    Hello, I no longer work for the company that had the Exchange server and I have my personal pop3 email coming into Outlook. When I try to use th...

    victor_eilander | Outlook | Latest reply: StefanFridriksson Oct 13, 2015
    2 replies
  • auto transfer data as i marked Solved/Closed

    Hello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...

    Deb | Excel | Latest reply: rizvisa1 Oct 11, 2015
    1 reply
  • IF formula error: False Solved/Closed

    Hello, I'm trying to get one of three answers to show up in my excel document. Currently I have: ==IF(((J43/I43)*100)>=81,"APPROVED")&IF(OR((J43...

  • Counting action under condition of theyr value, and month when.. Solved/Closed

    Hello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...

    Branok | Excel | Latest reply: Mazzaropi Oct 9, 2015
    4 replies
  • @if formula Solved/Closed

    Hello, how do i formulate the following:- if cell B12 contains the word Meals, then I want to use the formula F12/2 else take 100% in F12 Conf...

    junebug65 | Excel | Latest reply: BrianGreen Oct 8, 2015
    5 replies
  • conditional Formating a column Solved/Closed

    Hello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...

    Ian | Excel | Latest reply: Ian Oct 8, 2015
    2 replies
  • Copy cells based on conditions Solved/Closed

    Hello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...

    pefler | Excel | Latest reply: pefler Oct 8, 2015
    2 replies
  • Copying data from workbook to workbook using button Solved/Closed

    Hello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...

    Oxy | Excel | Latest reply: ac3mark Oct 7, 2015
    4 replies
  • Change color to different cells based on another cells text. Solved/Closed

    Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...

    Riggs2015 | Excel | Latest reply: Riggs2015 Oct 7, 2015
    4 replies
  • Copy row and insert n times Solved/Closed

    Hello, I have an example below, I'd like to take the first row, copy it "n" number of times, then take the next row copy it the same "n" number of ti...

  • Compare two worksheets and Remove duplicated data from one Solved/Closed

    Hello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...

    fillup56 | Excel | Latest reply: fillup56 Oct 6, 2015
    3 replies
  • Search for matches from columns on separate sheets. Solved/Closed

    Hello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...

    Tim | Excel | Latest reply: Tim Oct 6, 2015
    2 replies
  • How To Copy Data Between Several Sheets on VBA Solved/Closed

    Hi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...

    fcbarros | Excel | Latest reply: TrowaD Oct 1, 2015
    7 replies
  • values from one workbook to another Solved/Closed

    Hello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...

    charms72 | Excel | Latest reply: charms72 Sep 30, 2015
    2 replies
  • i am unable to send out Hotmail from MS Outlook Solved/Closed

    Hello, I have configured two email address in outlook 2007. one gmail another one is hotmail. I can send email by my first one gmail account but I...

    shabbir abbas | Outlook | Latest reply: ac3mark Sep 29, 2015
    1 reply
  • Giving false with certain answers Solved/Closed

    Hello, I am having an issue with my formula. Certain values will give me the correct answer (A, B, C, D, F) but other values will give me a FALSE...

  • Range of cells depending on a condition. Solved/Closed

    Hello, I am trying to change part of a cell reference for a range of cells depending on a condition. For example, the formulas in column A & E: A...

    Milvy | Excel | Latest reply: Milvy Sep 29, 2015
    2 replies
  • Outlook Express emails disappeared - can I get them back? Solved/Closed

    A user opens his Outlook Express 6 (all windows updates up to date) this morning and finds that his inbox is empty. 200-odd messages that were there ...

    DavidCum777 | Office Software | Latest reply: EdwardHunterS Sep 28, 2015
    2 replies
  • match cells in excel with all characters same except one Solved/Closed

    Hi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For eac...

    Murtuza | Excel | Latest reply: ac3mark Sep 27, 2015
    13 replies
  • Auto populate rows from master sheet to other sheets Excel 2013 Solved/Closed

    Hello, I'm working on a sheet to autopopulate from data that I've downloaded in Excel format. Currently, I have to recreate the wheel (spreadshee...

    RyanLug | Excel | Latest reply: vcoolio Sep 25, 2015
    3 replies
  • script which can check if a debit has a corresponding credit Solved/Closed

    Hello, I am new to VBA, and I am searching for a script which can check if a debit has a corresponding credit (same value bue with -/+), and highl...

    dennisvhansen | Excel | Latest reply: dennisvhansen Sep 24, 2015
    11 replies
  • IF functions with dates Solved/Closed

    Hi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...

    kev8687 | Excel | Latest reply: kev8687 Sep 24, 2015
    1 reply
  • Excel - Compare data in two worksheets Solved/Closed

    Hello, I need help with the best way to combine information in two worksheets and identify rows where data in colum B and column C has changed on...

    Cat | Excel | Latest reply: Manish Sep 24, 2015
    9 replies
  • Unable to Convert Date in Excel Solved/Closed

    I am trying to change all of the dates in an excel spreadsheet to the mm/dd/yyyy format, but when I go to format the cells, it does not change, even w...

    awallsy | Excel | Latest reply: Ambucias Sep 22, 2015
    7 replies
  • Using a comand button to open an external software? Solved/Closed

    Hello. I'm using Excel and I need do create a comand button to open an external software, e.g. I need do order that button to open "Profis Anchor f...

    alfa_eng | Excel | Latest reply: alfa_eng Sep 22, 2015
    7 replies
  • How to populate a version # change to a text sentence Solved/Closed

    Hello, Using Excel 2013 What I'm trying to do is I have for example a row that contains information about my software. And in 4 of those cells t...

    gamesactual | Excel | Latest reply: Mazzaropi Sep 21, 2015
    4 replies
  • Dynamic database Solved/Closed

    Hello, i have a database sheet about spare parts in my store .. this spare pasrts are changed their counted daily , i need the formula that refreash...

    Omar Tafnakji | Excel | Latest reply: omar Sep 21, 2015
    2 replies
  • sum different alphabets in an excel range. Solved/Closed

    some one please help to sum different alphabets in an excel range..........example.....range is ...A!:Z1 and i want to sum "P" and C...

    tahir147 | Excel | Latest reply: Mazzaropi Sep 20, 2015
    12 replies
  • Opening Word 2007 docs with Word 2010 Solved/Closed

    So I installed Office 2010, and removed Office 2007 from my computer (I had lost the product key, so it was in view-only mode, it's a long story) - ob...

    Notsmart | Word | Latest reply: Rockport Sep 16, 2015
    3 replies
  • Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format Solved/Closed

    I have looked at dozens of articles, but they all talk about converting different forms of mm/dd... etc. to other similar forms. I want to chart bloo...

    Lschwa01 | Excel | Latest reply: ac3mark Sep 14, 2015
    1 reply
  • =IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>&quot Solved/Closed

    Hello, I am at the crossroads with this functions string (doesn't work) any help will be much appreciated... =IF(F21="CTF",I21*15,IF(L21="CTF",O21*...

    j1969c | Excel | Latest reply: Mazzaropi Sep 13, 2015
    1 reply
  • IF function for "specific date" + 15 calendar days Solved/Closed

    Hello, maybe you can help with the following... I am looking for an IF function that alerts me to "PAY NOW" or to "HOLD" as follows; PRODUCT ENTRY ...

    josecruz | Excel | Latest reply: j1969c Sep 11, 2015
    11 replies
  • My compliments, great altruism everybody! Great forum! Solved/Closed

    Hello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello, especially t...

    j1969c | Excel | Latest reply: j1969c Sep 11, 2015
    4 replies
  • =IF(F9:F46="CTF",I9,"") Solved/Closed

    Hello, I would appreciate any help regarding the above formula - =IF(F9:F46="CTF",I9,"") - I am trying to compute a scheme where if any cell betwe...

    j1969c | Excel | Latest reply: Mazzaropi Sep 11, 2015
    1 reply
  • Conditional Cells Filing Solved/Closed

    Hello guys :), I use Excel 12. What I need help with is a conditional filling of cells, based on values in different cells/in the certain row. I l...

    Branok | Excel | Latest reply: Branok Sep 11, 2015
    2 replies
  • how to use a single part of a cell's date Solved/Closed

    So that's the scenario, I've a date in a Cell (D4) in the format 02/02/2008. I need to compare only the year of the date (2008) and if it's true re...

    TheMarcus | Excel | Latest reply: TheMarcus Sep 11, 2015
    2 replies
  • Help in Merging Codes Solved/Closed

    Hi I need help in the following VBA (Macro Codes) in Excel 2013 Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim Inva...

    smuneeb | Excel | Latest reply: smuneeb Sep 10, 2015
    2 replies
  • Function has too many arguments... Solved/Closed

    Why is excel telling me that this formula has too many arguments? =IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID")) I am stationed on ...

    j1969c | Excel | Latest reply: venkat1926 Sep 10, 2015
    1 reply
  • Search for multiple substrings and return different values Solved/Closed

    I have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string ...

    jotied | Excel | Latest reply: jotied Sep 9, 2015
    2 replies
  • Clicking data in one sheet..Saving all those clicked in another. Solved/Closed

    Hello, I'm working on excel which has names(Col A) numbers (Col B). I'm looking to create a sheet, who by clicking on the number, stores the number ...

    sram | Excel | Latest reply: sram Sep 8, 2015
    4 replies
  • Same Date in Column A on Mutiple Lines in seperate worksheets Solved/Closed

    Hi, Not using FILL with copy/paste....Is there a way to create a date range in Column A (IE: 9/1/15) from line 1 going downward when entering multi...

    grangeeman | Excel | Latest reply: TrowaD Sep 7, 2015
    3 replies
  • Acrobat Reader Solved/Closed

    Hello, I get a prompt that my acrobat browser plugin is missing and need to reinstall. Do I need to download the software again? Configuration...

    Margaret | PDF | Latest reply: Margaret Sep 3, 2015
    2 replies
  • Please help in getting data clubbed in one cell Solved/Closed

    Please inform how to get the following information clubbed in a row Data as follows Required data in a ...

    Pkg1403 | Excel | Latest reply: TrowaD Sep 3, 2015
    3 replies
  • master sheet to work sheet, Solved/Closed

    I have been getting help at this site and I am not able to get into my messages to respond anymore. I am not sure if it is just a work computer issue ...

    Wayvic | Excel | Latest reply: vcoolio Sep 3, 2015
    29 replies
  • Accounts data requires automatic analysis Solved/Closed

    Five columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...

    249ccjames | Excel | Latest reply: 249ccjames Sep 2, 2015
    2 replies