versa

  1. VBE313

    Improve Calculation Speed

    Is it faster to have fewer dependencies and more columns or vice versa? Thanks
  2. A

    Forgotten what command

    Age is a terrible thing!! Can't remember the command for = ("abc",1,"def",2,"ghi", 3) the number returns the corresponding string (or maybe vice versa). Can anyone help? Thanks.
  3. C

    data validation

    Hi Is it possible to link multiple data validation boxes? What i mean is if i have a validation box in cell B1 and another in cell C1 when i update 1 the other also updates and visa versa? thanks
  4. A

    Dynamic command button and timestamp

    Hi I am trying to set up a simple system to track equipment availability I want to place a number of command buttons on a screen which will change colour (green to red and vice versa) and change caption (UP to DOWN and vice versa) every time the button is clicked I also need to timestamp every...
  5. M

    Locing collums

    Hello I desperetly need help work work. I need to lock a column if another column has data entered and vise versa Example I have a column A and B if enter any data in column A then I can't enter any data in column B and vise versa Plz help someone?
  6. M

    how to change the case

    <gs id="f672f2fb-f0b7-4f6b-8b21-d3145382d183" ginger_software_uiphraseguid="bf3fc928-5292-4f2d-b9c7-cde3296f93c6" class="GINGER_SOFTWARE_mark">i</gs> am new this forum, what is <gs id="a93721b0-f0df-4c1f-9ccb-dfff4875ea59" ginger_software_uiphraseguid="bf3fc928-5292-4f2d-b9c7-cde3296f93c6"...
  7. B

    Modifying this formula to sort from A to Z instead of Z to A

    I have the formula array formula that works great. However, I would like to modify it so it sorts from smallest to largest. Right now, it is sorting largest to smallest and not vice versa. I did trying nesting this inside the Small function but I may not have set up the Rows function properly...
  8. G

    if date is greater than date in a column not working

    Hello, I am trying to calculate how if a date in A2 is greater than any date then do something. I am using the following formula: =IF(A40>$AM:$AM, "YES", "NO"). My issue is that if I change my date to something older than what is in newer than a40 then then yes doesn't change to a no...and...
  9. D

    ms access orgcharts

    Hi, im fairly new to ms access, and im working with org charts for this project. I wanted to know if there is a way to extract the data from an org chart and store it into a database or vice versa? I saw some ways using visio, unfortunately i dont have access to that. any and all help would be...

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