Create Custom Functions in Excel (User Defined Functions)

Поделиться
HTML-код
  • Опубликовано: 5 дек 2024

Комментарии • 6

  • @MohAboAbdo
    @MohAboAbdo Год назад

    Thank you so much

  • @aiswaryasanthosh7878
    @aiswaryasanthosh7878 11 месяцев назад

    Is there any we can the suggestion of the custom function in other sheets also?

    • @ExcelMacroMania
      @ExcelMacroMania  11 месяцев назад

      The custom function can be used in any sheet, and if it's public, even in any workbook if the workbook with the function procedure is open.

  • @saichandu5965
    @saichandu5965 Год назад

    Love your videos and easy to learn...can you able to make a VBA for validating sheet1 and sheet 2 as compare with unique numbers from both the sheets and bring out the data only which are not matching with both the sheets and our criteria should be date or quarter

    • @ExcelMacroMania
      @ExcelMacroMania  Год назад +1

      Glad you like it. What you are asking is more related to some other videos, please check those because it may have what you need. I have a mini-series to compare everything in Excel, these 2 are about comparing worksheets:
      ruclips.net/video/jyZHOIbHtv8/видео.html
      ruclips.net/video/T4QMCoFlVdc/видео.html
      Also, I have some older videos to compare two worksheets (this is probably what you are looking): ruclips.net/video/hZIFnKetyI0/видео.html
      And to compare 2 workbooks: ruclips.net/video/4lLlX_pXoA0/видео.html
      And to compare 2 columns: ruclips.net/video/UvnefIMtNnM/видео.html

    • @saichandu5965
      @saichandu5965 Год назад

      @@ExcelMacroMania thanks for your response... comparison is ok after comparing I am looking for reconciliation it's more like comparison two accounting sets...and pull the data where only variences from both the sheets using multiple criteria I know it's too much to ask but am also looking at your videos and learning and taking points on how to ease my tasks....