Excel Forum - solved topics

Ask a question
Results 751 - 800 of about 1,720
  • Solved
  • Some cell Date Could not change Solved/Closed

    Hello, I was having the same problem and this solution worked But Some cell Date Could not change Configuration: Windows XP / Firefox 36.0

    Muhammad Afzal | Latest reply: TrowaD Mar 24, 2015
    1 reply
  • Comparing data in 3 columns on a Microsoft Excel spreadsheet Solved/Closed

    Would be really grateful for some help. I have 3 columns of different lengths with email addresses in them and I want to see all instances where th...

    daniz39 | Latest reply: daniz39 Mar 23, 2015
    2 replies
  • Excel 2013 Formula - maybe IF formula? Solved/Closed

    I have a list of names in Excel and I need to put their supervisor name in the cell to the right of each name. I would like to find a formula that wi...

    Cookie5 | Latest reply: Cookie5 Mar 23, 2015
    2 replies
  • WordNum help needed Solved/Closed

    Hello, I hope somebody can help. I use WordNum to spell the result of a formula and it gives me 4 digits (spelled) after the point. I need just ...

    april_tat | Latest reply: TrowaD Mar 19, 2015
    7 replies
  • Cell format Solved/Closed

    Hi Guys, I'm new here, I have a very limited knowledge about excel. My superior has asked me to do some sort of Advanced Cell Formatting in our per...

    mastachaah | Latest reply: MaxStart Mar 17, 2015
    3 replies
  • Text-to-text equals number Solved/Closed

    Hi.. I'm looking for a solution for a dilemma I'm in.. On sheet 1 I have a dropdown box in cell A1 and B1 is an emtpy cell. On sheet 2 I have the...

    kriswiberg | Latest reply: kriswiberg Mar 17, 2015
    5 replies
  • Formula, Blank Cell Solved/Closed

    Sorry in advance if this has been asked but I can't see anything. Excel 2010 I have a cell that will contain a date then the next adjacent cell the...

    Andyman123 | Latest reply: MaxStart Mar 17, 2015
    3 replies
  • convert date into words(english) in excel 2003, 2007 or 2010 Solved/Closed

    Hello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into Twenty Second April T...

    manojfalak | Latest reply: MaxStart Mar 17, 2015
    1 reply
  • Conditional formating is applied based on date in two cells Solved/Closed

    Hi everyone I'm using Excel 2010 and applying conditional formating on dates in Column E. I don't want the formatting to be applied if there is the f...

    Capricorn56 | Latest reply: TrowaD Mar 16, 2015
    6 replies
  • Excel - Help Please! Drop Down and Data Filling Solved/Closed

    Good morning/afternoon. I was hoping you would be able to assist me with a query please. Currently my team is using 2 spreadsheets, one that li...

    CatherineGPR | Latest reply: CatherineGPR Mar 13, 2015
    4 replies
  • trying to have the current date go into one cell (A1) Solved/Closed

    Hello, I'm trying to have the current date go into one cell (A1) when an order number is entered in another cell (A2) but don't want the date to aut...

    dbmich | Latest reply: dbmich Mar 12, 2015
    3 replies
  • A strange Range question ... Solved/Closed

    Hi guys Im back with a new twist on one of my old problems. I had help earlier and one of you kind people hellped me out with a solution (thanks ag...

    BrianGreen | Latest reply: BrianGreen Mar 11, 2015
    8 replies
  • adding a loop to macro to insert pictures Solved/Closed

    Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...

    vba | Latest reply: M_TheJax Mar 5, 2015
    7 replies
  • Change calculated to a hard date Solved/Closed

    I used a +1 formula to create dates in column A. Now I want to make these "hard" dates so they don't keep changing every time I add a row. Thank you...

    Ritabook | Latest reply: Ritabook Mar 3, 2015
    2 replies
  • Transferring numbers to new worksheet automatically Solved/Closed

    Hello, I'm making a spreadsheet showing weekly costs. I've set it up so that each worksheet is a week, with totals using =SUM. I want to transfer th...

    Tresi | Latest reply: tresi Feb 28, 2015
    2 replies
  • Macro to create tabs and populate from other worksheets Solved/Closed

    I already posted this on the programming forum but have not had any responses as yet so I am trying here as it may be more appropriate. Current Set...

    ibtrini | Latest reply: Nickname Feb 26, 2015
    4 replies
  • How to transfer lines of txt from one sheet to another sheet? Solved/Closed

    Hello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there automaticly ...

    Mike | Latest reply: Mike Feb 24, 2015
    6 replies
  • Repair Excel Files. Solved/Closed

    Hello Experts, My problem is as follow: We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder contained ...

    allisoncharl... | Latest reply: pearsonjoseph301 Feb 22, 2015
    3 replies
  • how to remove image with VB? Solved/Closed

    Hello, I have everything working but removing the image before saving. The code is not working and not even sure where to place it. (using excel...

    Janit | Latest reply: vcoolio Feb 20, 2015
    6 replies
  • Conditional formatting based on another cell; apply to rows Solved/Closed

    Hello, I have two columns. Column A is for expiration dates, and Column B has a drop down menu indicating the status of an request (eg, pending, a...

    radiofriendl... | Latest reply: radiofriendlybox Feb 20, 2015
    2 replies
  • Need help with date and if statement newbie Solved/Closed

    Hello, I am trying to work out a formula if possible, to determine a date based on a date in another cell. So if the Date in Cell A is 3/1/2015,...

    T | Latest reply: cmarzahn Feb 20, 2015
    5 replies
  • How to replace * with / in all formulas in an excel sheet Solved/Closed

    hi Guys, does anyone of you know please how to replace the multiply sign with a divide sign in all of the formulas in an excel sheet? I could not f...

    DG83 | Latest reply: DG83 Feb 18, 2015
    4 replies
  • time calculation (TimeXnumber) Solved/Closed

    Hello, i want calculate the salary of workers like the following example. worker No.1 salary/hour 1$ working hours this week 3:45 (3 hou...

    ArashMan | Latest reply: ArashMan Feb 17, 2015
    4 replies
  • Conditional formatting with range Solved/Closed

    Hello, I have a little bit of a problem, I want to mark a cell in a range that is equal to another cell in different range, I can't figure it out....

    MindTwister | Latest reply: MindTwister Feb 10, 2015
    2 replies
  • IF/OR Formula Solved/Closed

    Help please I need to look up a cell and if it =1 return 1, =2 return 0.6, =3 return 0.4, = 4 return 0.2, if >4 return 0.0 for example A B ...

    ad1959 | Latest reply: vcoolio Feb 10, 2015
    3 replies
  • How to repeat a row 4 times, while increasing sequence Solved/Closed

    Hello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 ...

    Stumped.. | Latest reply: OldCoder Feb 6, 2015
    2 replies
  • Converting rows of data in notepad to columns Solved/Closed

    Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...

    Need help | Latest reply: Philgood_FR Feb 5, 2015
    2 replies
  • conditionally copy columns Solved/Closed

    Hello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...

    GMHerbs | Latest reply: GMHerbs Feb 4, 2015
    2 replies
  • Change a range dynamically - VBA script. Solved/Closed

    Hi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...

    BrianGreen | Latest reply: BrianGreen Feb 4, 2015
    5 replies
  • removing false in excel Solved/Closed

    =IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!

    umer007 | Latest reply: umer007 Feb 2, 2015
    2 replies
  • Increment a cell value - conditions applied Solved/Closed

    Hello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the value ...

    peweuk | Latest reply: peweuk Feb 1, 2015
    2 replies
  • Rating from Parameter Lookup Solved/Closed

    Hi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...

    dxa02091 | Latest reply: dxa02091 Jan 30, 2015
    11 replies
  • Nesting if() functions? Solved/Closed

    Hey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...

    gcaorsiw | Latest reply: pijaku Jan 29, 2015
    3 replies
  • 1 time data entry Solved/Closed

    Hello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...

    ArashMan | Latest reply: ArashMan Jan 23, 2015
    14 replies

    Hello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...

    Babu546 | Latest reply: Babu546 Jan 22, 2015
    5 replies
  • Regarding Pivot Solved/Closed

    Hi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag multiple ...

    Karthikeyan1207 | Latest reply: Karthikeyan1207 Jan 22, 2015
    2 replies
  • Find the first available (empty) cell on a worksheet. Solved/Closed

    As a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a wor...

    BrianGreen | Latest reply: BrianGreen Jan 21, 2015
    19 replies
  • Lookup problem. Solved/Closed

    I have a column of 20 dates in col. B spaced by 2 or 3 weeks, and a number beside each one in col. C. In cell C24 I need a formula that returns the v...

    pothole | Latest reply: Babu546 Jan 21, 2015
    5 replies
  • Copy Paste Data in Same column for multiple time Solved/Closed

    Hello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After copy p...

    sudeep.leadtech | Latest reply: sree Jan 21, 2015
    5 replies
  • Replacing Duplicates Solved/Closed

    My Excel spreadsheet is set out as follows: A B C D E F 1 2 14 0 14 14 2 1 13 0 13 13 3 4 4 1 4 4 4 3 3 1 3 17 ...

    whatsit | Latest reply: TrowaD Jan 20, 2015
    38 replies
  • Excel - Macro to highlight Rows with Duplicate values in a cell Solved/Closed

    Geetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers or ...

    ajaydwivediji | Latest reply: TrowaD Jan 19, 2015
    11 replies
  • IF function with DATE in Excel Solved/Closed

    Hi, hope someone can assit. I need to create a sheet where I must take the current date and add a fulle week or two weeks to the date by selecting an ...

    ace-82 | Latest reply: ace-82 Jan 19, 2015
    2 replies
  • Macro for copying data from different sheets Solved/Closed

    Hello, I am trying to copy data from different sheets to master sheet under the following criteria 1. Master sheet should be generated when ev...

    Kishore | Latest reply: NK Jan 16, 2015
    23 replies
  • Trying to sum a column that contains various text Solved/Closed

    I'm a novice when it comes to excel and I'm hoping someone can help me with a formula. I'm trying to give a value to various text in columns and then ...

    chris82675 | Latest reply: chris82675 Jan 15, 2015
    3 replies
  • Excel Query Urgent Please. Solved/Closed

    Hello, I have the below data in sheet 1, where as in column A its the activity and column b its the name of person who has done it. and the names ...

    wasey | Latest reply: wasey Jan 15, 2015
    11 replies
  • Compare two sheets based on a common ID in both sheets in col A Solved/Closed

    Greetings Kioskea team, First of all, my heartiest congratulations and thank you to the great Kioskea team that who have a mine of excellent solut...

    Ajay Dwivedi | Latest reply: Ajay Dwivedi Jan 8, 2015
    8 replies
  • Percentage Work Solved/Closed

    Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I at...

    Winndixie | Latest reply: RayH Jan 6, 2015
    6 replies
  • Text label and value if value in other worksheet is > 0 Solved/Closed

    Hello, can someone please help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label...

    fixradio | Latest reply: TrowaD Jan 5, 2015
    5 replies
  • Excel - To generate unique ID Solved

    Hello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Bel...

    wliang | Latest reply: ferg Jan 1, 2015
    4 replies
  • I need a macro please Solved/Closed

    Hello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B havin...

    rjbuer | Latest reply: rjbuer Dec 31, 2014
    7 replies