I have: An excel spreadsheet with a bunch of emails. I need: A self-updating text string that can be copy-pasted into an email TO: Field. I know about C1&","&D1 but is there a way for the list to be automatically updated when I or subtract an email, without specifically having to tell the formula to look in the newly added row?
[more inside]
posted by amethysts
on Mar 23, 2010 -
7 answers
Excel filter: Is there a simple way to iterate through all pairs in a list, perform a calculation on each pair, and sum the result?
[more inside]
posted by albrecht
on Mar 9, 2010 -
11 answers
I am trying to partially automate a tedious list comparison procedure, I think I should be able to do it through excel without any coding (which I don't know how to do)
[more inside]
posted by dripped
on Mar 19, 2009 -
3 answers
Within cell C2, If the content of a cell in $A$10:$A$900 is the same as the content in A2, I would like Excel to Average the contents of column H in the rows that match A2...does that even make sense?
[more inside]
posted by InfinateJane
on Jul 2, 2008 -
6 answers
Excel: How can I get text to stick in the cells after it's been copied from another spreadsheet?
[more inside]
posted by chuckdarwin
on Jul 4, 2007 -
6 answers
I need help writing a macro that will divide a 5000 row table into groups of 30 rows, and find the average of certain columns in each group.
[more inside]
posted by beammeup4
on Jul 2, 2007 -
10 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
Excel question: I'm looking to pull a months and years worth of spreadsheet information to a summary report. The days work is saved as reportxxxxxx (month/day/year)
[more inside]
posted by brent
on Dec 27, 2006 -
4 answers
