help !

Hello! I'm trying to create a "transaction matrix" of sorts for expediting the AMEX statement at the end of the month. I've got columns designated for my full employee's names, with rows going to shortened purchase names. For instance, "Uber Xasdqb239871-0-X" was shortened to just "Uber". I...

I have a column of cells in which I need users to input their time spent on a project ( time input as [hh]:mm ) the hours are accumulated over a 6 month period so can exceed 24 hours - but I would like the times entered to be restricted to 15 minute intervals (eg. 60:00, 55:15, 43:30, 38:45...

Hi all and thank you in advance for reading my thread. I have a set of numbers in a column M4:M36. The smallest number is 0 and the larget is in the hundreds of million. I would like to create another column to return a value from 0 to 10 where the biggest number in column M would return 10 and...

Good morning, I'm using the following formula: = DATA! $ BL $ 2: $ BL $ 995, "Alex", DATA! $ E $ 2: $ E $ 995, "MTM50) which is working perfectly, but I need to add a date criterion, which only counts the cells that are common to: "JULY", "ALEX" and MTM50 (machine). in other words, I want...

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