Search results

Hi , I am not sure I have understood your correctly. If you have a workbook called say Test.xlsx , on your computer , and if one other person has a copy of this same workbook on their computer , then these two workbooks are independent , and changes made in any one copy will not reflect in the...

Hi , I am not sure I can do it , because the website seems to not have a standard way of approaching each item that it is displaying. The order in which the items are displayed in the browser does not match the order in which the items appear in the worksheet. Let me see if I can do anything...

Hi , What is $F$11 displaying ? Is it possible the formula might not have been entered as an array formula , using CTRL SHIFT ENTER. Can you upload your workbook with this data in it ? The earlier version does not have this data. Narayan

Hi , I do not know whether this will work with other pages , but it works with the one you have selected. Run the macro named Sheet2.launch_amazon1 Narayan

Hi , The order of entries is different in my file and in yours ! Narayan

Hi , I am not able to get 9 entries ! See the attached file ; I copied the code to a sheet module and ran it from Sheet2 ; only 4 entries. I added a new sheet Sheet3 and ran the code from the code module ; only 4 entries. Narayan

Hi , See the attached file. Narayan

Hi , When I run it , I get only 4. Can you post a screenshot of the 9 entries ? Narayan

Hi , Try this : Sub launch_amazon() Dim IE As SHDocVw.InternetExplorer Dim idoc As MSHTML.HTMLDocument Dim doc_ele As MSHTML.IHTMLElement Dim doc_eles As MSHTML.IHTMLElementCollection Dim startoftitle As Integer, endoftitle As Integer, rownum As Long Dim vouterHTML As...

Hi , See your file. The OR works when the criteria are next to each other. Since you want an OR , the criteria have to be on different rows , so that the filter will return all those rows which have either "chev" in the Make column or "com" in the Type column. Narayan

Hi , If you do not want to use an additional column in your table , try this formula : =SUM(--(FREQUENCY(IF(Table1[Emp Code] = $M6, IF(Table1[Customer Type] = N$5, IF(TEXT(Table1[Date], "mmm") = TEXT($N$4, "mmm"), MATCH(Table1[Product Code],Table1[Product Code],0)))),MATCH(Table1[Product...

Hi , See the attached file. I have converted your data range into a table so that structured references can be used. I have also added a column to your data , so that the same COUNTIFS construct can be used. Narayan

Hi , Read this and learn about how to get a list of unique values from a list which contains repetitions. https://www.get-digital-help.com/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/ Narayan

Hi , If you can upload your revised workbook , I can try and help. Narayan

Hi , Try this in G2 , and copy across and down. =SUMIFS($C$2:$C$6, $A$2:$A$6, $F2, $D$2:$D$6, SUBSTITUTE(SUBSTITUTE(G$1, "QTY (", ""), ")", "")) Narayan

Hi, See if this is OK. Narayan

Hi , The logic is not clear. Please revisit your data and see whether the values in the result column have been entered correctly. Narayan

Hi , See if this works : =IF(COUNTIF(C$2:C2,C2)=1,INDEX(Store!$B$2:$B$9,MATCH(C2,Store!$A$2:$A$9,0)),INDEX(Store!$B$2:$B$9,MATCH(C2,Store!$A$2:$A$9,0)) - SUMIF(C$1:C1,C2, F$1:F1)) Narayan

Hi , You already have formulas which can do this : Won't this do what you want done ? =SUMIFS(ee_taxes, start, ">=" & $B$3, end, "<= " & $C$3) + SUMIFS(er_taxes, start, ">=" & $B$3, end, "<= " & $C$3) Narayan

Hi , So what you are looking for is formulas in I10 through I31 , which take into account all the 3 selections in cells B3 , C4 and D4 ? Narayan

Hi , Where is this macro placed ? For the button macro to work , it should be placed in a standard code module , not in the code section pertaining to a worksheet or the workbook. Narayan

Hi , It is clear that your computer is missing the Calendar control. Since this is not necessary , I am uploading this workbook , without this control added. See whether everything works now. Narayan

Hi , Can you bring up the Visual Basic editor screen , click on Tools and then References , and show a screenshot of what is displayed ? Narayan

Hi , I am also using Excel 2010 , and I do not get any error when I do CTRL u ; the worksheet protection toggles ON and OFF. Narayan

Hi , I downloaded the file I uploaded and tried it , and I do not get any error. Try with the attached file and give feedback. Narayan