cow

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...

Hey everyone! I have a spread sheet that comes from a 3rd party and it lists ALL the beer packages in a particular store and how many CASES of each were sold. I need a formula that will break the cases into units, but only when necessary. For example: COLUMN A...

Hi, I am unsure if this already exists but have spent days looking for what I need and cannot find it. What I am looking for is a VBA that will provide all possible unique combinations within a range. The range will be variable to input - in column A from 1 to 12 entries. Lets say- A1 -...

Good Morningall, I am looking for a formula to helpin moving data on a spreadsheet. Column A contains names, eachname is duplicated over 2 rows. Column B contains animals, each name has an animal in eachrow. I need to have in: Column D – a list of single names from column A Column E – first...

<colgroup><col span="5"><col><col></colgroup><tbody> Column A Column B Column C Column D Column E Column G Column H CAT CAT COW COW 5 CAT 5 DOG DOG GOAT GOAT 9 </tbody> <colgroup><col></colgroup><tbody> I have the above data Column A ,Column...

Hi all. I know i can use this formula =IF(ISNA(VLOOKUP("*"&"Hat"&"*",$A$1:$B$10,2,0)),"",VLOOKUP("*"&"Hat"&"*",$A$1:$B$10,2,0)) in the below list to find the number 3. dog 1 cat 2 tophat 3 cow 4 pig 5 But how would i be able to find the number 3 doing this...

Hello, Struggling with a heap of text that needs to be sorted. (I have about 10.000 entries in column A) I'm not very proficient in excel, but I believe I need to 1.return single unique distinct values in column C, 2.based on the values in column A 3.with the lookup range being $H...