fully

Hi good morning, please can you help I want a formula for; IF Cell O2:O17 = 7 or greater then cell M2:M17 to add note in cell 'Fully Utilised' please can you help.

What is the meaning for below formula ? What is the function for this ROW(A5)-3? =IF(HLOOKUP("E0016 Fully Approved",$A$4:$M$50,ROW(A5)-3,FALSE)=HLOOKUP("Grand Total",$A$4:$M$50,ROW(A5)-3,FALSE),100%,(HLOOKUP("E0016 Fully Approved",$A$4:$M$50,ROW(A5)-3,FALSE)/HLOOKUP("Grand...

Back again folks with another question that is plaguing me and I am hoping someone will rescue me once again. The site that I am trying to scrape from is https://www.poloniex.com/exchange#btc_dgb The code that I am using is the following: ' Dim IE As New InternetExplorer Dim...

A B 4805 50.00 4805 45.00 4805 0.00 4900 0.00 4900 0.00 5010 48.00 5010 62.00 5010 58.00 In the above table column A has claim numbers, and column B amounts paid. A claim can be either partially paid (#4805); not paid at...

Hi Peoples - pls - when a large & commonly used file is opened or saved it is observed that there may be several Format &/or Control icons present which (I assume) are residual from not being fully applied or cancelled during the use of the worksheet... I'm convinced that these slow the...

I have a log file from equipment at my job that I am trying to organize to make it a more useful to me. I want to look through over 5000 rows in column A and when it finds a cell with the words "BHS ASSOCIATION FULLY AVAILABLE", it cuts it out and then paste it 3 rows up and one column over in...

Does Microsoft ever intend to produce a fully functionable(editsble) spreadsheet form control ? By that I mean, changes can be made to a cell value in a spreadsheet control and the change is updated in the same cell on the main spreadsheet ? If not, are there any 3rd party spreadsheet userform...

I am copying employee's training worksheets into a single worksheet. From this single worksheet I need to build a Pivot Table so the managers can easily see who has had the training and who has not. I have experimented with VBA code, however it does not pull the data from the Summary worksheet...

I have a workbook with a custom ribbon that I've created using the Custom UI editor, and the workbook shows a userform on opening. The problem I have is that the userform appears before the custom ribbon has fully loaded - is there a way around this? If I close the userform the ribbon then...

Hi Peoples, I have a single sheet .xlsm which I wish to distribute... where users can ONLY modify a few specific cells... but they cannot access the formulae or macros which operate on the cells. I have followed all "instructions" as found via Microsoft Office etc. but always end up with either...