Search results

Hi: May be this? Formulas in yellow cells. Thanks

Hi: Power query solution, Just refresh the green table after adding data to the blue table it will pick up all the changes you have made. Thanks

Hi: May be using power pivot.... Thanks

@Peter Bartholomew , I have not tried any of these function you mentioned .I normally try to stay away from formulas if possible for summarising data since file size can become big and cumbersome to manage. And pivot tables will be much easier to mange for people who are not a super user in excel.

Hi: The easiest way to do this using pivot and slicers, this will give you the results as per all the random combinations you are selecting. I am not sure why you are going a formula method where you have a easy native function available in excel. Thanks

Hi: May be using power query? Thanks

Hi: Yes, if you filter out the 3rd row you will not be having any issues. I would recommend power query for collating and transformation of data above formula or VBA solution. Thanks

Hi: Find the attached. you did not increase the range, hence the values were missing. I have increased the range now and the formula is working fine. Thanks

Hi: If you are using excel 2016 I will do it using power query as attached. Thanks

Hi: I have added an helper column to get the results and have commented on values I am not clear. Thanks

Hi: May be this formula? =IFERROR(IF(H2=LOOKUP(2^15,SEARCH($A$1:$A$10,G2),$D$1:$D$10),LOOKUP(2^15,SEARCH($A$1:$A$10,G2),$C$1:$C$10),"Qty No Match"),"UnKnown ID") Thanks

Hi: If you are using any of the latest versions of excel you can achieve this easily using power query. Thanks

Hi: May be this? using Power Pivot. Thanks

Hi: Is this what you are looking for? Thanks

Hi: Not sure what you meant by one column in raw data, could you upload a sample? Thanks

Hi: One reason why you get error is because your sample size is too small for the no: of independent variables you are using in your model, try to see if you can drop some independent variable from the model. One way to do is to check for multicollinearity among the independent variable and...

Hi: Find the attached, using power query. Thanks

Hi: Find the attached. I have used Power Query to achieve this. Thanks

Hi: I want more information on this: Are you looking it based on only column A? What is the relevance of columns B,C &D? Which Pickup date you want to look up if 1 PO is having multiple pick dates? could you fill in expected results for couple more PO numbers? Thanks

Hi: Using Power pivot & DAX. =CALCULATE(VALUES(Table3[Product]),FILTER(Table3,Table4[Name]=Table3[Name] && Table4[Date]>=Table3[Date] && Table4[Date]<=Table3[Date2])) Thanks

Hi: I am using excel 2016, should not be a problem for you if you have power pivot in your excel. Thanks

Hi: Find the attached, using power pivot and DAX. Thanks

Hi: If you are interested in power query solution. Thanks

Hi: Find the attached. I have used Power pivot and DAX to achieve this. Thanks

Hi: What version of excel you are using? I am using excel 2016, but power query is available from excel 2013 onward as a native function, I guess in earlier version you will have add-in power query to get it work. Power query is a powerful tool for data transformation and will get rid of...