Posts by dkool

    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

    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

    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.

    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

    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.