Thanks both of these work
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

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 20112021) 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

Hello
I have an input sheet ( attached ). It contains two tabs ( Input 1 and Input 2). These have data for different years ( From 20112021) 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

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
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
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.

hello i need a bit of help for plotting graph of a continous data in excel. I have attached my file. Please could someone help me in knowing which graph will be the best for this data and suggest a way to plot it in excel

thank you both

hello
could someone help me with an excel formula to be used in attached sheet.I need a formula that writes each of the numbers in column A to column B in a date format.
For example Value in A2 is 20150730 therefore I need to write this as 30072015 i:e in date format in column B.
I have attached the sheet please help