multiple column

Hello, I need some help, I want to know if it's possible to select mutiple columns from one row until down : for exemple select A5, B5, C5 until down and copy to paste it on a other sheet. For the moment I use this type of code which move between sheets column by column 🤕 : Public...

Hi, this is my first time so I apologize for mistakes. I have already looked all over internet and have not manage to find an answer to fit my question. I have this set of data on sheet1 And I want to concatenate the IDs, Targets and DNS based on Name and Risk on Sheet2 like this So if it...

Hi all. I have a spreadsheet with x number of columns, I'm looking for the string "YES" in each row of a specified column and once found I place the name linked to the fruit into a jagged array. For example I have a name, surname and fruit columns. The reason I would like a jagged array is that...

Hi guys, I would like to know if there is a way to add more than 1 adjacent column for the presented code that I found on Internet and that Fluff helped me to modify in this Post Furthermore it's possible to apply a string extract (for example, extract the first 4 and the last 4 characters and...

Hi guys, I would like to know if there is a way to add more than 1 adjacent column for the presented code that Fluff helped me to modify in this Post Furthermore it's possible to apply a string extract (for example, extract the first 4 and the last 4 characters and put them in different column)...

Hi Everyone, First time posting so hopefully this is clear. I need a formula that can help find and populate an entry when 2 consecutive cells in the same row match 2 other consecutive cells in other columns. i.e. Cell A2 = John Cell B2 = Smith Cell C2 = Blue Cell D13 = John Cell E13 =...

Hi excel help community, I have a sheet that collects our planned scaffold tower quantities by type for each bridge we have with an associated date range of use. I would like to sum scaffold type in use by month (see below) to enable us to produce a histogram of scaffold type over several...

Hello, hope for anyone that can help. Basically, I have input a COUNTIF function for Column B such as =countif(B:B,B2=1). A popup will occur if there are any duplicate values. When I entered this and run, it worked as intended. Then on a different column, I used a Vlookup to carry out another...

I worksheet of 500+ column. I need to create radar 1 graph for each 20 column.Each column has 72 rows.means obviously 1 radar for 1 column. each chart has 20 columns/ radars. from 1 to 20 column 1 chart will be there next chart is for 21 to 40 column. 3rd chart for 41 to 60 column and so on...

I need help on how to take one column with an address and make it into multiple columns without using the Text to Columns method. My example address looks like this: <tbody> 2000 STREET ADDRESS DR CITY, STATE 20000 </tbody> After I copy and paste that into a multiple column cell, I would...

Hey guys, I'm trying to filter a report, but I want to filter multiple columns. for example, in column 1 I want to show the values "base" and "connect" and in column 2 I want to show the rows that contain "subgroup". however, the issue is, that rows that have base or connect in the first row...

Hi - I have a large spreadsheet with multiple tabs in it. I'm looking for a conditional formatting solution for the following - I'll explain: Say in my worksheet I have Tab1 and Tab2. Tab1 has a list of customers we work with based on submissions they send in. on Tab2, I keep track of these...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]-->Hi Folks, I wanted to know what the formula would be when using a VLOOKUP formula for multiple columns from another sheet. This is the formula I have however, I’m getting an...

Friends, I am trying to use PivotTable for a function that can be done in HLookup, but I am hoping can be done much faster in Pivot Table. I have five (5) related columns that all have the values of Positive, Neutral, Mixed, Negative, and NA. I am wanting these values to be the Row Headings in...

Hello, I'm a new member and I'm not entirely sure how this forum works and where to post questions. I've been searching on this site as well as online and did manage to find some info, but none of them seem to work or doesn't apply. Issue: I have a workbook with multiple tabs; each tab does...

Hello! I have this code below applying to one column right now so that I can select multiple keywords from a data validation drop down. I need this to apply to multiple columns. I found a similar query on here but I couldn't get the code to work for me. Please help, see below. I want it to...

Evening MrExcel Community, Well now it appears it's morning. I'm fairly decent with most things non VBA on excel but the VBA side I don't really know much about. Apparently this is my next area to learn. I have an excel sheet that I update the main info from another database by deleting the...

Trying to add 36 columns based on 1 criteria, and return the result. example: <tbody> product status units/$ wk 1 wk 2 total units total $ wk 1 wk 2 ttl a allocated 2 0 1 1 $10 b released $20 c allocated 7 2 3 5 $50 d released $70 </tbody> area from units/$ to ttl...

Hello all I am new here so im sorry if this has been asked and answered but this is what I am looking for.Currently I am using VLOOKUP like this =IF($A8="","",(VLOOKUP($A8,MASTER!$A$1:$G$1500,6,FALSE)))I have changed my master sheet to allow conversions so now I enter the master sheet like...

<tbody> Labour Cost Cleaning 200.58 Travel Time 489.56 Wet Time 55.00 Set- UP 855.00 Operating Equipment 780.00 Spotter 200.00 Supervision 1200.00 </tbody> I need a formula that gives me the top 5 values in Col B and then Displays them with the appropriate Value in Col A As such...