Hi, hoping some MS Excel or HTML wizards can help me out with this. The goal is as follows; format a list of domain names so I can publish them on a webpage with hyperlinks to their individual addresses
(currently they are all in Excel with each domain occupying a single cell in a single row; they are currently formatted like this: "domain.com"). There are just to many to go through and add this to each one.
[more inside]
posted by Jhaus
on Feb 21, 2006 -
8 answers
I'm using Excel to create a weekly pay stub for a nanny, but I haven't figured out how to automatically include the previous week's data to create a "Year to Date" column for wages and taxes.
[more inside]
posted by ShooBoo
on Feb 17, 2006 -
6 answers
It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank.
[more inside]
posted by godawful
on Feb 10, 2006 -
9 answers
ExcelFilter: How do I convert a column of names formatted
Smith, John into
John Smith. Feasible?
posted by furtive
on Feb 9, 2006 -
8 answers
I've got two columns in MS Excel. They each share 200 numbers. However, one of the columns has an additional 700 numbers. I want the column with 900 sorted in ascending order, with like numbers from the column of 200 beside those in the column of 900. How do I do that?
posted by panoptican
on Feb 8, 2006 -
18 answers
Excel problem. How do I convert the following number format.
106026 where from left - first digit is CENTURY. Next two are YEAR and last three are JULIAN DAY. So last example is CENTURY 1, YEAR 06, and 26th Julian day of the year.
I would like to convert to to mm/dd/yy. Anyone have good Excel-fu for this?
posted by thimk
on Jan 26, 2006 -
10 answers
Basic Microsoft Excel question. How do I join two databases together when they share elements but are not coextensively equal? (More)
[more inside]
posted by Mr. Justice
on Jan 22, 2006 -
8 answers
Excel Question: I have 2 lists of text data separated into 2 columns -- column A and column B. Column A is a significantly longer list (close to 10k cells) than Column B (5-6k cells), but many of the cells in Column A are identical to cells in Column B. What I would like to do is generate a Column C that only contains cells from Column A that are NOT also in Column B.
[more inside]
posted by Soulbee
on Jan 19, 2006 -
7 answers
Excel's built-in conversion to HTML results in a monstrosity of a web page. Can anyone recommend the best "scrubber" or converter utility that does the best job (Windows or Mac)?
posted by spock
on Jan 12, 2006 -
9 answers
Excel Wizards (or Apprentices, Probably) Grading is upon me again and there's something I've always wanted to do in Excel automatically -- from a range of values, drop the lowest N values and average the rest.
[more inside]
posted by ontic
on Dec 19, 2005 -
7 answers
Microsoft Excel. Is it possible to insert some "alarm" function that will notify me if I insert duplicate text in later cells?
[more inside]
posted by Amizu
on Dec 7, 2005 -
4 answers
I hate Excel. I have a load of data in an HTML table. One of the columns has the data in the format xx:xx.x (e.g. 03:45.7). THIS IS NOT A TIME. IT JUST
LOOKS LIKE ONE. Whenever and however I import this into Excel, it will always import it as a time causing me no end of aggrevation.
[more inside]
posted by Hartster
on Dec 5, 2005 -
17 answers
In Excel 2002 when I create a PivotChart and apply a custom or user-defined chart type (in this instance a 2-axis line chart), the chart type reverts to a standard single-axis line chart whenever I modify one of the PivotFields. How do I prevent this?
[more inside]
posted by Ritchie
on Nov 30, 2005 -
3 answers
Using MS Excel 2002 (Win), my mom has managed to reverse the order of the columns at the top of the page (Z to A instead of the usual). _Not_ the actual cell entries, but the columns themselves appear in reverse order. She has no idea how/when she did it.
[more inside]
posted by rexruff
on Nov 11, 2005 -
3 answers
Excel experts? Between two Excel files, anyone know how I can reassign the data source file when I'm working on my Mac with files emailed to me by my boss, created on his PC?
[more inside]
posted by seaward
on Nov 9, 2005 -
3 answers
Is there an excel version of writely.com? In other words, I need to find a free, collaborative, spreadsheet app hosted online. Does it (or something close to it) exist?
posted by limitedpie
on Oct 17, 2005 -
3 answers
I'm looking for advice on teaching basic Excel skills to adults in a classroom setting.
[more inside]
posted by jessamyn
on Oct 10, 2005 -
17 answers
ExcelFilter: I know how to import a text file into Excel using the wizard for fixed column widths. Can I automate the process?
[more inside]
posted by Lokheed
on Oct 5, 2005 -
6 answers
Is there a quick way to create a mail merge directory in Word from an Excel spreadsheet, broken down by a specific field (department, category, etc.)? This seems like a Microsoft 101 question, but the built-in Help doesn't seem to address this specifically, and
online help from Word 2002 gets into code I can't even begin to understand.
[more inside]
posted by pzarquon
on Sep 7, 2005 -
1 answer
Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table?
[more inside]
posted by clgregor
on Sep 2, 2005 -
5 answers
I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand.
[more inside]
posted by michaelkuznet
on Sep 1, 2005 -
5 answers
Excel - I am interviewing a couple of people tomorrow for an admin job within my team. One of the things we want to check is their proficiency with Excel. Does anyone know of a site that has a downloadable Excel spreadsheet that we could give them as a test
posted by lloyder
on Aug 24, 2005 -
1 answer
Is there a way to prevent a Pivot Table (in Excel) from displaying a row with all zeros?
[more inside]
posted by grateful
on Aug 10, 2005 -
10 answers
Timecode filter: how do I subtract a given number of frames from 400 timecodes in an Excel spreadsheet?
[more inside]
posted by forallmankind
on Jul 5, 2005 -
5 answers
Help me get a professional massage!
What is a "named range" in Excel and how do I create one? I cannot import an .xls file into her outlook contact folder until I address this issue.
[more inside]
posted by sourwookie
on Jul 5, 2005 -
6 answers
I have a number of Excel files with thousands of small bitmap images embedded. I need to extract these into individual files which a designer can put into Quark and match up with the original text.
[more inside]
posted by skarmj
on Jul 5, 2005 -
15 answers
I used to think I was good at Excel. I could add, subtract, multiply and even use PivotTables! But I have a big problem with Excel: Why does it jump to cell 65,000 occasionally when you try to copy and paste?
[more inside]
posted by Happydaz
on Jul 4, 2005 -
6 answers
I have a complicated Excel valuation spreadsheet. The "bottom line" is affected by about 20 variables. I'm comfortable fixing about 17 of them, but for the remaining three, I wish to output to a 4x30 matrix, consisting of parameters A, B, and C, and the bottom line value that corresponds to each of the three. As it stands now, I can plug and chug, but it's a bit unwieldy, and I may wish to make a bigger matrix soon (I'll keep the 4 parameters, but I may wish to go 4x100 or the like).
I can't reverse engineer the entire spreadsheet-- it would take forever. So, how do I build this matrix?
[more inside]
posted by Kwantsar
on Jun 23, 2005 -
6 answers
Suddenly, when I double click on an Excel document to open it, it won't open the document (specific details inside): can this be fixed without reinstalling Excel or Office?
[more inside]
posted by anastasiav
on Jun 16, 2005 -
4 answers
When I try running long complex macros in MS Word for OS X, created in Office for Mac OS 9.2, some of the macros are freezing/crashing. Perhaps even worse, the macros don't seem to be failing at the same point each time I try to run them.
[more inside]
posted by ParisParamus
on Jun 15, 2005 -
1 answer
Follow up Filter. Last week on AskMe
I asked for help getting a formula to calculate "future value" in excel. blue mustard came through with the perfect answer: "fv = pv (1+r)n + pmt ((1+r)n - (1+q)n) / (r-q)" Now, I need to have a formula I can plug into excel that solves for q in blue mustard's formula.
[more inside]
posted by wtfwjd?
on Jun 9, 2005 -
3 answers
Dear Excel Gods, please tell me there is an easy way to do this. I am so stuck! I am using FV (Future Value) to figure out the return of an investment. But, as it says in the excel help, "[FV] Returns the future value of an investment based on periodic, constant payments and a constant interest rate." The payment I am getting is
not constant, but rather itself grows by a constant interest rate each period. So what equation or formula do I need for that?
[more inside]
posted by wtfwjd?
on Jun 2, 2005 -
10 answers
Is there some way to link an Excel spreadsheet and Word document such that a portion of the Word document will update automatically from changes in the Excel file?
[more inside]
posted by nelleish
on May 30, 2005 -
6 answers
I'm working on my MA thesis and so have an enormous jumble of books, articles, and references kicking around. I am looking for an easy way to manage this.
[more inside]
posted by synecdoche
on May 4, 2005 -
31 answers
I dumped a week's worth (about 1400 rows) of successful connection data from my company's VPN concentrator logs into a .csv file containing the following columns (A through D): Date, Time, Username, Source IP. I am trying to filter the list in Excel so it only shows the most recent connection data per username, but I can't figure out how to accomplish this programmatically.
[more inside]
posted by pmbuko
on Apr 27, 2005 -
17 answers
I want to use Excel's mail merge feature to make students ID's. In order to do this, I must be able to insert photos into specific cells. When I insert a picture it just lays on top across whatever cell happen to be behind it.
Is there a way for me to get pictures into specific cells?
posted by leapingsheep
on Apr 24, 2005 -
4 answers
I was hoping someone might have insight into why, when I filter row of text in Excel for Unique Values, i.e., no duplicates displayed, I still get some duplicate rows. Has anyone experienced this? Again, it's text that I'm working with; not numbers.
posted by ParisParamus
on Apr 6, 2005 -
4 answers
Mathematical imbecile question: what's the simplest, most universal way to add a list of vectors?
[more inside]
posted by Jimbob
on Feb 19, 2005 -
7 answers
I am looking for software that will generate charts and graphs that isn't Excel. [MI]
[more inside]
posted by donovan
on Feb 16, 2005 -
16 answers
