Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    132

    Changing data pulled with filter

    I currently have a filter formula that works great to pull my data; however, I was wondering if there is a way to make it give show something different than what is pulled? Currently it pulls the...
  2. Re: Can Data Validation be imported and used in a separate sheet?

    I greatly appreciate the help, and was hoping you could help me understand what is happening here? Unfortunately, I haven't really used any VBA code at all so its completely new to me. There are no...
  3. Re: Can Data Validation be imported and used in a separate sheet?

    I don't know that I explained this very well. I am trying to see how I could potentially make this work properly with an indirect formula but the concern would be on the original document. Here is...
  4. Query changing dates to numbers and pulling data incorrectly

    Currently I am trying to figure out why Query is changing the information and pulling on cells it shouldn't be? I have a table setup which is this:

    <style type="text/css"><!--td {border: 1px...
  5. Can Data Validation be imported and used in a separate sheet?

    The answer to this may be just a flat no!, but I am looking for a way to allow a data validation to be imported to another sheet and be edited by that sheet. Here is what I am looking at:

    Cell A...
  6. Replies
    0
    Views
    113

    Filter Nth cell based on separate set

    I was trying to query every Nth row for a long time and was able to make it work using filter which is great, but I cannot seem to make it work based on another cell (similar to query where you say...
  7. Replies
    2
    Views
    270

    Re: Index Query not working

    Hey Domenic,

    I apologize if this posts twice but for some reason it didn't update on my computer for the post. I was hoping to use query to make it "auto populate" the cells and continue to do so...
  8. Replies
    2
    Views
    270

    Index Query not working

    I have a formula to query every 12th line using the index function. For some reason it is pulling every single line rather than every 12th line? I cannot seem to make the every 12th line work on...
  9. Replies
    0
    Views
    204

    do query and offset work together?

    Currently I have an offset function that I use to grab every 12th cell (starting at the first one and I can drag down as many rows as necessary). Here is the offset function:

    =OFFSET('Travis...
  10. Replies
    8
    Views
    475

    Re: finding year instead of date

    With the year working, is there a way to break down a year into quarters? I have tried converting the 2017 to each quarter for data referencing but everything I try doesn't seem to work? The...
  11. Replies
    8
    Views
    475

    Re: finding year instead of date

    I must have fat fingered something because I was going through trying again and again and the first formula worked. Thanks so much.
  12. Replies
    8
    Views
    475

    Re: finding year instead of date

    For some reason these are not working but I think it may be because of the date format in column b?

    <style type="text/css"><!--td {border: 1px solid #ccc;}br...
  13. Replies
    8
    Views
    475

    finding year instead of date

    I realize this is probably something small that I am overlooking, but currently I have a way to get a total of a certain month and I need to change it to a certain year. Is it possible to change...
  14. Thread: QUERY help

    by Ronderbecke
    Replies
    2
    Views
    166

    Re: QUERY help

    My Apologies and perhaps someone can help with the error occurring in the new formula. I don't know why I have so much trouble with Date and Time function on this. The formula is not pulling any of...
  15. Thread: QUERY help

    by Ronderbecke
    Replies
    2
    Views
    166

    Re: QUERY help

    SOLVED! Sorry, I knew it was something small. Forgot to convert to text. In case anyone has problems like this, here was the solution:

    QUERY(Data!A2:F,"where D >= '"&TEXT(E1,"YYYY-MM-DD")&"'...
  16. Thread: QUERY help

    by Ronderbecke
    Replies
    2
    Views
    166

    QUERY help

    I have a formula that I cannot seem to get to work. I am sure it is something super simple and im overlooking something but I would greatly appreciate any help on this.

    QUERY(Data!A2:F,"where...
  17. Replies
    2
    Views
    203

    3d referencing not working

    Hey There,

    I have a formula that works just fine when only using 1 sheet. I changed it to reference multiple sheets and it just gives an error? Any reason this could happen in google sheets?
    ...
  18. Replies
    12
    Views
    483

    Re: 3d mapping complex formula

    I used your exact formula that you posted (it should operate on the same principle in google sheets as it does in excel to at least see what it produced.
  19. Replies
    12
    Views
    483

    Re: 3d mapping complex formula

    Not sure if this will help, but the sheet has customer blocks which are 12 rows from A to H. This is what it looks like:

    <style type="text/css"><!--td {border: 1px solid #ccc;}br...
  20. Replies
    12
    Views
    483

    Re: 3d mapping complex formula

    When I copy the formula over it comes back with a value of 0 which is why I was trying to modify it. Not sure why it's not bringing back the values. When I use the original it brings back the 1 on...
  21. Replies
    12
    Views
    483

    Re: 3d mapping complex formula

    If you can explain what the purpose of this formula is, I could potentially modify it to work in sheets? Currently, rounding is unimportant in sheets due to the fact that it will be an endless...
  22. Replies
    12
    Views
    483

    Re: 3d mapping complex formula

    Certainly. With them being IF statements, its simply verifying that they're true! Its checking C12, C24, C36, etc... is a date in the date range specified and is in fact a number. It's also...
  23. Replies
    12
    Views
    483

    Re: 3d mapping complex formula

    Hey There,

    Sorry, yes I am not using a range because it continues to grow. This is all being done in Google Sheets so you can use an infinite range. Currently you can use C12:C1000 and it would...
  24. Replies
    12
    Views
    483

    3d mapping complex formula

    I was hoping someone could help with this (maybe it's not even possible?), but currently I have a formula that I can use that works perfect with sumproduct:

    =SUMPRODUCT(IF(MOD(ROW('Travis...
  25. IF/OFFSET Function not working properly

    Currently I have been using this function plenty of times; however, when adding the additional if statements to the OFFSET it is causing errors. I have tried it multiple ways and simply want to drag...
Results 1 to 25 of 46
Page 1 of 2 1 2