Office Software Forum - solved topics

Ask a question
Results 1751 - 1800 of about 2,650
  • Solved
  • looking for duplicate numbers from one column Solved/Closed

    Hello, i have 4300 old applicant numbers which i need to check against 3300 new applicant numbers and highlight duplicates. these are in two colu...

  • Excel: If A1 = a 4 the comy content of b1,2,3 Solved/Closed

    Hello, Please help! If A1 = a 4 the comy content of b1,2,3,4,5 to c1,2,3,4,5 The 4 in a1 are generated by a formula. Thanks Confi...

    Stormdronk | Excel | Latest reply: rizvisa1 Apr 3, 2011
    3 replies
  • Formulas to search for certain words in cells Solved/Closed

    Hello, I have monthly bank statements that are downloaded into excel, over 2500 line items. In Column A, I have the description of the transac...

    Juniore Guerra | Word | Latest reply: venkat1926 Apr 2, 2011
    4 replies
  • system password remove Solved/Closed

    Hello, how i can remove system password Configuration: Windows XP / Internet Explorer 7.0

    Nafyad | Word | Latest reply: bionik Apr 2, 2011
    1 reply
  • Excel - Help! Solved/Closed

    Hello, I require a formula which will recognise months in a column and select taht value from a different cell on the same row. The data is the...

    The_g | Excel | Latest reply: TrowaD Apr 1, 2011
    1 reply
  • Format using Macro Solved/Closed

    Hi I have some data in sheet1. Eg: Column A Column B Column C Column D 1 2 3 4 ...

    Rahul | Excel | Latest reply: harry Mar 29, 2011
    16 replies
  • Filter rows in one sheet Solved/Closed

    Hello, I have large amounts of data in one work sheet(say it as Sheet1) and another worksheet(sheet2) has few records(100) which are also present ...

    gd | Excel | Latest reply: RWomanizer Mar 29, 2011
    5 replies
  • converting rows data into columns on conditon Solved/Closed

    Hello, I have data which looks like below ColA-----------ColB-------ColC--------ColD------------ColE---------ColF-------ColG----ColH-------- AA-...

    gd | Excel | Latest reply: RWomanizer Mar 29, 2011
    3 replies
  • delete cells/rows but keep row info intact Solved/Closed

    hello, I am trying to import data from an excel spread sheet to access. I want to clean up my excel report before I import the date. In my report...

    lenice | Excel | Latest reply: TrowaD Mar 25, 2011
    2 replies
  • Looking for value in a column A Solved/Closed

    Hello, I have to prepare an invoice and calculate the amount of shipping. This is the lay out: I have to compare the subtotal value, E16, in ...

  • Dates in Excel Solved/Closed

    Hello, I have a list of people's birthdays in a list in Excel. I want to retain only the day and month of the birthday and get rid of the year. For ...

    eskagsms | Excel | Latest reply: RWomanizer Mar 24, 2011
    1 reply
  • Excel Comparing 2 columns removing duplicates Solved/Closed

    Hi, I would like to cmpare 2 columns in an Excel spreadsheet & remove duplicates from Column B if any matching fields are found e.g. A B 1 ...

    Ben | Excel | Latest reply: rizvisa1 Mar 23, 2011
    3 replies
  • Excel 2007 VLOOKUP and MATCH problem Solved/Closed

    Hello Long time lurker, first time poster. I'm having an issue with a Vlookup and match function. I have a set of data that is organised and sorted...

    Nikeyg | Excel | Latest reply: Nikeyg Mar 23, 2011
    1 reply
  • Transfer barcode info to inventory quantity Solved/Closed

    Hello, Is there a way to create a macros that would keep track of inventory quanitity by scanning a barcode? I have many boxes that have barcodes...

    osborns9 | Office Software | Latest reply: osborsm Mar 22, 2011
    2 replies
  • Office 2010 requirements Solved/Closed

    Hi, What are the requirements to install office 2010 on system?the minimum ram required? Please reply as fast as possible

  • Dell d505 booting password reset Solved/Closed

    Hello, DELL MODEL D505 BIOS REV. A09 laptop show service tag #9R1ZM1J-595B PLEASE TELL ME IF ANYONE HAVE SOLUTION Dell Latitude Bios Password un...

    rinkel78 | Word | Latest reply: bionik Mar 21, 2011
    1 reply
  • i forgot my password Solved/Closed

    Hello, could some one please help me i have a dell laptop inspiron 7500 and i cant log in i forgot my password can you help me ...

    morena | Word | Latest reply: bionik Mar 20, 2011
    1 reply
  • Pie Chart Comparison Solved/Closed

    Hello, I have made a number of different pie charts & want to compare them with each other. Each pie chart is comparing the same thing but the ...

  • i forgot my login password for my compaq CQ60 Solved/Closed

    Hello, i forgot my login password on my compaq CQ60 laptop, i just recently changed it and now i can't remember it. Can i please get a reply ASAP

    lawrence | Word | Latest reply: pcsces Mar 18, 2011
    1 reply
  • How to do if statements in Excel Solved/Closed

    Hello, I am having a problem trying to get an if formula right. If fig1 is +- 10% of fig2 I want it to say Fail If fig1 is within 10% of fig...

    Emerbeamer | Excel | Latest reply: Emerbeamer Mar 18, 2011
    2 replies
  • Summary Sheet Solved/Closed

    Hello Sir, I Have 30 Data Sheets Of Individual Date & 1 Summary Sheet. The Example Of Those 30 Sheets Are: A1------------B1------------------...

    Game Start Now | Excel | Latest reply: RWomanizer Mar 18, 2011
    9 replies
  • Assign a value depending on the font color Solved/Closed

    Hello, Can someone help me with this. I have a column with some text in each cell of that column. The text font is in either red or black co...

  • Searching a column for a list of values Solved/Closed

    Hello, I am using a macro to search for a list of values that i want to be written into the macro (Permanently). currently i am looping after each s...

    Charlie | Office Software | Latest reply: rizvisa1 Mar 17, 2011
    2 replies
  • Count appearances of specific words in Excel Solved/Closed

    Hello, I have a spread sheet with names of countries in the first column and over 1300 lines of text in the second column. I want to count number of t...

    eskagsms | Word | Latest reply: RWomanizer Mar 17, 2011
    1 reply
  • regarding samsung sgh-m20 slider password Solved/Closed

    Hello, please help me to reset the password for my mobile samsung sgh-m20, whose password has been forgotten by me. regards rajesh

    RAJESH | Word | Latest reply: Ambucias Mar 16, 2011
    1 reply
  • Bar and stacked bar graph in single graph Solved/Closed

    Hello, hi i have to make chart using three field month wise. and i want to make bar for first field and stacked bar for next two within same graph...

    RWomanizer | Office Software | Latest reply: RWomanizer Mar 15, 2011
    4 replies
  • Dell Latitude D-505 config password lost Solved/Closed

    Hello, Dear I have forgot the Confiq password of my Dell latitude D-505, which tag No. is 52MSW41 PLZ do help to reset or deactivate the said p...

    Khalid | Word | Latest reply: bionik Mar 14, 2011
    1 reply
  • Found Cell Color And Worksheet Viewing Solved/Closed

    Hello, The code below had cause the found value cell color to remain there even after I closed the Input Box.I would like to have the color to be re...

    azmiismail | Excel | Latest reply: TrowaD Mar 14, 2011
    2 replies
  • Compare the values and multiply the greater Solved/Closed

    Hello, A B 58.85 503.171 I want to compare the values in Column A and Column B and then multiply the greater with nu...

  • startup password Solved/Closed

    Hello, I just purchased a d260 mini secondhand and I stupidly thought I could change the administrator name, but of course it would not let me cha...

    pnknhd | Word | Latest reply: Ambucias Mar 12, 2011
    1 reply
  • Remaining Retirement Calculation Solved/Closed

    Hello Sir, I Wanna Calculate Few Things A1 Is My Date Of Birth A2 Is My Date Of Joining I Want Few Formulas Using These Two. First Thin...

    Game Start Now | Office Software | Latest reply: Game Start Now Mar 11, 2011
    5 replies
  • Lost password -SA6 Pink Solved/Closed

    Hello, My grand kids changed the password on her laptop cannot rember the pasword i need a disk.Thanks Configuration: Windows Vista / Internet ...

    Mitch | Word | Latest reply: Ambucias Mar 11, 2011
    1 reply
  • Macro to define a interval Solved/Closed

    Hello, i have a excel sheet of details of employee of the organisation. in that sheet I have a column D of age. I have to define age interval f...

    RWomanizer | Excel | Latest reply: rizvisa1 Mar 9, 2011
    12 replies
  • how to make xl readonly true or false on cond Solved/Closed

    Hi, I have an requirement like need to open an excle workbook and make it as readonly false then copy some rows to dat workbook then again make it ...

  • Vlookup Solved/Closed

    Hello Sir, In Sheet1 I Have Numbers Like A-----------------B------------ 4050 6080 9060 And In Sheet 2 I Have Data Like: A--------...

    Game Start Now | Office Software | Latest reply: Game Start Now Mar 7, 2011
    2 replies
  • find, select, copy, paste elsewhere in para Solved/Closed

    Hello, Can anyone help in the following matter: How to find, select, copy and paste elsewhere the paragraphs containing specific terms in...

    eskagsms | Office Software | Latest reply: Ambucias Mar 5, 2011
    3 replies
  • Adding new data sets to multiple worksheets Solved/Closed

    Hello, I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and the...

    Aaron | Excel | Latest reply: Aaron Mar 4, 2011
    2 replies
  • Macro To Copy Rows From One Worksheet To Anot Solved/Closed

    Hi , I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be "true"...

    Gowind | Excel | Latest reply: Gowind Mar 4, 2011
    9 replies
  • One Button To Execute Two Macros Solved/Closed

    Hello, I got one macro in Sheet1 and another macro in sheet2 under the same workbook.I want to assign a button in sheet1 so it can execute both the ...

    azmiismail | Excel | Latest reply: azmiismail Mar 3, 2011
    4 replies
  • Excel formula A+B=C with the following except Solved/Closed

    Hello, I really could use some help please. I am working on an 2010 excel spreadsheet. Would anyone know if there is a formula to do the following....

    Scott | Excel | Latest reply: Scott Mar 3, 2011
    2 replies
  • Use Excel VBA to create an e-mail w reminder Solved/Closed

    Hello, I create a file in Excel that does some calculations based on a small database and some user input. I then added a button to open an e-mail...

    BrunoD | Excel | Latest reply: Bruno Mar 2, 2011
    2 replies
  • Overtime Calculation Solved/Closed

    Hello Sir, I am having problem doing my work at office. I want to calculate the overtime hours of the employees. A1 is Time In where i...

    Game Start Now | Office Software | Latest reply: Game Start Now Mar 1, 2011
    21 replies
  • Filter all pivot table by same criteria Solved/Closed

    Hello, I am using excel 2007. I have a data on sheet1: I had make 4 pivot tables from that data in four different sheets: Now I have ...

    RWomanizer | Office Software | Latest reply: RWomanizer Mar 1, 2011
    10 replies
  • Toshiba password reset disk Solved/Closed

    Hello, hi how r u good i hope anyway i forgot my password on my toshiba satalite laptop is there any thing i can do from home to fix this Confi...

    joe1x4 | Word | Latest reply: Ambucias Feb 28, 2011
    1 reply
  • Codes Explaination Solved/Closed

    Hello, I have an text in excel as below. 1 1 1 2 2 2 3 3 3 After running a macro Iam getting the result as below. 1 ...

  • Macro to highlight a row if cells match value Solved/Closed

    Hello, I sorry but I am very new to macros and trying to create one in Office 2003. I need to bold a row if for example column E is greater than a...

    sgriffis | Excel | Latest reply: sgriffis Feb 22, 2011
    2 replies
  • Count if macro on multiple criteria Solved/Closed

    Hello, Could someone please help me out with a count-if macro on multiple criteria. I have attached a sample file in the below link http://ww1....

    waseem | Excel | Latest reply: Wasem Feb 22, 2011
    4 replies
  • Number convert to word in excel which formula Solved/Closed

    Dear Sir, Please help me number convert to word in excel which formula Hello, Configuration: Windows XP / Safari 534.13

    Sachin Tyagi | Word | Latest reply: RWomanizer Feb 21, 2011
    1 reply
  • help with excel Solved/Closed

    Hello, i have two speadsheets. the first sheet contains a total column EX: in C4 =SUM(E4+G4+I4+K4+M4) Value of C4 = (339816) on the ...

    markzasz | Excel | Latest reply: RWomanizer Feb 21, 2011
    1 reply
  • macro not saving file in excel format Solved/Closed

    Hello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan-11\B2B" ...

    RWomanizer | Excel | Latest reply: RWomanizer Feb 21, 2011
    4 replies