Complicated Excel formula question involving text-search and Japanese characters. Can you help? [more inside]
posted on May 27, 2008 - 2 answers 
Getting Excel to interpret text string as formula [more inside]
posted on Mar 29, 2008 - 7 answers
How to "text to column" a cell with multiple lines in Excel? [more inside]
posted on Jan 24, 2008 - 7 answers
Excel Filter: Selecting a cell/row based on current month. [more inside]
posted on Nov 23, 2007 - 5 answers
I need to put some test score data into Excel that works with children's ages in years and months.
[more inside]
posted on Aug 25, 2007 - 5 answers
I need help with counting formulas in Excel! [more inside]
posted on Aug 12, 2007 - 13 answers
Excelfilter!!
Okay, how would I do this in MS Excel???
[more inside]
posted on Jun 21, 2007 - 6 answers
I need some really REALLY basic spreadsheet help. I've been given the task of creating a spreadsheet that will work out for us several things - how many orders we need in total and per week, how much revenue this will bring, etc. I've got most of it worked out, but I can't for the life of me how to work out percentages.
Yes, I did Google this before asking. :D [more inside]
posted on Jun 16, 2007 - 8 answers
Excel question: How to define a range so that it always adds up to a constant value. [more inside]
posted on Jan 16, 2007 - 20 answers
I've got an Excel spreadsheet with numbers ranging from 2,000 to 600,000. I want Excel to look at each cell and essentially categorize all of those into five categories in a new column. If the value is less than 10,000, I want Excel to give it a 1, if the value is between 10,000 and 50,000 I want it to be 2, if the value is between 50,000 and 100,000, I want it to return 3, if it's between 100,000 and 500,000, I want a 4, and if it's above 500,000, I want a 5.
I tried the IF function, but I can't figure out how to a) make it recognize multiple variables, and b) I don't know how to tell it to look for numbers within a range. The Excel help section about arrays and lookups is fairly mystifying. Anyone got an idea?
(I know I could sort the data and do this manually, but I'd like to learn how to do this Excel's way.) Thank you!
posted on Nov 9, 2006 - 14 answers
I can't get a formula in excel to recalculate when copied and pasted to another cell. Help! [more inside]
posted on Sep 21, 2006 - 6 answers
ExcelFilter: I need help creating a pie chart as a separate worksheet in Excel that counts how often values appear in a column and creates a pie graph based on that data. I'm stumped, I'm not using the right Google terms, and my company's help desk couldn't guide me through the process, either. (That sounds awkward, so I describe it more comprehensibly inside.) [more inside]
posted on May 19, 2006 - 9 answers
Excel for OSX Filter: My Formula bar disappeared and I can't get it back! [more inside]
posted on Apr 23, 2006 - 3 answers
Excel Character Replacement [more inside]
posted on Oct 5, 2005 - 3 answers
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 on Jun 9, 2005 - 3 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 on Apr 27, 2005 - 17 answers
Excel formula question. Using Excel as an employee scheduler and need to help trying to create a formula for tracking.
posted on Feb 1, 2005 - 4 answers
I need to use Excel's FIND function to locate open-parentheses, but since parentheses are part of the syntax of the function itself, it's choking. How can I escape the character to make this work?
posted on Aug 6, 2004 - 8 answers
