• Excel graph gaps

    I would like to create an "x,y" type plot ("scatter graph" in Excel terms) in which the "x" array is continuous, but some of the "y" values are invalid because the formula has a limited valid range. I can use an IF to substitute "" or "nil" "invalid" or something for the invalid "y" values....

    TomGlass20 pointsBadges:
  • Help finding duplicate info in Excel in different columns

    Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a duplicate. The info is the same just in a different column whether it be Store1 or Store2,...

    Hmstacco20 pointsBadges:
  • coordinate file import

    can I import cartesian coords into acad from wordpad or exel

    Moseseh5 pointsBadges:
  • MAXIF formula

    Excel has SUMIF and COUNTIF functions, but I don't find a comparable MAXIF funciton. Can such a function be added into Excel? Any suggestions for sources?

    TomGlass20 pointsBadges:
  • Excel Macro to Create additional Sheets, based upon cell values

    I have a spreadsheet that contains a report of which department has an item entered. what I want to accomplish is to move the individual 'department' data to thier own sheets. I have one case where I will have 4 different departments combind on one sheet, the remaining will occupy thier own sheets....

    Donatelo305 pointsBadges:
  • Having problem opening Excel files on Zip drive results

    A reader asks: Hi There. My question relates to opening a file in Excel 2007. Briefly, files were created on another computer using Excel 2007, put on zip drive which I have been able to open print, update, etc. previously. Now it allows me to open the files, however, no data appears on screen once...

    BrentSheets6,925 pointsBadges:
  • Cannot Open Older Excel Files with 2003

    When trying to open older Excel files, i get this message: You are attempting to open a form that is blocked by your registry policy setting. How do I can my registery settings to access older Excel files???

    Reap5 pointsBadges:
  • Place Holder

    I have part numbers that are in the form of 12345678-001. I am trying to write a macro that will search through the 13000 lines of part numbers and enter a revision level next to it. I want it to only look at the first 8 numbers (before the "-"). This is what I currently have: Dim Timer As Integer...

    Davidhinze5 pointsBadges:
  • networking

    i have pc and thin clients in our bank how can i access to excel and word files on pc through thin client ?

    Sanjumaur5 pointsBadges:
  • automatic publish of charts to web

    On worksheet (5) I have graphs based on the 4 previous sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for the republishing to be automatic. The graphs are updated once the data is changed but I want the user to use the intranet rather than the spreadsheet.

    Gerrib150 pointsBadges:
  • Updating textboxes on a Userform

    How can I get real time information in a text Box on a userform when a macro is running

    Alanr5 pointsBadges:
  • Excel Graph Question

    I have a graph that isn't graphing all of the data and I don't know what to check. I have the cell range going through cell "FA7" but it stops at cell "GH7". I have several graphs with this range that are working fine, but this one graph stops short and I can't figure out why.

    Swh0085 pointsBadges:
  • Deleting all formulas in a worksheet when unprotected in VBA code

    I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...

    Barnoldswick5 pointsBadges:
  • importing an EXCEL tab

    while importing an EXCEL tab with the import wizard, ACCESS 2003 changes a text field with only numbers that exceeds the long integer format to scientific notation. Is there a possibility the numbers do appear?

    GIT02110 pointsBadges:
  • Macro determining end effective dates

    I am using Excel 2003. I am creating a data-entry spreadsheet that contains supplier costs for components. For each component (Record), it has a begin date for when the price goes into effect and an end date. Since I want a history of this item and the dates that it increased or changed, there will...

    Jhowells285 pointsBadges:
  • Designing a report in SQL from an Excel worksheet

    I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?

    SQL Server Ask the Experts2,585 pointsBadges:
  • External references in excel gives error while mailing

    I had an excel file having external reference. When I email this file to someone else, it shows #REF! in the columns having external reference

    Kapilrewari5 pointsBadges:
  • Auto Sort in Excel

    I have the worksheet to Sort in decending order on column L when the workbook is opened. I have a title in Row One, and Header in Row 2, The header in row 2 has autofilter turned on

    FJF5 pointsBadges:
  • Excel – Automatically Publish graphs to Intranet

    I want to publish updated graphs to my intranet automaticlly. ie open excel, refresh data (from as400)then save,publish&close (running from the scheduler ) I have my Downloaded vb express & looked at vb sites etc… & managed to create a project which publishes the page to the intranet correctly...

    Gerrib150 pointsBadges:
  • finding words within other words with an Excel macro

    column B has 2 letter words, the next 3 then 4 and so forth. I am looking to find the words in each column to the right to find all of theentrie that contain it and change the color of only the 2 or 3 or 4... letters in the new word for all words in each of the colomns to the right. Example: AA...

    Brayleen5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.