Search Results

Search found 61743 results on 2470 pages for 'excel web query'.

Page 13/2470 | < Previous Page | 9 10 11 12 13 14 15 16 17 18 19 20  | Next Page >

• Stop Excel from changing cell contents, ever

  - by Enable Manual-Correct

  I work with card numbers, like credit card and ID numbers. We do not do any calculations with card numbers, obviously. They are "text." I format them as text, I type them like text. I know how that works. Excel doesn't care. 16 digit card numbers get their last digit turned into a zero, changed into scientific notation, stupid stuff that I did not…

  Read the article

• In-memory Database in Excel

  - by user329174

  Hello, I am looking for a way to import a datatable from Access into an Excel variable and then run queries through this variable to speed up the process. I am trying to migrate from C# .NET where I read a data table from an access database into memory and then used LINQ to query this dataset. It is MUCH faster than how I have it currently coded…

  Read the article

• Exporting only visible datagridview columns to excel

  - by Suresh E

  Need help on exporting only visible DataGridView columns to excel, I have this code for hiding columns in DataGridView. this.dg1.Columns[0].Visible = false; And then I have button click event for exporting to excel. // creating Excel Application Microsoft.Office.Interop.Excel._Application app = new…

  Read the article

• Tell AppleScript to go to a specific window in Excel

  - by Nick

  I've got a script that pulls information from an Excel(Mac Excel'04) spreadsheet, and processes it through a local database. My problem(which is temporary, pending a dedicated scripting machine w/ Excel '08) is when I need to work on another spreadsheet in Excel. I want to ensure that the AppleScript…

  Read the article

• In Excel 2010, how can I show a count of occurrences on a specific date within multiple time ranges?

  - by Justin

  Here's what I'm trying to do. I have three columns of data. ID, Date(MM/DD/YY), Time(00:00). I need to create a chart or table that shows the number of occurrences on, say, 12/10/2010 between 00:00 and 00:59, 1:00 and 1:59, etc, for each hour of the day. I can do countif and get results for the…

  Read the article

• Query with UDF works in Access but gives Undefined function in expression (Err 3085) in Excel

  - by ronwest

  I have an Access table with a date/time field. I wanted to make a composite Key field out of the date/time field and 3 other text fields in the same format as the matching Key field in another database. So I concatenated the 3 text fields and wrote a User-Defined-Function in a Module to output the…

  Read the article

• How to hire a web-programmer : for non-programmer

  - by 0Complex

  I am a non-programmer that has used the services of : freelancer, odesk, etc I've tried asking for what i need but, I can't find anyone who can show me any type of example similar to what I request in the specs for the web-programming. They have front ends and back ends, but they don't fulfill…

  Read the article

• How to hire a web-programmer : for non-programmer

  - by 0Complex

  I am a non-programmer that has used the services of : freelancer, odesk, etc I've tried asking for what i need but, I can't find anyone who can show me any type of example similar to what I request in the specs for the web-programming. They have front ends and back ends, but they don't fulfill…

  Read the article

• Starting off with web dev with php

  - by pavan kumar

  I'm currently working with Java / C++. I'm interested in web development and am planning to shift my stream. I heard that PHP is a good platform to start off and also it does not require that much of knowledge in technologies like JSP / Servlets or frameworks like springs / struts / hibernate. …

  Read the article

• What Web Technology to use?

  - by Sven

  Hey guys, I would like to start a project and I am concerning what kind of programming language/web framework to use. There is not that much logic involved. It's about a community-page with a lot of users(not that much at the beginning but I would like to be ready to welcome a lot), that should…

  Read the article

• Web framework able to handle many concurrent users [closed]

  - by Jonas

  Social networking sites needs to handle many concurrent users e.g. for chat functionality. What web frameworks scales well and are able to handle more than 10.000 concurrent users connected with Comet or WebSockets. The server is a Linux VPS with limited memory, e.g. 1GB-8GB. I have been…

  Read the article

• how to create a wind rose in excel 2007

  - by Patrick

  I am attempting to create a wind rose graph (i.e.- here or here). My data is wind speed and cardinal wind direction in separate columns: Wind (mph) Wind Direction 3.66 SE 2.69 SE 2.62 SW 2.76 SW 2.11 NW 3.13 NW 3.55 SW 3.62 W My…

  Read the article

• Excel: Summing values within a certain date range (> start date and < Finish date)

  - by Mike

  How do I include a 'Between these dates' criteria inside a SUMPRODUCT? =Sumproduct((RangeName=Cell A1)*(RangeDate=Between 01/03/10 and 31/03/10)*(RangeCost)) What's the way to manage dates (between) in a sum product? Thanks Mike

  Read the article

• Excel - working with multiple workbooks

  - by cKK

  Got about 50 workbooks that cannot be merged but need to make the data available in a nice easy way. Aany ideas how to open and close multiple workbook modally i.e control remains in some interface / menu window? all workbooks have multiple sheets and need to be opened read-only. …

  Read the article

• Excel Help: Userforms

  - by B-Ballerl

  I have developed a macro that does a whole bunch of things for me based on a few things. (Importing files). The file names are dated dd_mm_yyyy and right now I enter them into a sheet where the macro can call the information. Not really wanting this I designed a userform where the…

  Read the article

• Excel how to get an average for column for rows that meet multiple criteria

  - by Jess

  I would like to know the average days between open and close dates for an item with a close date in a particular month. So from the below example in Jan 2013 items 2,5 and 6 were closed (Closed can be RESOLVED or CANCELLED status), each were open for 26, 9 and 6 days respectivly.…

  Read the article

• find the next due date after today within a group in an Excel PivotTable

  - by Dennis George

  I have got a table set up in one sheet with "transactions". Each row contains a name of a vendor, the amount owed or paid depending on transaction type, and the due date/transaction date. Here is some simplified sample data: Vendor Date Invoice Payment Vendor A 6/30 …

  Read the article

• embed file in Excel cell

  - by Crash893

  I'm working on a simple "DB" for some people at work and I don't want to do anything fancy. the fields should be something like name , number , notes , File:resume, notes (where file:notes is the acutall embedded resume. I cant see any obvious way to do this but i thought i…

  Read the article

• How to generate weekly dates from bi-weekly pay period in Excel

  - by A_Pointar

  I'm trying to convert bi-weekly pay period to weekly dates. Lets say I have 3/2/2012, 3/16/2012, 3/30/2012 and some gaps and then again biweekly dates. generate 3/9/2012, 3/16/2012, 3/23/2012, 3/30/2012 and so on...I was trying to use INDEX and MATCH but it would give me…

  Read the article

• Excel: ROUND & MOD giving me strange DATE results

  - by Mike

  This is sort of related to a previous question. My formula, which seemed to work fine yesterday now gives strange results. Today is the 30th of March (30/03/10). It's 10:11am on the clock that the computer is using for the time stamp in the NOW() part of my worksheet.…

  Read the article

• Where to find a VBA function's source in Excel

  - by rutherford

  I have a workbook that uses a certain vba function which doesn't appear in the Insert | Insert Function... dialog box list of available functions. How do I find it's source (to see what it does)?

  Read the article

• Excel - Referring to a certain cell based off of data in another

  - by Ethan Brouwer

  I have a spreadsheet where there is one table with the headings: Coordinate, Lat, Long Another with headings Triangle, Coordinate 1, Coordinate 2, Coordinate 3, Area What this is for, is taking the triangles formed by the specified three coordinates' area based…

  Read the article

• Comparing columns in Excel

  - by Regan

  I needed to take columns A, B, and C and compare D, E and F. Here's an example: A B C D E F Jump Smith 5 Jump Smith 8 Run …

  Read the article

• How can I copy cells in Excel 2007 and paste with formatting

  - by John

  I am wanting to be able to copy cells in a worksheet and paste them elsewhere in the same worksheet while maintaining the original formatting. I also want to be able to paste into Word and Outlook and keep the same formatting. Everything I have tried discards the…

  Read the article

• Excel 2011 for Mac VLOOKUP Date Issue

  - by Mitch

  I'm fairly proficient in using vlookups, but I'm having an issue vlooking up dates between two different spreadsheets. =VLOOKUP(B6,'[example.xlsx]Sheet1'!$B$1:$AA$260, 19, FALSE) My formula is retrieving a date fine, but the date is different when the cell is…

  Read the article

< Previous Page | 9 10 11 12 13 14 15 16 17 18 19 20  | Next Page >