Excel Forum - solved topics

Ask a question
Results 251 - 300 of about 1,710
  • Solved
  • Matchpoint score Solved/Closed

    hello I hope that someone can help me. I have an excel sheet in which I record scores of teams and I would like a formula to calculate the points acc...

    whatsit | Latest reply: Mazzaropi Feb 5, 2018
    5 replies
  • How to use conditional format based on text? Solved

    Hello, I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "Fi...

    Leanne99 | Latest reply: Mooseman Jan 24, 2018
    26 replies
  • Copy and convert data Solved/Closed

    Hi, in advance I would like to thank everyone for reading my post and providing any assistance. I have an exported worksheet with 50 rows of data (30...

    smcgrath3475 | Latest reply: vcoolio Jan 23, 2018
    29 replies
  • VLOOKUP, IF? Question assigning value to text options Solved/Closed

    Hello, I need to make an spreadsheet that corresponds different text values and gives them a score. I have several tables set up, that I was tryin...

    Soupies | Latest reply: Soupies Jan 17, 2018
    2 replies
  • Data showing who pays a doesnt after manually input receipts Solved/Closed

    Hello, Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the ...

    ramaemachado | Latest reply: Mazzaropi Jan 17, 2018
    5 replies
  • Filter the data in Excel through formula Solved/Closed

    Hello, I need a formula of the following quotation: Column A Belongs To Customer Name Column B Belongs The Date Column C Belongs To Item ...

    Game Start Now | Latest reply: Ash Jan 9, 2018
    27 replies
  • Insert rows on change of value in Excel table Solved/Closed

    Hello, I have an excell spreadsheet that contains a table. I want a macro of vb to insert a row into the table when the values in a particular colum...

    theHawk | Latest reply: Counselor Jan 4, 2018
    13 replies
  • IF function in Excel error Solved/Closed

    Hello, anyone can tell me where the error Is. =IF(G:G>="0:05", 0:30Min, IF(G:G>="0:20",1:30hrs, IF(G:G="0:00",0:00hrs , 4:00hrs))) * * ...

    AngelaTyq | Latest reply: AngelaTyq Dec 12, 2017
    3 replies
  • Conditional formatting with multiple rules and blank text cells Solved/Closed

    Hi, I wonder if someone would be able to help me with this. This is probably really simple, but I can't get it to work. I need excel to change a c...

    PaiviM | Latest reply: PaiviM Dec 6, 2017
    6 replies
  • Setting up Excel formula Solved/Closed

    Hello, I need some help with the excel formulas I have new taxation laws that apply my organization from January. The current taxes are 10%...

    Carlo1991 | Latest reply: ac3mark Dec 4, 2017
    7 replies
  • Comparing data between two excel sheets Solved/Closed

    Hello, I have two excel sheets with the same columns. Essentially Name, Email, Phone. One sheet is the 'original" data and the other is the "upd...

    Annie | Latest reply: dubla89 Dec 1, 2017
    12 replies
  • Formatting cell Solved/Closed

    Hello, I want to highlight the coloumn B, if the coloumn A is greater than 0, In column A having numbers and the column B having texts. here so...

    sheeba | Latest reply: sheeba Nov 21, 2017
    3 replies
  • Drop down look up Solved/Closed

    Hello all, I have a 40 sheet workbook. I want to hide 39 of the tabs and use one sheet as the "master" to pull all of the data. I have the tabs in ...

    nminnis | Latest reply: vcoolio Nov 21, 2017
    14 replies
  • Automatically update master worksheet from other worksheets Solved/Closed

    Okay, first I should mention that I'm a complete amateur when it comes to excel. No VBA or macro experience, so if you're not sure whether I know some...

    Saktivel | Latest reply: vcoolio Nov 21, 2017
    18 replies
  • Help- conditional cell formatting Solved/Closed

    Hello, I am trying to do some conditional formatting and having a little trouble. Here is what Im looking to get. I have a column A (estimated ...

    campbellty10 | Latest reply: campbellty10 Nov 21, 2017
    2 replies
  • Make a macro run when data entered in a cell Solved/Closed

    Hello, I have a macro that runs when the user clicks on a button. Instead, I want the macro to run when Cell D10 is populated. The data for D10 c...

    SandsB | Latest reply: Rajiv Nov 15, 2017
    36 replies
  • Worksheet_SelectionChange event not working Solved/Closed

    Hello, I wanted to execute a Worksheet_SelectionChange event code. But its not working. I searched on net to find that if I change (General) to Wo...

    Omi Kat | Latest reply: Omi Kat Nov 13, 2017
    2 replies
  • Working out the difference in times between two columns Solved/Closed

    I have various times in Column B (Departure time), and another set of times in Column C (arrival time). If the time in B is between 07.00 and 00.59...

    sailingdemon | Latest reply: sailingdemon Nov 12, 2017
    5 replies
  • How to copy columns to a specific column header and repeat? Solved/Closed

    Hello all, am new to using macros in excel. i have data and i want to be able to columns and paste it under some specific columns repeatedly. Examp...

    stylus33 | Latest reply: stylus33 Nov 10, 2017
    2 replies
  • Changing format of date in Excel Solved/Closed

    Hello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/...

    drizn | Latest reply: Dnbaugh Nov 9, 2017
    56 replies
  • Copying formula by changing only one rule. Solved/Closed

    Hello Team, I want to copy the formula "=INDEX((Sheet1!B2:B99),MATCH(B24,Sheet1!A2:A99,0))" 1000 cells by changing only "B24" to "B25, B26" and so ...

    shan_asa | Latest reply: shan_asa Nov 7, 2017
    2 replies
  • How to compare a range of data in Excel? Solved/Closed

    Dear Team, I want to compare a range of values from columns in row A (A1 to A6) with date input in column C1. If C1 is equal to data in A1 then D1 ...

    shan_asa | Latest reply: shan_asa Oct 29, 2017
    4 replies
  • VBA for copying from data entry sheet to corresponding sheets Solved/Closed

    Hi, I am new to excel and would need some help. I wanted a vba for copying from data entry sheet to corresponding sheets automatically in the same ...

    OMCHABRIA | Latest reply: TrowaD Oct 24, 2017
    7 replies
  • Delete or insert rows in a workbook Solved/Closed

    Hello, sir how i can delete or insert rows in a workbook between sheet one & sheet two for example when i insert or delete row in sheet one i wa...

    ehsan | Latest reply: TrowaD Oct 12, 2017
    1 reply
  • How to use a macro to check data in 2 work sheets Solved/Closed

    Hi team I have 2 work sheets with thousands of data. I need a macro to compare data in these 2 work sheets and show the result(matching or not matc...

    MadhaviLakshmi | Latest reply: ac3mark Oct 9, 2017
    1 reply
  • Use Macros to copy worksheet and rename using a list of names Solved/Closed

    Hi all, I'm an excel novice and hoping for help. I need to write a macro to 1. Copy worksheet "Alstromeria" and 2. Rename worksheet to the name...

    eswhi | Latest reply: eswhi Oct 7, 2017
    0 replies
  • How to generate a STATIC unique identifier for each Excel row Solved/Closed

    Hello, How can generate a unique identifier for each Excel row that WILL NOT change when I delete or add rows? System Configuration: Windows /...

    Musicar | Latest reply: ac3mark Oct 6, 2017
    4 replies
  • Two IF forumlas inside an IF formula Solved/Closed

    Hello, I am very new to using excel but somehow have managed to bluster my way around so please let me know if I am barking up the wrong tree! ...

    AdrianHowland | Latest reply: Mazzaropi Oct 6, 2017
    4 replies
  • Autopopulating multiple sheets from one main sheet Solved/Closed

    Hello, I'm making an accounting workbook for an organization I am the treasurer for, and I've run into a problem. On the first sheet "Account"...

    Mikey | Latest reply: TrowaD Oct 5, 2017
    45 replies
  • How to sum a number from a range of cells, based on value Solved/Closed

    Hello, I'm trying to update a spreadsheet that contains our wedding mailing list. The rows contain the invitee name, address and email address....

    cathcam | Latest reply: TrowaD Oct 5, 2017
    3 replies
  • Rank of numbers between specified range Solved/Closed

    Hello, Dear Sir, I have following data Marks Desired Rank 91.3 2 91.4 2 91.5 1 91.7 ...

    talent.anand | Latest reply: TrowaD Oct 2, 2017
    3 replies
  • Formatting cells based on certain criteria Solved/Closed

    I want to make a cell change colour based on a number of different criteria: Cell A1 Has an incident date B1 Displays the date 14 days after the inc...

    sailingdemon | Latest reply: sailingdemon Sep 29, 2017
    7 replies
  • SUM IFS function Solved/Closed

    Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a co...

    dshaviv | Latest reply: dshaviv Sep 25, 2017
    2 replies
  • Excel Macro: Copy formulas across worksheets Solved/Closed

    So first off, I have no Idea how to program, but I can kind of understand simple programs. Either way, I'm trying to figure out a macro in MS Excel...

    Bobo | Latest reply: OCG Sep 24, 2017
    12 replies
  • Arrow keys scrolling in Excel Solved/Closed

    Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do not...

    Deb | Latest reply: Upthewall Sep 20, 2017
    24 replies
  • Excel work sheet not copy to another sheet Solved/Closed

    Hello, System Configuration: Windows / Firefox 52.0 I am =DGET(Sheet1!1:156,"NAME",$A$1:E$2) but it is not work

    a g doddamani | Latest reply: a g doddamani Sep 20, 2017
    0 replies
  • Help with formula please Solved/Closed

    Hi, please could someone help me with a formula to add up cells that have data in them. My spreadsheet has data in columns B-N - some of them have ...

    CB7373 | Latest reply: CB7373 Sep 19, 2017
    3 replies
  • Subtract last column from first column Solved/Closed

    Hello, I am having a problem i have a excel sheet there are the data for various employees timing. first of all i want to search the last colu...

    Gaurav Kumar | Latest reply: vcoolio Sep 18, 2017
    3 replies
  • Need to calculate monthly avg and yearly miles from odometer Solved/Closed

    Good afternoon, I am having an issue figuring out how to get excel to calculate the yearly mileage and monthly avg by just monthly odometer reading...

    jamishore | Latest reply: vcoolio Sep 13, 2017
    5 replies
  • Auto-populate info. from master sheet to multiple sheets Solved/Closed

    Hi, I have been working on an excel sheet for the past month and have not found a solution that would do what I need it to do. I'm sure there have ...

    kvil | Latest reply: TrowaD Sep 12, 2017
    15 replies
  • Update data from one sheet to the next. Solved/Closed

    The macro I want just takes data from one tab and adds it to another like an update. i suspect that the macro will take some time to make as the updat...

    raymondald | Latest reply: ac3mark Sep 5, 2017
    3 replies
  • Conditional formating - apply on more cells Solved/Closed

    Hello, i'm not so familiar with conditional formatting, so I would like to ask something: I'm making a doc where Column A has number values, column ...

    Biljana | Latest reply: Raj Aug 30, 2017
    32 replies
  • How to change the date format in Excel 2007 Solved/Closed

    Hello, i want to know that howcan I change the dateformat in excel 2007 worksheet if I want it like :- monday,1dec.2008 plz. answer me soon....

    PANKAJ | Latest reply: Praveen Aug 26, 2017
    22 replies
  • Search for input criteria, return designated cells. Solved/Closed

    Hey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...

    crlarus | Latest reply: vcoolio Aug 19, 2017
    12 replies
  • Copying dates to another worksheet. Solved/Closed

    Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...

    Scencea | Latest reply: vcoolio Aug 17, 2017
    12 replies
  • Excel formula - Add days to date based on drop down selection Solved/Closed

    I want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...

    Sabernethy | Latest reply: Mazzaropi Aug 17, 2017
    3 replies
  • How to auto-populate values from certain cells into a new sheet Solved/Closed

    Hello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...

    Roadknee | Latest reply: vcoolio Aug 12, 2017
    18 replies
  • Highlight only one column which has greater value Solved/Closed

    Hello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...

    Awais Munir | Latest reply: Mazzaropi Aug 11, 2017
    3 replies
  • True or False Value based on 3 difference cells' criteria Solved/Closed

    Hello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...

    KEVB | Latest reply: ac3mark Jul 26, 2017
    1 reply
  • Repeating a simple macro loop up to 1,500 times Solved/Closed

    Hi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...

    shassall | Latest reply: TrowaD Jul 20, 2017
    5 replies