Excel Forum

Ask a question
Results 5801 - 5850 of about 9,840
  • compare data in seperate columns to find likely matches Solved/Closed

    Hello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...

    Spraoi | Latest reply: Spraoi Feb 18, 2013
    4 replies
  • No tool bars or address bar on my browser Solved/Closed

    Hello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...

    mandi | Latest reply: Paddy Feb 17, 2013
    175 replies
  • Excel function Closed

    Hello, please i need your help in the following problem I have one worksheet contains many colums, rows, and calculations as follows: empl...

    kadry | Latest reply: Zohaib R Feb 15, 2013
    3 replies
  • Code for macro that conditionally inserts rows Solved/Closed

    Hello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...

    bfleming | Latest reply: bfleming Feb 15, 2013
    4 replies

    Hello, I have a spreadsheet (d2:d7) with 2012 prices in column D2 and 2013 prices in column D3 for the same product...what i want is if D2 is bigg...

    valencc7 | Latest reply: rizvisa1 Feb 15, 2013
    1 reply
  • Excel if function: less than date Closed

    Hello, I need a what if formula to satisfy the following: if date in K34 is before 23 Nov 2012, then AB34 = yes and so on.. i.e date in K35> 23 N...

    ilovejr | Latest reply: rizvisa1 Feb 15, 2013
    1 reply
  • excel for mac opens all files on desktop Solved/Closed

    Hello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, t...

    emee | Latest reply: Dan Feb 14, 2013
    10 replies
  • is there anyway to use VLOOK with index Closed

    Hello, I have hard time to solve this: I have problem like this: 1st worksheet I have a table similar than this: A B C D 1 D...

    jsrodriguez2001 | Latest reply: rizvisa1 Feb 13, 2013
    2 replies
  • Can't open Excel file Solved/Closed

    Hello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first time I ...

    duncan | Latest reply: yolooo Feb 13, 2013
    6 replies
  • IF statement errors and using multiple IF statements. Solved/Closed

    Hello, I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it. I ...

    jsav | Latest reply: jsav Feb 12, 2013
    3 replies
  • comparing two xl sheets Closed

    Hello, I have two excel sheets. A and B A has two columns col1 ,col2 B has two columns col1 and col3 i want create new sheet which has col1 ,...

    vyk0522 | Latest reply: Zohaib R Feb 12, 2013
    3 replies
  • Conditional formatting of cell in other worksheet dependent Closed

    Hello, Hope I make this one clear. I am working on a workbook created by a another and here is what I am trying to achieve. An item selecte...

    Vincent pybis | Latest reply: Ambucias Feb 10, 2013
    1 reply
  • Can this be done? If Yes, How? Closed

    Hello, This is my beginners attempt to write VBA code (I just wrote a macro to write MsgBox "Hello World" :-)) Please chk the Following ex...

    resolehtmai | Latest reply: resolehtmai Feb 8, 2013
    5 replies
  • Writing rule in ms excel using vb Closed

    Hello, my question is...i'm having huge customer list mails in the format ******@***.es.us ******@***.es.in ******@***.net.us ******@...

    trainhr1 | Latest reply: rizvisa1 Feb 7, 2013
    7 replies
  • how to expert office excel work Closed

    Hello, I'm Salman i live in dhaka. i work in a company. some time facing many problem to office excel work. Pls told me to how to improve excel wo...

    Salaman | Latest reply: Zohaib R Feb 7, 2013
    1 reply
  • Conditionnal formating for more than 3 colors Closed

    Hi, I need some help with conditionnal formating. I have 27 conditions and for each I need a separate color. 1,0-2,0 2,0-4,0 4,0-6,0 6,0-...

    soeck | Latest reply: rizvisa1 Feb 7, 2013
    10 replies
  • merging more cells into one cell Solved/Closed

    Hello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. w...

    marjean | Latest reply: markswan20 Feb 6, 2013
    10 replies
  • how can calculate days between twodates Solved/Closed

    Hello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order date ...

    samruddhi naik | Latest reply: Kevin@Radstock Feb 6, 2013
    2 replies
  • How to insert & resize picture automatically Closed

    Hello, Configuration: Windows 7 / Chrome 24.0.1312.57 Sir I have an Excel 2007 file named "DTPH.xlsx" with data having person names, details i...

    DK Dhir | Latest reply: Zohaib R Feb 6, 2013
    1 reply
  • Insert row with formats and formulas Closed

    Hello, I am curretly trying to write a macro, that will insert a row on the next available line, keeping the formulas, formats, (including some co...

    Debs269 | Latest reply: TrowaD Feb 5, 2013
    2 replies
  • recurring billing fee Closed

    Hello all, I was wondering if anyone knows a way to have Excel add a monthly billing charge to invoices. I need something that would automatically...

    rawr | Latest reply: rawr Feb 5, 2013
    8 replies
  • organisation chart preparation Closed

    Hello, how to prepare organisation chart Configuration: Windows XP / Firefox 18.0

    chandramelimi | Latest reply: TrowaD Feb 5, 2013
    1 reply
  • Macro to count the answers in a table Closed

    Hello, I have a problem in macro in Excel. I am working on a file that counts the number of responses (0 or 1) of a certain type under certain que...

    theinvictus | Latest reply: TrowaD Feb 5, 2013
    3 replies
  • Comparing sales Closed

    Hello, I have two separate Excel spreadsheets (e.g. 2011 sales & 2012 sales) with the following columns: Customer ID, Customer Name, Product #, Sa...

    RZ1276 | Latest reply: RZ1276 Feb 4, 2013
    0 replies
  • Macro to download certain files from a webpage Closed

    Hello, I am trying to find a way to download a number of files that exist on a webpage (the names are in sequence, e.g. abc202, abc203, abc204...e...

    nzstorm | Latest reply: rizvisa1 Feb 4, 2013
    3 replies
  • changing cell formats based on another cell value Closed

    Hello, I was having difficulty in solving this problem. say: I have a dropdown on A2, text1, text2, text3 when you selected text1 the format...

    mgadrago | Latest reply: rizvisa1 Feb 4, 2013
    1 reply
  • Transferring data from one sheet to another Solved/Closed

    Hello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data) to ...

    cuffy70 | Latest reply: Cuffy70 Feb 3, 2013
    15 replies
  • convert text mixed numbers to spelling Closed

    Hello, i want to know how can we convert in excel the mixed numbers such as 1ZXV78 to "one ZXV seven eight".. can some one help on this task, ...

    sandeep8627 | Latest reply: rizvisa1 Feb 2, 2013
    1 reply
  • what formula shall I use Closed

    Hello, Hi morning! I Have a problem right now. Here's the thing. I' working on an Ms Excel. My data are the following: "Assigned Reg...

    flower_girl | Latest reply: rizvisa1 Feb 2, 2013
    11 replies
  • VB script to read data from another sheet Closed

    Hello, please provide solution , please find my requirement Sheet1 column name values A 1 B ...

    srini4547 | Latest reply: Zohaib R Feb 2, 2013
    1 reply
  • cell with cal/min Closed

    Hello, I want to calculate the (k)Cal/min in excel. I have a cell with start time defined in time and a cell with endtime (from a running session)...

    start1 | Latest reply: Zohaib R Feb 2, 2013
    1 reply
  • Time calculations on a 24-hr clock Solved/Closed

    Hello, I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything is b...

    Harters | Latest reply: Zohaib R Feb 2, 2013
    1 reply
  • Auto notify or mail when Excel sheet updated. Solved/Closed

    Hello, We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or puts ...

    Satya | Latest reply: cdb2013 Feb 1, 2013
    20 replies
  • Compare date in cell against dates in range of cells Closed

    Hello, I am trying to use conditional formatting to highlight a cell if the date in that cell is the same or earlier than dates in the rest of ...

    Grimsby21 | Latest reply: TrowaD Jan 31, 2013
    1 reply
  • Excel 2007 resetting cells to Date format Solved/Closed

    Hello, I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a vir...

    ktech25 | Latest reply: Archit Badwe Jan 30, 2013
    11 replies
  • Transpose and Removing Duplicates at same time Closed

    Hello, I have a spreadsheet with two columns. The left column is an eight digit house ID. The right column represents miles driven by individual...

    calflamesfan... | Latest reply: jamesfly Jan 30, 2013
    2 replies
  • Need a macro to sum range of cells Closed

    Hello, I am a teacher from Greece and I want your help to gather information and sum from different worksheets in different workbooks to another f...

    gtsellos | Latest reply: rizvisa1 Jan 29, 2013
    5 replies
  • worksheet name input to move data from one worksheet to another Closed

    I have a worksheet that is identical in all values other than price. All data is collected on worksheet one. Work sheet one has a column where a...

    jessica khani | Latest reply: rizvisa1 Jan 29, 2013
    2 replies
  • Excel - A macro copy to cell based on a specific criteria Closed

    Hello, how to split the data from state wise using macro ex: Location type month year state India email 12 2012 UP India email 12 2012 ka...

    mani11 | Latest reply: rizvisa1 Jan 29, 2013
    2 replies
  • conditional Formatting Solved/Closed

    Hello, I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2 states B...

    Harters | Latest reply: Harters Jan 27, 2013
    4 replies
  • Attendance tracker Closed

    Hello, I want to know how to do this kind of table Let's say I have two teams under 2 supervisor with 7 employees/supervisor and what I want is ...

    macbv | Latest reply: macbv Jan 26, 2013
    0 replies
  • Comparing two spreadsheet data Closed

    Hello, Please help me out on this issue. If I have an original sheet comprising of 8 columns and a number of other row items with subtotals in be...

    vikas.nandanwar | Latest reply: rizvisa1 Jan 26, 2013
    5 replies
  • Simply cannot find an answer Solved/Closed

    Hello, I have a spread sheet - column B lists dates for the last time a report for each product was completed. Each report is due every 28 days. ...

    mona3 | Latest reply: mona3 Jan 25, 2013
    8 replies
  • saved excel will not open Closed

    Hello, I got a shock when trying to open excel sheets. The message " THERE WAS A PROBLEM SENDING THIS COMMAND TO THE FILE" i can't open any saved exc...

    stevehartland | Latest reply: rizvisa1 Jan 24, 2013
    1 reply
  • Activity Reminder from Excel Column Closed

    Hello, I would like to reserve a column "B" on an excel spreadsheet to put a date in the field for "Next Activity Date". Then put the date in the...

    2RGarry | Latest reply: rizvisa1 Jan 23, 2013
    3 replies
  • VB issue with delete rows with specific values Solved/Closed

    Hello, I am using 2007 excel and have the VB doing 2 things: 1) looking at specific Column for EXACT values and deleting row 2) looking at speci...

    weenie | Latest reply: rizvisa1 Jan 23, 2013
    8 replies
  • Roster with each person getting their own weekly sheet printed Closed

    Hello, Ive put together a spreadsheet for work, where we have a main page called roster, the whole weekly roster for all staff members goes onto t...

    cobbadan | Latest reply: rizvisa1 Jan 23, 2013
    8 replies
  • Macro Help: Copy Data from a Range of Sheets to a Master Sheet Solved/Closed

    Hi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs to: ...

    supermate | Latest reply: supermate Jan 23, 2013
    7 replies
  • Tagalog Solved/Closed

    Hello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I cant ex...

    flower_girl | Latest reply: flower_girl Jan 21, 2013
    2 replies
  • How to convert number into text in Excel Solved/Closed

    Hello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"

    boratechandu | Latest reply: Raj Jan 21, 2013
    9 replies