Search results

Hi Kumar, To get the sum of TDS for each month, use the following formula. {=SUMIF(Sheet2!$A$2:$A$1002,B12,Sheet2!$C$2:$C$1002)}

Hi, I hope the following code helps you. Sub copyrange() Dim a As Workbook Dim b As Workbook Open both workbooks : Set a = Workbooks.Open(" path from copying book ") Set b = Workbooks.Open("C:\Users\Siddarth\Desktop\Test 0.xlsm") 'Copy what you want from a: a.Sheets("name of copying...

Instead of inserting sheet21 and then dragging it. insert a new sheet between sheet4 & sheet5, it will show as sheet21. All sheets are normal sheets, there is no sub-sheet in excel

Please upload the excel

Sorry attached here

Sri, here you go.

Check the data & window tab, It has been done with REPT Formula & CF. hope this is what you are looking for

Viwanou, If you are sure of the first 3 or 4 letters, you can use vlookup with the starting 3 words & you will get the results when the starting words match in another list. This is a common problem most of use face in worklife. VLOOKUP(LEFT(A1,3)&"*",B:B,1,0) VLOOKUP(LEFT(cell,first 3...

The best way to generate report for your scenario is with the help of Pivot Table. If you are using 2010 & above pls use slicers. The attached file is updated with the pivot. Hope this help you

One more solution, in E Column add ADD in the heading & sum Number Of Head Teacher+Number Of Teacher. In your sum product formula =SUMPRODUCT((A2:A12=H1)*(B2:B12=H2),IF(H3="All",E2:E12,IF(H3="Teacher",C2:C12,D2:D12))) Hope this helps

If you are using excel 2010, use the pivot table along with slicers, it will easy & less time consuming than an array formula.

Thanks, It helps a lot in my work..

Just select the columns you want to copy, press f5 function key, special & select visible cell only, now copy your data & when you past it, the details of the hidden column will not be pasted.

http://www.techonthenet.com/excel/formulas, this has what you have asked for but not in a consolidated sheet

Thanks Xiq, will get back to the forum if I am not able to code the VBA Part

Thanks Xiq you formula works. Is it possible to get the result data one below the other instead of the data with &. Sajan, Cell C has more than 5 data & the data is huge upto 5000+ rows.

Knochel, You have already posted the same question .

=IF(AND(c1>=a1,c1<=b1),"yes, worked in August 2013", "no, did not work in August 2013") If you want to include 1st & 31st AUG as well, use this formula

I guess you are looking for a formula to match both on the start date & End date. In c1 please enter the last date in august. Assuming the Start date is in A1 & end date is in B1 =IF(AND(C1>A1,C1<B1,"yes, worked in August 2013", "no, did not work in August 2013")

Hi Xiq, please find attached the excel file.

Narayan is truly an excel Ninja. Thanks I learnt a lot today from you.

I need to lookup values from a cell to another Multiline cell. ex: A B ID Name 001 ARUN OO2 Pawan 003 Sunil In C, I the ID, but the ids are in a single cell. C2 has ID number 001 & C3 has Id number 002 & 003 one below the other. In D, I want to...

Ok got your point, sorry I did not read it properly. your formula extract the numbers after that go to data Data>Text to column>Delimted>others, enter . & click on Finish. now you data is spread in 2 cells. Use the formula given above to extract the text.

I did not understand why you want 3 separate formulas, You need to extract the text in one cell & the numbers in another. To extract the text in a cell, use this formula. =LEFT(A1,MIN(FIND({"0","1","2","3","4","5","6","7","8","9"},A1&"0123456789"))-1)

To sort horizontally, you need to convert the Table to a normal range of data. As the option is not available in Table