Office Software Forum - solved topics

Ask a question
Results 2501 - 2550 of about 2,650
  • Solved
  • connecting outlook with gmail Solved/Closed

    Hello, plz suggest a way to synchronize my gmail account with outlook thanku

    parul | Outlook | Latest reply: alexi Jan 27, 2010
    3 replies
  • sum column if date (year) is greater than 09 Solved/Closed

    Hello, Hi I'm trying to calculate 2 column if the date is greater than 2009 in Column A Column B Column C 5/31/2009 ...

  • Cell Reference Solved/Closed

    Hello, I need a formula that can check a specific value in a range of values and show the cell location for each time the value is find Suppose we...

    faqisoft | Office Software | Latest reply: venkat1926 Jan 25, 2010
    3 replies
  • format nard drive Solved/Closed

    Hello, i want to clear my hard drive and then relaod win xp, i have no real idea where to start and what i should save first ect ??? can anyone advi...

    richi rich | Office Software | Latest reply: dancedhall Jan 23, 2010
    1 reply
  • delete all rows except first and last row Solved/Closed

    Hello, I have an excel file, I need to delete all rows in this file except for the first and second row. First Row = header row last row = contai...

    urgentMe | Excel | Latest reply: fairbud Jan 18, 2010
    2 replies
  • formula or else ??? Solved/Closed

    Hello, I have a range of cells B5:AC5 containing each a letter from a name, ex: DAVID THOMAS SMITH So B5=D, C5=A, D5=V, E5=I, F5=D..and so on up to ...

    GALAPAGO | Office Software | Latest reply: tompols Jan 14, 2010
    3 replies
  • Need to sum Coumn F only when B & C identical Solved/Closed

    Hello, I am trying to set up a formula that will allow me to get the average of values in F, but only for the rows where both Coumn B & C are identic...

    mazeracer | Office Software | Latest reply: tompols Jan 14, 2010
    21 replies
  • If X is between A and B, then C Solved/Closed

    Hello, Worksheet 1 Jan 10 Jan 12 Jan 12 10am Jan 13 Jan 15 Jan 16 9am Worksheet 2 Jan 11 I'm having trouble coming up wi...

  • Excel Help Solved/Closed

    Dear All, I really need your support with my issue: I have around 70 tasks in Sheet1 some of them done with 100% (according to other numbers in th...

    Omoor | Excel | Latest reply: Omoor Jan 12, 2010
    2 replies
  • VBA Code that will find, copy and transpose Solved/Closed

    Hello, I'm looking all around for a VBA code that will: 1 - Search down one column for the word "ADDRESS" 2 - Once "ADDRESS" is found, I need t...

    siddharthariver | Excel | Latest reply: venkat1926 Jan 11, 2010
    1 reply
  • how to count rows which show specified dates Solved/Closed

    Hello, I am trying to get help with stats. I have a spreadsheet which shows the date a specific action was started in each row. I need to be abl...

    sparker | Excel | Latest reply: venkat1926 Jan 8, 2010
    3 replies
  • select Y in all 3 columns and return value Solved/Closed

    Hello, There are 3 columns where range is unknown for all the 3 columns( A, B & C). Macro need to selcect "Y" in all the 3 columns then No action ...

    kk | Excel | Latest reply: venkat1926 Jan 7, 2010
    1 reply
  • Incorrect Product Key Solved/Closed

    Hello, I have just purchased a new computer. A Windows 7 Acer, actually... Well, as a new computer, a Product Key is required... right? See, Micros...

    Disappointed | Office Software | Latest reply: aquarelle Jan 6, 2010
    1 reply
  • Reg: Macro - Auto run Solved/Closed

    Hello, I need to run a macro automatically when i open an excel sheet. and aslo to run a macro when i close the sheet can any one help me...

    jee | Excel | Latest reply: jee Jan 5, 2010
    10 replies
  • VLOOKUP HELP Solved/Closed

    Hello, I would be very thankful if anybody solve my problem which exactly need. The details are given beloW: DATE SCRIP NET(Cr/Dr) 19-...

  • I receive PDF files but can't open them. Solved/Closed

    Hello, I have windows XP and when I receive an e-mail with a PDF file attached I try to open it and all I get is grafeate. Is it the Windows XP th...

    Gunny | PDF | Latest reply: Gunny Dec 30, 2009
    2 replies
  • Macro question Solved/Closed

    Hello, I'm trying to write a macro in excel 07 to select the last row in a range. I want it to select the last row of the range only. Does anyone...

    Jay | Excel | Latest reply: Jay Dec 28, 2009
    3 replies
  • Excel Solved/Closed

    Hello, I need some help. I would like to find out how many occurences of the same number occur in a column with in excel. Eample: 11111555555556666...

    WILL511958 | Excel | Latest reply: venkat1926 Dec 27, 2009
    1 reply
  • Excel MAtching Data Solved/Closed

    Hello, I have two rows of data in excel one has the name of all members about 100 and the other list is of members who have paid their dues about 5...

    Shak | Excel | Latest reply: Kamal Dec 21, 2009
    3 replies
  • where does the reference (weekends/holidays) Solved/Closed

    Hello, in regard to your formula in counting days. you said that a list of holidays/weekends should be created. onces it is created where does that i...

  • How to Update Prices in Excel by % Solved/Closed

    Hello, I have a lengthy spreadsheet (Office 2007) with stocked items and their prices, the prices are simply entered in a cell when I created the spr...

    pgh | Excel | Latest reply: pgh Dec 20, 2009
    2 replies
  • excel: if then else with multiple criteria Solved/Closed

    Hello, Essentially, I would like to determine a numeric value (1-9) for the letters of the alphabet. Returning the number value in relation to a n...

    Luchtain | Excel | Latest reply: venkat1926 Dec 11, 2009
    8 replies
  • VBA/Macro: Removing titles Solved/Closed

    Hello, I need to remove Mr/Mrs/Miss preceeding the names in one cell and copy them to another cell. Any idea? Your advice is much appreciated. i...

    Austin | Excel | Latest reply: Austin Dec 10, 2009
    8 replies
  • I NEED A FORMULA IN EXCEL? Solved/Closed

    Hello, Hello... I have a cell A1 that show $200.00. now if am type $ 200.00 in B2 automatically A1 cell amount should show as 0 your help much ap...

    Mafrin | Excel | Latest reply: Mafrin Dec 7, 2009
    2 replies
  • IF statement Solved/Closed

    Hello, Please help me with the following if statement : =IF(A1:A34"Ba","Ba","") Column A1 to A34 contains the following text :Co, Cs, Th, Nk et...

  • how can i open my files without password Solved/Closed

    Hello, i lock the forder with "free hide folder" software, i forget the password how can i open my files without password

    ice | Word | Latest reply: closeup22 Dec 3, 2009
    1 reply
  • constant in formula Solved/Closed

    Hello, I am trying to use a input cel in excell 1) On my excel sheet I have data on A1,A2,A3,A4,A5 containing the amount of ml ink being used. ...

  • countif function Solved/Closed

    Hello, I'll like to know if i can use the coutif function on multiple values? for example: =COUNTIF(E2:E30,(AND(G2:G30, "=הסתיים",A2:A30,"=11"),"=...

    goldi | Office Software | Latest reply: venkat1926 Nov 30, 2009
    3 replies
  • marcos Solved/Closed

    Hello, I had someone help me make a marco in excel three years ago in office 2003. the mecro worked fine, but now I have installed office 2007. I can...

  • Stay on same row when selecting next sheet Solved/Closed

    Hello, I would like to know how to stay on the same row when selecting another sheet. My file contains 17 sheets. Sheets 2 and 5 till 16 contain...

    Trowa | Excel | Latest reply: Trowa Nov 26, 2009
    5 replies
  • Stable Date Solved/Closed

    Hello, Is there any function in Microsoft Excel where in we can get a stable date, the date should not change as it changes depending on the system ...

  • Help with Excel Macro Solved/Closed

    Hello, I am certainly a macro noob and require some help, please, :( I work at a travel agency and I have a worksheet with all of our reserves. It h...

    sahkab | Excel | Latest reply: aquarelle Nov 24, 2009
    3 replies
  • using a named cell in a macro - same workbook Solved/Closed

    Hello, seems simple but I'm just not getting it....I'm using excel 2003 and am trying to use a named cell on one sheet in a macro on a different sh...

    marcia | Excel | Latest reply: venkat1926 Nov 24, 2009
    3 replies
  • Activate userform in userform Solved/Closed

    Hello, I've just started exploring the possibilities of userforms. My userform contains a TextBox named "txtAanvraagDat". In this textbox a date...

  • COUNT # ROWS where 2 conditions are true Solved/Closed

    Hello, I am having problems counting the # rows of problem reports where the priority = 1 and the PR is active. here is the array: PR PRIORI...

    tepatl | Excel | Latest reply: aquarelle Nov 11, 2009
    1 reply
  • Excel 2007 Formula Help - if cell is empty... Solved/Closed

    Hello, Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get t...

    Melissa | Excel | Latest reply: Melissa Nov 11, 2009
    2 replies
  • excel issue Solved/Closed

    Hello, please give macro for hiding blank rows

    cophe77 | Excel | Latest reply: iveal Nov 11, 2009
    1 reply
  • EXCEL: Nested IF formula question Solved/Closed

    Hello, I've read some answers to similar questions, but not quite the same... How can I have *certain* results of my nested "IF" formula display...

    bunda3 | Excel | Latest reply: Tonio Nov 10, 2009
    2 replies
  • for my password Solved/Closed

    Hello, i forgot my password . can any one help me

    mohan | Word | Latest reply: closeup22 Nov 6, 2009
    1 reply
  • Simple Excel Question (I think) Solved/Closed

    Hello, I am putting together an XL sheet and would like to find the MAX value in a column of numbers, then return the contents of the cell next to it...

    ruh-roh | Excel | Latest reply: ruh-roh Nov 5, 2009
    2 replies
  • VBA Excel Search Select Paste Delete Solved/Closed

    Hello, If someone could possible help on this I would be very greatful. I have reems of data in Excel (tidal data). I'm looking to get the highs...

    Clint16 | Excel | Latest reply: Clint16 Nov 4, 2009
    1 reply
  • Auto_open Solved/Closed

    Hello I have a question about Auto_open. Where do I put it in VB Editer? Do I put it in a Module, or Sheet, or Workbook. I have 3 sheets in the work...

    selflearner | Office Software | Latest reply: selflearner Nov 2, 2009
    2 replies
  • forgot Password & secret question of orkut Solved/Closed

    Hello, I m using new gmail & orkut A/c. But i forgot my ol orkut a/c's password & secret question. I want to delete my old a/c. Can anybody pls help...

    mitu | Word | Latest reply: LouisSteph Nov 1, 2009
    1 reply
  • Adding Dates Solved/Closed

    Hello, I am trying to find a formula that calculates dates. Like I have two boxes with a beginning and date in them, and I want to calculate the day...

  • IF iserror with 2 cells match Solved/Closed

    Hello, If i have 2 cell that i need to match to 2 array row and print "W" or "L" if both of the cell match. This is what i have =IF(ISERROR(M...

    sangng978 | Excel | Latest reply: Excelguru Oct 30, 2009
    1 reply
  • IF formula Solved/Closed

    Hello, wondering if you can help me with excel i need a formula that shows if A1 is starts with letter then give me a that first letter. If it sta...

  • macro help...copying and pasteing Solved/Closed

    Hello, I'm trying to write a macro to copy a row of cells to where the cursor is. The info is constant and the pasteing changes. I've used the "reco...

    selflearner | Excel | Latest reply: selflearner Oct 27, 2009
    10 replies
  • What is HDD (HP) Master Password? Solved/Closed

    Hello, I have Windows XP and it's shut me out of me out. When I turn on it has black screen, asks for a DriveLock Password, a second I forget, then ...

    spidey69 | Word | Latest reply: xpcman Oct 8, 2009
    1 reply
  • VBA to Open an excel file in notepad Solved/Closed

    Hello, Can someone tell me the vba code to open an .xls or .csv file in notepad? thanks PM

    PM | Excel | Latest reply: iveal Oct 8, 2009
    1 reply
  • Conditional activation of macro button Solved/Closed

    Hello, I was wondering if it is possible to only make a button work if there are only two cells selected. I have got a button which will copy th...

    Trowa | Excel | Latest reply: Trowa Oct 6, 2009
    17 replies