I've got three new baby kittens with no mother, and I need to feed them. I don't have access to any good pet stores or veterinary clinics, but I do have lactose-free baby formula and a plastic syringe with the needle removed, which I've been using to feed them so far. But is there a foolproof method of holding them or something to get them to drink from it? I can usually get them to drink, but only about half of the amount recommended. More details inside.
[more inside]
posted by ferdinandcc
on Apr 23, 2013 -
20 answers
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
I have a formula for inputting into my expense sheet but it doesn't populate the field like it should. I stole the formula from my time sheet, and that does populat the column for the 4 weeks after I manually put in date 1.
It is:
=IF($B$4=0,"",SUM(B4+1))
So...why does it work in one sheet but not the next?
[more inside]
posted by dash_slot-
on Jul 1, 2011 -
7 answers
I'm looking for simple recipes which follow a set procedure, but whose ingredients can be easily changed up.
[more inside]
posted by purplecrackers
on Feb 18, 2011 -
33 answers
YTD total based on sum of last number in another row that has a value?
I need to sum up the values in one row based on the matching row below it. For example, if I have a target of $1000 a month, and I only have actual revenue numbers through June, I would like to calculate the year to date for the target from Jan to June. Once July numbers are put in, I'd want the YTD for the target to update to Jan to Jul.
I have tried a couple of variations on COUNT, INDEX and OFFSET.
Example is here:
http://malcommc.com/ytd.xls
I am using Excel 2003
posted by malcommc
on Jul 12, 2010 -
12 answers
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
Excel question: I have a list of values, sorted from lowest to highest. I want to rank them. But I have a specific issue with regard to ties, and I'd like to be able to craft an Excel formula which will deal with this automatically, if possible. Full explanation below the fold.
[more inside]
posted by Conrad Cornelius o'Donald o'Dell
on Mar 6, 2010 -
8 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
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
Any Excel whizzes out there? I'm having a problem that I just know is going to have a head-slappingly simple solution, but I still can't figure it out.
[more inside]
posted by andrewcilento
on Nov 10, 2009 -
8 answers
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.
[more inside]
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?
[more inside]
posted by Akeem
on Mar 12, 2009 -
3 answers
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.
[more inside]
posted by schyler523
on Mar 3, 2009 -
7 answers
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?
[more inside]
posted by Rock Steady
on Nov 14, 2008 -
13 answers
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
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.)
[more inside]
posted by WCityMike
on May 19, 2006 -
9 answers
