Search results

Hi, Looks to me like a dot plot. Check out this link. http://peltiertech.com/Excel/Charts/DotPlot.html Jai

Hi, Try sumproduct. Assuming Products in A1:A10, Fruit etc in B1:D1, colour in B2:D2 and values in B3:D10. =SUMPRODUCT((A1:A10="Product1")*(B1:D1="Fruit")*(B2:D2="Red")*(B3:D10)) Jai

Thanks Luke and Shrivallabka, It worked as expected. Jai

Hi Luke, According to the post, the two lists are on different sheets in the same workbook. Conditional formatting doesnt seem to work between 2 different sheets. Is there any workaround for this? Jai

Hi Chandoo, Sorry for the late reply and thanks for personally responding. I will check out these links as well. Jai

Hi, with the first table in A19:E22 and second in A25:E28. Try in B26 and drag down. =INDEX($A$19:$E$22,MATCH(A26,$A$19:$A$22,0),MATCH($B$25,$A$19:$E$19,0)) Jai

H, Try in J2 =IF(J1="NP",E1+10,IF(J1="P",E1+3,"")) Jai

Hi, Try this. =VLOOKUP("EM1001*",A1:D10,2,0) Adjust the range as per requirement. Jai

Hi KPJ, I will check out the book you mentioned and see if I still have patience to go throgh 500 page books. Thanks for replying. Jai

Hi All, I have learned a lot of good things in Excel from this site. Now I am planning to learn VBA. Can you guide me to some good resources available on the net for learning VBA? Thanks in advance!! Jai

Hi, check out this link to get more information about lookup functions. http://chandoo.org/wp/2012/03/30/comprehensive-guide-excel-vlookup/ Jai

Hi, Try, =INDEX($A$1:$C$19,MATCH(3.833,$A$1:$A$19,1),3) Your column says "But less than" which means it would be 2.22 at the max for first row. You would not get 2.23 for first row. So I dont think there is no need to begin with 2.24 in the next row. Jai

Hi BM, If your data is in say K1:K10, you can put this formula in L1 and drag down. You will get the comissions for each entry. After that you can simply add them. Jai

Hi, Try, =IF(K1<=100,(K1*0.01),((100*0.01)+((K1-100)*0.005))) Jai

Hi, check out this link. http://www.itechtalk.com/thread1099.html Jai

Hi, Try this in B1. =DATEVALUE(MID(TRIM(A1),4,2)&"-"&LEFT(TRIM(A1),2)&"-"&RIGHT(TRIM(A1),4)) Format the date as required. By the way the values in A1 and A2 in your sheet are not in date format. Jai

Hi, Try, =COUNTIFS($A$1:$A1,A1,$B$1:$B1,B1)>1 as the conditional formatting rule. Jai

Hi, From what I understand, you are entering the invoice numbers in a sheet and want to be alerted if a number already exists in the sheet. Try conditional formatting with new rule and formula. =countif($A$1:$A1,A1)>1 Format as required. Jai

Hi, The first one is correct. There is no need to use "" for numbers. Jai

Hi, You might have entered this as a normal formula i.e. just pressed ENTER. This is an array formula. After pasting the formula in the cell, do not just press enter, press CTRL + SHIFT + ENTER. You will see braces { } around the formula. After this, copy down the formula. Let me know...

Hi, Try this in A3 and copy down. =IFERROR(INDEX(Data!$B$2:$B$17,SMALL(IF($A$1=Data!$A$2:$A$17,ROW(Data!$A$2:$A$17)-1),ROW($A1)),0),"") This is an array formula.To be confirmed with CTRL + SHIFT + ENTER. I have made one change in your sheet. In Cell A1 on Buyers tab, I put 1 instead of...

Hi Debraj, I tried the UDF and got this result. 087911153  200872404 095885477  205008592 074614622  094121771  072348032 Can we get rid of the leading spaces in some of the results? Jai

Hi, Did you put the complete formula exactly as it is? I was also facing the same issue.I was not able to get rid of the 2 spaces.So I used RIGHT. The RIGHT function is pulling 9 digits from right which are the numbers. Now the result I get is: 087911153 200872404 095885477...

Hi, As far as I understood from the post, J7 and E13 are on different tabs/sheets. Try, =IF(sheet1!J7=Sheet2!E13,"MATCH","NO MATCH") change the sheet no. to match those on your file. Jai

Hi, Try this. Assuming all numbers are 9 characters long and you have "@" and "-" in the data =TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A1,"@ ",""),"-",""),9)) Not an elegant solution. But seems to work. Jai