column

  1. A

    Grabbing the latest data from a Column based on a cell

    Hello, Calling all help! I cannot figure out a formula to make this work. I am tracking my pups got their medical history and I would like it to auto-give me a expiration date based on the most recent date i entered where its checked (I added checkboxes into columns- not sure if that is a good...
  2. H

    Cashflow forecast based on start dates and either monthly, bi-monthly, quarterly, annually

    Hello and thank you for your time: I have a table of overheads. Each overhead has a value in column D Each value is paid monthly, bi-monthly, quarterly or annually stated in column F Each overhead has a start date for when the first payment is due in column G Column H is the start date of...
  3. T

    Power Query: transpose column to one comma seperated cell

    Hi I have a list of 4 digit numbers in a column in Power Query, for example: 1234 3827 3845 4028 3957 The file is refreshed with a new list each week with a differing amount of numbers. I want PQ to combine them so they end up in a single cell in the following format...
  4. S

    When pasting, only allow to use the first X columns

    Hi all, I have text that I paste in my sheet that takes about 10 columns. The problem is that the last column is a hyperlink. I already have hyperlinks in other columns which activates a macro (sending email) when I click on it. Therefore when I paste the text, the pasted hyperlink undesirable...
  5. N

    Vlookup max value and finding number in specific column

    Hi, thanks for help. 1. I am trying to find a max number in a vlookup but my formula is not working (see below) 101 101 3 96 78 So if im trying to find 101 in the table i would do =VLOOKUP,101,table,3,false) but it will bring up 78 but what i need it to...
  6. I

    Count instances of a word in a column

    Howdy, I am trying to find how many instances of "normal" i have in a column full of different values. Is there a way I can count how many of the cells are "normal" in the column? I tried using a couple options from the official microsoft forumns, and so far i am not getting anywhere near...
  7. L

    Using INDEX...SMALL...IF...ROW and COUTNIF in order to match multiple peoples names to single email for mail marge

    Hi there, I have found some old posts on this topic but nothing that seems to solve my issue. I am using the below formula in order to pull a list of individuals names that have correspondence through the same email address. For example if Mr John Smith, Mrs Jane Smith and Miss Janet Smith are...
  8. K

    Deselect from Multiselect Dropdown / with vbNewLine / for 2 columns

    I am new to vba, and for two columns I am trying to create a multi-select drop down lists using with vbNewLine (rather than being separated by a comma), but now I want to add in the capability to "deselect" items. This is my current code, as I do not know how to add in the "deselect" code part...
  9. N

    use same VBA code in a different column

    Hi, I have a code which runs on column A, but i need the code to ignore column A and start working from column B. Sub transpose_in_place() Dim rw As Long, cl As Long With ActiveSheet For rw = .Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1 For cl = .Cells(rw...
  10. D

    List.ContainsAny within same column

    I'm trying to check each list if any of its content matches any other lists' contents, and then flag them if found e.g. for each List in Time if List.ContainsAny(Current List, Any List from time column) then flag repeat for all...
  11. K

    VBA 'if/then' Code Error

    Hello! Today is my first day exploring VBA coding, and I'm having trouble with the below 'if/then' VBA code (also attached a screenshot). In short, what I need is for data in Column E to automatically populate according to what is in Column D. For example, if any rows in Column D read...
  12. D

    Create column of all dates in a month (Power Query)

    = Table.AddColumn(Source, "Custom", each {Date.From(Date.StartOfMonth)..(Date.EndOfMonth)}) I am trying to create a custom column but I keep getting this error:
  13. J

    Queryname or table name als column in Query

    Bye all, I would like to add the query name as a column name in my Power Query. For example, the query name is "Cost1", so I would then like to have a column cell with the data "Cost1" at each row. Or is there any way to add the table name as the column name Is there any particular formula I...
  14. R

    Randomly pick string element from array

    Hi, I have the following code which creates an array "Ary" with string elements from a table column that match value "x" from another column in this table. I would like to have cell E6 display a randomly picked string element from this array "Ary". How would I have to alter the VBA code? Sub...
  15. E

    Comparing two comma-delimited lists and getting unique values

    Hello! A set of data was gathered where it consists of name of certifications and those who have completed such certifications. Required certifications (certs to shorten) needs to have a 'Yes' filled out . What I'm trying to figure out is returning a list of what certs that are required against...
  16. Woozypictures

    VBA Code to copy specific rows from one sheet to another, based on cell value

    Hi All, I've been using this fantastic forum for previous VBA issues I've had, seeing other peoples posts and using the brilliant answers people have provided, however It seems Im going to need the extra help on this one! I have a workbook that I use as a report for Aged Debtors, with a query...
  17. J

    Change Column Position by Input

    Hello guys! I need a help with VBA code to chnger order of columns when I click using drop down list I have data of 12 stores, with 12 columns, each column consisting of stocks for each stores. What I want is, I want to specify the columns (each time it is going to be different) to be in what...
  18. H

    Auto coloring in the same row

    Hi, I want your help. I try to make a VBA macro that it will be searching TRD from column B and auto coloring in the same row on column A the corresponding number.
  19. N

    Data from API into Excel sheet shows "[List]" How to expand values in spreadsheet

    I pulled data into excel from an API. However, it shows as list then record. I need all records expanded when I close and load, but can't figure it out. A few screenshots to help see what I'm trying to work with: I need the values: id, ticket_id, user_id, reason, and created_at. I do not...
  20. Z

    How to loop over all indice in a filtered column

    Hello, I want to loop over all indices in a filtered column & do something for each indice each time, how can i do that please ? Thank you in advance :)

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