b21

  1. H

    Array depending on 2 variables

    I have the following sheet https://1drv.ms/x/s!Ai6fM6lT5gt6h0vP6kgG5MmfsdsU It consists of a table that is populated by a list (with an array). The last column of the table is based on a value in B21. Goal: I want to populate a second table based on the value in B21 and based on the last...
  2. P

    How can I add OFFSET function to this formula?

    Hello, I have the formula below in B21. If I want to cut/paste B21 to C21, D21 etc, how can I add the OFFSET function so it adjusts automatically? The area 'UPLOAD FILE'!G2 obviously pulls from the G2 cell of the UPLOAD FILE. When I copy B21 top C21 I need the G2 to change to G3 Cell B21...
  3. P

    Find,count, copy & transpose loop macro...perhaps?

    OK. So I have been given a list of 18000 rows in the following format <tbody> ABC5016 B21 C833 J069 R222 R4589 Z21 DEF0290 D090 R001 Z8643 </tbody> It appears that the 7 digit alpha-numerics are the UID & the shorter alpha-numerics are attributes that append to the...
  4. X

    Counting one column if one of two other columns have a value

    A21:A30 are locations C32:C2000 has names of locations G32:G2000 has a dollar amount H32:H2000 has a dollar amount I need B21 to only count locations in C32:C2000 that correspond to A21 and have a value in either G21 or H21. Example C32 is "Home". The formula sees that A21 is "Home", but also...
  5. A

    Formula calculating mınutes

    =IF(TEXT(SUMIF($A$21:$A$27,A31,B21:AF21)/60/24,"[h]\h\r\s m\m\i\n")="0hrs 0min","",TEXT(SUMIF($A$21:$A$27,A31,B21:AF21)/60/24,"[h]\h\r\s m\m\i\n")) Hi, Please help me with above formula, Why it is calculating only B21 values ınstead total of B21:AF21 values? Many Thanks

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