Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    99

    Re: IFERROR Formula help

    I understand now. thanks for all the help.
  2. Replies
    5
    Views
    99

    Re: IFERROR Formula help

    Not sure I follow. Isn't the last iferror telling me if column d in main city matches ai2 to populate the corresponding cell in column b
  3. Replies
    5
    Views
    99

    IFERROR Formula help

    I could use some help with this formula. First time using an IFERROR formula so not sure what I'm doing wrong. I keep getting a "too few arguments error". Any help would be appreciated.

    ...
  4. Replies
    3
    Views
    681

    Re: MSACCESS Formula Help

    That did it. Thanks
  5. Replies
    3
    Views
    681

    MSACCESS Formula Help

    Not sure why I keep getting an Invalid Syntax error for this formula. I want it to return "Complete" in the cell when StepsDetailOpen column cell is blank. Below is the formula I'm using. Any...
  6. Replies
    5
    Views
    529

    Re: No Read Permission message

    Thanks for the info. Iíll check google to see how to access the hidden tables. Btw it is not a linked table and I cannot open the query in design view either. Another odd thing is when I pull up the...
  7. Replies
    5
    Views
    529

    Re: No Read Permission message

    I Can't do this because I can't open the queries and I can't find the table anywhere so I can delete it. I assume it's hidden somewhere. Any ideas on how to locate the table if it's hidden.
  8. Replies
    5
    Views
    529

    No Read Permission message

    Anyone know how to clear this issue. I get this message with any query I run associated with this table and can't find this table anywhere now. I no longer see tt in my relationship either. I tried...
  9. Replies
    5
    Views
    746

    Re: AccesS Formula help

    Great!! Thanks for the help.
  10. Replies
    5
    Views
    746

    AccesS Formula help

    I could use some help with how to write this formula in ACCESS to determine age bucket for the column DaysAged. It works fine when I input just the formula for <= 30 days but, when I add 30-60,...
  11. Replies
    5
    Views
    783

    Re: Convert Excel Formula To Access

    Thanks. Iíll give it a try
  12. Replies
    5
    Views
    783

    Re: Convert Excel Formula To Access

    I got it to work by using this formula in case anyone needs this in the future


    <>5YRS_OLD: IIf([NTG INTERVAL]<=1825,"< 5yrs",IIf([NTG INTERVAL]>1825,"> 5yrs"
  13. Replies
    5
    Views
    783

    Convert Excel Formula To Access

    I am trying to convert an excel formula in access but don't have the knowledge to do so. Is there a way to convert this excel formula to run with my access query? This is what I am using in Excel....
  14. Replies
    3
    Views
    136

    Re: Pivot table Question

    I was looking to count the unique values when using the Pivot Table. I was able to figure out how to do this with Power Pivot. Thanks anyway.
  15. Replies
    3
    Views
    136

    Pivot table Question

    I have a spreadsheet with a column of names and column of dates. The column of names have duplicate names for same dates. I need to count how many names were on a certain date but my pivot table only...
  16. Replies
    2
    Views
    136

    Re: saving hyperlinks between Workbooks

    great!! Works well. Thanks for the help.
  17. Replies
    2
    Views
    136

    saving hyperlinks between Workbooks

    I am having problems with losng my hyperlinks when I save the exel spreadsheet to another workbook name. Is there any way to save my hyperlink info to another workbook so it appears in the new...
  18. Lose Hyperlinks when saving file to new name

    How can I retain the hyperlinks when I save my excel file to a new name
  19. Replies
    23
    Views
    587

    Re: Matching Number To Number In text

    I got it to work and it works great!!! Thanks for all the help. I'll definitely keep this for future use as well.
  20. Replies
    23
    Views
    587

    Re: Matching Number To Number In text

    I tried the formula this morning and this is what I got. No errors but the formula continues to show in the cell instead of the calculation. I checked the options tab and interactive calculations is...
  21. Replies
    23
    Views
    587

    Re: Matching Number To Number In text

    Will do. Never used VBA before but, will to try it.
  22. Replies
    23
    Views
    587

    Re: Matching Number To Number In text

    The ticket # doesn't always follow TRANSFER and if the ticket # can't be found then N/A is fine or whatever it defaults to.
  23. Replies
    23
    Views
    587

    Re: Matching Number To Number In text

    I don't have any further examples tonight as the spreadsheet is a t work. However, the ticket # in the desc column is not always in the same place in the string of text. It appears random in each...
  24. Replies
    23
    Views
    587

    Re: Matching Number To Number In text

    That's right it doesn't work. I'l try to explain different way. If the number in the description matches a ticket number in column Q, I need the matched ticket # to appear in column I where the...
  25. Replies
    23
    Views
    587

    Re: Matching Number To Number In text

    I tried this formula but, it didn't work. Column has the identical Ticket Numbers as column Q

    =INDEX(R:R,MATCH("*"&J2&"*",Q:Q,0))
Results 1 to 25 of 65
Page 1 of 3 1 2 3