32 posts tagged with excel and formula. (View popular tags)
Displaying 1 through 32 of 32. Subscribe:
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
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
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 question: I need a row number to automatically increment as I copy a formula horizontally across columns. Sample spreadsheet downloadable here, or viewable as a Google Doc here. Further details inside. [more inside]
posted by Conrad Cornelius o'Donald o'Dell
on Nov 7, 2009 -
12 answers
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. [more inside]
posted by malcommc
on Oct 26, 2009 -
13 answers
In Excel, how do I calculate the average of every 300 data points in a large data set? [more inside]
posted by Midnight Rambler
on Oct 18, 2009 -
10 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
Excel question: Need formula to COUNT cells WHERE text is NOT "foo" or "bar" [more inside]
posted by desjardins
on Feb 13, 2009 -
16 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
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
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. [more inside]
posted by drpynchon
on Aug 1, 2008 -
2 answers
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.
[more inside]
posted by coollibrarian
on Jul 26, 2008 -
7 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
Getting Excel to interpret text string as formula [more inside]
posted by found missing
on Mar 29, 2008 -
7 answers
How to "text to column" a cell with multiple lines in Excel? [more inside]
posted by keasby
on Jan 24, 2008 -
7 answers
Excel Filter: Selecting a cell/row based on current month. [more inside]
posted by shinynewnick
on Nov 23, 2007 -
5 answers
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
I need help with counting formulas in Excel! [more inside]
posted by Lilou
on Aug 12, 2007 -
13 answers
Excelfilter!!
Okay, how would I do this in MS Excel???
[more inside]
posted by keep it tight
on Jun 21, 2007 -
6 answers
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
Excel question: How to define a range so that it always adds up to a constant value. [more inside]
posted by corpse
on Jan 16, 2007 -
20 answers
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
I can't get a formula in excel to recalculate when copied and pasted to another cell. Help! [more inside]
posted by batcrazy
on Sep 21, 2006 -
6 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
Excel for OSX Filter: My Formula bar disappeared and I can't get it back! [more inside]
posted by crapples
on Apr 23, 2006 -
3 answers
Excel Character Replacement [more inside]
posted by prostyle
on Oct 5, 2005 -
3 answers
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. [more inside]
posted by wtfwjd?
on Jun 9, 2005 -
3 answers
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. [more inside]
posted by pmbuko
on Apr 27, 2005 -
17 answers
Excel formula question. Using Excel as an employee scheduler and need to help trying to create a formula for tracking. [more inside]
posted by cyniczny
on Feb 1, 2005 -
3 answers
I need to use Excel's FIND function to locate open-parentheses, but since parentheses are part of the syntax of the function itself, it's choking. How can I escape the character to make this work?
posted by scarabic
on Aug 6, 2004 -
8 answers