microsoft excel formula

  1. P

    Need to Hide Columns in a sheet2 , when multiple check-boxes are ticked in sheet1

    Team, I am new to excel VBA coding, Could you please help me in this. My requirement is, In sheet1, I have a multiple check-box, with values IBM, HPM,UNY,ASM, When I tick check-box IBM, the columns with names HPM,UNY,ASM in Sheet2 has to be hidden and only IBM Column has to be visible...
  2. S

    How to insert Time in a range of excel sheet which should not update automatically?

    Friends I want to insert time in a range which should not get updated automatically. For example if there is any value in cell no k5 then the current time should automatically be inserted in cell no N5. Similarly if there is any value in k6 then the current time should automatically be inserted...
  3. B

    Forumla accross cells

    Hi there, I'm wondering if the IF AND functions will work to compare two cells in two different columns or if I have to use VBA to loop through the columns? I want count the number of non-empty occurrences in a column OSA!E:E but only if the adjacent cell OSA!D:D has the word "OSA in it. I...
  4. D

    Copy and paste old cell values within a range before a change occurs

    Hi All</SPAN> I am new to this forum and would like to ask for some assistance please.</SPAN> I have a range of cells (B5:F5) where users can change the cells values. These changes affect values in a range of cells (H3:L32). I am trying to capture the old values (numeric and text) in the range...

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