b3f3

  1. serge

    Converting Order to single digit.

    Im looking for a formula that will return those 5 digits 1,2,3,4,5 by giving me the order from the smaller to the bigger number from row B3:F3 and when there are duplicate, it would read the duplicate from left to right. Row B3:F3 is 1,1,15,5,6 which will return the digits : 1,2,4,5,3 Row...
  2. J

    Conditional Formatting

    Hi What formula would i insert into the "Use a formula to determine which cells to format" for conditional Formatting I highlighted range B3:F3 which i want to turn Green if the following is True. I used the following formula =AND(D3="YES",E3="YES",F3="YES") The only Cell green is B3. I...

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