identifiers

  1. S

    VBA Loop

    Hello, I have a giant file that I am trying to use VBA to quickly work through. In column D, there are ~4500 unique identifiers. Somehow, i need to copy and paste those 4500 identifiers in the cell B1. Any idea how to code this on VBA? EDIT: Sorry to be clear - i am trying to find a way...
  2. C

    Dynamic Correlation (possible PivotTable)

    I am trying to figure out a way to do dynamic correlation between variables by choosing start and end date, (Vertical Column A), and doing correlation between 2 different columns of values. The kicker is there is also a column of identifiers in Column B. So i'd like to select correlation between...
  3. D

    Countifs with a lookup

    So I have a bunch of column identifiers in column A on Sheet 1 (AVG_EFC_MTY_YR_QT EG). On sheet 2 I have the same column identifiers, except that they go across starting in A1 through IN1 and have data below them in the columns. What I wanted to do on sheet 1 in column B is say go and count all...
  4. D

    Worksheet change event to edit data range using lookuplist update

    Hello. Just curious if this is possible - it seems like really anything is possible in vba if the data is structured right ;). I have a lookuplist sheet that stores identifiers and a separate sheet that uses these unique identifiers as a group attribute. Consequently there can be tens...
  5. B

    Count if Formula

    would this be a situation for countif or something else? Column A I have a column full of unique customer identifiers and column B I have a list of owner names so for example column A has A00000076678 and Column B has Joe Smith I need a formula for how many unique customer identifiers in...
  6. E

    Building reference numbers for different selections from defined list

    Hi there, Sorry folks not sure even where to start on this. At work I have 12 sites , and I need a work code for each variable so i can identify jobs.. I.e. If supplier goes to site 1,2,3 I need one code, or he goes to sites 6,8,4,9 i need another. I need enough options to cover all variables...

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