Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Randomly generated list with duplicates in column

    Hi Sdown,
    Here is an idea:


    <tbody>

    A
    List of places
    B
    Previous
  2. Re: VBA Copy specific sheets to new workbook and paste as values

    To paste values in a range use

    .PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks :=False, Transpose:=False
    Cheers
    Sergio
  3. Re: Bank Transaction Description/Merchant Cleanup & Auto Categorize (like Mint)

    Hi Poppie,
    Here is a MACRO that I think does what you need



    Sub CleanUpSelection()
    Dim s As Range
    Dim r As Range
    Dim n As Range
    Dim c As Range
  4. Re: VBA: Extracting multiple strings from cells onto multiple columns.

    Image links in yr post are broken, sorry
  5. Re: Find text in one column = add "#, " to different column?

    Sorry you need to anchor the ranges to copy the formula down
    ={TEXTJOIN(", ",1,IFERROR(FIND(tags!$A$2:$A$6,U2)>0,0)*tags!$B$2:$B$6)}

    (Same test file)
    Like this
    Cheers
    Sergio
  6. Re: Find text in one column = add "#, " to different column?

    And if you want use this formula (No matrix formula this time)
    =SUBSTITUTE(SUBSTITUTE(R2,"0, ",""),", 0","")

    To get exactly what you asked for


    <tbody>
    Improved result
  7. Re: Find text in one column = add "#, " to different column?

    Here is an idea,
    For Office 365 you can use the Matrix Formula
    ={TEXTJOIN(", ",1,IFERROR(FIND(tags!A2:A6,U2)>0,0)*tags!B2:B6)}

    It is not exactingly what you want but it is a start

    <tbody>...
  8. Re: Can a excel formula be made for this equation?

    Hi xeven
    Here is an idea: Try to solve the equation using Wolfram Alfa
    https://www.wolframalpha.com/input/?i=solve+convolution
    Cheers
    Sergio
  9. Re: need help with formula to set up a warning after 2 work days

    Hi Martin,
    Here is an idea that may work for your problem


    For Column F =IF((NETWORKDAYS.INTL(E2,J2,1)-1)*24-HOUR(E2)+HOUR(J2)>48,"late","")


    For instance for a set of data

    <tbody>
  10. Replies
    1
    Views
    1,311

    Re: Unable write to read - only property

    Xin cho nqtran1081,
    Đy l một m lm những g ti nghĩ bạn cần


    Sub test()
    ' m vbs thể ghi vo chỉ đọc thuộc tnh
    Dim objExcel, objWorkbook, objSheet, i As Variant
    Dim USERID,...
  11. Thread: Listbox

    by sergioMabres
    Replies
    4
    Views
    2,043

    Re: Listbox

    Change line If Right(colname, 1) <> "1" Then
    For this line If Right(colname, 2) <> le & "1" Then
    Cheers
  12. Thread: Listbox

    by sergioMabres
    Replies
    4
    Views
    2,043

    Re: Listbox

    Bir şey değil, her zaman yardım etmekten mutluluk duyarım
    Sergio
  13. Re: Need EXCEL To go get info for me and return dollars

    Always glad to help people around the world with Excel issues
    From Argentina cheers
    Sergio
  14. Re: Need EXCEL To go get info for me and return dollars

    It is very easy to miss write a SUMPRODUCT formula for instance matrix size have to be coherent, if you change size in one matrix you need to change in the same way the second matrix
    To see how it...
  15. Thread: Userform

    by sergioMabres
    Replies
    1
    Views
    167

    Re: Userform

    Here is an idea you could use the Data Form Option, if you do not see the Data Form Option activate it, here is how
    https://trumpexcel.com/data-entry-form/
    Cheers
    Sergio
  16. Re: Need EXCEL To go get info for me and return dollars

    Hi PSF12,
    Here is an idea in Sheet1 you have

    <tbody>
    CODE DESCRIPTION
    DOLLARS
    Code


    722988- Large Color Display Combine
  17. Thread: Listbox

    by sergioMabres
    Replies
    4
    Views
    2,043

    Re: Listbox

    Sevgili kardeşim;
    İşte UserForm2 iin kod



    Private Sub ComboBox1_Change()
    Dim colname As String
    Dim vntList As Variant
    Dim i As Integer
    Dim le As String
  18. Replies
    2
    Views
    143

    Re: Missing linked data file

    Here is an idea
    http://www.avantixlearning.ca/microsoft-powerpoint/how-to-break-or-update-links-to-microsoft-excel-charts-or-worksheets-in-powerpoint/

    Cheers
    Sergio
  19. Re: Get minute difference between working days and hours

    oh yes you are right, your not working hours are 14 not 10 in your case, so the formula is

    =((((B2-A2)-(DAYS(B2,A2)+1-NETWORKDAYS.INTL(A2,B2,1)))*24)-14)*60
    Btw your first row data start date...
  20. Re: Get minute difference between working days and hours

    That is what the formula does, it excludes time from 6 pm to 8 am
  21. Replies
    3
    Views
    559

    Re: Averages per Day

    This code is for SQL Server it might run on Access but you will have to try
    Sergio
  22. Replies
    13
    Views
    972

    Re: convert excel formula to vba

    If you want to be in E27 change the macro to


    Sub Macro1()
    '
    ' Macro4 Macro
    '

    '
    Range("E27").Select
  23. Replies
    13
    Views
    972

    Re: convert excel formula to vba

    E27 works too the formula is relative, but, you have to be in E27 it works on the selected cell
  24. Replies
    13
    Views
    972

    Re: convert excel formula to vba

    I don't know what are you doing to get a ERROR 1004, it works fine when I run with cell G10 selected in an empty Sheet, I cannot know what is going on in your environment, sorry, this is the...
  25. Replies
    13
    Views
    972

    Re: convert excel formula to vba

    Use like this in a module, run the macro by hand NOT on change

    Sub Macro1()
    '
    ' Macro1 Macro
    '

    '
    ActiveCell.FormulaR1C1 = _
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4