Join 3,512 readers in helping fund MetaFilter (Hide)

11 posts tagged with formula and Spreadsheet. (View popular tags)
Displaying 1 through 11 of 11. Subscribe:

Need help with conditional lists in excel

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

Turning in my spreadsheet wizard badge.

Spreadsheet question: I want a column containing all the names in THAT column EXCEPT all the names in THOSE columns. [more inside]
posted by Salvor Hardin on Aug 2, 2011 - 6 answers

CONCATENATE/ CATASTROPHISE

In-over-my-head-Excel-filter: I need to put little braces {like, brackets}around a whole column of values using the concetenate function.. column A has all the values I need braced- but how do I get those same values {braced} in column B? [more inside]
posted by Philby on Mar 14, 2010 - 8 answers

Need a formula to lookup/match two values and return a third in Excel

Need a formula to look for two values in another sheet, and return a third corresponding value. Example provided (google spreadsheet.) [more inside]
posted by malcommc on Dec 28, 2009 - 5 answers

Blind Spot in my Excel Formula Abilities

Excel Idiot Filter: Is there some simpler way to calculate the averages of the same cell along multiple worksheets? [more inside]
posted by itsonreserve on Dec 23, 2009 - 7 answers

Reverse my percentage?

How do you find a number that minus a percentage of itself is a certain number? [more inside]
posted by JulianDay on Dec 6, 2009 - 7 answers

How do I select the last number in a column in Open Office Calc?

How do I select the last number in a column in Open Office Calc? [more inside]
posted by tomble on Jul 9, 2009 - 3 answers

Getting Google Spreadsheets to interpret string as formula

I have hundreds of text strings entered through a form in a Google Spreadsheets which look like 4*3 9*2 17*3 22 37*4 52. I can easily substitute " " for "+" and concatenate a "=" in front =4*3+9*2+17*3+22+37*4+52. Now I have a text string which looks like a formula but isn't one. How can I make Google Spreadsheets interpret this string as a formula? [more inside]
posted by Akeem on Mar 12, 2009 - 3 answers

Age formulas in MS Excel

I need to put some test score data into Excel that works with children's ages in years and months. [more inside]
posted by chairish on Aug 25, 2007 - 5 answers

2 + 46% = ?

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 by Solomon on Jun 16, 2007 - 8 answers

AppleWorks Spreadsheet help?

AppleWorks Spreadsheet: how do I write a formula which returns a count of the number of times a specific string of text occurs in a cell range?
posted by Dick Paris on Sep 1, 2004 - 3 answers

Page: 1