How do I match number IDs from 2 worksheets - when one worksheet is only a subset of ids from the other?
Excel help: How do I match number IDs from 2 worksheets - when one worksheet is only a subset of ids from the other? [more inside]
Could someone help me to analyze statistical relationship between two dimensions of a frequency matrix - preferably in Excel? [more inside]
Former excel magician attempts to use Google spreadsheets, fails. It should be easy to make a function that can tally a monthly total from a column of dates and a column of numbers, right? [more inside]
Dear Chaps, I have two products, an Excel spreadsheet and a Filemaker Pro database. The excel spreadsheet is for sale to mortgage brokers. It's the kind of thing designed for a user to enter figures and get all kinds of graphs and information based on the data entered. The other is a contact manager database, again designed as an easy-to-use program for the end user. Does it make sense to turn these products into iPhone/Android/Cloud-based apps, and what would be the next steps in doing so? In other words, what exactly would I be turning them into, and whom would I outsource this job to, if it makes economical sense?
Is there a way to define a link by the number of links into the webpage it is? [more inside]
Is it possible to create an amortization schedule in Excel when the payment amount, the principal amount, and the interest amount each year is unique? [more inside]
ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!) [more inside]
How do I get Excel to search through multiple files and extract data into a separate worksheet? [more inside]
Does anyone else manage their finances in excel? How exactly do you do it? I would like to manage my (pretty straight forward) personal finances. Alternatives to excel welcome. [more inside]
I made an awesome dartboard-type chart in Excel, but now I'm trying to put it on the web. Help!! [more inside]
Excel-Filter: I am using Excel 2011 (for Mac, if it matters). I want to create a simple X-Y chart of two columns. That's it. Should be simple. But I must be missing something. [more inside]
I have a data set of user activity. It records every time an activity is completed by a user, with the date and user ID attatched. I need to tally up the number of times, by user, the user completes the activity on a unique day. [more inside]
Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time. [more inside]
I need to a formula that will calculate accumulated points based on the number of sales an employee had during a quarter, when there are certain milestones he or she has met. [more inside]
I have a PDF document and a spreadsheet in XLS format. We want to be able to put the spreadsheet into the PDF and allow users to click on the sheet's column headings to sort the data alphabetically depending on need. Is this possible? If so, what is the best way to do it? [more inside]
I want to do something ridiculously simple in Excel that doesn't seem to be possible. Please tell me that's not true. [more inside]
ExcelFilter: Is there a way to create a sheet for every row in Excel? [more inside]
ExcelFilter: Compare rows for data changes? I want to find out whether row values are different between two sheets on records that match. [more inside]
ExcelFilter: how do I get SUMIF to work so that if a cell in the reference range is blank, the corresponding cell in the sum range is picked up in the sum? [more inside]
In Excel I have 2 columns with dates in them. D1:D20 Start Date G1:G20 End Date. I want to highlight the cell in the range G1:G20 if the date is more than 14 days form the date in D1:D20. Obvious answer is conditional formatting, but I can't seem to create a formula with relative cell references. [more inside]
Mail merge woes - how can I get these decimals to display properly? [more inside]
In Excel, is there an easy way to make the sum of a column automatically ignore cells that contain date information? Also, is there a way to freeze both the top row and first column so they are always visible? [more inside]
An Excelfilter question, because I cannot for the life of me figure out how to do this without getting an error or making Excel crash... [more inside]
Help me understand how to make a macro do what I want it to do - automatically select the relevant area instead of a previously recorded cell range. [more inside]
I have about 200 separate Excel spreadsheets that I need to change one field in. There is a date in G4 that needs to be the same in each sheet. Is there way way to do this without opening, editing, and saving each sheet one at a time?
I have about 4000 pdfs that i need to scrape data from and put into a database. [more inside]
Excel skills required for a particular job… I'm not sure what they are asking for. [more inside]
Excel is treating me like a child because it thinks I can't tell the difference between .csv and .xlsx. It's wasting my time. Help? [more inside]
Excel issue. Tried looking on the internet, had no success. Can y'all help? Selecting and deleting multiple nonadjacent rows. [more inside]
How to prevent accepted tracked changes from carrying over into an excel + word + outlook email to 50 people?
Hi everyone, Hoping someone can help me sort this problem ... It's a excel + microsoft word document + mail merge to outlook email to 50 people. I am trying to help someone out - this is is as it just as it was described to me: Track changes were accepted and turned off and the email looked as it should - so off went 50 customized emails. ..unfortunately the sent email then shows that all the emails are sent showing all of the tracked change revision markings! Sorry if this is too vague. Thanks for your efforts :)
Explain to me Excel macros and how I can learn to program them (assume that I know absolutely nothing, because that would be correct). [more inside]
Excel statistics question (linear regression with weighted data points) [more inside]
Asking for a colleague: "Back in October 2008, I found a free online app that uploaded data from Excel and produced (very pretty) charts and graphs. Unfortunately, I didn’t keep track of the website, and I’m having trouble tracking it down again. Most of the free graphing apps I’ve found online today require that you manually input the data; I’m looking for something that will more easily upload a set of data from Excel."
Can I create pivot table from subset of data? If not, is there another way to do what I want to do? [more inside]
How do I become a spreadsheet power user? And do I have to get Excel to do it? (Or can I stick with LibreOffice/Google Docs?) [more inside]
Excel - Find and Replace -- I use the excel function find and replace often. One spreadsheet finds it instantly. Another searches each cell and takes longer. I stopped updating the instant one before I noticed the effect. Windows xp -- Office 2007 I'd like to have more of the instant search.
Help me write an Excel formula to extract specific data from a list? [more inside]
ExcelFilter: Currently using a clunky nested for loop - is there some way to make this more efficient? [more inside]
Inside is a recorded excel macro, designed to sort a specific range of cells on a specific worksheet from smallest to largest, from left to right, using the values in a specific range of cells in a row. Is there a way to edit this macro so that it will do the same sort on any selected group of cells on any worksheet? [more inside]
ExcelFilter: I'd like to copy the contents of cells from one sheet to another, based on the value of a cell in the first sheet. I'm struggling the proper vocabulary to Google this problem effectively. [more inside]
Excel-filter: Is there a way to copy a formula from a cell on one sheet (e.g., page 4) to a different cell on a different sheet (page 1), where the total from page 4 is carried over to page 1? [more inside]
Excel 2007 issue: I'm trying to have Excel mark matching data in two columns with some kind of color or formatting. [more inside]
Recommendations for an online Excel refresher course, preferably free, that will make me an Excel
God Master Wizard user compentant enough not to embarrass myself in 72 hours? [more inside]
Is there a way to Anonymize various excel columns to protect privacy during a presentation? [more inside]
I have reason to believe that in Microsoft Excel 2002 (PC) there is a shortcut that makes a menu pop up at the bottom of the worksheet (where the tabs are), that contains a list of all of the sheets in the current workbook, that you can use to go from sheet to sheet. What is the shortcut? [more inside]
I'm trying to merge multiple month's worth of data into one master spreadsheet with a master column on the left, and individual month's counts on the right. My data is laid out as such: [more inside]
How can I find the average of multiple columns in excel without selecting each individual row that I want averaged?
How can I find the average of multiple columns in excel without selecting each individual row that I want averaged? [more inside]
Excel question: I'm making a calendar/schedule in Excel, and I have the dates (numbers) aligned in the bottom right corner. I want to add information and text, though, starting in the top left corner. How do I do this? [more inside]
In Excel, how would I do the following: if a cell in a certain column has a duplicate in that column, plus the corresponding cell in that row but another column is blank, delete the whole row? [more inside]
Asking for a friend: I was entering some data into excel and I realized it was changing gene names into dates. E.g. there is a gene in my dataset called SEPT5 and Excel automatically makes this into Sep-05. If I manually set the column as text, it inexplicably changes the cell to a 5-digit number that represents that date, in this case 38596. [more inside]