I have a batch of mixed-format data including long-form text fields, hyperlinks, number and plain text in an Excel doc. I have assembled a Word catalog merge file intended to allow me to proof the data manually. There are 42 records.
On merge, the output document results in what appears to be the correct number of pages and records. However, records 28-42 do not appear to place any data in the destination document.
[more inside]
posted by mwhybark
on Apr 15, 2013 -
1 answer
I need a solution to a pretty simple problem with counting instances of different text phrases in Excel.
[more inside]
posted by clockzero
on Mar 26, 2013 -
8 answers
I need help taming a very long list of numbers into useful tabulated data, in Excel.
[more inside]
posted by 256
on Feb 28, 2013 -
10 answers
I'm hoping there's an easier way to do this than my current manual process: I want to highlight text cells in Excel 2010 that are a duplicate of ONLY the cell below. Specifics inside.
[more inside]
posted by bibbit
on Feb 25, 2013 -
4 answers
I have roughly 20 people who each need a project. I have 27 projects and don't want anyone to share a project. I let the people pick their top five projects and rank them so I know who wants what. What is the best (easiest...) way for me to fairly figure out who should get what project so that the most people get their top choice, or at least one of their top choices?
[more inside]
posted by pwb503
on Jan 22, 2013 -
8 answers
I need to correlate two spreadsheets which relate to the same group of people. The name data is messy, however, and I'm having a hard time matching the names.
[more inside]
posted by mammary16
on Jan 18, 2013 -
8 answers
I'm writing some VBA code (in Excel) which uses a reference to
Microsoft XML, v6.0, and creates a
MSXML2.XMLHTTP object.
I used the
clsXMLHttpMonitor example from
this page as a starting-off point.
How can I access the response text when readyState = 3?
[more inside]
posted by jozxyqk
on Jan 8, 2013 -
10 answers
[Excel 2007 filter] Is it possible to input some text into a cell, e.g. "Click here for Worksheet 2" or similar, and create a hyperlink on that cell to open, uh, Worksheet 2? In the same window, not a new instance. Neither a search of AskMe and/or the Excel help-screens has been successful. Thanks in advance.
posted by aqsakal
on Dec 12, 2012 -
7 answers
Excelfilter: How do I find and replace (e.g. replace 17 for 18) a set of numbers in the format: 17-01-06 without it being recognised as a date?
[more inside]
posted by freddymetz
on Oct 30, 2012 -
4 answers
In Excel, I have two columns. Column A has many rows of names (e.g., Mary, Maryjane, Maryanne, Anne, Jane) and in Column B I have their ages (e.g., 4, 20, 40, 10). I would like to find the MEDIAN age of all the "mary's"; i.e., both "mary" and "maryanne", etc.
Is this possible? I have been getting errors on variations of {=MEDIAN(IF(A1:A4="*mary*",B1:B4))} constructions...
I do not want to use VBA.
thank you!
posted by noway
on Oct 26, 2012 -
5 answers
In Excel 2007, is there a way to highlight all cells within a certain range (in my case, five adjacent columns) that contain dates in the future?
[more inside]
posted by smirkyfodder
on Oct 15, 2012 -
2 answers
Displaying ideal ranges in the plot area of an Excel 2007 chart. Possible?
[more inside]
posted by xyzzy
on Oct 11, 2012 -
2 answers
I need to quickly figure the 9th and 20th business days of each month for the rest of 2012 and all of 2013. Preferably not in a manual fashion.
[more inside]
posted by reenum
on Sep 14, 2012 -
6 answers
Seeking recommendations for on-line training on business applications, particularly MS Office.
[more inside]
posted by dg
on Sep 4, 2012 -
8 answers
How can I improve my computer skills for job hunt when I use a Mac and the software is for PC?
[more inside]
posted by hrj
on Aug 9, 2012 -
24 answers
How to populate PDF form from Excel data: number of copies based on number of rows?
[more inside]
posted by GuppieXX
on Jul 13, 2012 -
3 answers
How to reformat pivot table data so that it works like any other spreadsheet? Simple instructions needed.
[more inside]
posted by Frowner
on Jun 20, 2012 -
6 answers
How do I import tables from HTML into Excel when some cells have multiple lines?
[more inside]
posted by KGMoney
on Jun 14, 2012 -
6 answers
How do I set conditional formatting in Excel based on whether a list value has been selected in a range of other cells?
[more inside]
posted by doyouknowwhoIam?
on Jun 2, 2012 -
1 answer
Is creating a compound line graph possible with this dataset? If yes, how? If not, how should I set up the data?
[more inside]
posted by chillmost
on May 31, 2012 -
3 answers
Excel Filter: Advanced Conditional Formating, Format based on type of formula used (average, sum, sumproduct etc..)
[more inside]
posted by MechEng
on May 7, 2012 -
5 answers
Could someone help me to analyze statistical relationship between two dimensions of a frequency matrix - preferably in Excel?
[more inside]
posted by Susurration
on Apr 10, 2012 -
10 answers
ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!)
[more inside]
posted by smirkette
on Mar 26, 2012 -
10 answers
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]
posted by Patbon
on Mar 5, 2012 -
13 answers
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]
posted by Servo5678
on Feb 17, 2012 -
5 answers
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]
posted by kensch
on Feb 1, 2012 -
6 answers
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]
posted by sillymama
on Jan 31, 2012 -
5 answers
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]
posted by yasaman
on Jan 12, 2012 -
20 answers
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]
posted by komara
on Jan 2, 2012 -
6 answers
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."
posted by lassie
on Nov 22, 2011 -
5 answers
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.
posted by notned
on Nov 18, 2011 -
8 answers
ExcelFilter: Currently using a clunky nested for loop - is there some way to make this more efficient?
[more inside]
posted by hot soup
on Oct 25, 2011 -
2 answers
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]
posted by Lentrohamsanin
on Oct 20, 2011 -
2 answers
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]
posted by cramer
on Oct 19, 2011 -
8 answers
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]
posted by headnsouth
on Oct 13, 2011 -
16 answers
Excel 2007 issue: I'm trying to have Excel mark matching data in two columns with some kind of color or formatting.
[more inside]
posted by lattiboy
on Oct 10, 2011 -
3 answers
Is there a way to Anonymize various excel columns to protect privacy during a presentation?
[more inside]
posted by fozzie33
on Sep 13, 2011 -
5 answers
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]
posted by periscope
on Sep 8, 2011 -
3 answers
I have a formula for inputting into my expense sheet but it doesn't populate the field like it should. I stole the formula from my time sheet, and that does populat the column for the 4 weeks after I manually put in date 1.
It is:
=IF($B$4=0,"",SUM(B4+1))
So...why does it work in one sheet but not the next?
[more inside]
posted by dash_slot-
on Jul 1, 2011 -
7 answers
As a result of my method for saving money, I've ended up with a huge excel spreadsheet for the last 4 years detailing how much I've put in and taken out of my savings account. The problem is that although I've taken time to record all this information, I've now realised that I'm not sure what I can actually do with it. Do you have any ideas?
[more inside]
posted by mr_silver
on Jun 30, 2011 -
12 answers
Excel help needed in calculating times.
I need to calculate and predict times based on fixed distances and a known average speed.
[more inside]
posted by dg
on Jun 28, 2011 -
8 answers
I have an excel file with a list of expenses that are continually updated, sorted by date. There is a column for specifying the category that each expense belongs to. Is it possible to create a formula that adds up the expenses that belong to a specific category?
[more inside]
posted by Phire
on Jun 21, 2011 -
4 answers
