Office Software Forum

Ask a question
Search
Close
Results 2001 - 2050 of about 16,600
  • If cell contains a certain text, add the numbers of another cell Solved/Closed

    Hello, I am trying to do my finances in an easier way, and would appreciate it if anyone can help me with the below question: B2=Supermarket , C2=30$...

    mmbitar | Excel | Latest reply: Mazzaropi Feb 6, 2017
    1 reply
  • stop duplicated with multiple cells Closed

    Hello, I have a holiday home that I rent out and I am making a spreadsheet to control bookings, I have it set up so that the entry date and departur...

    rosswcarter2 | Excel | Latest reply: rosswcarter2 Feb 6, 2017
    0 replies
  • Need formula for comparing differences of two columns. Solved/Closed

    Column A and B both contain numeric values. I want Excel to look at both and give me the numeric difference between the two in a new column C. I reali...

    oduana777 | Excel | Latest reply: oduana777 Feb 4, 2017
    3 replies
  • if cell contains a certain text, add the numbers of another cell Closed

    B2=Supermarket , C2=30$ B3=Fuel, C3=20$ B4=Fuel, C4=50$ if Bs="Fuel", i want to add the numbers in the adjacents cells together. but only if they c...

    mmbitar | Excel | Latest reply: mmbitar Feb 4, 2017
    0 replies
  • Opening 602 spreadsheets with window 10 excel. help Closed

    Hello, I have used 602 Office suite for several years and now I have 10 years of spread sheets that I cannot open with windows 10. Do I have to purch...

    Bob Lawrence | Excel | Latest reply: ac3mark Feb 3, 2017
    1 reply
  • Transfer formulas only from one spreadsheet to another Closed

    Hello, I want to transfer formulas only from one spreadsheet to another but I get all the data I even specify paste formulas

    msmaggie | Excel | Latest reply: msmaggie Feb 3, 2017
    0 replies
  • Stripping out some text form a larger string Closed

    Hi All, I have very basic skills in excel - I'm trying to work through some data, and I have a long string of text - which has a common word "Naam:" ...

    maillme | Excel | Latest reply: Mazzaropi Feb 3, 2017
    1 reply
  • need help for excel formula Closed

    Hello, if cell contains text and date also for e.g 02-01-2017_Address Verified / 30/12/2016-Number busy / 28/12 Number busy. like this their no pro...

    Priti Bambarkar | Excel | Latest reply: Priti Bambarkar Feb 3, 2017
    0 replies
  • Copy ActiveChart properties to cell (from graphics) Solved/Closed

    Hello, I hope someone could help me. Working with graphics in excel, I generate dispersion plots from some datas, later I add the trendline, display...

    mendokzeni | Excel | Latest reply: mendokzeni Feb 2, 2017
    2 replies
  • Formula Help - IF FUNCTION Closed

    Hello, I'm trying to create a formula which would give me the total amount sold. So for example I'm trying to get a formula which would say if column...

    Hamsto | Excel | Latest reply: Hamsto Feb 2, 2017
    0 replies
  • link info Closed

    how do I link text information from one worksheet to another?

    judia | Excel | Latest reply: judia Feb 2, 2017
    0 replies
  • desktop reminder with excel sheet and VBA formula need. please s Closed

    desktop reminder with excel sheet and formula need please support.

    Kasi | Excel | Latest reply: Kasi Feb 2, 2017
    2 replies
  • Copying Conditional Formatting with Formulas Accross Rows Solved/Closed

    Hello, I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula. Exam...

    Wearrien | Excel | Latest reply: Wearrien Feb 2, 2017
    2 replies
  • short cut keys not working Closed

    Keyboard shortcut keys not working in ms word example ctrl+A,ctrl+ A etc.

    @RJUN | Word | Latest reply: TrowaD Feb 2, 2017
    3 replies
  • Multiple IF formula in one cell, date comparison Solved/Closed

    Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...

    She.Charm | Excel | Latest reply: TrowaD Feb 2, 2017
    3 replies
  • Text colour doesn't change and cell borders don't print Closed

    I cannot change the text colour in a spreadsheet and the cell borders do not print out although they are there on screen. I have the CD for Office Ho...

    Rothera85 | Excel | Latest reply: Rothera85 Feb 2, 2017
    0 replies
  • Why sum of some numbers is 0 Closed

    Hello, I am trying to find the sum of some numbers in a column in a maxro book. I make the formula of sum and the sum appears 0. In fakt, althout th...

    Sonu | Excel | Latest reply: ac3mark Feb 1, 2017
    1 reply
  • Convert number to assigned names and joined with another names  Solved/Closed

    Hello, Please anyone can assist me on the below issue. that if I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell...

    Mariam | Excel | Latest reply: Mariam Feb 1, 2017
    4 replies
  • Excel VBA scripting - Changing a cell color based on contents Closed

    My VBA is a bit rusty so hopefully I can get a little help. There is a report I need to create every week that I want to automate a bit. I have a ...

    Porkpants | Excel | Latest reply: Porkpants Jan 31, 2017
    0 replies
  • Conditional Formatting Excel 2013 based on content in other cell Closed

    Hello, I have a spreadsheet with columns that have targets and results next to each other. If the target is reached (=) or exceeded (>) I want the r...

    Paul Davids | Excel | Latest reply: TrowaD Jan 31, 2017
    1 reply
  • Excel Sheets automatic updates Solved/Closed

    Hello, I am trying to collect budget request from different departments and if all approvals fields are Approved, I want all data to be collected in...

    sumi | Excel | Latest reply: sumi Jan 31, 2017
    0 replies
  • If Date Closed

    Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...

    Ahmed Dagh | Excel | Latest reply: TrowaD Jan 31, 2017
    1 reply
  • Macro for merging data from multiple sheets Solved/Closed

    Hello, I want to copy data of 2nd columns from all the sheets to different columns of single excel sheet. Is there any macro code available for per...

    Ashwathi V K | Excel | Latest reply: TrowaD Jan 31, 2017
    5 replies
  • Display dates from multiple cells in one cell Closed

    Hi, I want to combine dates from multiple cells into a single cell in the same row, with the result displayed in the format: dd/mmmm/yyyyy, dd/mmm...

    IanL | Excel | Latest reply: IanL Jan 30, 2017
    0 replies
  • a lot of names and dates Closed

    Hello, I am trying to find out a formula to use. I have a lot of names and dates. and another tap has names with days worked. I am trying to find ...

    roma | Excel | Latest reply: roma Jan 30, 2017
    0 replies
  • how to convert Date into text. Solved/Closed

    Hello, how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two System Configuration: Win...

    rk gupta | Excel | Latest reply: TrowaD Jan 30, 2017
    1 reply
  • convert number to assigned names and joined with another names Closed

    I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell A - i will enter 123 cell B - will have result of Biju, Daisy, Mah...

    Mariam | Excel | Latest reply: Mariam Jan 30, 2017
    0 replies
  • Excel 2013 coping on row of a spread sheet to another Closed

    I have a workbook with spread sheets wk End 1-15-2017, wk End 1-22-2017, wk End 1-29-2017 Looking for a way to have the row that is unfinished to mov...

    Woody | Excel | Latest reply: Woody Jan 29, 2017
    0 replies
  • Calculating rate based on date range Closed

    I'm trying to figure out how to calculate a rate of payment based on two sets of date ranges: 3 days or less - $15 4 days or more -$10 How would I ...

    Christina K ... | Excel | Latest reply: Christina K Moore Jan 29, 2017
    0 replies
  • Insert New Excel Sheet Closed

    Hello, I need the code which will create a new sheet in existing workbook if data are entered in a row. data generating should be in the format whic...

    santhusocute | Excel | Latest reply: santhusocute Jan 27, 2017
    0 replies
  • Using 1 Table to Apply Values to Subsequent Cells Closed

    Hello, I usually search google for my excel questions, but this one is tricky! It may even be beyond the scope of Excel. In a nut shell, I'm design...

    Gregory | Excel | Latest reply: Gregory Jan 26, 2017
    0 replies
  • Updating Master Sheet with most recent data Closed

    Hello, I'm curious if anyone knows of a way to have a master sheet/summary sheet only update with the most recent data entered on a different sheet?...

    Mike | Excel | Latest reply: xpcman Jan 26, 2017
    1 reply
  • How to create auto sheet in excel macro Closed

    Hello, I need a excel Macro which contains separate sheets for each day in a month. By running the macro there should be auto sheets created in wor...

    Chaitanya | Excel | Latest reply: Chaitanya Jan 26, 2017
    0 replies
  • copy files from Google Spreadsheet to Excel Closed

    Good Day partners How do I copy files from Google Spreadsheet to Excell, or How do I merger files from Google SPreadsheets

    Gqibs | Excel | Latest reply: Gqibs Jan 26, 2017
    2 replies
  • Copy row and it's contents based on value in X cell. Closed

    Hi everyone, this is my first post so I hope I'll explain myself clearly! I have a spreadsheet with the following content: (Column I (in yel...

    vmvmvmdew | Excel | Latest reply: TrowaD Jan 26, 2017
    1 reply
  • IF formula needed Closed

    Hello, I need a formula that IF there is any data/text in the cell it will EQUAL another cell, BUT... I want the cell with the formula to display th...

    modemers | Excel | Latest reply: TrowaD Jan 26, 2017
    3 replies
  • Statement that returns pass, fail, "" Closed

    Hello, Wanting to test row of numbers to a certain number and return pass, fail, or blank. =IF(AND(X7

    dooley | Excel | Latest reply: TrowaD Jan 26, 2017
    1 reply
  • Adding 2 cells to another sheet under If condition Closed

    Hello, if i have 2 sheets and i want to add 2 cells of the 1st sheet to the other one -- only if another 3rd cells has the text "Done" what should i...

    Noha youssef | Excel | Latest reply: Noha youssef Jan 26, 2017
    0 replies
  • INSTALLATION LICENCE IS EXPIRING Closed

    Hi When turning on my Lapt-to a message is telling me to renew my licence ans is sking for cetsin numbers from the original disks by the 01/02/2017 a...

  • Excel Formula Closed

    Hello sir, . But its can't working why i dont know! Please find my attachedments. Regards, Bicky Das, bickydas00@gmail.com 

    bicky@7 | Excel | Latest reply: bicky@7 Jan 25, 2017
    6 replies
  • Function button: Unhide cells between values and hide all other Solved/Closed

    Hello! I am new to macros and this one is proving to be a bit of a challenge for me. I am building a template that contains several sections. What ...

    MartaGH | Excel | Latest reply: MartaGH Jan 25, 2017
    2 replies
  • Macro for adding pictures according to cell value Closed

    Hi! I have this visual sheet (pic attached), and I would like to create a macro that would insert a picture from a folder on my computer in the cell ...

    livrett | Excel | Latest reply: livrett Jan 25, 2017
    0 replies
  • Cell content move with VBA code Closed

    I have a workbook that we create service tickets from. The main sheet is used to enter information about the job. When complete I have a button that n...

    kd5jnx | Excel | Latest reply: TrowaD Jan 24, 2017
    1 reply
  • How do you have multiple out comes for the same if condition in Closed

    Hello, I have a condition in my file such that =IF(C5=C4,D3+1,D5=1 ->>>> trying to add this andD4= D3+1) Basically this what I want to happen C...

    J9 | Excel | Latest reply: TrowaD Jan 24, 2017
    1 reply
  • recovery of unsaved word/open office document Closed

    I recently had my computer worked on at Geek Squad because it crashed on me. After they restored my computer, they were unable to reinstall my Office ...

    DDmann12 | Open Office | Latest reply: xpcman Jan 23, 2017
    1 reply
  • Conditional formatting based on another cell? Closed

    Hi everyone! I'm trying to finish my financial sheet to work out where I am for this year. I need it so that when I type in the word "yes", It shows t...

    JTTaylor92 | Excel | Latest reply: TrowaD Jan 23, 2017
    1 reply
  • Formula 1,2,3 division Closed

    Hello, sir Plz notice the formula =if(cell address >55%,"1st",if(cell address >50%,"2nd",if(cell address >45%,"3rd","Fall"))) is the correct answer? ...

    BICKY | Excel | Latest reply: Mazzaropi Jan 23, 2017
    1 reply
  • Can't open Microsoft Office Word Closed

    Hello, i'm using Word 2007. Yesterday I opened a file and it kept loading and loading but didn't open. Every files is the same. Then a notification po...

    yukiriaki | Word | Latest reply: usama1993 Jan 23, 2017
    2 replies
  • Automatically transfer data from one sheet to another Solved/Closed

    Hello, I have a workbook with several worksheets (Master, Pending, Lost, Sold, and Bidding). I would like to be able to have certain line items base...

    Lghtningt4u2 | Excel | Latest reply: vcoolio Jan 22, 2017
    5 replies
  • Quick Access Tool Bar Closed

    Hi Everyone, I'm new to this forum. Thanks for the help and advise in advance. I'm a beginner to VBA. I have created a custom Quick Access Tool bar ...

    Dubey | Excel | Latest reply: Dubey Jan 22, 2017
    0 replies