Office Software Forum - solved topics

Ask a question
Results 2351 - 2400 of about 2,650
  • Solved
  • Changing a value using a look-up table Solved/Closed

    Hello, I am looking for help on writing a macro that will perform a VLOOKUP formula that will compare the value in G2 on Sheet1, to the value in A...

    froggy6703 | Office Software | Latest reply: rizvisa1 Apr 6, 2010
    1 reply
  • copying % formula Solved/Closed

    Hi, I regularly calculate a series of number as a percentage of a sum that remains constant (expense item as a percentage of total expenses, for eg.) ...

  • Help on Excel Formula Solved/Closed

    I need to create a formula to give me with value and not TRUE/FALSE information. I did use the IF function, but it results in TRUE/FALSE and I need a...

    teeco | Excel | Latest reply: venkat1926 Apr 6, 2010
    1 reply
  • Comparing Column Values Solved/Closed

    I am trying to compare two columns to see if they carry the same values - column A has 556 values (starling at line 3), and column B has 69 values (st...

    ExcelHelp | Office Software | Latest reply: rizvisa1 Apr 5, 2010
    2 replies
  • 2+2=5 Solved/Closed

    can u prove it with littel mistake in mathematics.

    maulik | Office Software | Latest reply: le hollandais volant Apr 5, 2010
    1 reply
  • Identify two or more are same or not in Excel Solved/Closed

    Hi Everyone, I have an excel formula question that someone might can help me with. A B 1

    SatGod | Excel | Latest reply: venkat1926 Apr 2, 2010
    1 reply
  • Count 2 values in one column and 1 val in oth Solved/Closed

    Hello, I have two column lists (two values in first column and one value in the other) e.g. Column A has the following values: A B C B B A C ...

  • Moving Data Solved/Closed

    Is there any one who can kindly come to my rescue!! I have been presented with date in the form: A B C D E F G H I J ? My aim is to pre...

    rhoknee | Office Software | Latest reply: venkat1926 Apr 1, 2010
    4 replies
  • match a string to a col & increment by 1 Solved/Closed

    I have two sheets with data as follows: Sheet 1 String, result A0101 Format of string in Sheet 1 column A: Axxxx (A - alphabet a to z, x num...

    seema_gu14 | Office Software | Latest reply: venkat1926 Mar 30, 2010
    1 reply
  • how to convert a numberic valu in to english Solved/Closed

    how to convert a numberic valu in to english

  • merge rows of similar data Solved/Closed

    Hi, I am trying to merge various rows of data with a common headin in Column A. For example I have the following data: A 1 0 0 0 1 B 1 1 0 0 ...

    Jay | Excel | Latest reply: rizvisa1 Mar 30, 2010
    1 reply
  • excel pro Solved/Closed

    hi , i have some data like gvn below M/C SR NO. total b4 a4 cl4 k92661400 18632 8544 544 9544 K81667500 21844 18948 1948 948 H25102020 6756 8...

    usha | Excel | Latest reply: rizvisa1 Mar 30, 2010
    6 replies
  • Filter duplicate entry with condition w excel Solved/Closed

    Hi, I've 2 columns of data. Column A are repeated Test sequence and Column B are Status (OK / Fail). I would like to extract those test sequence wi...

    Roger See | Excel | Latest reply: rogersee Mar 30, 2010
    2 replies
  • someone has stolen my password Solved/Closed

    hi, someone has stolen my email password.. and iam not able to get it back. how should i get it back?

    nana | Word | Latest reply: Ambucias Mar 29, 2010
    1 reply
  • memory card password Solved/Closed

    Hello, i have nokia 3110c and I had put a password for the memory card and now I have forgotten the password so if u can help me thank ...

    sangarsh | Word | Latest reply: abhi Mar 29, 2010
    2 replies
  • Changing cell ranges in all series of a graph Solved/Closed

    Hello, I have a graph with 5 series on it. ='Entire series of data'!$E$17,'Entire series of data'!$E$5066:$E$6375,'Entire series of data'!$I$17...

    Sasi | Office Software | Latest reply: Kenneth Just Mar 28, 2010
    17 replies
  • Find Max Valu every 10 rows &mark row as keep Solved/Closed

    Hi, I need help creating a formula in excel to Identify the Highest and Lowest values Every 10 rows THEN Identify those two rows...

    Jman | Excel | Latest reply: venkat1926 Mar 27, 2010
    3 replies
  • Compare numbers in two columns in Excel Solved/Closed

    I appreciate any response to help me with this. I have two columns of numbers A B B.121 S.222 S.154 B.121 B.164 ...

    rypton | Excel | Latest reply: rizvisa1 Mar 26, 2010
    1 reply
  • Keeping only specfic text in a cell Solved/Closed

    I have an excel file that has data dumped from external source (P6). One cell contains a lot of data of which I only need very specific. Here is wha...

    noobkelsey | Office Software | Latest reply: noobkelsey Mar 26, 2010
    4 replies
  • Excel Macro - using integers as cell referenc Solved/Closed

    OK, I've written this and I'm having some trouble. I've put the comments in the code (preceded by ****) rather than giving you a summary here. I thi...

    Andy May | Excel | Latest reply: Andy May Mar 24, 2010
    9 replies
  • Excel: Need Macro to run when value entered Solved/Closed

    Hi! It's been a long time since I used VB. I seem to be a bit rusty, and I can't figure this out. What I need is for a specific macro to run when...

    beka0422 | Excel | Latest reply: aquarelle Mar 24, 2010
    8 replies
  • Macro to Deleting Multiple Rows Solved/Closed

    Hello, I am running a simple formula in excel to sort out duplicates from a given row, by adding the value "DUP" in a new column on the spreadsheet. ...

    froggy6703 | Excel | Latest reply: rizvisa1 Mar 24, 2010
    1 reply
  • Select by lowest cell value & group by column Solved/Closed

    Hi There, I would appreciate, if anyone could help me with the following. Item Qty Length Supp1 Supp2 Supp3.......Supplier7 A ...

  • Copy with lookup Solved/Closed

    Hi, I am working with 2 Excel, One field is common in both the excel "SID". I need to copy the row of SID say 'ABC' from Excel B and append to the ...

    Shankar | Office Software | Latest reply: venkat1926 Mar 22, 2010
    1 reply
  • microsoft word Solved/Closed

    i have a old microsoft word dosc i cant remember the serial # for how do i go about finding it on the program?

    shasha | Word | Latest reply: xpcman Mar 22, 2010
    1 reply
  • Win messenger my secret answer or my password Solved/Closed

    Hello, i need to get in my windows messanger but i forgot my password and my secret answer. It is very important for me to get in there right n...

    chubbyneat | Word | Latest reply: aquarelle Mar 21, 2010
    3 replies
  • how to remove password of my micro memory car Solved/Closed

    Hello, i m V andana. i forget my memory card password .my phone is nokia 5130. and i have sd micro memory card of !GB.i want data from memory card p...

    Vandana | Word | Latest reply: ash_perez01 Mar 20, 2010
    1 reply
  • extracting data from specified columns Solved/Closed

    I have some columns of data looking somewhat like this: data1...data2...data3 val.........val........val val.........val........val val............

    shuvit | Excel | Latest reply: rizvisa1 Mar 19, 2010
    1 reply
  • Need help on VLOOKUP Solved/Closed

    I have list of Incident numbers(both Closed and open) in Cloumn A and only open incident numbers in column B. I should be able to filter the rows base...

  • forget skype password Solved/Closed

    Hello, my skype password has changed by someone how i open my accountConfiguration: Windows XP Internet Explorer 8.0

    mrs.saleem | Word | Latest reply: John Mar 19, 2010
    3 replies
  • Need help on an excel if/then in Macro Solved/Closed

    I'm trying to create an If/Then in Macro for a cell which you input what GPM you want to use. The goal is to stop sales people from making errors and ...

    Gman24 | Excel | Latest reply: Gman24 Mar 19, 2010
    2 replies
  • VB for split data Solved/Closed

    Department | Name | Amount Spent | In my file, there's one column specified different departments of a company, with their money spent by the peo...

  • Copy down formula if cells on left non blank Solved/Closed

    Hi, I need code to copy down a formula from R2 to R3, R4 , R5 etc only if H3, H4, H5 etc is nonblank. I also need to copy formulae from U2:CY2...

    Cochise | Excel | Latest reply: rizvisa1 Mar 18, 2010
    1 reply
  • Lookup/Identify next number,Paste into cell Solved/Closed

    Hello,I need help with a identifying the next number! When pressing the Save button on sheet1-Form(Code below),lookup the last number that was used...

  • repeat formula Solved/Closed

    Hello, I need the the formula to work for every cell in column A. So if I select A1 and enter a number >= 40 it skips the next cell, and if I select ...

  • Compare two columns and delete duplicates Solved/Closed

    I have a large amount of data that is supposed to be unique based on two columns (Column A, Column B). The combination of these two columns are not s...

    tmiddlemas | Excel | Latest reply: tmiddlemas Mar 17, 2010
    2 replies
  • Compare 3 Columns excel Solved/Closed

    Hello, I have to compare 3 columns (A,B AND C) filled with names and return, in another column (E), the list adding the names from the 3 columns (...

    Lookup | Excel | Latest reply: Lookup Mar 16, 2010
    2 replies
  • Help Need writing a formula Please Solved/Closed

    Hello, I have a report I pull which outputs IDs. There are 5 IDs. Management would like to display their respective Site locations instead of the IDs...

  • Excel Macro to group by column & sum value Solved/Closed

    Hi there, I need to write a macro for following example. Item Qty Length A 1 100 A 1 100 B 2 200 B 1 100 B 5 100 C 4 200 C 2 100 C...

    Shital | Excel | Latest reply: Pearson24 Mar 16, 2010
    2 replies
  • Adding Cells Solved/Closed

    Hello, I am trying to build a macro that allows me to input a number on Sheet1 and then on Sheet2, add that number of Cells. Example. Sheet1 ...

    DC | Excel | Latest reply: rizvisa1 Mar 15, 2010
    6 replies
  • Help with Excel percentages Solved/Closed

    Hello, Please bear with me as I a very new to this type of syntax with that said here we go. I have four date columns in Excel like so: P...

    krzykris | Excel | Latest reply: krzykris Mar 15, 2010
    2 replies
  • Convert active excel wksht to pdf file Solved/Closed

    Hello, I'm trying to figure out how to create a macro to save an range selected in an active worksheet and save to a pdf file by clicking an inserted...

    onedog | PDF | Latest reply: onedog1 Mar 15, 2010
    14 replies
  • figuring a number based on a percentage incre Solved/Closed

    Hello, if i have a number and want a formula to know that it is a percentage of another number, what is the formula in EXCEL? i.e. if i have a s...

    molli0707 | Office Software | Latest reply: molli0707 Mar 14, 2010
    2 replies
  • assign Macro to all yellow highlighted cells Solved/Closed

    Hello, I am in currently in a pickle ... I hope all the masters could lend a hand to this VBA noob... Right now i wrote a macro to copy all formula ...

    Alby | Excel | Latest reply: rizvisa1 Mar 14, 2010
    3 replies
  • Excel VBA Msg Box when cell meets criteria Solved/Closed

    Hello, Hi this will probably be very simple for someome however I am having a nightmare day, all I want is a vba formual which will bring up a mess...

    Iangough16 | Excel | Latest reply: rizvisa1 Mar 13, 2010
    9 replies
  • forgeten my password Solved/Closed

    Hello, hi could u please help me to found my alternate email address and to found my password too because they have steal my password and i can...

    mab | Word | Latest reply: dist.urbd Mar 13, 2010
    4 replies
  • forgot password Solved/Closed

    Hello, i forgot my password in facebook. The problem is that the e-mail adress in google is different from e-mail adress of the facebook. Please help.

    erik | Word | Latest reply: Ambucias Mar 13, 2010
    1 reply
  • Excel page linking Solved/Closed

    Hello, I'm trying to link 5 pages which each have a total amount on, I am looking to put all the totals automatically on one page, what i am asking i...

    Bubba | Excel | Latest reply: rizvisa1 Mar 13, 2010
    3 replies
  • How to make formula in excel cell for time? Solved/Closed

    Hello, I want to make spread sheet with time in the Excel CELL How to do that? For example 1st cell should show 11hrs.56mins.05sec and next cell I ...

    Ram | Excel | Latest reply: Excel dummy Mar 12, 2010
    2 replies
  • Marco to delete cells containing an interger Solved/Closed

    Hello, I am stuck and would love some help. I have two Columns in Excel J and K. The two Columns contain numbers from 1 to 53. I would like to...

    KareemB | Excel | Latest reply: KareemB Mar 12, 2010
    7 replies