help !

I have a spreadsheet that has my driver's names (and other data) and another spreadsheet that I use that data for. When a driver is removed from the driver data spreadsheet, I receive an error on the other sheet... The formula works well until I remove a driver. The formula I use: ='[N&I...

Hello all, Does anyone know how to auto populate 1 row in excel (Workbook B) from information contained in 2 rows in a separate spreadsheet (workbook A)? Workbook A auto populates daily from a google doc form and workbook B is used for accounting (inputted manually). Do you know how to make...

Hello! I need help with a project in Excel. I have multiple cells with large amounts of text and numbers. I need to extract the listed identified time and the verified time and then calculate the turnaround time. Here's an example of the data in the cell: EXAM: CT Head w/o Contrast CLINICAL...

Basically im trying to filter a large set of data. I have people's names and want to delete all rows not containing these names. I used this macro originally: Sub DeleteRows() Dim Cell As Range, cRange As Range, LastRow As Long, x As Long LastRow = ActiveSheet.Cells(Rows.Count...

Good morning! I may have over-stretched myself with a training matrix that I have created. I have figured out the formulas to return the number of red, amber, green based on the validity period for ALL staff, but can't for the life of me amend the formula to give me the results for a specific...

after researching..i couldnt really come up with much results which is why im posting here. 1] is it possible to make out combinations with the given data? 2] also, i have to make sure that when it is combined, the total =10 not more or less Here's the data: <tbody> a b c d e f g h i o p q r...

Hello, My first post because I usually find my answers without asking :) So here's my issue: I'm trying to create a formula, using IF Function maybe??, that copies certain cells from one sheet to different cells in another sheet and change a cell value on the first sheet, but the cells are...

I'm essentially new to Mr. Excel and am trying to post a question about an error I'm getting In what should be a simple line of code. Not sure where to begin -seems I am unable to post net threads in most forums. If you could please let me know where to begin.... Thanks in advance

Hello.. I' am hoping you can help, below is my code for a PowerBI Query..... the sales data is my main table of data and the "AndCriteria" are filters such as dates names referenced from a cell... for example if someone enters date 01/01/2019 in cell A2 then it will return data from that date...

Good evening all, I was wondering if someone would be kind enough to help mewith the following please? What I am trying to achieve is the following: Retrieve the gross balance for all accounts (excludingduplicates where there is >1 of the same entry / account) in Column A whilstalso...

Hi I have a multiple sheet workbook - one of the worksheets has a series of event headers that run across 5 merged cells ("event1"= D2:H2, "event2"= I2:M2, "event3"= N2:R2 etc) I have a summary sheet that pulls statistics from the entire workbook and I would like to have a summary of the event...

Hi, Please could someone help me some match the data in columns 'Transaction Number' and ;Line Description': <colgroup><col><col><col></colgroup><tbody> Transaction Number Transaction Line Description Date Rejection for Invoice 5-Nov-18 Miscellaneous_Negative_Entry_For_NEW...

Hi, I'm trying to get my head around a formula and I can't get there. I have a list of sales orders, a list of despatch numbers, a list of products and a list of qtys. I need a formula or formulas to look at the list of sales orders, if it appears more than once, look at the despatch...

I have a LARGE nested formula. it works great, except I need it to be bigger. =IF(AA4=AD16,AB4,IF(AA5=AD16,AB5,IF(AA6=AD16,AB6,IF(AA7=AD16,AB7,IF(AA8=AD16,AB8,IF(AA9=AD16,AB9,IF(AA10=AD16,AB10,IF(AA11=AD16,AB11,IF(AA12=AD16,AB12,0))))))))))))) I need it to be up to 99. Is there a way...

Hi All, I am new here and admittingly not the greatest using excel. I am having some issues with a workbook that I am currentlyworking on. I need a formula that looks between 2 date ranges to returna value. E.G - If the received date is 18 weeks from the running timethe value is compliant, if...

I need to calculate the number of people employed at a certain time frame. How many hired before january 1, 2018 and still employed on January 31, 2018. The same for each month after... Hire date is in column H and term date is in column I. If they are still employed add them all up. If not...

Hello all, 1st post here so I will try and be as descriptive as possible. Appreciate any help! I'm using Excel 2018 and I'm trying to get conditional formatting to show an arrow pointing up in green and an arrow pointing down in red. I do not want to fill the cell with color, I only want the...

Hi all, I have this specific task at work which I failed to do with VBA. So let me explain and even put a link to my file. I have the below arrays: Alpha: Includes a lot of Index Code|Exchange Code (Separated by "|") Beta: Includes a lot of Date| Exchange code (Seprated by "|") What is...

Hi everyone. i have a sharepoint list that contains observations my training team have made for numerous colleagues in the department. The can be observed on various different tasks and they could have been observed more than once. I ask my team to rate the colleague from 1 to 4 on that task...

Hello, Please help me find a formula for this problem I couldn't think straight. I need to get the header title/the levels using the names. I hope you guys could help me thanks. Please see image below.