excel & array

How to marge 3 table into one table , because i face reference error , i tried......, pleased solving this query.... step by step.

Hello all, I'm trying to create an array loop that goes through columns A1,D1,G1, J1 (Keeping the headers) from one workbook and paste all the data to one column (keeping cell formatting) on another workbook. The data in the copied columns (A,D,G,J) will vary every time the macro runs so I'm...

Hi Masters, I need your help again. I was trying to use an index formula to sort the 2 sets of data from a smallest value. I cannot get it sorted how I want the data should look like in my excel. =IFERROR(INDEX(A$1:A$44,SMALL(IF($B$1:$B$44<>"",ROW($2:$44)-ROW($2:$2)+1),ROW($A2))),"") 1ST SET...

like ... "SR FOODS LTD" two time make Purchase products. 1) how to count target Unique Invoice Number & same party Name ???????????????????????????????????????????????

NOTE* Please skip until the next line highlighted in bold if you're not interested in seeing how my setup functions. Thank you! Hello everybody, I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this: To briefly explain the sheet...

I am having 2 sheets in excel and I am trying to combine the data such that for every record in Sheet1, I get records from Sheet2 based on the common key. Below is the sample data to clarify: I have SHEET 1 and SHEET 2 Data and I want to generate something like SHEET 3. Can you please suggest...

Hi all, I need your guidance if possible on how to amend the below array formula? =TEXTJOIN("/", TRUE, IF(MATCH(AN4:AN23, AN4:AN23, 0)=MATCH(ROW(AN4:AN23), ROW(AN4:AN23)), AN4:AN23, "")) Currently it adds the "/" as a pefix to the end of all values but i need this removing so it shows like...

I tried to return a value in sheet1, column A (vertical), to sheet 2 (Horizontal format), if the "Process_Step" and "WO" is matched. As the data is huge and there're many columns, I do not know how to specifically to use the index and match or vlookup, to return the column A value (Date) if the...

I have two workbooks, one where I am doing the Vlookup and the other contains the table I need to retrieve the information from. I am trying to basically Vlookup the table found in the other workbook '[Database_IRR 200-2S.xlsm]Changes'! below row 3 as sometimes the lookup retrieves information...

Hello I have this array of numbers and alphabets stored as text as you may notice :{”6”;”4”;”1”;”D”;”R”} I want to convert the numbers to numbers and let the text stored as text, it may look like this: {6;4;1;”D”;”R”} is there a formula to work around that? Any help will be very appreciated...

I have below code where we arrived at the list based on criteria and I have assigned it to an array called arr1. Now I am looking to apply a filter in "K" colum to select "Yes" alone loop through this array of items which are in "I" column and get the total sum from R column. I am fine if array...

Hi All, I have table data as below. There are 3 column. Vol1 CNT CNT_WISE_AVERAGE I want to write a VBA code to display the average value from "Vol1" column, based on "CNT value, and put the average value in "CNT_WISE_AVERAGE" column. There are nore then 5000 rows, having CNT values upto 80...

Hi Everyone Unfortunately I cannot download XL2BB (work IT security), so I have had to use the below screenshot. I am working on a large formula and have got stuck on one component. For ease, I have broken out this component and simplified it as follows: I have 5 values: MYTPP; MAPTM; EGPSD...

Dear Pros, Please how can I use formula to create COLUMN C from A and B?

Hi, I'm trying to insert this formula =IF(ISNA(INDEX(Pivot!$D:$D,MATCH('Schedule View'!$A4&'Schedule View'!$GS$2&'Schedule View'!GT$3,Pivot!$A:$A&Pivot!$E:$E&Pivot!$D:$D,0))),""No Commit Data"",INDEX(Pivot!$D:$D,MATCH('Schedule View'!$A4&'Schedule View'!$GS$2&'Schedule...

Hi, I have this data on excel SCALE_NO SCALE_NAME SIZ 1 DUAL 3942 1 DUAL 4346 1 DUAL L/XL 1 DUAL M/L 1 DUAL S/M 1 DUAL XS/S 2 ONE SIZE O/S 3 TALLA L 3 TALLA M 3 TALLA S 3 TALLA XL 3 TALLA XS 3 TALLA XXL 3 TALLA XXS if possible rearrange with some steps like...

How can I convert my Excel VBA code, which currently loops by each row, to loop through 10,000 sets, with each set containing 20 rows? I understand that the Step function might work, but I can't figure out how to amend my code to enable this. Basically, I would like to "paste" an array of 20...

Hi, I'd like to ask help with excel. Is it possible to detect which comes first? example: John smith took his break 3 times a day, how can i identify the first break and the other 2, like is it possible that a formula can Make it like Break 1, Break 2, Break 3?

Hi, I'm having a lot of trouble trying to get some values in some documents I have What I need to do is, get the amount of duplicate values that are in a column, for example In this table I need to do this calculation All the repeated values in the Column "L" are basically a single Item, but...

Hi All, I have a table with months in the top row; Locations in the first column. Corresponding numbers in the remaining cells of the table. I am trying to do a Sumproduct to get the data for each Location for the required month. For Example, sum of numbers from Bangalore for the month of...