## when is 6oz not 6oz? Baby formula measuring.

How do you measure how much formula your infant is eating?
posted by dpx.mfx on Nov 6, 2009 - 12 answers

## How to return every Nth value in a column in Excel?

I am trying to pull values from one sheet into another master sheet for daily trending. The OFFSET function works for a single cell, but I can't figure out how to copy that formula to the rest of the column.
posted by malcommc on Oct 26, 2009 - 13 answers

## Trouble calculating regular averages in Excel

In Excel, how do I calculate the average of every 300 data points in a large data set?
posted by Midnight Rambler on Oct 18, 2009 - 10 answers

## Baby eczema

Is our baby formula causing eczema?
posted by Blackwatch on Sep 18, 2009 - 13 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?
posted by tomble on Jul 9, 2009 - 3 answers

## Will our babies be affected by their mother's weak immune system?

My wife's mother did not breastfeed her; she was fed formula until she was weaned.
posted by anonymous on Jun 26, 2009 - 41 answers

Have they changed the formula for Sierra Nevada Pale Ale without telling anyone?
posted by asavage on Jun 9, 2009 - 41 answers

## Whither double asterisk-inserting custom Excel formula??

Excel n00b needs help with what ought to be a very simple custom formula. And yes, I have looked around on the interwebs for the answer.
posted by wowbobwow on May 6, 2009 - 6 answers

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?
posted by Akeem on Mar 12, 2009 - 3 answers

## Merging worksheets in Excel.

Excel-Fu Filter: I need to merge latitude and longitude values (in two columns) corresponding to a specific site from one worksheet to the corresponding site in another worksheet.
posted by schyler523 on Mar 3, 2009 - 7 answers

## Stupid excel question

Excel question: Need formula to COUNT cells WHERE text is NOT "foo" or "bar"
posted by desjardins on Feb 13, 2009 - 16 answers

## How does this calculator work?

How do mortgage calculations work?
posted by missmobtown on Jan 16, 2009 - 3 answers

## Magical DST Formula, or just funky math?

posted by SquidLips on Nov 23, 2008 - 2 answers

## Excel date arithmetic problem

MS Excel Question: If I have a column with a range of dates in it, is there a formula that will tell me how many years ago that date was from today?

## Excel Formula Display Help

I have an excel file full of formulas that span multiple sheets and rows. I would like to be able to go into a formula and see the actual data used in the formula rather than just the cell references. So, for simplicity's sake, imagine A1=1,000, A2=2,000, A3=A1/A2 When I go to cell A3 and press "F2" or "cntrl`" the formula with the references shows up "=A1/A2". What I would like to see is "=1,000 / 2,000" (what you would get if you wrote =A1 &" / "& A2) I know that I can do this sort of with the watch window or the evaluate formula but I am looking for a quick way to roll down a sheet and see the actual math that is being done without having to scroll all over the place or flip sheets. Hopefully this makes sense. If not, I can further clarify. No one at my office thinks that it is possible so I might just be out of luck but I live in a world of hope...
posted by GrumpyMonkey on Sep 22, 2008 - 5 answers

## Tell me everything you know about infant formula!

Tell me everything I need to know about infant formula!
posted by Alabaster on Sep 20, 2008 - 29 answers

## Statistics Filter: Finding the top 10% from thousands of data points. Bonus question: inflection point value.

Statistics Filter: Finding the top 10% from thousands of data points. Bonus question: inflection point value.
posted by lrivers on Aug 7, 2008 - 4 answers

## Excel formulas 201...

Intermediate level Excel formula question.... Say I have a column with an array of dates in order and a matching column with an array of values. I need a formula that outputs the date at which one of the values first falls below a certain number.
posted by drpynchon on Aug 1, 2008 - 2 answers

## Help, Please - I'm an Excel Moron

I have to create an excel sheet to keep track of a book budget - in the most basic terms, I will have a total budget figure, and I want to subtract invoice figures to keep a running total. Here's an example of what I want the sheet to look like: http://i109.photobucket.com/albums/n46/coollibrarian/excel.jpg The simpler the better.
posted by coollibrarian on Jul 26, 2008 - 7 answers

Complicated Excel formula question involving text-search and Japanese characters. Can you help?
posted by Vorteks on May 27, 2008 - 2 answers

## Getting Excel to interpret string as formula

Getting Excel to interpret text string as formula
posted by found missing on Mar 29, 2008 - 7 answers

## How Do I Ethically Dispose of Unneeded Infant Bottles?

Now that my son has accepted that his "Ba" (bottle) is truly a thing of the past, what should I do with his bottles? Part of me wants to donate them (I even have unused nipples in packages) to a local shelter / food bank, but of course we all now know that clear polycarbonate bottles probably leach bisphenol-A into the milk. (saccade, I should have listened to you!!) I'm very conflicted about this. Can you help me make the most ethical choice?
posted by anastasiav on Mar 12, 2008 - 32 answers

## Multi line Text-to-column - A CHALLENGE FOR YOU!

How to "text to column" a cell with multiple lines in Excel?
posted by keasby on Jan 24, 2008 - 7 answers

## Help me with triangle math.

Triangles.math.Filter: Its been a while since algebra - I am trying to calculate the linear length of material required to fabricate a repeating V pattern out of sheet metal in various lengths.
posted by dripped on Jan 17, 2008 - 8 answers

## Excel: How to select a cell based on current month

Excel Filter: Selecting a cell/row based on current month.
posted by shinynewnick on Nov 23, 2007 - 5 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.
posted by chairish on Aug 25, 2007 - 5 answers

## How to use counting formulas in Excel?

I need help with counting formulas in Excel!
posted by Lilou on Aug 12, 2007 - 13 answers

## Formulas for Food

Looking for math formulas involving food.
posted by JaySunSee on Aug 4, 2007 - 5 answers

## Make Excel Make Coleslaw!

Excelfilter!! Okay, how would I do this in MS Excel???
posted by keep it tight on Jun 21, 2007 - 6 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
posted by Solomon on Jun 16, 2007 - 8 answers

## How can I find a legendary "formula" for an A-Bomb and not be put on a terrorist watch-list in the process?

How can I find a legendary "formula" for an A-Bomb and not be put on a terrorist watch-list in the process?
posted by Becko on Apr 11, 2007 - 13 answers

## How to optimize desk assignments?

In the office we’ll be moving to soon, we’ll have about 50 desks, and almost that many workers to be assigned to them. How can we optimize who’s assigned to each desk so that as many workers as possible are as pleased as possible with their desk assignment?
posted by daisyace on Feb 21, 2007 - 19 answers

## Excel formula question

Excel question: How to define a range so that it always adds up to a constant value.
posted by corpse on Jan 16, 2007 - 20 answers

## Finding the right Microsoft Excel formula

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 by stonefruit on Nov 9, 2006 - 14 answers

## Where can I find fomulas for calculating coordinating colors?

Where can I find mathematical fomulas for calculating coordinating colors for interior decorating projects?
posted by Vorteks on Oct 20, 2006 - 10 answers

## I need a fix for an excel formula recalculation error.

I can't get a formula in excel to recalculate when copied and pasted to another cell. Help!
posted by batcrazy on Sep 21, 2006 - 6 answers

## What's exerted force?

Calculation of Force Filter: How do I determine the exerted force at the end of a (small) lever? Yes, there's
posted by schwap23 on Aug 23, 2006 - 6 answers

## SpheroidTruncatedIcosahedronFilter!

My daughter wants to decorate a sphere in a football pattern. How do we determine the correct side length for the pentagons and hexagons, given a sphere of diameter n?
posted by i_am_joe's_spleen on Jun 9, 2006 - 11 answers

## Bottle Feeding - what do I really need?

[BottleFeedingFilter] I'm expecting our first child in July. Although my preference is to breast feed exclusively, for medical reasons that simply may not be possible. Therefore, I'm trying to mentally prepare myself for exclusively bottle feeding, and then anything else that happens will be a welcome bonus. What equipment do I really need in order to bottle feed, what is just "nice to have", and what is a waste of money? Rabid La Leche League Types please read the [more inside] before responding....
posted by anastasiav on Jun 5, 2006 - 60 answers

## Excel Help for Pie Graph of Frequency of Appearance of Values in a Column?

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.)
posted by WCityMike on May 19, 2006 - 9 answers

## Missing Formula Bar

Excel for OSX Filter: My Formula bar disappeared and I can't get it back!
posted by crapples on Apr 23, 2006 - 3 answers

## Looking for vintage F1 vids.

Does anyone know where I can download some flag to flag coverage of the 1976 Formula 1 season?
posted by roguescout on Mar 10, 2006 - 5 answers

## How to calculate per second versus per minute billing?

Telcos bill calls in varying minimum time increments (e.g. per second, per 6 seconds, per 30 seconds). Is there a formula to tell the difference this makes? Bonus points if it is on a web page or spreadsheet I can download.
posted by bystander on Dec 15, 2005 - 8 answers

## Excel Character Replacement

Excel Character Replacement
posted by prostyle on Oct 5, 2005 - 3 answers

## Embarrassing but true: basic algebra eludes me, how do I solve this equation?

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.
posted by wtfwjd? on Jun 9, 2005 - 3 answers

## Filtering for text uniqueness in Excel

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.
posted by pmbuko on Apr 27, 2005 - 17 answers

## Tracking employee schedules with Excel?

Excel formula question. Using Excel as an employee scheduler and need to help trying to create a formula for tracking.
posted by cyniczny on Feb 1, 2005 - 3 answers

## Can I import some Coca-Cola Light?

NotQuitePepsiBlueFilter: Vacationing in Europe, I was surprised and pleased by the flavor of Coca-Cola Light, which is not made with the same formula as the rather dire-tasting American Diet Coke. The drink tastes pretty much the same as Coke's new C2, but instead of that soda's bizarre half-sugar, half-sweetener compromise, the European Coke Light does it with no sugar or calories. Why they don't sell this stuff in America is truly beyond me.

Thing is, I'd like to import some -- and while imports of other (slightly stiffer) European beverages are common, I can't find anywhere locally or on Google who will sell it to Americans. Then again, my EU language skills are lacking. Anywhere I can have a 12-pack of this stuff shipped to me?
posted by eschatfische on Dec 5, 2004 - 27 answers