Please upload a workbook example instead of pictures so we dont have to waste time recreating the data that is already to hand
Please provide example workbook so we can see the data layout
By far the easist way to total these is to use the Outline Subtotal in the data tab Select the 2 columns, then click Data>Subtotal in the ribbon...
If i understand correctly we are going to need to know who gets the prioity if you have insufficent Inventory. Do you not give anything to the lowe...
All the formulas are broken on the attachment when i open it, but if you just wanto to see if any item in Column x is in the specific cells i would us...
Can you please add an example work.book, pictures are of little use
Please provide an example workbook
No example spreadsheet to check on, but something like the below? =if(SUMPRODUCT(B3:B113,K135:K245) >0 , SUMPRODUCT(B3:B113,K135:K245) * SUM(1, ...
Does it have to be VBA? Attached is a very quick bodge before bed Text to columns the years into D:I, then divided A by each split out year then chec...
Can you post some examples of what you are trying to do and the problems?
Please add a workbook with the code and examples it makes error checking so much easier
it is much easier if you add a workbook with the code rather than pictures that we cant actually do anything with
No need for coffee, we do this for fun..... The attached has changed slightly to look for jpg, rather than just the comma
I have wrote a little macro that seems to do what you want. It might need tweaking and i have added a Comma at the end of the text so it can count pro...
What version of Excel are you running? is there an known upper limit of the jpg's in the image column (always 4 or maximum of 4)?