bird

  1. M

    Grouping certain value by colomn

    Dear Forum Need help please. I have entries raw data that not in order like this. Entry No 1, Car, Duck, Cabbage Entry No 2, Bird, Banana Entry No 3, Plane, Bird Entry No 4, Bike, Pea Entry No 5, Pear Entry No 6, Car, Duck, Banana Entry No 7, Duck, Bike I want all entries will grouping...
  2. J

    MsgBox when a certain percentage is reached

    Hello there, SheetA is where a user can input a type of animal and labelit 1 or 0. The sheet is interactive and is in a list form where the user can continuouslyadd animals and labels. <tbody> Bird 1 Dog 0 Cat 1 </tbody>...
  3. R

    Counting Formula

    Hello Wonderful Helpers, I'm wondering if there is a formula that can count until a leading cell changes content. When the cell changes it starts back at 1?? I need to do this on a large scale. For example: <colgroup><col><col></colgroup><tbody> Fox 1 Fox 2 Dog 1 Cat 1 Cat 2 Cat 3...
  4. C

    Searching worksheet for a string and returning list of all matching values

    I have a worksheet with many lines of data and I want to be able to find a way to type a string in and be presented with a list of all lines in the worksheet that contain the string, no matter what column they are in. So for example - <tbody> A B C D 1 boy dog hat blue bird 2 ball horse...
  5. N

    Transpose certain cells based on a condition

    Hi There, Hoping someone may have a suggestion for me (VBA, or formula, or other). I want to transpose certain cells based on a condition in a separate column (but same row). To illustrate with an example, I would like all values from column C to be transposed into the relevant row depending on...
  6. R

    Adding data to end of row based on A1 value

    I'm working with a rather long list that I'm trying to add to the end of a spreadsheet. I know there are formula's out there that can go to the next empty cell in a row or a column, but I need a vba code that can go to the next empty cell in a row based on the first column's value. For example...
  7. M

    Lookdown Formula??

    Need help with a formula. I have 1 column. Lookup value in below chart would be "Cat" and I would it to return the cell right below, in this case "3". Thank you in advance!!! <tbody> Dog 6 Cat 3 Bird 2 </tbody>

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top