Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    4
    Views
    60

    Re: Pull info from First Column with Data

    I simply take the example of the OP as a basis, if it is something different, then the OP will comment.
  2. Re: Additional code needed for existing working code

    Try this



    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    On Error GoTo Eventes_Activate
    If Not Intersect(Target, Range("D5:D30")) Is Nothing Then...
  3. Replies
    4
    Views
    60

    Re: Pull info from First Column with Data

    Try a regular formula.

    If the cells before the value are empty, you only need:
    =MIN(C2:K2)
  4. Re: How can I edit this code to import local HTML files rather than an online Web Query fetch

    Try this



    Sub MX_Quote_loop_through()
    Dim h1 As Worksheet, h2 As Worksheet
    Dim u1 As Long, u2 As Long, i As Long, u3 As Long
    Dim MyUrl As String, wPath As String
    '
    ...
  5. Re: Help setting fixed values in an amazing macro that splits columns using dialog box feedback!

    Try this



    Sub SplitColumnVersion2()
    'Updateby20191015
    'Dim rng As Range
    Dim InputRng As Range, OutRng As Range
    Dim xRow As Integer, xCol As Integer, xArr As Variant
    Dim xValue,...
  6. Re: Counting values in 1 column based on a category in another

    If I understood correctly, you need something like this:

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col...
  7. Re: VLOOKUP then return date between two dates

    Try this

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col...
  8. Re: Help fixing 'Subscript out of range' error

    I'm glad to help you. Thanks for the feedback.
  9. Re: How to filter data in a Pivot Table when data is Sum

    Youre welcome & thanks for the feedback.
  10. Replies
    15
    Views
    131

    Re: LEFT() for each rows in a single cell?

    This may be an option to extract a phone in a cell with a formula.
    Copy the formula to the right to extract one phone at a time.

    <table border="1" cellspacing="0" ...
  11. Replies
    4
    Views
    52

    Re: Finding most common words in excel

    Try this, The result on the same sheet in the columns CA y CBCheck the result and you can order the number of words from highest to lowest.



    Sub Finding_most_common_words()
    Dim c As Range, w...
  12. Re: Help fixing 'Subscript out of range' error

    Thanks Fluff
  13. Re: Help fixing 'Subscript out of range' error

    Additional to Fluff's comments:



    Sub test()
    Dim LastRow As Long ' Integer only reaches 32,767
    Dim MyArray As Variant
    Dim i As Long

    With Sheets("Testing")
  14. Replies
    15
    Views
    131

    Re: LEFT() for each rows in a single cell?

    I have not used google sheet either.
  15. Re: How to filter data in a Pivot Table when data is Sum

    Maybe with an auxiliary column and the following formula.

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col...
  16. Re: What is wrong with this as an array formula?

    I'm glad to help you. Thanks for the feedback.
  17. Replies
    15
    Views
    131

    Re: LEFT() for each rows in a single cell?

    Try whit this UDF

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col...
  18. Re: What is wrong with this as an array formula?

    It seems to me that COUNTIF does not work with an internal formula

    Try this "regular" formula

    =SUMPRODUCT(--(ABS(Alg.Oth!$AO$602:$AO$4592)>20))

    Or this array formula

    ...
  19. Replies
    9
    Views
    193

    Re: Dynamic unique lists

    Don't worry, I'm here to help you.
    You can also upload a file or image to the cloud:

    You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for...
  20. Thread: #Value Error

    by DanteAmor
    Replies
    6
    Views
    68

    Re: #Value Error

    I'm glad to help you. Thanks for the feedback.
  21. Replies
    9
    Views
    98

    Re: Conditional Formatting Help

    Hi @tonic1972, welcome to the forum"

    Try this

    1. Select the cells you want to format. ... (example: A2:E10)
    2. On the Home tab, in the Styles group, click Conditional formatting > New Rule…...
  22. Re: Dynamic Graphs, as columns are added daily

    One option may be to select all cells from Oct 1 to Oct 31.
    But, following your example, you hide the column cells from Oct 10 to Oct 31, so only the data from Oct 1 to 9 will be shown in the graph.
  23. Re: Expanding a working code in Workbook_BeforeSave to more sheets with small alterations? VBA

    Hi @JBM91, welcome to the forum!


    I made some changes to the code.
    I removed the part of selecting the cells because they can be different sheets.



    Try this
  24. Replies
    3
    Views
    103

    Re: Toggle filter on/off using VBA

    I'm glad to help you. Thanks for the feedback.
  25. Replies
    9
    Views
    193

    Re: Dynamic unique lists

    I don't know what solution worked for you. I don't understand the fourth column, maybe if you give examples of what you have and what you expect as a result.

    Upload an excel image:...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4