I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump.
[more inside]
posted by FireStyle
on Feb 23, 2013 -
9 answers
Is it possible to create an amortization schedule in Excel when the payment amount, the principal amount, and the interest amount each year is unique?
[more inside]
posted by lea724
on Mar 29, 2012 -
16 answers
I need to a formula that will calculate accumulated points based on the number of sales an employee had during a quarter, when there are certain milestones he or she has met.
[more inside]
posted by desjardins
on Feb 21, 2012 -
8 answers
There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data.
asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.
posted by spinturtle
on Mar 17, 2011 -
6 answers
Excel Spreadsheet - AutoMagically re-arrange data from one sheet to many based upon Alphabet?
[more inside]
posted by DrtyBlvd
on Jan 28, 2011 -
7 answers
Excel Filter: Say I have a spreadsheet with two types of data. a) list of transactions with date/time + transaction, and b) days with traffic. How do I reconcile the two sets of data swiftly & easily?
[more inside]
posted by Muffy
on Feb 12, 2010 -
8 answers
Please bear with me, as I'm having difficulty wording this question. I'm trying to use excel to add values that belong to a list. Basically, the list has a entry, each entry has a value, and I want to total the values of like entries.
[more inside]
posted by FireStyle
on Dec 2, 2009 -
4 answers
How can I create an Excel worksheet which uses something like VLOOKUP (or anything which works in a similarish way) not to pull values, but formulas?
[more inside]
posted by Bugbread
on Oct 22, 2009 -
7 answers
I need a formula to help calculate the number of days as compared to a range.
Importing a CSV for a query to show bookings within the date range of 9/1 to 9/30. Some bookings are booked through the entire month and some are partial. I need to figure out the number of days or percentage for the bookings that don't run all the way through the query range.
[more inside]
posted by malcommc
on Oct 1, 2009 -
9 answers
Asking_for_friendFilter/ExcelFilter: I’ve built a pretty basic calculator in Excel to help people figure out how much to bill for partial months vs. full months. As you can guess, there's...
[more inside]
posted by littlerobothead
on Jul 8, 2009 -
2 answers
This is probably a pretty basic Excel formula question, but I'm clueless.
[more inside]
posted by zardoz
on May 27, 2009 -
3 answers
Complicated Excel formula question involving text-search and Japanese characters. Can you help?
[more inside]
posted by Vorteks
on May 27, 2008 -
2 answers
I need a tool to help me analyze the probability of certain events occurring regarding a pool of X dice for a game I am creating. See my examples below.
[more inside]
posted by DetonatedManiac
on Dec 21, 2007 -
7 answers
I need help with an Excel formula. Warning: this may venture into the realms of calculus. Maybe.
[more inside]
posted by thecjm
on May 21, 2006 -
7 answers
