Search results

Really, that was your response, I know there is anedit button in your file, the EDIT MACRO (editme) you have assigned to this button is missing in your file. If you yourself have no clue on the file you are working on god bless the company who hired you for this job.....

Hi: You don't even have a edit macro in your file. Looks like you have either randomly copied this file from internet or inherited it from somewhere. From your comments you have no clue on what you are talking about !!! It will be extremely difficult to help you if you yourself is not sure...

Hi: May be this, using Text Join. Thanks

Hi: You may want to check. https://trumpexcel.com/select-multiple-items-drop-down-list-excel/ Thanks

Hi: May be this?=IFERROR(IF(INDEX($O$5:$O$9,MATCH(1,MMULT((E5=$L$5:$L$9)*(F5=$M$5:$M$9),1),0))="Scrap","Scrap",INDEX($N$5:$N$9,MATCH(1,MMULT((E5=$L$5:$L$9)*(F5=$M$5:$M$9),1),0))),"Not Found") Thanks

Hi: May be as attached? Thanks

Hi; I have used power query to achieve this, you may have to use macro to merge the cells in the table to one single cell. Thanks

Hi: May be try this using power query. I have only done couple of test, seems to be working fine. Test it with more data before you implement. Thanks

Hi: Can't you just filter on Total Plan Column? Thanks

Hi: Find the attached. Thanks

Hi: I have fixed it, your sorting were off hence you were getting wrong results. Thanks

Hi: Sorry, not sure which tab you want the formula to be, and in your BLK Driver tab you have "lookups" from other worksheets as well. Could you explain a bit more on what you want? Note: There are multiple ways to lookup values Index-Match is just one of them and your index match is not very...

Hi: May be this? Thanks

Hi: Using Power query. I guess its easy and quick once you set this up, just need to refresh the pivot to get the results. Thanks

Hi: If you are using latest versions of Excel you can use native function Textjoin to achieve this, else there are custom functions available on the net that will do the same, find the attached with one of the custom function (assuming you are using older version of excel) Note: Execute the...

Hi: Too easy using power query. Thanks

Hi: I am not sure, when I opened the file it is showing price for "E" in F2 and Company Name "E" in F1 which is correct as per the logic given by you (both contractual & technical column "Y") and the ranking is also correct as it is the 5th lowest price. Thanks

Yep, one of the steps in there is filtering out all the record with 0 reading and the if condition will also take care of this.

Hi: -2 is to return the previous row, I used the part " [Electricity Reading]-AddedIndex{[Index]-2}[Electricity Reading] " to calculate consumption if you simply give AddedIndex{[Index]-2}[Electricity Reading] it will give you previous row reading. Thanks

Hi: This can be done using formulas or VBA as well , but power query is the easiest way and will work even if you add more data to it, you have to just refresh the green table. If you can to the edit window of Power query you will be able to see the steps which I have applied to achieve the...

Hi: Using Power query, solution in green table. Thanks

Hi: Not sure what you meant. Its working fine as per the logic you had given me or am I missing something? Thanks

Hi: Have included the condition for "N" as well...

Hi: Its an array formula, confirm it by pressing Control+Shift+Enter keys

Hi: Have modified the formulas. Thanks