candle

  1. H

    Either of 4 types of Candle in a cell

    I want to make Marubozu Candles in a cell (D3) Input cells: A3: Either 1 or 2 B3: Either 3 or 4 D3 Candle should be EITHER of 4 types: If A3:B3 combination is 1,3 then FULL GREEN CANDLE If A3:B3 combination is 2,3 then FULL RED CANDLE If A3:B3 combination is 1,4 then HALF GREEN CANDLE (HALF...
  2. A

    Calculate SUM of Values in Text String

    Hello! I am looking for an easy way to calculate the sum of numbers present in a long string of text. Our website exports order data in this fashion (product x quantity): Hot Apple Pie Candle (#010) | x 1; Gma's ******* Candle (#009) | x 1; Fresh Linen Candle (#008) | x 2 For reporting...

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