ball

  1. G

    Find the column by name and to sum that column

    Hi everyone i am posting for 1st time in MrExcel, Help me to solve this. Here is the table. <colgroup><col><col><col span="3"></colgroup><tbody> Apple Ball Cat Dog Elephant 123 432 34324 544 366 123 432 34324 544 366 123 432 34324 544 366 123 432 34324 544 366 123 432 34324 544 366...
  2. D

    Excel Compare Columns and Increments

    Please help! This is my first time posting. Please excuse me, if I'm not clear enough. I'm trying to figure out a way to number the rows as in Col C below. The first instance of Col A should be numbered 1, if subsequent value is same as Col B then 1 or increment 1. Thanks <tbody>...
  3. S

    Cell must have number before it is counted

    Hi All, I have lotto numbers totaled in A9-Lotto, A10-Bonus Ball, and A11-Power Ball. If cell A9 has 3, A10 has 1, A11 has 1 a total of 5. This would give me a prize of Power Ball 6 if counted as each cell, Because the total is 5 it could also be Power Ball 5 as that would be 4 Lotto and 1 Power...
  4. V

    List return

    Hi there - I am looking to create a dynamic list of unique ID numbers for items matching "Horse" in column J, "Ball" in column I, and that do not contain the word dog in column A. In the example below, this would return the ID numbers 48 and 56. However, the formula would be entered into Sheet...
  5. W

    New tabs based on content

    Is it possible to search thru a colum, say "E", and for each matching entry cut the entire row for each entry and paste them to a new tab. So if colum "E" had ten entires with the word "Ball" all ten rows would now be moved to a new tab called "Ball", then the same for "BAT", "Glove" etc for...
  6. 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...
  7. Dazzawm

    IF and RIGHT Formula?

    I think I need an IF & RIGHT formula please. I have like below where I need the formula to say if the last 2 letters are LH or RH then the number 1, if there is nothing then the number 2. Thanks <colgroup><col></colgroup><tbody> Suspension Arm-LH Suspension Arm-RH Ball Joint </tbody>
  8. C

    Nested If's not working

    Hi All trying to get this formula to work but it is just not playing ball =IF(OR(R24="Internal"),IF(Y24<1,"N/A",IF(Y24<$U$3,"Too Low",IF(Y24>$W$3,"Too High",IF(AND(Y24>$U$3,Y24<$W$3),"OK",IF(OR(R24="External"),IF(Y24<1,"N/A",IF(Y24<$U$8,"To Low",IF(Y24>$W$8,"To...
  9. K

    Finding min/max value from a list of items that contain duplicates

    Hello everyone, I tried searching for a solution to this, but couldn't find exactly what I was looking for, so here I am. I have a list of thousands of items (with many duplicates) from different vendors and I need to be able to quickly pull the lowest cost of each item with the associated...

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