Excel 2007 Filter: I need to convert a text file to XML. I have an existing XML file that has the correct schema, but no functional xsd file. How do I get the schema from the old file to map to the data in the new text file? [more inside]
How can you merge and combine imported and converted .pdf to Excel 2007pages? [more inside]
So I am stuck at work with Excel 97. I am trying to do something that seems simple enough in my head but just isn't. Basically, I have a workbook filled with a bunch of worksheets. In some of those worksheets, I would a list of documents in a given folder with hyperlinks to those documents. I've managed to sort out a way to create a list of documents in a folder which updates each time the whole book is opened, but I really, really want that hyperlinked capability. More inside. [more inside]
Excel 2007 text to column help. [more inside]
Microsoft Excel Filter: When I type 0.000, I want the cell to display "0.000" and not "0". How do I stop all of this ridiculous autoformating in Excel for good? [more inside]
Microsoft Access 2007 - how on earth do I cut / copy / export / do anything with my Pivot Chart, besides print it? [more inside]
I need help calculating a construction interest payment schedule that is likely to follow a bell-curve. [more inside]
Yet another excel question - month + text criteria counting... [more inside]
Scanning, Excel, data input help needed. I need to convert info from a lot of hard copy bank statements into a an excel spreadsheet. Have tried scanning directly into xls and it results in a disorganized mess. Have tried to cut and paste from scan created pdf but it will not allow. Please help in automating this process and making my life a much happier place. [more inside]
Excel VBA Macro Help: I am trying to come up with a very basic script to paste a formula into any Non-Empty cells in the currently selected Range. but its not working. argh! [more inside]
Excel - How to get 'auto-complete' to work in an excel list being used to validate data entry? [more inside]
Microsoft Office 2007 filter: Can you recommend a program/plugin (or the like) which will replace the "ribbon" interface with a traditional menu interface? Free is ideal, but for-pay is okay, too. Running Windows XP. Thanks.
Excel 2007 question: I have several cells/columns of numbers that I simply need to double. So 5 becomes 10, 9 becomes 18, etc. I'm an Excel n00b and can't figure this out for the life of me. Help! [more inside]
Excel Filter: If, Count and Sum functions, oh my! I need help creating a function that will search between worksheet B, and if certain conditions are met, count the sum of cells in another column (also in worksheet B) and return that result in column A. Mock Excel workbook enclosed! [more inside]
The short of it: avoid duplicates, show multiple sales in one row. I am trying to aggregate sales data on an Excel workbook, and it really isn't as complicated as I'm making it out to be. Maybe MeFites have ideas? [more inside]
Wrangling Excel data in InDesign: When first creating a multi-page pricelist (which will need to be updated regularly), importing data from a 2000-odd row speadsheet, what should I be considering? [more inside]
My very important spreadsheet has become too big to use without excel/calc slowing so much that I want to take an axe to the computer. Help! [more inside]
i need to gather data from paginated tables and return them as a feed or something that can be easily pulled as a query into excel. [more inside]
I need help copying a table from Word to Excel in Office 2007. Where there are hard returns within a cell in the Word table, Excel splits the table cell into multiple rows. I need Excel not to split cells in the Word table into multiple Excel rows. At the same time, I need to retain the paragraphs that appear within the Word table cells - that is, I can't just get rid of all those hard returns; the formatting must be preserved. My Google-fu is failing me rather seriously. Is there any way to do this?
Map-plotting / excel filter: I have precise latitude and longitude coordinates in excel for approximately 100-200 different locations. These locations are all located in a certain region of the U.S. What software can I use (free or paid) to populate a nice looking summary map with each of these locations? I need this to look presentable for client purposes.
seeking a spreadsheet solution. I'm sure something like this exists, but searches have found templates that don't quite fit what's needed. [more inside]
I need to export a distribution list from Outlook to Excel (MS 2007 in both cases). [more inside]
Excel 2007 filter: How do you change the dictionary language for specific cells/columns/rows? [more inside]
Can I use Excel 2007's SUMIFS function to do the following on a budget/finance report worksheet: Sum all of the transactions given a specific category AND a specific month. [more inside]
What is the advantage of making a flow chart in Visio instead of Excel? I haven't played with Visio much yet, but I'm not seeing anything that's significantly better or easier.
Excel 2007 conditional formatting help! [more inside]
How do I "expand" time ranges in Excel? [more inside]
Is there a way to preserve grand total sorting in an Excel Pivot table when I've got a top 5 value filter on one of the columns? [more inside]
Excel filter: How to insert delimiters within one column?? [more inside]
How do I find and fix broken links in Excel.... when it's not in a cell formula? [more inside]
Help me make a smooth transition into a new job in finance. I need to brush up on technical skills, most likely via excel. [more inside]
Microsoft Excel substitute (Open Office seems not to work) needed to open a spreadsheet (directory of businesses) based on macros. [more inside]
help me parse this range of data using excel, by number of events per time span... [more inside]
iPhoneAppFilter: I have an Excel document on my home computer that I would like to be able to open and edit on my iPhone while I'm out and about, on an ongoing basis. The catch: app needs to be able to handle "index" and "match" functions. Without this functionality, the app would be useless to me. List of previous disappointments: DropBox (can't edit), QuickOffice (interfaces with DropBox but can't do index/match functions), Calc Lite (can't open document). I have zero programming skills and not that much more cash. Is my dream app (or combination of apps) out there?
Excel filter: Nearest neighbor identification. Do I need a UDF? [more inside]
PowerpointN00Bfilter: How do I use the graphing functions in PP and Excel to simply display 2 columns showing two different values of x% of something? [more inside]
Excelfilter: This may be a long shot, but..... Is there a quick way of formatting a table to group like records under a single heading? [more inside]
Passing an MS Office test with flying colors. [more inside]
ExcelFilter: Help me avoid scientific notation when importing a .csv file. I face the same problem faced by "Mark" in this article. Is there a solution to this problem that does not require changing the file extension? I am using Excel 2003.
Well, I created a spreadsheet in Google docs. A simple, no frills document where there are various columns - one s for email addresses. Those addresses I want to go into my Address book in either Gmail or Thunderbird. Downloaded the spreadsheet into Excel - in CSV format - tried to save it to text - it's obviously not working. Someone online directed me to the Google Scripts and to API. This is so not my forte' and it's for a non-profit and am getting lost in a sea of geekage. Is there a simple way to just export the column of email addresses, convert them into a database separated by columns, fit for my email program? Thanks in advance.
How does one auto-fill an Excel spreadsheet with terms from another data source? [more inside]
How do I chart my life? I'm using an Android App to input information against a date/time such as weight/mood/alertness/alcohol units etc. How can I easily view all this data on a big chart so I can see what relationships might exist? [more inside]
Windowing problem in Excel. [more inside]
Excel-finance future value help please.... Google Spreadsheet inside. [more inside]
YTD total based on sum of last number in another row that has a value? I need to sum up the values in one row based on the matching row below it. For example, if I have a target of $1000 a month, and I only have actual revenue numbers through June, I would like to calculate the year to date for the target from Jan to June. Once July numbers are put in, I'd want the YTD for the target to update to Jan to Jul. I have tried a couple of variations on COUNT, INDEX and OFFSET. Example is here: http://malcommc.com/ytd.xls I am using Excel 2003
I would like to take the information from this Wikipedia page (the HTML table parts) and dump it into Excel. I don't need the flags, I just need the latitude, longitude, city name and country. What's the easiest way of doing this? [more inside]
I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]
How to sort to count yes/no answers.... In Access or Excel. Help! [more inside]
Excel guru filter: I want to change this formula every week, and have the change cascade across 20 tabs of independent data. [more inside]
Is there a way to insert into a text string in Excel a "hard enter" so that when a series of rows of text are copied into Word that it automatically incorporates paragraph breaks between them? [more inside]