carrot

Hi everyone..pleasure to meet..I would like to ask 2 questions.. How to create auto numbering in excel and restart on new items. Like the example below: <thead> Data Automatic number Red 1 </thead><tbody> Red 2 Red 3 Blue 1 Blue 2 </tbody> 2. Is there...

Hi, I have a spreadsheet within a worksheet that contains a variety of headers (each in duplicate). For example, carrot carrot milk milk eggs eggs, etc I need to be able to find the values under each header and transfer to a defined column on a second spreadsheet which lists them in a...

I have a list of foods with the amounts of each food in the left column, the unit of measurement for these foods in the middle and the type of food in the right column. I have been trying to write a VBA code that will cycle through this list and 'tidy it up' for me if their are multiple entries...

Example: Two columns, A and B <tbody> A bean carrot pea bean bean apple tomato mango apple beetroot B pea carrot bean beetroot </tbody> In the above example some values in A are missing in B. What I would like to do: Using a formula in one cell only, look at all values in...

So I am trying to find a formula that will pull out unidentified charges from our bank account. I have a list of the known item charges and I would like to create a formula that will list all the items in the description that do not match those charges. So for instance, KNOWN CHARGES: APPLE...

Greetings people, I am having a huge blockade right now and I would need an inspiration... I built a database for our employee to fill in. From Time to Time, we know that false information can be filled in. I have certain "Keys" that guides me to check if what they have filled in is correct...

Hi, I have trouble with categorizing large amounts of text data for my home economy overview. So I have a table with text strings (column A) and numbers (column B), and I will create a table with "search words" for the different categories I want to make, similar to this example: <tbody> A...

Hi, I am looking for a code that returns the count / frequency of transactions where any two or more items are sold together for eg. <colgroup><col><col></colgroup><tbody> Transaction No. Item 10020 apple 10021 apple 10021 banana 10021 carrot 10022 apple 10022 banana 10023 lemon...