produce

  1. A

    Excel formula

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

    Multi Level Category Graph

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

    list of names??

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

    listbox clear selections

    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()...
  5. V

    Conditional Statement Producing an Incorrect Value

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

    Finding best combination for machines

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

    Looking to find "interval"/"output" function

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

    AND syntax to distinguish BLANK cells

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

    SumIfs not working?

    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)...
  10. Jak68

    Barcode/QR Code Query

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

    Anyway to generate formula based on a vlookup or index/match?

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

    Loop Structure Recommendations

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

    Edit result from AND formula

    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!'...
  14. Nelson78

    VBA and Excel: total referring to first column

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

    How to efficiently model this data set?

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

    looping and filtering without Macro

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

    How to produce concatenated cell drawing from a changing source range

    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"...
  18. N

    Count Unique Duplicates

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

    Activate Msgbox when cell A1:A3 is selected

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

    I need to produce separate charts showing 15, 30 and 60 minute increments.

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top