• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. B

    How to graph array data

    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
  2. B

    How to graph array data

    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...
  3. B

    How to graph array data

    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...
  4. B

    How to graph array data

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

    How to graph array data

    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...
  6. B

    How to graph array data

    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...
  7. B

    Formatting a watchwindow

    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 ;)...
  8. B

    Keyboard shortcut to increase/decrease font size

    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...
  9. B

    Renaming existing functions

    Thanks, Luke.
  10. B

    Renaming existing functions

    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?
  11. B

    countif for distinct values....

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

    Sum a list of values starting at a variable record

    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...
  13. B

    Sum a list of values starting at a variable record

    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...
  14. B

    Create random list with multiple criteria

    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...
  15. B

    Create random list with multiple criteria

    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...
  16. B

    Choosing which vertical grid lines show in a chart

    That's a great technique! I can't wait to shock and amaze. Thanks for the link.
  17. B

    Choosing which vertical grid lines show in a chart

    Hi All, Is it possible to choose specific vertical grid lines to show in a chart while hiding all the rest? For example, I would like only to show a line between data points 4 and 5, and another one between data points 10 and 11. This would be to visually separate the data before and after...
  18. B

    Replacing with 0

    I pretty much did the reverse of what I did before. =IF(N3="",0,N3) did what I needed. Thanks, though.
  19. B

    Replacing with 0

    =IF(N3>0, N3, 0) The blank cells remain blank, and should be 0. Thanks again.
  20. B

    Replacing with 0

    Hello, Previously I wrote a formula that wrote "" if below a certain value. Then I copied the output as text. Now I want to make that column have 0s instead of blank cells. I tried an IF statement with the value if false as 0, but no luck. Any suggestions?
  21. B

    Is there a way to use offset by referencing the cell it is used in?

    Thanks, Luke. The R1C1 style looks extremely useful; however, I had some trouble writing the reference into a cell without returning an error. What I ended up doing is naming the columns for start time and end time, and then writing into my program to write the text following all of the data...
  22. B

    Is there a way to use offset by referencing the cell it is used in?

    Hello, I'm trying to automate my data analysis. I have a program that gives me a text file of names, dates, and times that I have to paste into Excel and delimit into columns. It would be great if I could add a line of code to my program to write a formula to be delimited into the last column...
  23. B

    Altering axes of line and scatter charts

    Thanks for the help, Hui. I just emailed you.
  24. B

    Altering axes of line and scatter charts

    I'm just using random data for an example to give to my class. I could send you a graph with labels and arrows indicating the problems I'm having, if that would help.
  25. B

    Altering axes of line and scatter charts

    I'm having a tough time finding a way to correctly format the x- and y-axes according to APA style (American Psychological Association). First, the zero y-axis value must be raised off the x-axis. For example, if you have days of the week on the x-axis, and number of times a student speaks in...
Back
Top