multi column

  1. S

    Formula for pulling the counts on items in i different locations but with same name

    =XLOOKUP([@Item]&[@[Bin Number]],Item19&Bin_Number19,"@[Count19]","",1) =XLOOKUP("[@Item]='R19'!@Item19*'Calculate sheet'!@[Bin Number]=@'R19'!A3:A68",Item19,Count19,"",1) this only pulled the first instance of the same name I tried the above and a few other variations but could not get the...
  2. R

    VBA Nested If Statements to ensure Valid Input

    Hi all, I have been working on a dashboard which will, dependent on a yes/no indicator, require updates from a given user. The dependent variable is in column B, with about 2000 rows. These cells have drop downs with two choices: "No Changes" and "Update Result". "No Changes" is the...
    • Roberto2712
    • Thread
    • cells multi column multi conditional multi row records nested "if statements"
    • Replies: 2
    • Forum: Excel Questions
  3. T

    2 Listbox selection to a worksheet

    Hi, I have two multi column Listbox on a userform, the first listbox1 finds details about a customer Order. Listbox2 displays the current stock. Now Listbox1 is a single line selection and Listbox2 is a multi line selection, So to fill a order you select the order from Listbox1 and then the...
  4. BrighterLater

    Listbox with customisable Property Headings

    When one uses a file dialog to select a file, the standard MS windows form contains a multicolumn list box with customisable column headings showing a selection of property names: file name, size, type, etc. Is it possible to incorporate that component of the form in a VBA form. Is this an...

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