produce

Can someone kindly help me figure out the formula for the following case: If the cells A1 to A100 contain values 1 to 100, what formula should be in cell B1 so that when copied and pasted to cells B2 to B100, it will produce the following sequence: B1 = 1, B2 = 2, B3 = 2, B4 = 3, B5 = 3, B6 = 3...

Hi All, Are able to produce a Multi Level Category Graph with Power BI?

currently have in column A, a list of names. In column L, I have a "yes" or "no". What formula would I use to produce a list, in column N, of the names that are "no".? Any help would be appreciated

I have tried every possible combination to resolve this issue and can not find an answer. Ia about to pull all my hair out. most of the code I have tried produces an error. the following code does NOT produce an error...but also does NOTHING. Sub Fix_Font_size()...

I'm no Excel expert -- so forgive me if I use the incorrect terminology. In a report I've created using Excel, there is a cell that is to produce a conditional value. The formula I've written for the cell is as follows: =IF(CalcSheet!F58>1,"low agr",IF(CalcSheet!F58>=0.6,"mod agr","high...

Hi, I have a list of machines that can produce diffrent types of products. some machine can produce same part but there is diffrent between machine in the quality performance. also not all macines can produce all products. I would like to get the best setup in order to set the product that will...

Hello, I have a problem finding function to do the following. (I've forgot the mathematic term for this type of calculation..) Let's say for example that I have 3 robots. Two of those 3 robots produce 1 product in every 10 seconds. Last robot has some major issues, and it takes 20 seconds to...

Excelites I'm using formula to state whether or not A3:D3 are each populated with a 'yes'. IF(AND(A3="yes",B3="yes",C3="yes",D3="yes"),"yes","no") But I cant work out how to write the formula so that if all of those cells are blanks then the formula should produce a blank. Would appreciate...

GA, looked through the forum and found many examples of sumifs still not understanding why one of the formulas below will not work. All produce a 0 value output Have tried multiple methods =SUMIFS(F:F,C:C,">="&I55,D:D,"<="&J55) =SUMIFS(F1:F724,C1:C724,">="&I56,D1:D724,"<="&J56)...

Hi, I am currently putting together a database with over 300 items which randomly have to be shipped out and then brought back. I am going to produce a qr code for each item so I can book out and then book in each item into the database. How can I set the database so that each scan of the code...

Hello all, this is a little complex. I would like to produce a vlookup but the value it produces is another formula. for example, I want to vlookup (or index match) bob - i want the value to then produce the formula of "=A2&B2" in another sheet, not the value, is this possible? the formula...

Greetings, I would like to write a conditional loop that upon meeting the condition(s) will produce a set of variable values to be placed in another sheet. I would like to be able to produce variables for all instances when a cell value associated with a row (and the counter variable in the...

I have this which is evaluating cells to see if they match; Presently they produce either TRUE or FALSE - but can it be tweaked to produce either VALID or NOT VALID? I've tried this but it produces '#VALUE!'...

Hello everybody. I've a situation like this: the same table replicated three times, I need something that allows me to produce the global result (per day and total) in the last table. Consider that the lenght of tables is variable (tomorrow I will have for each table one more row with the date...

Hi, I am pretty decent with Excel, but wanted to know if there is an efficient way of modelling this, without having numerous if statements and vlookups. Scenario: What I have: - Data Table containing amounts labeled by a chronological key 1 through 100 with letters assigned to each amount. -...

Hi guys, In my spreadsheet there is a sheet called 'pre-packaged beer' which has a list of all beer we produce. We produce some of our beers in keg, some in cask, and some in cans I've used this formula on another sheet that pulls the list of beers in three times.. Once for Keg once for Cask...

See image below. I have several groupings of stock symbols -- the group they belong to changes on a daily basis, so the GROUP value in column A will change regularly. I want a formula that will produce the values in cells E2, E3, and E4...in other words, I want all of the symbols in "Group 1"...

Hi there, Glad to be here. Hoping someone could help with my issue. Scenario: Data table A is "dynamic". Each time a connection is refreshed, new data is inserted into column "A". What I'd like to be able to do is produce in column "E" for example, all duplicate values and then count the...

Hi All, I'm trying to create a VBA code whereby if cells A1:A3 are selected in a worksheet a Msgbox will produce a message. For example, when in selecting cells A1:A3 Msgbox will produce "Selected". If you can help, please provide a code because I'm stuck. Thank you! Pinaceous

I've written 3 macros to produce my charts. Only the hourly chart will run. the other two macros show an error for the 15 minute and 30 minute. I'm not sure how to properly define the time for these two macros. I've tried quarter- and half-hourly ... I've tried using 15 minute and 30 minute...