# Posts by dkool

• ## excel formula to lookup year and sum

Thank you. This is helpful 😀

• ## excel formula to lookup year and sum

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.

## Files

• Book1.xlsx

(15.62 kB, downloaded 31 times, last: )
• ## VBA code to find unique values , create sheet by their name and paste data

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

• ## need VBA code to find unique values, create sheets and pste data

works perfectly thanks

• ## need VBA code to find unique values, create sheets and pste data

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

• ## VBA code to find unique values , create sheet by their name and paste data

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

Dhruv

• ## need macro to filter and paste data

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

• ## excel formula to lookup number and give ext

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.

## Files

• sample.xlsx

(16.71 kB, downloaded 55 times, last: )
• ## excel formula needed to lookup values

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

• ## excel formula needed to lookup values

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.

## Files

• lapse.xlsx

(10.11 kB, downloaded 59 times, last: )
• ## excel graph help needed for continuous data

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

## Files

• BMI DATA.xlsx

(8.92 kB, downloaded 55 times, last: )
• ## excel formula needed for date

thank you both

• ## excel formula needed for date

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 30-07-2015 i:e in date format in column B.

## Files

• example.xlsx

(8.81 kB, downloaded 58 times, last: )
• ## populate the list of chnaged items

please could someone help

• ## populate the list of chnaged items

hello

could someone help me with a vba macro.

I have 2 folders and both of these have text files by similar names.

I need a macro that compares the contents of two folders and tell me the name of text files that have changed.

please note that I only need the name of text files that have changed , I don't need to highlight any differences, just populating the names would be enough.

Please could someone help me with this.

• ## excel formulae to find grade by certain conditions

I have a data and I need to find out the grade of each student by marks with certain conditions. I have attached the image of worksheet for reference.[ATTACH=JSON]{"data-align":"none","data-size":"full","title":"dummy.png","data-attachmentid":1202780}[/ATTACH]

• ## Vba code to compare two different sheets in a workbook

I want to compare range A1: N2781 in both the sheets.

• ## Vba code to compare two different sheets in a workbook

Hello

please could someone tell me a vba code that compares 2 sheets in the same workbook and highlights the difference.

The two sheets have text in it.