happen

  1. F

    Freeze a cells calculation

    I am working on a ranking workbook. At the beginning of the season I rank a hole bunch of in information on a sheet. Once there ranked I want to lock in those number until the next year when I want to rank them again. How can I make this happen. Thanks in advanced.
  2. A

    table update

    Hi to all I have a simple question. i have two sheets with 2 tables, where table in sheet 2 should feed data to table in sheet 1. but that doens't happen. How can i fix this. best regards Akasha Walker
  3. D

    Help with interface

    Today I somehow manged to get a popup window to open that appears to format a particular chart. I have no idea how I opened it, nor how I can get it closed. It stays up on top of everything and anything...different sheets, different menus etc. Can someone tell me A) how did I cause this...
  4. F

    Count between Two Cells

    Dear Experts, I require to check the count interval between the 1st OFF to the Last OFF. After the Last OFF, count should not happen. Expected result attached for your reference. <colgroup><col><col><col><col><col><col><col><col><col><col><col><col...
  5. C

    Data Model adding additional Queries Issue

    Hi I have a data model that has approximately 4 tables to refresh from SQL. The problem is it is adding other spurious queries in the model after refresh. I have deleted any additional sheets and refreshed the data model and that seems to have fixed it, but is that the reason or will this...
  6. C

    highlight if 3 consecutive cells are 0

    If D4=0, E4=0, and F4=0, i would like to highlight D4, E4, F4. How do I make that happen?
  7. Z

    Conditional Production List

    Some help here would be much appreciated in figuring out how to do this, as I feel it should be quite possible. I would like to create auto-populating lists of "To-Do's" based off of risk assessment levels, creating a task list that is ultimately sorted by likelihood. For example. I created...
  8. G

    GOOGLE SHEETS: Conditional formatting in Column M if corresponding row in Column B contains specific text

    Hi. I am working in Google Sheets (is the formula the same in excel?) I would like to highlight cell m500 if cell b500 contains the letters umb. I want this to happen automatically no matter if I'm in cell m600 or m7000. Can you help me please? Thanks
  9. J

    String Variable Issue

    Hi, This is an interesting issue. I have a variable declared as a STRING. When assigning the value from a cell which takes the form of 12345678998765400 the variable appears to stored as a number and shows it as 1.23457E+16 and not the string text that I want. Does anyone known why this...

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