column

Hi everyone, I need help with a VBA code to shift an existing table from right to left in Excel. I’ve attached two screenshots for reference: Screenshot 1: Shows the current layout, where the columns "Number", "Name", and "Salary" are in columns A, B, and C. Screenshot 2: Shows the desired...

I would like to determine if there is an Excel Formula solution for counting the number of unique values in a column where cells have multiple values separated by a comma. Please see the illustration below.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

= 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:

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...

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...

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...

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...

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...

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.