network profile
| bio | website | |
|---|---|---|
| location | United States | |
| age | ||
| visits | member for | 3 years, 9 months |
| seen | May 7 at 18:58 | |
| stats | profile views | 21 |
|
Mar 29 |
awarded | Notable Question |
|
Oct 31 |
awarded | Notable Question |
|
Oct 25 |
awarded | Popular Question |
|
Dec 15 |
awarded | Popular Question |
|
Nov 3 |
accepted | What determines the icon Windows Explorer shows for a particular file? |
|
Nov 2 |
asked | What determines the icon Windows Explorer shows for a particular file? |
|
Oct 18 |
awarded | Notable Question |
|
Sep 9 |
answered | Graphics asset management software |
|
Apr 4 |
awarded | Taxonomist |
|
Dec 6 |
answered | Is there a way to tell which cells reference a selected cell in Excel? |
|
Nov 30 |
answered | Creating a very detailed report using Excel and/or Access |
|
Oct 19 |
awarded | Suffrage |
|
Aug 17 |
awarded | Commentator |
|
Aug 17 |
comment |
How can I estimate the Nth value (or Nth percentile) from a frequency distribution in Excel? With that volume of data, perhaps storing the data in a database (Access, SQL Server Express) and manipulating the data with Excel would be a better approach? Unfortunately, I don't have any practical experience with manipulating large database data sets with Excel. Any thoughts, @dkusleika? |
|
Aug 9 |
answered | Remove VIM search highlight |
|
Aug 9 |
awarded | Yearling |
|
Jul 29 |
comment |
Fill down in Excel, but based on multiple values I just happened to need to do this again, and decided to try again. I had no difficulties. Do you know which step(s) caused problems for you? |
|
Jul 7 |
comment |
Excel how to reference a list I just tried your example and the @ sign in front of ColB causes an error. just using =[ColB] works for me. |
|
Jul 7 |
comment |
Excel how to reference a list +1, but the terminology in Excel 2007 is "table", not "list". Also, this only works if you have all the data in a single table. It looks like @Stan has those 2 columns separated out. Otherwise, he'll have to follow @Dan's advice and drag the formula sufficiently far enough down the sheet. |
|
Jul 6 |
comment |
Good books for learning Excel VBA +1 for any of John Walkenbach's books. There's also an edition out for Excel 2010 now too. |
