Excel Forum - solved topics

Ask a question
Results 651 - 700 of about 1,710
  • Solved
  • 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 | Latest reply: rizvisa1 Oct 11, 2015
    1 reply
  • 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 | 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 | 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 | 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 | 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 | 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 | Latest reply: Riggs2015 Oct 7, 2015
    4 replies
  • 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 | 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 | 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 | 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 | Latest reply: charms72 Sep 30, 2015
    2 replies
  • 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 | Latest reply: Milvy Sep 29, 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | Latest reply: omar Sep 21, 2015
    2 replies
  • sum different alphabets in an excel range. Solved/Closed

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

    tahir147 | Latest reply: Mazzaropi Sep 20, 2015
    12 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | Latest reply: TrowaD Sep 7, 2015
    3 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 | 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 | 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 | Latest reply: 249ccjames Sep 2, 2015
    2 replies
  • custom sorting & calculating average based position Solved/Closed

    please help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u h...

    oluwaridenawa | Latest reply: oluwaridenawa Aug 31, 2015
    2 replies
  • search word from list, match it copy values next to it Solved/Closed

    I have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in...

    haris1989 | Latest reply: haris1989 Aug 31, 2015
    2 replies
  • Concatonating within commands??? Solved/Closed

    Ok - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...

    BrianGreen | Latest reply: BrianGreen Aug 21, 2015
    4 replies
  • Comparing columns and returning value Solved/Closed

    Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...

    Thakkudu | Latest reply: TrowaD Aug 20, 2015
    14 replies
  • Word "False" kept on Appearing? =IF function Solved/Closed

    =IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data")))) How is it happen that I put "Incomplete Data"...

    InfoTech04 | Latest reply: InfoTech04 Aug 19, 2015
    2 replies
  • sumproduct based on relative cell Solved/Closed

    Hello, I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to do ...

    Brian | Latest reply: BrianP Aug 19, 2015
    2 replies
  • stack range of data to next empty row in other sheet Solved/Closed

    Hello, I have a set of data in Sheet1 Range("D24:D50") and Range("AC24:AC50") would like to be copied and paste special value to Sheet2 Column A a...

    milli | Latest reply: Milli Aug 18, 2015
    4 replies
  • Macro that kills a macro when a new workbook is opened. Solved/Closed

    Hi All, I am still new at excel macros. I am using a command button to copy all work sheets in a workbook then pasting just the values into a new w...

    JStill | Latest reply: ac3mark Aug 17, 2015
    5 replies
  • Excel, how to use macros and conditioning. Solved/Closed

    Hello, I have been looking up how to use excel to help sort data but ran into a few problems. First I have searched how to delete a row with certain...

    Matt | Latest reply: Matt Aug 13, 2015
    2 replies
  • Using 'rept' inside 'If' Solved/Closed

    Hello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...

    dinu | Latest reply: dinu Aug 13, 2015
    2 replies
  • date formula Solved/Closed

    Hello, Can someone please create a formula for these numbers to change to a date. 152030355A, the answer should be 7/22/2015. The first two nu...

    judy | Latest reply: Judy Aug 12, 2015
    9 replies
  • fetch data Solved/Closed

    fist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift desire s004 Nisha...

    khroliya | Latest reply: vcoolio Aug 10, 2015
    3 replies
  • Need VBA code to create loops Please Solved/Closed

    I have done loops before but it has been a long time. I need to loop through rows of data and the rows of data changes. The value in column "N" is t...

    Jan | Latest reply: FaizanRoshan88 Jul 31, 2015
    6 replies