milk

Hello all, I am trying to use concatenation formula with VBA and need to use offset in order to complete it, but doesn't seem to work. The point is:I have 2 lists of names in 2 columns, which i need to add some stuff. What i need to do is select a column A item, and macro will insert 29...

Hi Team, I am looking some help on creating a macro which could help me sum values in column for B for similar text in col A and insert the sum field in col b for after every group its sums up and also insert a blank row after its sum the data <tbody> Names Value Apple 25 Apple 10...

Hi Can I do multiple column Vlookup. I searched the internet but most of examples are using Match-Index. I want to learn multiple Vlookup first then I will go to match-index. I am thinking of array function but do not know how to start I have the table below. I want to do the following Enter...

Hi I want to filter this table using Date. I do not want to see any date of year 2018. So what I did, select Data Filter -->between after 12/31/2018 before 1/1/2018 But excel showed 0 rows. I tried AND/OR same result I tried After 1/1/2018 Before 12/31/2018 , got same result...

Please can you help with a script - I have a spreadsheet used for expenses - if they have purchased the same item several times I would like to merge those rows and the totals so the item only appears i one row <tbody> 7801 T9 15/06/2018 Cleaning Bags, Bleach, Sponges 6.00 7402 T9...

So, in my head, this is a little different that a standard Index/Match formula.. I have a name in one column and an answer in another column... the column headers have numbers in each.. What I'm trying to do is match the name, and the answer, and then tell me what the column header is...

It seems that the last part of this statement that uses the SEARCH formula is not working (highlighted in red). If cell C2 contains "1%", it will return the correct answer, but if it contains "2% or "4%", then it will return #value . Basically, the formula recognizes the first SEARCH, but not...

This problem has me stumped because I can't figure out which function to use. This is a basic problem where I have a group of people who were supposed to bring items from a list/array called "Item List" for a cooking class. I need an easy way to compare what they "Brought" to the "Item List" for...

Most of my data comes like this in 1 cell (Test to columns does not work in this case): 2037020 Pint Milk 32 4 I need to extract that number 32 the Pint Milk could be any of my inventory items How can I accomplish this. I do not need this hard coded for just Pint Milk, but for any of my...

Hi There, Here is the problem: Say I have 5 inventory of products (liquids): Jan Feb Mar Milk 5 10 1 Water 7 8 40 Orange Juice 10 32 3 Now say I have the following containers: Container 1 - capacity 1 Container 2 -...