How do I delete multiple (several thousand) custom lists in excel all at once? I can delete them individually, but if I did that I would end up wasting a ton of time. [more inside]
Excel question: Can I enter just a 1-31 value into one cell and have a complete date appear in a different cell based on fixed month and year values? [more inside]
Is there a way to solicit responses to weekly queries in a way that would allow a tabulation of the responses without allowing anyone else to see another individual's answers? Difficulty level -- working for the federal government so have to do this within sharepoint and/or using excel spreadsheet. [more inside]
(Background at the top; question at the bottom) I work for a tech company and clients routinely send us their data for us to process. These are quasi-employee records, including the employee's department, location, age, etc. They give us all of the valid selections for each of these fields as part of their initial account setup and we can change them at any time. These are the selections they've chosen and most often match what is in their HRIS. But, they often send us mismatching data... [more inside]
I am trying to create a list that then calculates the quantity of people on the list. I want a formula that will check A1 and B1 and see if they are blank, if so, I want nothing, if they have anything in them, I want them to be added together. I don't know exactly how to do this formula. [more inside]
I want to use Google Apps Script to detect when certain cells in my Google Sheet are changed, and write a timestamp in another cell to denote when they were changed. I can't use the NOW() function because it gets re-evaluated every time the sheet is calculated. I need a more permanent timestamp. [more inside]
Please help me eliminate duplicates in a table based on specific criteria. [more inside]
In three cells in a single column in Microsoft Excel, I'd like to be able to input a number in the bottom cell, have the middle cell calculate what a 6% sales tax on the figure below it is, and provide the amount before that 6% tax in the top cell. Any help will be appreciated. The last math class I took was 44 years ago and I didn't pay much attention in that one.
There are these selectable objects/lines all over my Excel spreadsheet. Instead of selecting a cell, I'll often accidentally click one of these instead, and it is very annoying. Please help. [more inside]
I've been recently getting interested in various Macros and what they can do in Excel. Is there suppository of various Macros available online as well as clear demonstrations of what they can be used for that I can insert into my spreadsheets.
I need to make a series of 40 graphs (all of the same format) from an excel dataset and I'm having trouble figuring out how to do this efficiently. Basically, I would want something that would cycle through all the rows producing a separate graph for each row that could be copied into the appropriate section in the report. Although, I would prefer to do this in excel so that others in my dept could also use it, I do have R available if there is an easier way to do this in that environment. Any ideas? Thanks!
I have a spreadsheet that has students’ names and their class schedules. We want to be able to email the class schedule to the students using an email mail merge. I am willing to use Excel/Word or Google Docs/Sheets. I think I have figured out how to use a directory mail merge in Word to print the schedules, but we really need to email the schedules to the students instead of print them. [more inside]
I need to have two Microsoft Excel documents open side by side, on my monitor, at the same time. However each time I open a second document, the first one disappears and turns into the second, so only one of the two documents shows on my screen. [more inside]
I will be having a job interview that requires me to have some knowledge of Excel. I know this is vague but it includes, I presume, filters, hlookup, vlookup, and establishing filters to search out education data. The interview is to get a data analyst fellowship in the education setting. [more inside]
I recently started a new job as a Project Manager for an educational travel company and would like to beef up my Excel and project management skills. I was previously managing academic research studies. While a lot of that experience is relevant, my new responsibilities are more in line with those of a formally trained/certified Project Manager and so I’d like to do some self-study outside of work. Any recommendations out there for good online coursework? [more inside]
I often (upwards of 15 times a day) need to select some of the text within a cell or textbox in Excel, and format it bold and red. Not all the text in the cell/box -- just the text I select. Is it possible to write macros to do this task? And where should I go to find someone to write it? [more inside]
Hey Hivemind, So I am just beginning to foray into excel. I have create a worksheet for data entry and it has a lot of columns. To make my life easier, I viewed this website which provide a tip to make data entry more manageable. The author suggested to create a data entry form, http://www.launchexcel.com/excel-data-entry-power-tips. However, I cannot get this to really work in excel, it only partially works, excel is saying that the table is too large. Any ideas on how I can do this? Is there a work around?
ran a test that spits out a text file, need to excel it. having issues. more inside. [more inside]
I have data on one sheet of an Excel document with three columns. I want to extract this for use on another sheet as follows: If a row in Column A contains X (text string) and a row in column B contains Y (also a text string) then what does the row in column C (always a value) which matches these two criteria contain? With the data I have, this will always return a single result. [more inside]
I have limited experience with Excel. However, some of the templates, when you open a new workbook are beautiful, I have no idea how to make those types of workbooks. Any advice on online tutorials that take you a little beyond the basics? Also, I am making a template/workbook to capture qualitative data. I am not using a qualitative data analysis software, just Excel, any tips or tricks on this? thanks
I've recently discovered Excel's Power View plugin and I'm naive enough to think it can solve a problem I have. I've watched this pie chart video (about halfway down). I can't make it do the 'partially shaded slices' thing in the video at 3:23. Help? [more inside]
Probably pretty simple, but I would like to clean up the Metafilter Infodump timestamp, help? [more inside]
I'm looking for recommendations on software or practices to do automated testing of spreadsheet models. [more inside]
I only have a basic understanding of Excel functions. I know that it's possible to do what I want, but I'm not sure how to go about doing it. I need help figuring out the average amount of time that passes between the dates two particular actions happen across multiple different people. I'm looking for the overall average, as well as the average for each person. Complication, some of the rows don't have the action I'm interested in tracking, so that column reads as N/A and is messing up my formula. [more inside]
With my gmail account I am in frequent contact with a particular individual. So frequent that our emails are kind of a mess, and I want to know if I can organize them in any way. [more inside]
ExcelFilter: I have two columns of data- column one is every day in a month, column two is attendance. I'd like to have a line graph that shows the data split into 7 lines- one for Mondays, one for Tuesdays, etc. How can I do this?
How can I better track specific parts of my life with an app or spreadsheet? [more inside]
I have an Excel spreadsheet I use to track glucose readings. There’s a value diabetics use called “A1C” which looks at the last three months of readings. It's based on a blood test, but can be estimated by averaging your readings for the last three months. I try to track every day, but I can’t reliably say “look at the last 90 values” – so I’m wondering how to set up a formula to tell it to only look at readings going back 90 days, not necessarily 90 readings. More inside. [more inside]
How can I combine these two tabs of data in Excel using VLOOKUP and/or some other function? [more inside]
I have a range of cells in Excel that all have the same text, but within the text are two numeric values. I want to remove everything besides the second numeric value. [more inside]
I am stumped and hope you can help. [more inside]
My data are outputted from the source as a single-value column, but I'd like the data formatted as a four-replicate column. Is there a function in Excel for this? [more inside]
This will be easy for someone, but math is my second language so I'm at a loss. How do I solve for the percentage of a TOTAL budget, when one line item is unknown (and is part of the total budget)? [more inside]
Is there an easy way to convert Excel checkboxes to text? I have hundreds of workbooks I'm trying to combine. They all have 7 columns of checkboxes and varying numbers of rows. Once we get to a few hundred rows in the individual workbooks the file starts wanting to hang, so when I combine all of these workbooks, I'm envisioning a lot of pain. Is there a quick and easy way to replace these checkboxes with simple text? Something as easy as find and replace would be ideal.
I'm working on a formula (not a macro) to convert a Letter (in this case, a column letter) to a Number, and vice versa. So: A = 1, B = 2, C = 3, Z = 26, AA = 27, AB = 28, AC = 29, ZZ = 702, AAA = 703, AAB = 704, AAC = 705, BAA = 1379, etc... Of my three part formula(s), I have the one-letter and two-letter columns working, but I run into issues with the three-letter columns (AAA and beyond). [more inside]
I need to get some patent data (Pat Number, Issue Date, Main Claim, Abstract, Forward and Reverse References) from about 100 patents into excel. Is there a site that does this for free? [more inside]
I need help with gmail functionality. I need to figure out how many(ish) extra hours I generally work. I think an easy way to capture part of this is to check out the volume of email sent outside of my working hours. Is there a reasonably easy way to do this? [more inside]
I'm undertaking a research project in which I'm evaluating several different organizations based on specific yet qualitative criteria, e.g. "promotes outreach", "reports on progress", etc. I need to able to capture the information and then display the results in some sort of meaningful way so that it can be incorporated into a report. [more inside]
Can an Excel expert help me with counting rows in a spreadsheet that can match one of 15 possible combinations? [more inside]
I'm in charge of a tuition reimbursement process in my company-- people give me their approved applications along with their grades and receipts and I calculate the reimbursement and send it along to accounting. Part of this process is keeping tabs on what's being spent on what. Right now, I'm using a massive Excel sheet to do this and it is messy. [more inside]
I need to provide some sales data but am unsure how to manipulate the data in a pivot table to get the specific details requested. I'm sure this is simple but my pivot table skills are, admittedly, terrible. Details inside. [more inside]
At work I have the responsibility for an Excel-based model, which is a nested series of workbooks and folders with many links to each other. We need to be able to rename the master folder, move the folder about, and keep all links still linked to the enclosing folder. [more inside]
I want to generate synthetic user-session data to predict how big a peak in application usage might be shortly before a weekly deadline (for timesheet submission - it's a time and labour tracking application). I've come up with a method that looks like it works - it involves a gamma distribution for the login time. But I don't have enough (in fact, any) statistical training to know whether I'm using that distribution meaningfully. Statisticians, please reassure me. Thanks! Excel functions inside... [more inside]
I have a spreadsheet that contains information I want to use to fill out a form, Mad Libs style. Essentially, I'd take each row of the spreadsheet and use the cells to populate a text document. It's not actually in Excel/Word - it's in Libreoffice, if that changes anything. I also need room for conditional if-then statements, because some text may require additional accompanying notes. I tried generating a pdf in Nandeck (card game generation software) but that doesn't work well for formatting text relative to other text, so I'm looking for a better solution.
Give me your best invitation/list/contact/event management software suggestions. My employer hosts numerous events every year. Most are political, and seek to raise money or garner support. All require complex invitation lists, based on affiliation or past attendance at similar events. Do you know of any very user-friendly list management software that will create contact lists based on this kind of criteria? [more inside]
As users of Excel may know, only one hyperlink is allowed per cell. I'm trying to import HTML tables in which there are sometimes two hyperlinks per cell. The Excel importer does not seem to like this, so it gets rid of the link. Is there any way around this? [more inside]
I have a PDF with several hundred pages. Each page is formatted identically and contains data on a single person, divided into various tables. I want to parse the PDF so that each person's data is a single row in a spreadsheet, with various key points (e.g. "name") in the same column. I feel like this has to be an already-solved problem. How can I do this?
I need to print simple 4"x3" conference name badge inserts - just first name, last name, and a custom background image. I have Word, Excel, Illustrator and Access (though I've never used Access). I have the names in an Excel spreadsheet, and I've created a nice .jpg/.png image as the background. How do I pull this all together? Thanks!
Does anyone know of a friendly program for batch-converting a folder full of hundreds of HTML tables to CSV format that will load in Google Spreadsheets? I know I could just load one in Excel but I need to automate it to handle tons of these files.
I'm trying to test if a a series of cells exist, and then concatenate the values that do exist with a paragraph I have. [more inside]