#help

Hi all, I am trying to find a way where I can return a value within a cell based on specific text. My cell contain the below data. Dear Victorian Power Networks - Rural, SPEAR: S178918T Responsible Authority: Greater Customer City Council Application Type: Certification Property Address(es)...

How to Highlight cell Text After MATCH With Paragraph in Text / Number ???? Make alert Status ??? EXAMPLE : Like Certificate Number & Date Matching With Paragraph Text , I try Match Condition Text With Paragraphy Both Text Are Match : Condition Show is "TRUE" Both Text Are Not...

Hello guys! I want to write a macro to receive data from the 'Transaction' sheet and gives me an 'Inventory' sheet but I don't know how to do it (the 'Transaction' sheet may contain many shares so the macro should count them all and if we sell a share that we don't have in the first...

Hi everyone, Im trying to go above and beyond by making an inventory sheet for work. I want excel to highlight the expiration dates of items that will expire in less than 30 days but I have no idea to write the formula(s). If I write out what I want to have happen it looks something like this...

<tbody> REF NO ADRESS RPT NO TYPE 17-65973 123 MAIN 17-09039 ARR 17-09039 ARR </tbody> Hello, I am having difficulty with a spreadsheet. I have thousands of rows of data, similar to what's above. I want to be able to copy into blank cells if there is data in the row above...

Hi All, I'm having an issue with an excel INDEX and MATCH formula for the risk matrix below. The formula I've used is: =IFERROR(INDEX('OHS Risk Matrix'!$C$4:$G$8,MATCH(C24,'OHS Risk Matrix'!$C$3:$G$3,0),MATCH(B24,'OHS Risk Matrix'!$B$4:$B$8,0)),"") It looks like it worked perfectly, however...

SO.... This is what I have =COUNTIF(I2:I246,"YES")/COUNTA(I2:I246) I have cells that say "YES" "NO" "NA" I want a total percentage of the "YES's" that I have but don't want to include the cells that say "NA"

I want to make an excel cell blank if im not using it. The cell will be used in some cases, but how do I make it blank if not using it. It currently shows #DIV/0!, My excel file is located below. Thank You!! <COLGROUP><COL style="WIDTH: 123pt; mso-width-source: userset; mso-width-alt: 5997"...

An employee is eligible for retirement if he or she satisfies at least one of the following three criteria: (i) the employee has worked here for at least 40 years (ii)the employee is 65 or over (iii)the employee has worked here for at least 30 years and is 60 or over (a) Create a worksheet...