15 posts tagged with excel *and* formulas. (View popular tags)

Displaying 1 through 15 of 15. Subscribe:

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

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

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

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

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

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

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

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

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

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

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

posted by zardoz on May 27, 2009 - 3 answers

Intense Excel Question: Calculate a rolling YTD/YTD that is dynamic? [more inside]

posted by Carialle on Sep 11, 2008 - 10 answers

posted by Carialle on Sep 11, 2008 - 10 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

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

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

posted by thecjm on May 21, 2006 - 7 answers

Page:
1