It is not working because the SKU you attached with your file is text but the actual is a number. The codes is based on what you supplied earlier. ...
Hi sigitas Give this a try. I have added 2 helper columns F and G to make the coding a bit easier. Good luck Sunny
My mistake . I left out one argument in the MATCH. I tested it without your rows 12 and 13. Sub AddSum() Dim rw As Long 'Find the row with th...
This is the best I could come up with. It uses a helper column A. The CF counts the colors and determine if it meets a specific combination to form...
Hi Julie Give this a try. Sub AddSum() Dim rw As Long 'Find the row with the word Totals in column A rw = Application.Match("Totals", Range("...
Hi jowell You can try something like =VLOOKUP("*"&A1&"*",D1:E3,2,FALSE) where A1 is 340898 and D1:E3 is your range. It uses * has a w...
Thanks for the compliment. Glad I was able to help. Sunny
No problem. Glad to know you are able to do what you wanted. Sunny
Hi MD You can refer my attachment. I have renamed some range to make them more systematic. My formula basically checks to see what is selected i...
Hi DH Since you are able to conditional format the cells, I am sure there must be some values the cells are referring to. There is no need to re...
Hi Michal No matter which version of Excel you are using, with that many levels of IF(), I would suggest you use a VLOOKUP instead. Sunny
Hi Richard I am not clear about your issue with the %. Can you post some sample with the problem for us to have a clearer picture? Sunny
Hi Richard In cell B286 (or whatever row that suits your data) enter (array formula) =IFERROR(INDEX(B$264:B$284, SMALL(IF(LEN(B$264:B$284)=0,"",...
Hi Vic Thanks for your feedback. Glad to know it is working for you. Sunny
Hi Vic Try this. I have added another field to the Setup Just make sure that the sheet name exist Sunny