ball

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

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

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

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

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

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

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>

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

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