Excel Forum - solved topics

Ask a question
Results 551 - 600 of about 1,710
  • Solved
  • combine of column Solved/Closed

    Hello, How can we show value of more than two column in a single column but in two rows. please reply at the urgent.

    Deepak Upreti | Latest reply: TrowaD Mar 10, 2016
    3 replies
  • Comparing two excel worksheets Solved/Closed

    please, I need a macro code that can actually compare two worksheets and flag up the differences using same color to show the dissimilar rows. Be...

    wingie | Latest reply: vcoolio Mar 10, 2016
    9 replies
  • conditonal format a because of values in another cell Solved/Closed

    Hello, i am trying to figure out how i can format a cell to show green when above a figure and red when below the figure simple i know but here co...

    Watson | Latest reply: BrianGreen Mar 7, 2016
    3 replies
  • Function Formula Date and Text Solved/Closed

    Good day I am looking for help with a function formula PLEASE. Example Decleration Start Date 2016.02.17 Last inv_ Inventory_ Decl frm 1...

    Gerberreinette | Latest reply: vcoolio Mar 7, 2016
    4 replies

    Hello, I alreadly use spellnunber but the problem is it does not convert incorrect for my currency. Present Situation =SpellNumber(1,100,000) =...

    khamlanathph... | Latest reply: Lan Mar 5, 2016
    2 replies
  • Conditional formatting on an entire row Solved/Closed

    Hello, I want an entire row to turn red, only when one cell in that row is less than 0. I tried highlighting the whole row with the formula =A12

    AKA | Latest reply: AKA Mar 4, 2016
    4 replies
  • Copy rows from sheet 1 to sheet 2 if rule is met Solved/Closed

    Hi I have a contact list I need to extract data from. Full contact list is sheet 1 Names are in A2:A12948 Internal phone numbers in B2:B12948 ...

    sierranz | Latest reply: sierranz Mar 3, 2016
    2 replies
  • formula Solved/Closed

    Hi please I am looking for a formula to get difference between 2 sheets example sheet 1 sheet 2 ndc quantity nd...

    krissannidhi | Latest reply: RayH Feb 26, 2016
    1 reply
  • Need cell value copy to defferent -2 work sheets within a Excel Solved/Closed

    Hello, hi all i need to maintain a MIS on daily basis. in this, i need to enter same values multiple times on individual worksheet within a excel...

    naresh | Latest reply: BrianGreen Feb 25, 2016
    3 replies
  • excel function to Check neighbour cells match for all Solved/Closed

    Hi, I need to check if (each) cell in column A is having a match in column B, Example as below: Column A is phone numbers list, column B is mes...

    Frank211 | Latest reply: Dan slow Feb 25, 2016
    3 replies
  • To change cell value automatically Solved/Closed

    Hello everyone here, this is my first question in this forum. In Excel 2013, If I type 1 in cell A1, then it should automatically change as Apple in s...

    Dhanuj | Latest reply: Dhanuj Feb 22, 2016
    9 replies
  • Help with IF STATEMENT / VLOOKUP (I think) Solved/Closed

    I work for a planning company where we submit lots of applications to do with housing. Different application types have different lengths until decisi...

    bselby123 | Latest reply: ac3mark Feb 22, 2016
    1 reply
  • Help w/If Statement Solved/Closed

    Hello, Let us say I have 3 columns, column A is home email, column B is work email, and column C is other email. On column D, I want to return th...

    Cathy | Latest reply: Ann Feb 22, 2016
    2 replies
  • Macro Help Solved/Closed

    Greetings fellow users! I am in need of some assistance: Recently, I have created a macro in which I need to copy 100+ variables from one sh...

    futurepsych92 | Latest reply: futurepsych92 Feb 19, 2016
    2 replies
  • VBA single click to get current date Solved/Closed

    Hello, I'm brand new to VBA and the code that bhargav posted on Feb 6, 2013 10:48AM worked perfectly to get current time in a range of cells with ...

    sroche317 | Latest reply: sroche317 Feb 19, 2016
    10 replies
  • How to compare two Excel sheets with varying data Solved/Closed

    Hello, Before I start let me just say Thanks in advance. So I am looking for an ongoing updated answer. Every 3 months we receive a new price lis...

    BWIRyan | Latest reply: TrowaD Feb 18, 2016
    15 replies
  • CELL = YES or Other text return value Solved/Closed

    Hello, I'm using IF statements to return a value for the specifc answer supplied for the question and then adding up all the questions for the t...

    Jason | Latest reply: vcoolio Feb 12, 2016
    2 replies
  • How to check % value in excel and macro using VBscript? Solved/Closed

    Want to check a cell with % percentage format matches the value in Vbscript code. Sub ChangeColor() Dim lRow Dim myVar lRow = Range("AC" & Row...

    anjanasundaram | Latest reply: anjanasundaram Feb 11, 2016
    4 replies
  • Formula to copy rows a set number of times Solved/Closed

    Hello, I have a delivery manifest that shows the amount of products coming in, descriptions etc. that we use to produce barcode labels. Unfortunatel...

    cunla | Latest reply: Sadat Feb 11, 2016
    2 replies
  • VBA Using subroutines - help please Solved/Closed

    Ok guys, I have a problem (well more than one, but Im not sure I should mention those on this forum!). Im in the process of writing an Excel macro ...

    BrianGreen | Latest reply: BrianGreen Feb 10, 2016
    7 replies
  • Date format nightmare Solved/Closed

    solved with this: Because it is not a date to excel. 1. Select the column in which there was date 2. Goto data and choose text to column 3....

    Webill | Latest reply: xpcman Feb 5, 2016
    1 reply
  • Excel sum value... Solved/Closed

    Dear I would like to know how to do the below mentioned formula I have tried but not resulted. Excel - Sum value in column when cells contains ...

    anazar | Latest reply: anazar Feb 3, 2016
    2 replies
  • Formula Help Solved/Closed

    Can someone please help me with this formula =IF(G2="1",VSC410, IF(G2="2",VSC450, IF(G2="3",VSC470))) What i am trying to do is : if G2 has the...

    marg2810 | Latest reply: vcoolio Feb 3, 2016
    3 replies
  • Conditional Formatting based on year Solved/Closed

    Guys, I come again cap in hand with another plea for help on a sort of finished project, but I want to make it better. I have some conditional f...

    BrianGreen | Latest reply: BrianGreen Feb 2, 2016
    1 reply
  • Extracting rows from excel Solved/Closed

    Hi there, I have an excel sheet with a very large data. I want to extract different rows and write them in to different sheets of the same excel (or ...

    Teke | Latest reply: vcoolio Feb 1, 2016
    3 replies
  • Column to vlookup Solved/Closed

    I am trying to write a formula that will give me the value in a cell, it needs to come from two sources. I must be able to locate the column based on ...

    benhalla | Latest reply: NickBR Jan 28, 2016
    1 reply
  • Disable a cell in excel using VB code Solved/Closed

    Hello, I am looking for a VB code to disable a cell based on the value of another cell in excel. Example:- Need to disable Cell B1/C1/D1 based o...

    Jinto | Latest reply: TrowaD Jan 28, 2016
    13 replies
  • User Friendly Code for Admission No Solved/Closed

    Hello, I would like to request to Code for Admission No Range is started from B11 to B510 If user enter a123456789 or a-123456789 it always conv...

    smuneeb | Latest reply: smuneeb Jan 26, 2016
    6 replies
  • If one cell G4 has value 12345 then cell F4 will have.... Solved/Closed

    I need help with a basic excel formula. Please :) If cell G4 equals 12345 then cell F4 equals USXX but also if cell G4 equals 54321 then cell F4 w...

    NeedExcelHel... | Latest reply: ac3mark Jan 26, 2016
    3 replies
  • Auto Copy Row from one Sheet to another via Info in first Cell Solved/Closed

    Hello everyone, hope you all had a great New Year. I am in the process of exporting a BOM out of Inventor and then opening it with Excel. Once I ha...

    DK97008 | Latest reply: TrowaD Jan 25, 2016
    10 replies
  • Macro to rename sheets based on cell value in another sheet Solved/Closed

    I am attempting to rename 5 sheets in a workbook based on values from a sheet titled Raw Data Information. The first sheet should be named based on '...

    jlcorte14 | Latest reply: jlcorte14 Jan 20, 2016
    0 replies
  • Excel Filter/Macro Solved/Closed

    Hello, Thank you in advance for any time/help you can offer! I'm working on a contact list in Excel and I need to be able to filter my contacts i...

    LSKM | Latest reply: vcoolio Jan 15, 2016
    4 replies
  • Columns & Rows Help Solved/Closed

    Hello all, In short, here is what I need help doing: I would like to take 15 items in one column and transfer them into a row in another spread...

    futurepsych92 | Latest reply: futurepsych92 Jan 14, 2016
    5 replies
  • formula if you have credit in one column, debit in next column Solved/Closed

    Hello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column. Many thanks R Horner Configurat...

    Jack | Latest reply: Jackthelad Jan 13, 2016
    4 replies
  • How to re/name a cell if another cell contains X Solved/Closed

    Hello, Apologies if this is a simple question but having some trouble figuring it out. I have say 1000 rows of data and I need to label them all...

    Alexzandeur | Latest reply: vcoolio Jan 8, 2016
    5 replies
  • Strike through when entering date Solved/Closed

    Hello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last d...

    Bill | Latest reply: vcoolio Jan 2, 2016
    3 replies
  • Place new Code to Working Code Solved/Closed

    Hello, I would like to request that some line of code (marks as bold) I have to place in the Working Code which is given below that I cannot figure...

    smuneeb | Latest reply: smuneeb Jan 1, 2016
    2 replies
  • Excel help Solved/Closed

    In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last date to the far ri...

    wpsmith9 | Latest reply: wpsmith9 Dec 28, 2015
    0 replies
  • Hello, where am I going wrong with this formula? Solved/Closed

    =P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10) The final result in cell AV10 must be the value in cell P10 plus ROUND(SUM... [H...

    j1969c | Latest reply: j1969c Dec 22, 2015
    6 replies
  • I want to build intelligent excel Solved/Closed

    Task is: For example I have list of different fruits in cells in separate rows Apple Pear Plum I want the data to be copied to third cell,...

    nullun | Latest reply: nullun Dec 21, 2015
    7 replies
  • Extracting multiple date from master sheet to new sheets Solved/Closed

    Hi I run a sports tipping site and I want to extract data from my master sheet to make other sheets. I.e in sports cloumn I have multiple sports and w...

    alan180 | Latest reply: alan180 Dec 21, 2015
    32 replies
  • specific price depending on the words in 2 cells? please help Solved/Closed

    Hello, I am using excel 2008 for Mac, i need help with the following: example: A1 has a drop down box of 3 choices, apples, pears and peaches ...

    JoeyM | Latest reply: JoeyM Dec 20, 2015
    6 replies
  • Uniques identifiers Solved/Closed

    Hello, I have an excel spreadsheet with twelve months (5 columns each) with names and product type for each month. Each month can vary by name but...

    OPM | Latest reply: OPM Dec 20, 2015
    0 replies
  • Excel 2013 has stopped working Solved/Closed

    Hello, Every time I'd open Excel 2013 under Windows 8, it would crash instantly, leaving me a message: "Excel 2013 has stopped working". I looked ...

    Naileamm | Latest reply: kudret_hayrettin Dec 20, 2015
    2 replies
  • Find data and copy dynamic range Solved/Closed

    Hello all, I would like to find text in one column and copy the range values which is adjacent to the text searched. I've attached the sample...

    Poojapriya | Latest reply: Poojapriya Dec 16, 2015
    4 replies
  • Resize the range Solved/Closed

    Greetings, I would like to resize the range without keeping the starting position. I've attached the image In the above example, while usin...

    Poojapriya | Latest reply: Poojapriya Dec 16, 2015
    3 replies
  • Using the IF function for dates Solved/Closed

    Hello, I am trying to figure out in Microsoft excel 2010 the appropriate IF formula to use. I am trying to calculate the number of working days th...

    courtney | Latest reply: RayH Dec 15, 2015
    1 reply
  • help writing a IF formula Solved/Closed

    Hello, I need to write an IF formula for excel. Cell A2 will either say ''receive'' or ''deliver''. This formula works IF(A2=''receive'',1,2);...

    alex | Latest reply: ac3mark Dec 10, 2015
    1 reply
  • help with a formula Solved/Closed

    Please help !! Looking to calculate totals based on the following... Entering the formula in the following field K4 I have rows (B4 thru B18) e...

    hockeymom | Latest reply: hockeymom Dec 8, 2015
    2 replies
  • Formula to add 1 with IF statement Solved/Closed

    Hi, Here's the breakdown of what I'm trying to do: The formula is going in cell 'Y28' and I'm attempting to do two different things: 1) I want...

    edmaclod | Latest reply: edmaclod Dec 8, 2015
    2 replies