Office Software Forum - solved topics

Ask a question
Results 651 - 700 of about 2,640
  • Solved
  • My email have been deleting without reading Solved/Closed

    Hello, I keep getting emails saying that some emails have been deleted without being read. The message below is typical of what I am seeing is: ...

    Ganesh | Outlook | Latest reply: raja Mar 4, 2016
    8 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 | Excel | Latest reply: sierranz Mar 3, 2016
    2 replies
  • outlook repair tool for .pst files Solved/Closed

    Hello everyone, I'm not really sure what happened, but this morning, one of my pst-files was missing and for another I got the error: "Errors have ...

    hestomaras | Outlook | Latest reply: ankitsajwan90 Feb 29, 2016
    3 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: Ann Feb 22, 2016
    2 replies
  • Frequent missing emails inbox (blank) Solved/Closed

    Hello, Please assist me , why my email in my inbox goes missing, this is my 5th time it happen again. Once my inbox emails goes blank, I need to s...

    Ganesh | Outlook | Latest reply: Ambucias Feb 20, 2016
    7 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: TrowaD Feb 18, 2016
    15 replies
  • Find Serial Number and input Average Value into Adjacent cell Solved/Closed

    Hello, I'm trying to find out if there is a way to do this. i have a list of 15k serial numbers. several of them repeat because the value vary. i ...

  • 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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... | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: smuneeb Jan 1, 2016
    2 replies
  • How To Apply Conditional Formatting in Excel Solved/Closed

    Hello, I need to apply conditional formatting to range H1:H10000 based on corresponding values in another column, G1:G10000. If the value in t...

  • excel question, if cell contains certain word Solved/Closed

    Hello, I have a excel spreadsheet that has a bunch of companys with full addresses, phone numbers, etc. They are all in column A. I want the inf...

    Christin | Word | Latest reply: Kym Dec 29, 2015
    5 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | 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 | Excel | Latest reply: RayH Dec 15, 2015
    1 reply
  • outlook can receive mail but can't send mail Solved/Closed

    Hello, I have a friend who is suddenly unable to send emails. But he Can receive, however. Error Message is "unknown error" Ox800CCC13 windows 10 ...

    Pinto | Outlook | Latest reply: Ambucias Dec 12, 2015
    3 replies
  • 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 | Excel | 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 | Excel | Latest reply: hockeymom Dec 8, 2015
    2 replies