rows

Hello- Hopefully an easy question. Have a large dataset where there are two rows for each Group & Category. Is there's a way to consolidate as in the example below? ABCD1Current2GroupCategoryBaseline_CountFollow-up_Count3Age Group65 to 69 years254Age Group65 to 69 years275Age Group70 to 74...

Dear all, I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel: I have the current sheet of data: The formula and the data links to this test sheet of data: Now I have done about 90% of the work (I hope), seen as my...

Hello All: Looking for some VBA to do the following: I am routinely hiding and unhiding rows 5 through 15 on a number of worksheets in one workbook. Would like some code that when run would hide the rows if unhidden -THEN- unhide the rows if hidden. Will assign to a button thereafter. Thank...

Hello all, I'm trying to figure out how to do this properly, but making functional loops seems to be my VBA Kryptonite. I have this code: Private Sub CommandButton2_Click() Sheets("Summary").Range("A1").Value = FEP.TextBox1.Value AllBanks End Sub that takes the number entered into the...

Hello, I have just started with VBA and I need your help. I've attached a picture and I will try to explain my problem. In "lastat"-sheet, I will add stock/pallets that I will move to another warehouse. With "Move"-button i move numbers to "Lagersaldo"-sheet. This warehouse will use...

Is there a way i can copy paste specific rows to the excel ark. The things i need: - copy paste e3, e4, e9, e13 and e15 from mappe2 (book) to mappe 1 (book) - has to copy the value in the given row if the cell next to it is empty - the macro has to be applied from mappe1 (book) - next month the...

Hi Guys, I hope I can explain myself clearly . I have a user form, what I want to do is: Type a name, (let's think that I have 3 people call Jessica but with different last names), when I click in search, I want to be able to see displayed the 3 names Jessica inside the list box The sheet name...

Hey good folk, I have a timesheet i get my engineering dept to fill in, we have a lot of customers who's name they have to input when working on a design. The "short" name our ERP system uses is noting like the actual customer name and my guys sometimes get confused. Anyway i have created an x...

Hi, Let me try and explain what I need with a simplified example: I have a table (H3:I5) that gives me the value for each item (I have dozens of items in the reality). I need, for each month (in B9, C9, D9), to know the sum of the value of each item for the particular month... but only...

Never encountered this problem before. Have a file, tried to add new rows but it moves the Pivot Table down (like I expect it to) but leaves the data that was in the Pivot Table in the original rows... Thought something was amiss with the file itself so I created a new file and tried to...

Hi! My data set has 117,000 rows and 14 columns. It is at an item and week level. There is a week column, an item description column, 11 columns of characteristics that describe/classify the item, and finally the value column (cost). Is it possible, via M code or otherwise, for me to group by...

Hi all, I have a giant database of NBA players and their NBA 2k ratings, what I'm trying to do is automatically pull them into team lists: To get the starting 5 I use this formula in column C...

I have the 2 tables below: Table1 ID Start Date End Date ABC123 01/04/2020 13/09/2020 DEF456 03/01/2020 17/02/2020 ABC123 15/09/2020 30/09/2020 Table2 ID Start Date End Date ABC123 17/12/2019 12/07/2020 ABC123 13/07/2020 11/11/2020 DEF456 07/07/2020 09/09/2020 DEF456...

Hi, Required a formula help to Extract and return a rows which contains alphabetical text, and return a list wise cells values which contains alphabetical text as based on data specified in column(B4:E8) desired results enclosed. Thanks for the help...

Hi, Required a formula help for Filter/Transpose a multiple rows and multiple columns in a same row as per condition met with row headers . Row Headers that contain duplicate row headers and reorder all values or text values from multiple columns into one row. solution to be needed in Column...

Hello, I'm trying to get 2 multiple results from 2 different columns under 1 column and in order. Column E = Matching Apple in column A -> returning C value {=INDEX($C$1:$C$6,SMALL(IF(ISNUMBER(MATCH($A$1:$A$6,$E$1,0)),MATCH(ROW($A$1:$A$6),ROW($A$1:$A$6)),""),ROWS($A$1:A1)))} Column F =...

I have a excel sheet with around 5lakh rows and i want to reduce number of rows by cumilating same data. below is the sample data (Couldn't share original data due to privacy reasons). Data should be combined based on Columns B,D,E,G. If data present in B,D,E,F columns is same the code has to...

Hello, I'm trying to make the formula working on each 2 rows respectively, but I couldn't FX SWP product is displayed in 2 rows. I want to separate the two rows, and put one in the Short sheet and one in the Long sheet. Each FX SWP has the same Swap Number, with two Trade Number, one will have...

Sub Del_Non_00() Dim a, b Dim nc As Long, i As Long, k As Long nc = Cells.Find(What:="*", After:=Cells(1, 1), LookIn:=xlValues, SearchOrder:=xlByColumns, _ SearchDirection:=xlPrevious, SearchFormat:=False).Column + 1 a = Range("B1", Range("B" &...

Hey all, I am not sure if this is even possible, but I figured I'd ask/give it a shot. In a spreadsheet I have a marker (denoted in cells with a * symbol). Is there a way (without using VBA) to use conditional formatting to adjust the colors of the cells around the marker? The following...