RE: LeoThread 2023-07-16 23:39

[magnacarta]

1🧵21

#XLSref: #Excel Function DMIN():

🔤DMIN(DB,F,CRITERIA)

➽ Returns MIN value based on qualifying DB criteria

‼️👂 DB▶️ Database

‼️👂 F▶️ Field in DB

‼️👂 CRITERIA▶️ Limiting factors

🔊 Numeric data

#spreadsheets #xls 👉

Comments

[magnacarta]

2🧵21

#XLSref: #Excel Function DMIN():

🎁 Below▶️ (A1:D2=Criteria section) & (A4:D22=Database)

⋱   A   B   C   D   E
1   Date    Day From    HIVE    ▓
2                   
3   ▓   ▓   ▓   ▓   ▓
4   Date    Day From    HIVE    ▓
5   26  S   BF  157 ▓
6   26  S   DH  12  ▓
7   25  S   BF  161 ▓

#xls 👉

[magnacarta]

3🧵21

#XLSref: #Excel Function DMIN():

⋱   A   B   C   D   E
⁞   ⁞   ⁞   ⁞   ⁞   ⁞
4   Date    Day From    HIVE    ▓
⁞   ⁞   ⁞   ⁞   ⁞   ⁞
8   25  A   UT  18  ▓
9   25  A   DH  12  ▓
10  25  A   DU  10  ▓
11  25  A   PO  35  ▓
12  24  F   BF  167 ▓
13  24  F   DH  12  ▓
14  23  H   BF  173 ▓

#xls 👉

[magnacarta]

4🧵21

#XLSref: #Excel Function DMIN():

⋱   A   B   C   D   E
⁞   ⁞   ⁞   ⁞   ⁞   ⁞
4   Date    Day From    HIVE    ▓
⁞   ⁞   ⁞   ⁞   ⁞   ⁞
15  23  H   DH  12  ▓
16  22  W   BF  181 ▓
17  22  W   DH  11  ▓
18  22  W   DU  11  ▓
19  21  T   BF  188 ▓
20  20  M   BF  194 ▓
21  20  M   BR  43  ▓

#xls 👉

[magnacarta]

5🧵21

#XLSref: #Excel Function DMIN():

⋱   A   B   C   D   ▓
⁞   ⁞   ⁞   ⁞   ⁞   ⁞
4   Date    Day From    HIVE    ▓
⁞   ⁞   ⁞   ⁞   ⁞   ⁞
22  20  M   DH  11  ▓

💬 Row 2 is used for defining Criteria
💬 Row 3 separates Criteria from DB

#spreadsheet #spreadsheets #xls 👉

[magnacarta]

6🧵21

#XLSref: #Excel Function DMIN():

🎁db=$A$4:$D$22; criteria=$A$1:$E$2; date=$A$1:$A$2; day=$B$1:$B$2; from=$C$1:$C$2, hive=$D$1:$D$2 💬Named ranges

🎁ndate=1; nday=2; nfrom=3, nhive=4 💬Names

#spreadsheet #spreadsheets #xls 👉

[magnacarta]

7🧵21

#XLSref: #Excel Function DMIN():

💬 Based on above 🎁s, these formulas are equivalent:
♦️ DMIN(A4:D22,4,A1:E2)
♦️ DMIN(db,4,criteria)
♦️ DMIN(db,nhive,criteria)
♦️ DMIN(A1:D22,nhive,A1:E2)
♦️ DMIN(db,,A1:E2)

#spreadsheets #xls 👉

[magnacarta]

8🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ Find MIN value for Date
💬 Criteria section▶️Row 2 is blank

⋱   A   B   C   D   E
1   Date    Day From    HIVE    ▓
2                   ▓

👀DMIN(db,date,criteria)💬20

#spreadsheet #spreadsheets #xls 👉

[magnacarta]

9🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ Find MIN value for Day
💬 Criteria section▶️Row 2 is blank

⋱   A   B   C   D   E
1   Date    Day From    HIVE    ▓
2                   ▓

👀DMIN(db,day,criteria)💬0

#spreadsheet #spreadsheets #xls 👉

[magnacarta]

10🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ Find MIN value for From
💬 Criteria section▶️Row 2 is blank

⋱   A   B   C   D   E
1   Date    Day From    HIVE    ▓
2                   ▓

👀DMIN(db,from,criteria)💬0

#spreadsheet #spreadsheets #xls 👉

[magnacarta]

11🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ Find MIN value for HIVE
💬 Criteria section▶️Row 2 is blank

⋱   A   B   C   D   E
1   Date    Day From    HIVE    ▓
2                   ▓

👀DMIN(db,hive,criteria)💬10

#spreadsheet #spreadsheets #xls 👉

[magnacarta]

12🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ Find MIN value of HIVE when Day=A
💬 Criteria section▶️B2="A"

⋱   A   B   C   D   E
1   Date    Day From    HIVE    ▓
2       A           ▓

👀DMIN(db,hive,criteria)💬10

#spreadsheet #spreadsheets #xls 👉

[magnacarta]

13🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ Find MIN value of HIVE when Day=A & HIVE>10
💬 Criteria section▶️B2="A"; D2=">10"

⋱   A   B   C   D   E
1   Date    Day From    HIVE    ▓
2       A       >10 ▓

👀DMIN(db,hive,criteria)💬12

#xls 👉

[magnacarta]

14🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ Find MIN value of HIVE when From starts with "D"
💬 Criteria section▶️C2="D"

⋱   A   B   C   D   E
1   Date    Day From    HIVE    ▓
2           D       ▓

👀DMIN(db,hive,criteria)💬10

#spreadsheet #xls 👉

[magnacarta]

15🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ Find MIN value of HIVE when From=D*
💬 Criteria section▶️C2="D*"

⋱   A   B   C   D   E
1   Date    Day From    HIVE    ▓
2           D*      ▓

👀DMIN(db,hive,criteria)💬10

#spreadsheets #spreadsheet #xls 👉

[magnacarta]

16🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ Find MIN value of HIVE when From=DU
💬 Criteria section▶️C2="DH"

⋱   A   B   C   D   E
1   Date    Day From    HIVE    ▓
2           DH      ▓

👀DMIN(db,hive,criteria)💬11

#spreadsheets #spreadsheet #xls 👉

[magnacarta]

17🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ HIVE when 15<HIVE<100
💬 Criteria section▶️D2=">15"; E2="<100"

⋱   A   B   C   D   E
1   Date    Day From    HIVE    HIVE
2               >15 <100

👀DMIN(db,hive,criteria)💬18

#spreadsheet #xls 👉

[magnacarta]

18🧵21

#XLSref: #Excel Function DMIN():

💬 Scenario▶️ HIVE when 15<HIVE<100 or Day=M
💬 Criteria section▶️D2=">15";E2="<100";B3="M"

⋱   A   B   C   D   E
1   Date    Day From    HIVE    HIVE
2               >15 <100
3       M

👀DMIN(db,hive,criteria)💬11

#xls 👉

[magnacarta]

19🧵21

#XLSref: #Excel Function DMIN():

📝 DMIN() returns smallest value based on given criteria
📝 DMIN() returns 0 if
♦️ CRITERIA aren't met
♦️ F is a column of non-numeric data
📝 Inequality comparisons must be entered as text

#xls👉

[magnacarta]

20🧵21

#XLSref: #Excel Function DMIN():

📝 If CRITERIA is left blank, entire DB is used by DMIN()
📝 AND logic is expressed within a row of CRITERIA
📝 OR logic is expressed w/ conditions in separate rows of CRITERIA

#spreadsheet #xls👉

[magnacarta]

21🧵21

#XLSref: #Excel Function DMIN():

📝 Wildcards can be used for text data in CRITERIA

#spreadsheet #spreadsheets #xls ⏹️