Posts by dkool

works fine . Thank you

Hello . Thanks for this. This should work . Just one request , if the code can be made flexible. If I add more products in products column and more items to my fixed list , then currently it doesn't work . If that can be done that will be helpful

Hello

I need an excel formula or Macro to do the following in my attached spreadsheet

1. In the input tab filter on each unique product in column A to identify possible combinations of product with each of the values in column B-D (see expected output tab).

2 . For each unique combination paste the values from column H in a separate tab.

3 . Do this for each product

I have attached the sample expected output in the expected output tab for product 1 but I will need to do the same for each unique product in my list.

Thanks in advance

query.xlsm

Thanks both of these work

Hi , I need an excel formula to do the following

1 . in the calc sheet column A has month and column B has year

2. in column C and D i need to find which quarter of the year it is corresponding to the month

3. for example if the month in column A is 1 , 2 or 3 then quarter is Q1 , if the month is 4 ,5 or 6 then quarter is Q2 , if the month is 7,8 or 9 then quarter is Q3 and finally if the month is 10 ,11 or 12 then quarter is Q4

4. I have done this manually in column C but I need an excel formula to do this in column D using the months from column A

I have attached the excel sheet named calc below . Please can someone help me . Thanks in advance

calc.xlsx

Thank you so much . works perfectly fine.

when there is more than one file and if these are unique then I need name of both the files "File used" column .

For example in the 2nd example you mentioned 2 unique files are Dummy4.xlsx and Dummy3.xlsx . so I would like the output in the "File Used" column to be like this:

1. Dummy4.xlsx

2 .Dummy3.xlsx

Hello

I have an input sheet ( attached ). It contains two tabs ( Input 1 and Input 2). These have data for different years ( From 2011-2021) and different products ( A to G). Both of these tabs takes values from external excel sheets

I need a VBA code to identify or create a list which contains tab name , the name of external sheet used and for which product and which year it is used . Please note that some of the products use more than one external file and I all the name that are used

I have attached a sample output for the same . But I need a VBA code to do this as my original file has a lot more data.

1. For example in the output sheet you can see for product A year 2011 file name is Dummy4.xlsx and similarly for product A year 2012.

This is just a sample output . I need a VBA code that gives the full list along with year and product name.

Thanks in advance

Input.xlsx

Output.xlsx

Hello

I have an input sheet ( attached ). It contains two tabs ( Input 1 and Input 2). These have data for different years ( From 2011-2021) and different products ( A to G). Both of these tabs takes values from external excel sheets

I need a VBA code to identify or create a list which contains tab name , the name of external sheet used and for which product and which year it is used . Please note that some of the products use more than one external file and I all the name that are used

I have attached a sample output for the same . But I need a VBA code to do this as my original file has a lot more data.

1. For example in the output sheet you can see for product A year 2011 file name is Dummy4.xlsx and similarly for product A year 2012.

This is just a sample output . I need a VBA code that gives the full list along with year and product name.

Thanks in advance

Input.xlsxOutput.xlsx

Thank you. This is helpful ?

Hi

I need an excel formulae that can do the following in the attached excel sheet

1 . Look up the year from output sheet starting from cell A4 . Look up this value in the sheet investment returns

2. Take the sum of values from year looked up in step 1 till year 2019. The values from column D( Cumulative return to end of 2019) in the investment return sheet should be summed.

As an example in the output sheet I have manually done the calculation for year 2017 . But I need an excel formula that can do the same thing so that i can drag it for other years.

Thank you both. I like both the approaches . Both of these work fine

works perfectly thanks

Hello,

I have an input workbook ( attached ) which has a worksheet ( sheet1). I need a VBA code to do following things:

1 . Identify unique values ignoring duplicates in column A ( for example in this sheet unique values are A , B and C)

2. Create new worksheets by unique names identified above ( for example in this case create sheets A ,B and C)

3. Paste the data corresponding to each unique values from sheet1 into the sheets created above ( for example all data corresponding to A gets pasted in sheet A ).

I have also attached the required output workbook along with the input workbook

Input.xlsm    Output.xlsm

Thanks in advance

Hello,

I have an input workbook ( attached ) which has a worksheet ( sheet1). I need a VBA code to do following things:

1 . Identify unique values ignoring duplicates in column A ( for example in this sheet unique values are A , B and C)

2. Create new worksheets by unique names identified above ( for example in this case create sheets A ,B and C)

3. Paste the data corresponding to each unique values from sheet1 into the sheets created above ( for example all data corresponding to A gets pasted in sheet A ).

I have also attached the required output workbook along with the input workbook

Input.xlsmOutput.xlsm

Thanks in advance

Dhruv

I need a VBA macro or excel formula to do the following in the attached excel file

Column A to Column E has unique values

Column F to column EY has the data

I need to do following

1 . Filter unique values from column A to E one by one.

for example filter the first value from Column A and keep values from Column B to E same and paste all the corresponding data on these filters from Column F to EY in a separate sheet.

2 . Also indicate in that sheet which combination of filter is used for the data . for example indicate which filter is applied for the values from Column A to E.

I have attached the sheet

Thank you

Hello

Could someone please give me an excel formula that does the following in the attached excel sheet

1 . Look up value in column G ( source_2_value) and match that value in column B ( source_1_value)

2 . Give the corresponding value from column A ( Source_1_data_field) based on the above matching . The output should be given in Column D ( Mapping_output).

I have attached the excel sheet.

Hello

for number 2 .

we have input as Dur_M as 6 wich means 6 months and when we convert it to year we should get 1 as the expected output. I am giving an example below to let you know what exactly I want.

Case 1 : DUr_M = 6 , output should be 1

Case2 Dur_M = 14 , output should be 2

Basically Dur_m reperesents the number of months a particular thing is in force and we need to convert it into years

Hello

I need an excel formula that can do the following ( in the attached excel sheet)

1 . Look up the value from input sheet from rows 8 and 9

2 . Convert the value in row 6 which is in month to completed years. If this is less than 1 then value will be 1. Place this value in row 7 of input sheet

Match the value from rows 7, 8 and 9 to the corresponding value in output sheet to give a final rate for a particular year.