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

Intense Excel Question: Calculate a rolling YTD/YTD that is dynamic? [more inside]
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

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