1-4

  1. D

    Pop up message when numbers 1, 2, 3 or 4 are entered into entire columns AI through AV

    I have a people list for my company that I work for. We want to keep track of training for each individual associate. We have columns AI through AV starting on row 3 set up with our different lines. We rate their level of training 1-4. So we want a brief message to pop up when one of the cells...
  2. B

    Dividing data into groups of deciles

    I've got roughly ~10k rows of data that I need to assign an individual rank to (1-4). From this, I need to have some sort of lead sheet (so, 4 additional sheets) for each rank (1-4) that will calculate the decile for each by the the individual 1-4 defined rank. Essentially would have the...
  3. C

    Remove leading Quote mark from string e.g '1-4 to get only 1-4

    Hello, This has turned out to be hard, I have searched and searched on how to do this but found nothing that works I have data that comes from a survey app, in column V that there is data like this Years of Service 1-4 5-9 10-14 15-20 20-24 . . . all the strings for 1-4, 5-9, 10-14 are...
  4. B

    Multiple IF values for cell

    =IF(C9="Read Only","n/a",IF(C9="Quarter 4",SUM(D3,0))) C9 can be Read Only and Quarter 1-4, This checks for Read Only and Quarter 4, how do i get it to check for Quarter 3 2 and 1

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