Office Software Forum - solved topics

Ask a question
Results 951 - 1000 of about 2,640
  • Solved
  • Converting rows of data in notepad to columns Solved/Closed

    Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...

    Need help | Excel | Latest reply: Philgood_FR Feb 5, 2015
    2 replies
  • Problem with formula using ISBLANK Solved/Closed

    Hello, I am using the ISBLANK function to execute formulas in my spread sheet. If I use a formula to add or subtract, such as =IF(ISBLANK(D13)...

  • conditionally copy columns Solved/Closed

    Hello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...

    GMHerbs | Excel | Latest reply: GMHerbs Feb 4, 2015
    2 replies
  • Change a range dynamically - VBA script. Solved/Closed

    Hi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...

    BrianGreen | Excel | Latest reply: BrianGreen Feb 4, 2015
    5 replies
  • Exchange inbox repair tool Solved/Closed

    Hello, I have Exchange 2010 server that is being used to temporarily hold mailboxes. After a reboot the .edb file went from 276gb to 0kb. Of cour...

    sorincornea | Outlook | Latest reply: sorincornea Feb 3, 2015
    2 replies
  • removing false in excel Solved/Closed

    =IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!

    umer007 | Excel | Latest reply: umer007 Feb 2, 2015
    2 replies
  • Increment a cell value - conditions applied Solved/Closed

    Hello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the value ...

    peweuk | Excel | Latest reply: peweuk Feb 1, 2015
    2 replies
  • Rating from Parameter Lookup Solved/Closed

    Hi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...

    dxa02091 | Excel | Latest reply: dxa02091 Jan 30, 2015
    11 replies
  • Nesting if() functions? Solved/Closed

    Hey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...

    gcaorsiw | Excel | Latest reply: pijaku Jan 29, 2015
    3 replies
  • Why dbx files do not opened Solved/Closed

    As soon as I have not tried to open the file through Outlook. Out - walked into account. Downloaded the new version - nothing helped. Outlook does not...

    boer8787 | Outlook | Latest reply: wauters87 Jan 27, 2015
    1 reply
  • I am looking for Outlook Express fix tool Solved/Closed

    Hello everyone...How can i restore damaged .DBX file of OE? I am not able to see the mails. My 4 Gb data in inbox.dbx is corrupted of .dbx files by u...

    rescuma | Outlook | Latest reply: samlund Jan 24, 2015
    2 replies
  • 1 time data entry Solved/Closed

    Hello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...

    ArashMan | Excel | Latest reply: ArashMan Jan 23, 2015
    14 replies

    Hello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...

    Babu546 | Excel | Latest reply: Babu546 Jan 22, 2015
    5 replies
  • Regarding Pivot Solved/Closed

    Hi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag multiple ...

    Karthikeyan1207 | Excel | Latest reply: Karthikeyan1207 Jan 22, 2015
    2 replies
  • Find the first available (empty) cell on a worksheet. Solved/Closed

    As a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a wor...

    BrianGreen | Excel | Latest reply: BrianGreen Jan 21, 2015
    19 replies
  • Lookup problem. Solved/Closed

    I have a column of 20 dates in col. B spaced by 2 or 3 weeks, and a number beside each one in col. C. In cell C24 I need a formula that returns the v...

    pothole | Excel | Latest reply: Babu546 Jan 21, 2015
    5 replies
  • Copy Paste Data in Same column for multiple time Solved/Closed

    Hello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After copy p...

    sudeep.leadtech | Excel | Latest reply: sree Jan 21, 2015
    5 replies
  • Replacing Duplicates Solved/Closed

    My Excel spreadsheet is set out as follows: A B C D E F 1 2 14 0 14 14 2 1 13 0 13 13 3 4 4 1 4 4 4 3 3 1 3 17 ...

    whatsit | Excel | Latest reply: TrowaD Jan 20, 2015
    38 replies
  • Excel - Macro to highlight Rows with Duplicate values in a cell Solved/Closed

    Geetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers or ...

    ajaydwivediji | Excel | Latest reply: TrowaD Jan 19, 2015
    11 replies
  • IF function with DATE in Excel Solved/Closed

    Hi, hope someone can assit. I need to create a sheet where I must take the current date and add a fulle week or two weeks to the date by selecting an ...

    ace-82 | Excel | Latest reply: ace-82 Jan 19, 2015
    2 replies
  • Corrupt word file - says to use text converter Solved/Closed

    Hello, I have been reading some posts about you to repair a file and it says to use the text converter. I dont see how to use it though. I want to ...

    JordanBryc | Word | Latest reply: josephcols81 Jan 16, 2015
    1 reply
  • Macro for copying data from different sheets Solved/Closed

    Hello, I am trying to copy data from different sheets to master sheet under the following criteria 1. Master sheet should be generated when ev...

    Kishore | Excel | Latest reply: NK Jan 16, 2015
    23 replies
  • Trying to sum a column that contains various text Solved/Closed

    I'm a novice when it comes to excel and I'm hoping someone can help me with a formula. I'm trying to give a value to various text in columns and then ...

    chris82675 | Excel | Latest reply: chris82675 Jan 15, 2015
    3 replies
  • Excel Query Urgent Please. Solved/Closed

    Hello, I have the below data in sheet 1, where as in column A its the activity and column b its the name of person who has done it. and the names ...

    wasey | Excel | Latest reply: wasey Jan 15, 2015
    11 replies
  • Compare two sheets based on a common ID in both sheets in col A Solved/Closed

    Greetings Kioskea team, First of all, my heartiest congratulations and thank you to the great Kioskea team that who have a mine of excellent solut...

    Ajay Dwivedi | Excel | Latest reply: Ajay Dwivedi Jan 8, 2015
    8 replies
  • Percentage Work Solved/Closed

    Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I at...

    Winndixie | Excel | Latest reply: RayH Jan 6, 2015
    6 replies
  • Text label and value if value in other worksheet is > 0 Solved/Closed

    Hello, can someone please help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label...

    fixradio | Excel | Latest reply: TrowaD Jan 5, 2015
    5 replies
  • How do I get my old inbox back? Solved/Closed

    My computer had some network difficulty. After shutting down I noticed my Outlook Express inbox was empty. When browsing to my OE folder I see two i...

    stokesjohn451 | Outlook | Latest reply: wilkersonbria Jan 5, 2015
    1 reply
  • Excel - To generate unique ID Solved

    Hello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Bel...

    wliang | Excel | Latest reply: ferg Jan 1, 2015
    4 replies
  • I need a macro please Solved/Closed

    Hello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B havin...

    rjbuer | Excel | Latest reply: rjbuer Dec 31, 2014
    7 replies
  • Copy daily cost entries into the particular ledgers Solved/Closed

    Hello, I want to copy the daily cost entires into the particular ledgers, which i put in different sheets. Ex: I have the following data: D...

    shanthich | Excel | Latest reply: vcoolio Dec 31, 2014
    6 replies
  • date Entry Solved/Closed

    Hello, i have an Excel sheet which my colleague should enter the date after he finished his job, for example:\today date is 2014/28/12 he shou...

    ArashMan | Excel | Latest reply: ArashMan Dec 30, 2014
    2 replies
  • How to Lock or password protected specific cell in excel 2010 Solved/Closed

    Dear all: Hope you are fine. How can I Lock a specific cell of excel 2010 that any one can not change or input anything in that cell. Pleas...

    Biswajit-Shaha | Excel | Latest reply: Biswajit-Shaha Dec 30, 2014
    4 replies
  • Excel macro to format report Solved/Closed

    Hi everyone, I am new to this new I've already typed my question, then clicked "ask your question" again instead of submit..........

    LaurenM | Excel | Latest reply: ramu sanga Dec 29, 2014
    7 replies
  • Need to write a macro to copy a row of information if true Solved/Closed

    Hi, I have a workbook with several tabs and I want to first check if Column F on the first sheet contains 13 as the year (12/16/13 is the format) and...

    lrjupiter | Excel | Latest reply: vcoolio Dec 22, 2014
    7 replies
  • Using a Macro to copy & Paste from one sheet to another. Solved/Closed

    Hello, Hi Guy's I hope you can help, I am using two sheets. one is spread across different rows so when I click create list it copies everything ...

    Marksman702 | Excel | Latest reply: vcoolio Dec 18, 2014
    8 replies
  • excel formula numbers to dates Solved/Closed

    Hi, I need an excel formula for changing numbers to dates. It is part of the Julian Calendar but backwards and one extra number. Ex. 273143 is 9/...

    ah2jh1sh2 | Excel | Latest reply: ah2jh1sh2 Dec 18, 2014
    6 replies
  • how to use releative refrences in conditional formating?? Solved/Closed

    the first picture is the formatting rule of C7 cell the second picture is the formatting rule of E7 cell which i copy from C7. as you c...

    ArashMan | Excel | Latest reply: Mazzaropi Dec 18, 2014
    8 replies
  • Conditional formatting based on another cell Solved/Closed

    Hello, this is what I want: EXAMPLE: B3= Arash if B6=1 then B3 goes red if B6=2 then B3 Goes yellow and if B6=3 then B3 goes green i want to...

    ArashMan | Excel | Latest reply: ArashMan Dec 17, 2014
    2 replies
  • Conditional formatting based on another cell Solved/Closed

    i want to type a name in cell B3. and I want the cell's color change when I type 1,2 or 3 in B6 cell by using conditional formatting. is that possible...

    ArashMan | Excel | Latest reply: ArashMan Dec 17, 2014
    5 replies
  • help me to add particular cells Solved/Closed

    Hello, i want to sum particular cells when a number consists in a cell eg:- =IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0) it calculates a...

    mathewmunna | Excel | Latest reply: mathew munna Dec 15, 2014
    2 replies
  • Macro/command button help Solved/Closed

    Hello, I am in need of some help here and would greatly appreciate it. Here is what I am trying to accomplish. I have a basic excel file with two s...

    sillygoose2014 | Excel | Latest reply: vcoolio Dec 13, 2014
    12 replies
  • Copy info from one excel sheet to another sheet Solved/Closed

    Hello, I am respectfully asking for assistance on an issue i am having trying to write a macro for a form that i am currently working on. I have ...

    sstanger | Excel | Latest reply: sstanger Dec 12, 2014
    2 replies
  • What Type does it want? (VBA question) Solved/Closed

    Hello, So I have a pull-down list in Excel 2003 that is an expanded version of this: 011 012 01T 111 If I type in the cell (rather than ...

    InsertNickna... | Excel | Latest reply: TrowaD Dec 11, 2014
    3 replies
  • Conditional Formatting to hide 00:00 in column Solved/Closed

    Hello, I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a grea...

    sharky9000 | Excel | Latest reply: Sharky9000 Dec 8, 2014
    4 replies
  • help me on this formula to shorten Solved/Closed

    Hello, i have 2 formulas tick mark automatically on worksheet.. please help me if further it can be shortened.. i want to know if J1 K1 L1 can sho...

    mathewmunna | Excel | Latest reply: mathewmunna Dec 6, 2014
    5 replies
  • Prefix 0 to all records in a column Solved/Closed

    Hello, I want to prefix 0(zero) to all records in a particular column of an excel sheet.Please let me know how to do it. Thanks for your time, Mano...

  • Excel Picture Inserting Macro Help - Urgent Solved/Closed

    Dear Rizvisa, please consider this little urgent and be kind to help me please I m trying to insert picture in excel column using macro which ta...

    nadimn | Excel | Latest reply: jackcluseau Dec 4, 2014
    25 replies
  • How to count different charecters Solved/Closed

    Hello, Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1 spa...

    mathewmunna | Excel | Latest reply: mathewmunna Dec 4, 2014
    5 replies
  • How can I transfer data from one spread sheet to another? Solved/Closed

    Hi, I'm working in excel and on one spreadsheet and I'm having to retype everything on to another spread sheet, I want to be able to have my data ...

    elizatex | Excel | Latest reply: elizatex23 Nov 30, 2014
    5 replies