excel

  1. D

    Help complete my incomplete MS excel spread sheet?

    I have in one column 5 or 6 school names in a row and in the other column I have only 1 phone number for each school name. What I want to do is match up the phone numbers with the school names. I do not want to drag each phone number down to match up with the school. Should I use an IF THEN...
  2. E

    Is there a way to convert a time in Excel to its value in minutes?

    Greetings, I just have a long list of times that are currently in HH:MM:SS and want them all converted to their values in just minutes. Is there a way to do that? I am using MS Excel 2003. 2:29:01 i want to change to 149 minutes and so forth.
  3. R

    Excel Question, Please Help Formula.?

    In cell A1 i have enter 1 and in cell C1 i have entered 100's and in cell D1 i have entered a formula =A1*C1 but then i get the result #VALUE. Is it because I have the apostrophe in the 100? I really need to have that apostrophe because it is required. What should I do. Please help! thanks!
  4. A

    What is my Excel skill level if I scored 75%?

    Hi, I have just taken an Excel test for a Job interview and score 75% of the basic question correct, 80% of the intermediate questions and 70% of the expert questions. Which gave me an overall score of 70%. Does that mean I should describe myself as having intermediate IT skills when talking to...
  5. R

    Mixrosoft Excel data chart?

    Select the data and click on create table. You can choose to have the boundaries visible to show lines when you print or leave them invisible, in which case they don't show up when printing.
  6. T

    EXCEL - Help on how to create a formula?

    I have two raw data tables - Orders and Sales. Both tables contain fields for PO number, and item number. I want to lookup from the Sales Table the quantity sold for each item ordered per PO number on the Orders Table. What formula should I use?
  7. J

    Macro page in Excel causing two pages to open how do I?

    I wrote several macros for a report that I created. They are simple macros and I saved them to a "personal" macro page. When I open excel, this personal page comes up every time, is there anyway to stop that page from coming up but still use the macros? Also, at some point I had put a report...
  8. J

    Excel question: How to Mark Duplicates in Sequence?

    Sorry, i don't know how to word this so here's an example... I want to count the number of duplicates of a particular value within a range, but i want them to be numbered according to when they appear in the range, so for example, here are some sample values James Bob James James I know how...
  9. S

    see in excel, i have two books book1 and book2. i want to copy, c4, c7, c10 and

    so on... on book 2. How to do? i have to copy contents of book1 in the column of book2 as =book1!c4, =book1!c7, =book1!c10. If i use auto fill to continue it is not coming correctly. How to do this?
  10. F

    Concatenate in Excel.. how do I do it for the whole sheet?

    I have a spreadsheet formatted like this: 1 High V 1 High T 1 High C 1 Low T 1 Low C 2 High V 2 High C and I would like to format it like this: 1 High V, T, C 1 Low T, C 2 High V, C In other words, I want to concatenate...
  11. A

    Would a hyundai excel be considered as a "chicks" car?

    Thanks
  12. F

    excel help by tomorrow???

    I need to make a climograph on excel so I was going to use the line-column on 2 axes graph but the problem is my computer doesn't have that type. Does anyone know how I can get that type of chart on my computer???
  13. M

    How can I resolve a #VALUE! Error in Excel when summarizing from multiple sheets?

    I have a home-made budget I created in Excel. The last page is a project page where I have preset project numbers I can assign to allocate portions of each month's budget toward. I have a SUMIF equation which basically says if the "Project #" shows in the "Description" column on the Month work...
  14. D

    How can I change the column names in Microsoft Excel 2007?

    I'm going crazy! How can I change the names of the columns in Microsoft Excel? At present, across the top they are just "A," "B," "C," and so on, but I need to give them actual titles. Is there a way to do this? Some formatting trick or anything? Help, please!
  15. J

    How to turn a PDF file to a Excel file?

    Also how to turn a Word fiel to a PDF with out scanning?
  16. M

    CitectSCADA Excel Report?

    I am using CitectSCADA 7.10 , I've been asked to generate a report for the project i am working on ,that must be opened in microsoft excel( i know how to do it in RTF format ), I do not know how to do that ... am i supposed to do the report in dbf format dbase ?!?! if so i don't know the steps ...
  17. C

    how to increment value in excel?

    i want the rows to increment by 1 down the rows the starting number will be 1 and then ending number will be 7 i need to come up with a way to do this using a function and then dragging down the function please help!
  18. S

    I'm having trouble copying an pasting into excel /apple numbers?

    When I try to copy and paste(or for that matter just type) into excel (or my version of apple numbers, but problem on both) it either comes out across multiple cells instead of entering down on the cell, or enters down and does not show all writing in the box except for the first line unless I...
  19. K

    excel macro to clear filters?

    Does anyone have code for an excel Macro that when run it will clear filters for all columns in a sheet? Or even workbook? Its just really hard to go through a sheet and look at each column to see if there are any filters applied. A macro that would clear them all at the push of a button would...
  20. R

    Excel "=COUNTIF" help?

    If cells F3-F27 do not contain the text from cell O5, how do I get the following formula to display a blank space rather then a 0? =COUNTIF(Sheet1!F3:F27,Sheet1!O5)
Top