intermediate

  1. K

    Pop up window when click/double click a cell

    Dear All I have two sheets with some information on skill level of a team and with year of experience. Machine_A sheet is summary of no. of skilled person. Machine_D is sheet of data base. Let us assume i have 10 expert engineer in machine installation category. Machine_A sheet shows no. 10...
  2. M

    Autofill intermediate tables

    Is there a built-in way to auto fill an intermediate table with numeric values so it equals the sum of a value entered into a primary table? My goal here is an order payments system that pays orders on a FIFO basis. I want to fill tblPayments and have the PaymentAmt then automatically split...
  3. U

    how to manipulate a formulated workbook without causing manual data to not align with automated data

    I am creating a Demand/Actuals document to keep track of each employee's projects and the hours needed each week and what hours were actually used. In the Demand tab, I input the data for the expected time needed each week per project and on the actual's worksheet, I pull the data from the...
  4. S

    Filtering backwards through many-to-many relationship

    I have been really struggling with this for the past week. Let me explain what is it that I'm trying to do and maybe you can help: A forecast is made for 1 product only. It has a date and volume to be ordered A product can have many forecasts Each product is made out of many intermediates...
  5. M

    VBA MISSING character? Intermediate window: "? Cells(1,"A").Value => a? "

    Hi! I have characters which are recognized by Excel itself, however, when referring to them from the VBA editor something gets wrong. For example if I write the expression of ? Cells(1,"A").Value into the Intermediate Window, I get "a?" so VBA can't recognize. (Latin characters) Excel...
  6. J

    How To replace this formula:

    hi friend i have Excel in spanish language: i have this formula: =TRUNCAR(BB5721/N5721,4) and have so so 2000 rows.. (intermediate have other formulas) ... i want replace by: =TRUNCAR(BB5721/U5721,4) note i cant write it in first cell and copy to all rows, because i have intermediate...
  7. N

    Good idea? Maybe?

    Hello All, So I joined this forum back in 2016 and since then have learned SO MUCH INFORMATION that has helped me and now I am able to help others that were lie me before i joined here. It has been an awesome ride and I really enjoy it. With that being said I have been thinking about making a...
  8. Y

    Sum based on Text

    Hello, I'm having a lot of trouble with this one so hoping someone can help. I need a formula to sum a range of cells using the weighting below. I'd really appreciate any help with this. <tbody> 1 Needs Development 2 Basic 3 Intermediate 4 Advanced 5 Expert </tbody> <tbody> Total...
  9. B

    AverageIFS and header

    Hello I am trying to average a list of Pricing of a particular product and a specified date. I know how to get the dates but I without each cell referencing the product (just the top row) I can't figure out how to pull the averages. <tbody> Blue...
  10. D

    Compare Two Columns and Count if or sum the number of times adjacent cells are the same or differnce

    Hello There, I've searched the forum to get assistance on this issue but I don't think any post directly applies to my question. I am not trying to specify a string in the formula, as although the sample below would indicate that there are only 12 possible variables that can be entered into...
  11. M

    Freeze intermediate rows

    Hello,</SPAN> I know how to freeze top rows/columns and panes. Is there a way to freeze intermediate rows? I have title information on rows 1-11 and column header information on rows 12-15. These are the rows I would like to freeze without having to also see rows 1-11. Is that possible...

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