sub_id

  1. S

    MINIFS in Power BI DAX

    Hi, I only discovered the MINIFS function in Excel today, and instantly wondered if there was a DAX equivalent. I have a quite basic excel formula of; =MINIFS(A:A,B:B,B2) Lets say A:A = Sub_ID & B:B = ID I am trying to find the Min Sub_ID when there are more than 1 count of ID's If there...
    • Shales
    • Thread
    • dax excel find minifs sub_id
    • Replies: 1
    • Forum: Power Tools
  2. J

    Creating a macro that returns results of a SQL query

    Hello, I am new to VBA and I am looking to create a macro that connects to database "REPT" and returns distinct values for columns "sub_id" and "term_date" where the value in "plan_code" column is "444"
  3. A

    Vba to get related cell values

    Hi Im new to VBA. I have a question below it would helpful if i got the answer <tbody> Department Sub_ID ID 8585 00_A01 00_A 9585 01_B20 01_B 1010 00_C50 00_C 2025 05_P20 05_P </tbody> I have the above table for data.I want function/sub to search and get/return the value in Sub_Id...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top