Recent content by bctyner

It's a work in progress. I like your solution. Will it be simple to add more arrays to the original table and have them extracted to the new table? Thanks again, BT

I'll also be calculating some stats, maybe using pivot tables and charts. For example, I'll be graphing the average and standard deviation for every 3 transactions (1,2,3; then 2,3,4; etc.). Definitely preferable to extract in a concise table, but I'm still working on it... I got my solution...

Hi Faseeh, That looks great. Most of the lookup function you use is way over my head; how easily can I add new data? For example, if I paste a new array after the last one on this worksheet, how will I update your table to extract the values? In any case, it works far better than what...

Here's a sample. Thanks for the help. http://dl.dropbox.com/u/10012690/Bctyner%20Array%20Data.xlsx

Thanks, Hui. The X values cycle 0, 5, 10, 15, 20, 25. The data are all written in the same row - A2 is the first X value, which is session 0, B2 is the transaction amount for session 0. C2 is the amount for session 1, D2 is session 2 etc. B3 is the transaction amount for session 5, B4 is the...

I have an array in which column A is a list of transaction numbers, but only the 1st, 11th, 21st, and 31st numbers are there. Then in column B those transaction numbers are listed. Then it gets tricky - colum B has transaction #s 12, 22, 32, etc., column C has 13, 23, 33, D has 14, 24, 34, on...

Mike Girvin and Bill Jelen had a podcast duel about this. The built-in watch window is pretty limited, but Bill Jelen made a VBA version that can be formatted however you want. Even if you aren't too familiar with VBA, it's simple enough to make your first project ;)...

You can use ALT, H, FG to increase the font size (not as convenient for searching for a font size that works, but it's still there). Also, typing ALT, H, then FF lets you type the font size you want. Alternatively, you can add the font size up and down buttons to the quick access toolbar...

Thanks, Luke.

I've seen tutorials on creating your own function, but is it possible to rename existing functions? In my department, we use the term "mean" instead of "average." Can I tamper with the average function so that I can type =MEAN and have it work the exact same way?

Could you use a table with filters and subtotal or a pivot table?

Because there are so many different values in the A column, a sumif statement becomes extremely large. Using a table and filter would work but my staff isn't familiar with working with tables. Is there a simpler way to do the same thing as a sumif? Since it needs to sum everything after the...

I have a table of records, and need to sum every value in column I that occurs AFTER the cell in column A of the same row = "ABCD Pretest". The record for ABCD Pretest is not always in the same row. Every value in column I needs to be summed after that row. Is there a way to use subtotal or...

Hello Faseeh, Thank you for the help. It works well, however sometimes the first list pulls all 8s or all 9s, and sometimes the second list pulls all numbers between 1 and 7, and other times all between 10 and 16. Essentially I need one list to calculate three numbers between 8 & 9, and...

I have a list of 16 names. I need to create a random list of 6 names, three of which are either the 8th or 9th name and both the 8th and 9th name have to appear in the random list. The remaining three names must be from 1 through 7 and 10 through 16, and at least 3 of the names must be from 1...