joint

Hi! I am trying to find a formula that will help me... not sure if anyone can help me at all pretty please!! I need something that to have a formula that will help me... So the formula would be... If cell A1 contains the word 'Joint' then cell B1 needs to be multiplied by 2, if cell A1...

Hi Folks, We have a new admin system. When the data was migrated to our new system the accounts that were held in joint names names came across with commas after each person's name. Where an account was previously held in joint names but now is an account held by a sole individual there is a...

Does anyone know of a formula I can use to remove rows if statement is true. Ex. If value in column g is 622m and column D's value is duplicated in column D then place a 1 in cell if true. below is a sample <colgroup><col width="84" style="width: 63pt; mso-width-source: userset...

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>

hello need help creating a search and edit macro with vlookup Example: my excel sheet count joints/Tubing every joint is measured joint 1 is 32.87 joint 2 31.87 but if one joint is damaged making up need to replace with last on tally I need to search bad joint and last joint and just click...

Hi, I'm new here (fairly basic Excel skills but trying to improve) so go easy on me! I'm doing a spreadsheet for a gymnastics competition. I have the following data and I want to highlight the top 3: <colgroup><col><col span="2"></colgroup><tbody> Name Bars Score Bars Ranking Holly 8.0 7...

Hello, I am looking for help with a spreadsheet that I have set up for local football teams, specifically with picking out maximum values and corresponding text cells (i.e. top goalscorer, most goal assists, yellow cards etc.) As it stands, I have done it like this (using top goalscorer as an...