Search:

Type: Posts; User: Labrat24; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Index is returning a blank cell in the middle of the data set

    AJ/AL are empty rows so you may have to elaborate on how to impliment your formula. Thanks
  2. Re: Index is returning a blank cell in the middle of the data set

    Sorry about how messy that works, I only had a couple minutes to put it up and couldnt figure out how to put it in as a table. The column on the right is two lists that are combined and seperated by...
  3. Re: Index is returning a blank cell in the middle of the data set

    <tbody>
    Date

    Date



    10/1/18 8:30 AM

    `=INDEX($AI$5:$AI$200,MATCH(ROWS($AI$5:AI5),COUNTIF($AI$5:$AI$200,"<="&$AI$5:$AI$200),0))
  4. Index is returning a blank cell in the middle of the data set

    I have a spreadsheet that contains a couple hunded date/times with coresponding sample results. I use several different arrays to combine multiple sets of dates into one column and then use this...
  5. Replies
    4
    Views
    140

    Re: Array is giving me a blank cell

    The problem with that is there are 10s of graphs using these dates so it could take me hours to update all graphs when now I don’t have to update them at all when new data is generated.
  6. Replies
    4
    Views
    140

    Re: Array is giving me a blank cell

    The problem with using that is it gives me #NUM ! instead of #N/A which causes problem with my graph.
  7. Replies
    4
    Views
    140

    Array is giving me a blank cell

    I have an array that takes two lists of dates that are in the same column and re-organizes them in chronological order and ignores blank cells that are a result of a gap in the two lists. For some...
  8. Replies
    8
    Views
    344

    Re: Adding Blank Row via formula/array

    Also "" or #N/A are acceptable in place of a blank cell
  9. Replies
    8
    Views
    344

    Re: Adding Blank Row via formula/array

    Sorry for not being more specific. The reason that I dont think a macro will work is that my data is automatically dumped into excel using PI. I use the dates that are generated to pull additional...
  10. Replies
    8
    Views
    344

    Re: Adding Blank Row via formula/array

    Michael

    Entering an entire row wont work. This is just a few columns of a much larger spreadsheet. That is one of the reasons I was asking for help. The list of dates that I have is several...
  11. Replies
    8
    Views
    344

    Adding Blank Row via formula/array

    I would like to automatically add a blank row in a series of Dates so that when I graph the data there is a gap whenever there is a new month. This makes it alot easier to read when there is a bunch...
Results 1 to 11 of 11