Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    62

    Re: Counta with If

    Thanks,

    Yes that does work but I ended up settling on =COUNTIFS(tblCourses[Name],"<>",tblCourses[State],"<>Inactive") since by default, the State column would be blank. Only the courses with an...
  2. Replies
    3
    Views
    62

    Counta with If

    For whatever reason, I'm drawing blanks on this one. I'm currently using =COUNTA(tblCourses[Name]) to count the number of courses I have. I had to add a column to my table, tblCourses[State] and I...
  3. Replies
    1
    Views
    37

    Re: Filter function with wildcards

    So I was able to figure it out. For anyone who has the same question and is on Office 365 Insiders, the following formula works. It's results return anything with the text in cell B1.
    ...
  4. Replies
    1
    Views
    37

    Filter function with wildcards

    Hello,

    I'm trying to figure out how to use the new filter function in Office 365 Insiders. =FILTER(tblCourses[Name],tblCourses[Name]=B1) works perfectly fine if the text in B1 explicitly matches...
  5. Office 365 Insiders Excel 64 bit Userform Date Picker

    Hiyas,

    I have a spreadsheet where there's a field in my table for a date. Currently, I'm entering in the date manually but, I wanted to try my hand at creating a userform with VBA and for the...
  6. Re: Count how many entries begins with a number

    Yeah that makes sense. In this particular use case, its 3,133 rows, much of which are duplicates with 489 rows actually unique. I'd like to learn more about PowerQuery though, it sounds right up my...
  7. Re: Count how many entries begins with a number

    I'll have to look into that, it sounds quite interesting. I know I can accomplish what I'm trying to do already with a pivot table, which is what I used to use but I got tired of having to refresh...
  8. Re: Count how many entries begins with a number

    I think I figured it out. It does appear working but I don't know if I actually did it right. Any thoughts or advice?

    This should show all entries that are blank
    ...
  9. Re: Count how many entries begins with a number

    To further elaborate on that formula, is there a way to add an if statement to it? For example, I'm using the below formula to show me all the movies for "A" (which is in E2) that don't have a blank...
  10. Re: Count how many entries begins with a number

    That works perfect, thanks!
  11. Count how many entries begins with a number

    Hello,

    I have 27 rows listed # to Z. What I'm trying to do is count how many entries in my table begin with each letter as well as 0-9. I've been able to figure out the A-Z part but the number...
  12. Replies
    2
    Views
    738

    Re: HTML Maker for Excel 2019 x64

    Outstanding! Exactly what I was looking for, thank you so much!
  13. Replies
    2
    Views
    738

    HTML Maker for Excel 2019 x64

    Is there an updated version of the HTML Maker addin for current versions of Excel such as Excel 2019 x64? All of the addins I used to use seem to no longer work. I don't know if its the version of...
  14. Replies
    3
    Views
    188

    Re: Build new table from existing table

    Thank you so much! I'm still running into a bit of an issue. Ideally, I was hoping for the output to be an actual table as opposed to a list or range but, I'm not sure that's possible. This solution...
  15. Replies
    3
    Views
    188

    Build new table from existing table

    Hiyas,

    I have a worksheet ("Plugins") that contains a table ("tblPlugins") with one of the columns ("Installed") having data validation that contains Yes/No. I'm trying to build a new table in a...
  16. Replies
    1
    Views
    273

    Combo Box in Search Form

    Hello

    I have a combo box on my form that gets values from qryTypes and I would like to be able to use these values as a part of my search form. The values display correctly on the form however, I...
  17. Replies
    1
    Views
    253

    Refresh Query Issue

    I have the below code on frmDashboard. When I click on cmdAddEmployee, I'm directed to frmAddEmployee and when finished and close, frmDashboard updates the list of Employees and goes to the latest...
  18. Replies
    3
    Views
    357

    Re: Simple Relationships Question

    Michael,

    Thank you for the link. I actually found out what I was doing wrong. It was different data types (text/autonumber). I don't know how I missed something that trivial but I guess it...
  19. Replies
    3
    Views
    357

    Simple Relationships Question

    This is probably the dumbest question ever however, after 2 days of searching via the web, I haven't found an answer and I'm probably just doing this wrong. When creating a relationship in my...
  20. Re: Why does just opening and closing a database modify it?

    Is your database set to automatically open a form via AutoExec? Also, default values could cause that. For example if you have a table that has a Now() default value in like a timestamp or something,...
  21. Replies
    2
    Views
    289

    Re: Math Calculations in Unbound Form

    I was able to get working. I found the problem. txtCoverageRequirement is supposed to have a default value of 04:00:00 but I entered this wrong. Access did not like the colons however, I found out...
  22. Replies
    2
    Views
    289

    Math Calculations in Unbound Form

    I have a form that has a simple calculation that needs to be done and I was almost certain I was able to do this in an unbound form but I'm not having any luck

    I have two values in unbound text...
  23. Replies
    6
    Views
    543

    Re: Update Time Format in Cells

    Your code is working beautifully. Thanks again for all the help, I greatly appreciate it!
  24. Replies
    6
    Views
    543

    Re: Update Time Format in Cells

    I'll try that and see if that helps. The code in the macro is as follows.



    Rows("1:6").Delete Shift:=xlUp
    Rows("2:6").Delete Shift:=xlUp
    Rows("3:7").Delete Shift:=xlUp
    ...
  25. Replies
    6
    Views
    543

    Re: Update Time Format in Cells

    The macro is very simple, it only deletes a few columns and rows that are not needed. Nothing else fancy takes place. The report itself is an export from our Cisco call reporting system and as it...
Results 1 to 25 of 71
Page 1 of 3 1 2 3