Office Software Forum

Ask a question
Search
Close
Results 2751 - 2800 of about 16,600
  • Copy a cell in the same row as a matched cell on a sheet2 Closed

    Hey, Let me try and explain this better. I need to match A2 with Sheet2!A:A, but the value I need is a cell on Sheet2 in the same row as the mat...

    Matt | Excel | Latest reply: Mazzaropi Jul 21, 2016
    3 replies
  • Move Rows of Spreadsheet to second spreadsheet Closed

    Good Morning- I am keeping a spreadsheet of my projects. I want to keep the information for tracking and statistics later. Is there a way to move...

    Scott Hicks | Excel | Latest reply: vcoolio Jul 21, 2016
    1 reply
  • Macro to Copy Cells and Save multiple entries Closed

    Hello, I am looking to create a macro (never done this before). Here is what I want it to do. 1) I have a master store name excel file (for exampl...

    campbell0822 | Excel | Latest reply: ac3mark Jul 20, 2016
    3 replies
  • Conditional Formating: formula cell text change color Solved/Closed

    Hello, How do I get Text in a Cell to Change from Black to White, based on data? The cell already contains a formula to extract data from elsew...

    Marshall | Excel | Latest reply: ac3mark Jul 20, 2016
    3 replies
  • Colour in spreadsheets that are formulated Closed

    Hello, I would like to know how to do the following on excel Same sheet with the amount of calls taken in number form goes into a cell then the ...

    Spud | Excel | Latest reply: ac3mark Jul 20, 2016
    4 replies
  • How to highlight the extra data in column Closed

    Hello, I want to get the extra data in a column when compared to other column. For Ex: If ColumnA has following data 1 2 2 3 5 & column B...

    Sumit | Excel | Latest reply: Sumit Jul 20, 2016
    2 replies
  • Excel Macro help Closed

    Hello, Would like to create a macro to assist in an excel spreadsheet. Have data in Columns A to E with rows of up to 150. For each row would ...

  • Transfer between excel worksheets Closed

    Hello, I would like to be able to transfer an entire row of attendance of students when it hits zero for attendance to another sheet or at the bot...

    Vira | Excel | Latest reply: vcoolio Jul 20, 2016
    1 reply
  • Conditional Formatting to change value base on multiple conditio Closed

    Hi All, I would like to get some help with conditional formatting. Let say that I have 6 columns with Cell 1, Cell 2, up to Cell 5 and Cell 6 as Over...

  • Correlation with complex Arrays Closed

    Hello, I understand how to do a basic correlation. But, if I have thousands of student data and want to run correlations of student test scores i...

    Teacher | Excel | Latest reply: Teacher Jul 19, 2016
    0 replies
  • Automatically transferring rows of data between sheets Closed

    Hello, I am creating an excel spreadsheet that will be used to keep track of my organization's board member and supporter attendance at events. I ...

    jzendran | Excel | Latest reply: vcoolio Jul 18, 2016
    3 replies
  • date format *dd/mm/yyyy and dd/mm/yyyy Closed

    LS, Hello, Please help me with the following question; What is the difference between the format dd/mm/yyyy and *dd/mm/yyyy when uploading dates an...

    HorsemanNL | Excel | Latest reply: ac3mark Jul 18, 2016
    1 reply
  • Conditional Formatting when a cell says "NO" Solved/Closed

    Hello, I need your expertise in conditional formatting. I have a worksheet that where i have hidden a column ("J") with just Yes and No on it. W...

    Grace C | Excel | Latest reply: Mazzaropi Jul 18, 2016
    3 replies
  • If a cell has a certain value after certain date, color the row Solved/Closed

    Hello, I'm working with deadlines, and projects need to progress from one stage to another by specific dates. I have 3 deadlines: A: Create BR...

    ManxMaggie | Excel | Latest reply: ManxMaggie Jul 18, 2016
    4 replies
  • Matching 2 values from one spreadsheet Solved/Closed

    Hello, I have 2 spreadsheets.. first has 3 columns id, date, time value second volume with id header across of date would like to populat...

    sargiesan59 | Excel | Latest reply: sargiesan59 Jul 16, 2016
    3 replies
  • Copying a range of data between 2 values Closed

    Hello, Please could someone assist. I have a workbook with 97 sheets and I am wanting to create a macro that can copy a certain range of data bet...

    Roxyg | Excel | Latest reply: Roxyg Jul 16, 2016
    0 replies
  • Help please need formula Closed

    Hello, I need for anything in column J that says complete to be moved to another sheet. How do I do that ?

    Bee | Excel | Latest reply: Bee Jul 15, 2016
    0 replies
  • Change text in cell if other cells have any values Solved/Closed

    Hello, I am working on a spreadsheet where I have 5 important columns. Column B is the "Completed" category. Columns C, D, E & F will all contain ...

    C.J. Leffel | Word | Latest reply: C.J. Leffel Jul 15, 2016
    5 replies
  • How to count how many times a number appears in a spreadsheet? Solved/Closed

    Hey~ I need to count the number of times a number appears in a spreadsheet. For example, how many times the number 1 appears in an entire spreadshe...

    kimipapineau | Excel | Latest reply: kimipapineau Jul 15, 2016
    4 replies
  • Conditional formatting from other spreadsheet Closed

    Hello, Every day I update my excel spreadsheet based on customer demand. My boss uses a separate spreadsheet that pulls from mine. He wants to be ...

    cleggwde | Excel | Latest reply: ac3mark Jul 15, 2016
    1 reply
  • excel formula Closed

    I need to generate a number list of 1-20000. is there any method?

    theja123 | Excel | Latest reply: theja123 Jul 15, 2016
    0 replies
  • Automatically copy data from one sheet to another Closed

    I have read numerous articles about this and none have really solved my issue. I decided to post my own specific question. I have an excel workboo...

    atera7 | Excel | Latest reply: vcoolio Jul 15, 2016
    1 reply
  • Removing false statement Closed

    Hello, I would like to remove a FALSE statement, want it to show nothing. My formula is as follow =IF(A23=1,G23,IF(A23=2,G23,IF(A23=3,G23,IF(A23...

    Formula | Excel | Latest reply: Mazzaropi Jul 14, 2016
    1 reply
  • Excel formula Solved/Closed

    Hello, I am having trouble getting the right formula for: Column O is equal to column N if Column C contains the text "Mastercard." Nothing I'...

  • Formula should be easy Closed

    Hello, I am having trouble getting the right formula for: Column O is equal to column N if Column C contains the text Mastercard. Nothing I've t...

  • send email when a cell changed in excel Closed

    Hello, hi guys, straight off, im stupid, extremely stupid so if you can help me please keep it simple as im barely technical at all :) anyways, im...

    disposablehero | Excel | Latest reply: Haval Jul 14, 2016
    4 replies
  • calculate to distance between two addresses on google maps excel Closed

    Hello Friends, please help me if you can. what im trying to do is, i need to calculate the distance between two addresses on google maps and want t...

    lynng | Excel | Latest reply: lynng Jul 13, 2016
    0 replies
  • Recover corrupted PDF files Solved/Closed

    Hello, I'm trying to recover a folder with some critical data that was damaged or corrupted, likely by a virus. It’s a 10GB folder that contains P...

    StevenMiller | PDF | Latest reply: Ambucias Jul 13, 2016
    1 reply
  • code for date in words Closed

    Hello, i want code for coverting date in to words in c Configuration: Windows 7 / Chrome 51.0.2704.103

    anee | Word | Latest reply: anee Jul 13, 2016
    0 replies
  • Creating multiple lists from one master data table Closed

    Hello, I am trying to create a master data tab where expenses will get coded. I need each subsequent tab to be for a specific account and that ta...

    KelliG | Excel | Latest reply: vcoolio Jul 13, 2016
    2 replies
  • How do I extract specific data from a cell in excel? Closed

    Hello, what function would I use to extract just the city name from the cells below?...thanks! 6211 E Holmes Rd ,, ,Memphis, TN 381418310, U.S.A. ...

    mcat79 | Excel | Latest reply: ac3mark Jul 12, 2016
    5 replies
  • changed pdf to word, now all documents are gibberish Closed

    Hello, I changed one of my documents with "Open with" from PDF to word. I has now changed all my word documents to gibberish. How do I get it to ...

    me | PDF | Latest reply: xpcman Jul 12, 2016
    1 reply
  • Conditional Formatting Based on Data in Another Call Closed

    I'm a new member and I hope my question is clear. I need to change the background field color of cells in a column based on a value in a different fi...

    anniedavis1980 | Excel | Latest reply: anniedavis1980 Jul 12, 2016
    0 replies
  • Change color of text or cell if the value entered is same Closed

    Hi! Can someone please share me how to change font or cell color if a value entered in a cell is already selected before. Ex. I wanted the font or...

    Mark | Excel | Latest reply: Mazzaropi Jul 12, 2016
    1 reply
  • ms word 2007 files converted in to ms word 2003 Closed

    Plz help me. M research scholar I have created my file in ms word 2007 but after few hours I have opened then I have seen my all files have converted ...

  • comparing the two names respective of Upper & Lowercases letters Solved/Closed

    Hello, here am trying to know something about the compare of 2 names in excel below is my format Http:CCM_net_C2E http:cCM_Net_c2E i have ...

    KICK | Excel | Latest reply: ac3mark Jul 11, 2016
    7 replies
  • macro for inserting multiple rows between data Closed

    Hello, I need a macro that will insert 45 new blank rows between each existing row that I have now. can someone help me with this? Also, I have li...

    vba dummy | Excel | Latest reply: TrowaD Jul 11, 2016
    1 reply
  • Count if it is monday? Closed

    Hey all; I could not manage to work this out after 1 day research and try my chance here. I have dates on column A and numbers (both positive,negat...

    serdargurlek | Excel | Latest reply: tunnde80 Jul 11, 2016
    1 reply
  • Copy data from one sheet to another based on condition using VBA Closed

    The data looks like this A B C D 1 3.45 ...

    tunnde80 | Excel | Latest reply: tunnde80 Jul 11, 2016
    0 replies
  • Macro to Merge Data Based on Condition Closed

    Hello Dear, I have multiple sheets with different columns, the headers are mentioned in row 3 and there are few headers which are common across al...

    Chanti | Excel | Latest reply: Chanti Jul 11, 2016
    0 replies
  • Transferring data by row onto new tab Unpaid and Paid Sales Closed

    Hi I am new to this forum. I have an excel spreadsheet which looks like this: Date Description Invoice Destination Amount Status ...

    MILIMINX | Excel | Latest reply: vcoolio Jul 11, 2016
    1 reply
  • format copy upon condition Closed

    Hello, I have a workbook with two worksheets, one with a legend using 2 columns. Column a for name b for colors. On The first worksheet i am ...

    nonya | Excel | Latest reply: nonya Jul 10, 2016
    0 replies
  • add the value of one cell only if another cell has a certain # Closed

    Hi everyone. I'm trying to make a spreadsheet to categorize business expenses into IRS categories. For example Column C has the cost for each ex...

    SilentWhisper | Excel | Latest reply: SilentWhisper Jul 10, 2016
    0 replies
  • Using if statement to add 1 to total Closed

    Hello, I am trying to get a formula to add + 1 to a total cell based on the word typed. Example : If I type the word Duty in cells B3:B18 then ad...

  • Totaling amount from 1st tab depending on another column states Closed

    Hello, I have 2 worksheet, 1st worksheet shows 2 columns A1 ($0.00) and A2 (names). 2nd worksheet I want it to calculate if the name column A2 sta...

    jenny | Excel | Latest reply: Mazzaropi Jul 9, 2016
    1 reply
  • How to populate data to another tab Closed

    Hey there, If anyone could please spare a moment to help me with this, it would be much appreciated, more than you will know ! What I want to d...

    gxxrgx_ | Excel | Latest reply: RicSan Jul 8, 2016
    4 replies
  • comparing 2 columns from 2 different spreadsheets Solved/Closed

    Hello, Here is what i am trying to do. Spreadsheet 1 column B has customer numbers Spreadsheet 2 column A also has customer numbers Spreadsheet 2...

    agauth | Excel | Latest reply: agauth Jul 8, 2016
    2 replies
  • excel question Closed

    Hello, i want to calculate distinction,first,second and third divisions Configuration: Windows 7 / Firefox 13.0

  • Copy 10 sheets (along with data) into new 10 sheet in Same excel Closed

    Hello, I have an Excel which contains 10 Sheets with data.., Once a Go button is Clicked it new 10 sheets should be opened in same Workbook along ...

    Aswinraj | Excel | Latest reply: TrowaD Jul 7, 2016
    1 reply
  • set a conditional year end date outcomes Closed

    Hello, I am trying to set a conditional year end date outcomes. 1. If cell "A1" shows 10/31/2016, then I want cell "B1" to show year end 12/31/201...

    Kevdfw | Excel | Latest reply: Mazzaropi Jul 7, 2016
    1 reply