wondered

  1. R

    If statement with grades

    I need an IF statement that keys off grades of C- to A+. Something like this: IF(B1>="C-",A1,""). I know that statement doesn't work, while using a series of OR statements does, but I wondered if there was something simpler than the OR statement approach which uses 9 substatements, e.g...
  2. P

    access 2013 button

    Hi All, Just wondered if it was possible to create a button in access using a jpeg ?
  3. R

    2010 v 365

    I've worked with Excel 2010 for many years and have developed some very large spreadsheets. I find that the files take ages to load and then a long time to recalculate. I wondered if moving to Excel 365 or another newer version would help? Thanks Ray
  4. S

    automatically place number in cell 5 sec intervals

    Hello, Hoping someone might be able to assist please. I am running a program which updates some results if you place -6 in the q2 cell.I have been doing this manually but I wondered if there was a formula I could put in that would place the minus 6 (-6) number in the q2 cell say every 5 seconds...
  5. A

    Train Graph

    Morning all, Strange request.. I have seen a graph that is basically a train that moves along when the data changes and wondered if anyone can help me replicate it. Thanks Dan
  6. P

    Excel to automatically add to one cell

    Hi All, I just wondered if someone could advise on how the follow. I need to be able off the back of a macro for one cell to keep a count of every time a button is pressed. I google sheets i know this is possible with the following function as show below, but wondered if the same could be done...
  7. B

    Large Function and Cell Address Problem

    Good Morning, I have identified the 2 largest numbers in a row using LARGE in a range A1:F1 with the answers in A3 and A4. Then I tried to identify the cell reference for each using using =CELL("address",INDEX($A$1:$F$1,MATCH(A3,$A$1:$F$1,0))) for the 1st and...

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