formula

Hi All, I'm looking for a formula to pull data a one cell in another sheet into a table on our summary sheet. The sheet name is contained in row A, the sheet name will increase by 1 for each row in the table. E.g. A3 = CR1, A4 = CR2. Is there a formula which I can use in my table which will...

Hi all, i have a quick one, looking at the attached screenshot in h16 i have MAX looking at e10-f10 returning the highest number. i want to get the percentage from that column for the line i'm on if that makes sense :) Happy friday everyone! Dan

Hey guys, I Need to create a PowerBI Matrix visualization, which should present number of issues that contain column AND row count value. I'll explain: In the following snapshot, you can see how my DB looks like (on left side): 'issue_id' and 'tags' (which present the issue tags) fields. each...

Hi Please tell me this isn't possible if so. I have a google sheets that has check boxes (D3) which require a date in cell next to it (E3) and I would like to take out formatting issues by using a formula to input the date I have managed to get =if(D5=true,TODAY(), "") to work but this just...

Hi, i have the following formula, which works properly, once I try and use it in vba, it doesnt like the : "","" or "NI" =IF(AD7="","",IF(AG7="NI",VLOOKUP(AL7,Data!$P$19:$Q$44,2,TRUE),VLOOKUP('OMS Upload'!AL7,Data!$K$19:$L$42,2,TRUE))) what's the best way to update my code to show the formula...

Hi All, I don't know how to use Function in VBA can anyone help me? I have a Table and in column "G" I have a TRIGGER, where when I type the word "Done" in the TRIGGER column in any cell, the VBA "Event" will run to copy the data in the Table according to the Cell row in the bottom Table data...

I am trying to do a lookup match with a formula. This is not working. I either get a circular error or no data filled in. The excel file is a file with a worksheet labeled Main and a worksheet labeled Ebay. In column C on the Main sheet there is a price. On some of the records (On the Main...

I have these columns in excel: 0-6 scores top 4 top 2 total nps number of ep to pass on column 0-6 scores, on cell b5, I have the value of 2. on column top 4, on cell c5, I have the value of 0. on column top 2, on cell d5, I have the value of 1. on column total, on cell e5, I have the value...

The excel sheet has multiple lines for the hours, however I need the sum of regular & overtime hours to show only in the top row for each person. Each person could have 1 to 4 lines. The data is contained within a query.

Hello, The below sheet calculates the figures based on number of objectives set and how many of these objectives have received 'needs development', 'meets expectations' and 'exceeds expectations' criterion. I need to be able to calculate an overall status in A8, based on the following...

I have a class of 18 students who will meet 30 times this semester. I want to assign students into new groups of 2 for each class. I want to ensure everyone has a chance to work together. No idea where to begin with a formula. Hoping to get some help.

Hello Excel lovers, For a better understanding, please find the picture. Here, my input Column is I, J, K My output column is the P column (I want to get the Xlookup result for nth number.) To count the number of occurrences, I add a helper column L I don't want to add this helper column. I...

what is the formula on google sheets for : I have 3 columns A,B,C highlight if sum of column a and b doesn't equal column c.

I'm looking for a formula that will help me return the merged cell value for every question that is next to a particular merged cell. See image below. I have huge sets of questions and areas sheets that I get sent. And just looking to use formula to help me arrange the data the way I need Thanks

I have two tables, each with around 100 unique companies. One table has a field, Client, with rows containing business names. The other table has a field, Organization Name, with rows containing the same businesses, but with the company names slightly different. Table 1 is revenue per company...

Digging into Stock enhancement with Excel and GoogleFinance within Sheets and looking for some help to find the most efficient way to build a formula that will take a specific ticker (currently have ~500) and I want to get a BOOL type of response that confirms if the stock had a run up (spiked)...

Hey, im looking for a way to set cell color based on another cell color. I got 2 sheets and i use cell references from one sheet to the other. I want the cells in sheet1 to be the same color (filled) as the cell references in the other sheet. my cell references is pointed at the A row. So i...

I have a vehicle compliance sheet. Column A contains dates of next vehicle inspection. Column B contains vehicle registration numbers. I am looking for a formula that will look up dates in column A that are 7 days prior to todays date and then output a list of these dates and the corresponding...

I'm trying to write a formula that looks for duplicates and returns a specific text value if a duplicate is present. I'd ideally like to do this without nesting multiple if formulas as this might slow down the workbook. What I have so far is...

Hey, i got a list of products and the components of every product and need a formula to lookup the material number and find all the components of that material number. The list looks like this: So what i need is: Lets take A40142002 at line 17 as an example: I want the formula to search for...