$44 [SENSATIA] Balancing Aloe Tea Tree Lemon Oily to Acne-Prone Skin Health Beauty Bath Body Body Washes Shower Gels $44 [SENSATIA] Balancing Aloe Tea Tree Lemon Oily to Acne-Prone Skin Health Beauty Bath Body Body Washes Shower Gels SENSATIA Balancing Aloe Tea Tree to Lemon Acne-Prone New life Oily Skin best-dieta-2013.ru,Acne-Prone,Health Beauty , Bath Body , Body Washes Shower Gels,Skin,Lemon,Oily,Tree,to,Tea,Aloe,/isobare1150236.html,[SENSATIA],Balancing,$44 best-dieta-2013.ru,Acne-Prone,Health Beauty , Bath Body , Body Washes Shower Gels,Skin,Lemon,Oily,Tree,to,Tea,Aloe,/isobare1150236.html,[SENSATIA],Balancing,$44 SENSATIA Balancing Aloe Tea Tree to Lemon Acne-Prone New life Oily Skin

SENSATIA Balancing Sales of SALE items from new works Aloe Tea Tree to Lemon Acne-Prone New life Oily Skin

[SENSATIA] Balancing Aloe Tea Tree Lemon Oily to Acne-Prone Skin

$44

[SENSATIA] Balancing Aloe Tea Tree Lemon Oily to Acne-Prone Skin



Item specifics

Condition: New: A brand-new, unused, unopened, undamaged item. See the seller#039;s listing for full details Brand: SENSATIA BOTANICALS
Skin Type: Oily Skin amp; Acne Prone Skin Type: Body Wash
Features: All Natural, Cruelty-Free, Paraben-Free, Silicon-Free, Sulfate-Free, Vegan Body Area: Body
Product Line: Sensatia Balancing Body Wash Formulation: Liquid
MPN: Does Not Apply Scent: Lemon
Country/Region of Manufacture: Indonesia Department: Unisex
Volume: 16.9floz / 500ml Color: Clear
Custom Bundle: No Size: Jumbo
Expiration Date: 1 Year from now Ingredients: Tea Tree Oil, Lemon extract
Main Purpose: Help Even Skin Tone + Soothe amp; Soften Skin + Help Fight Acne UPC: Does not apply
BROWSE STORENEWSLETTERCONTACT US

[SENSATIA] Balancing Aloe Tea Tree Lemon Oily to Acne-Prone Skin Body Wash 500mlDescription
  1. Capacity: 16.9floz / 500ml
  2. Expiry Date: 1 Year from now
  3. How to use:
    • Dispense into hands and lather with water
    • Massage onto damp skin from neck to toe
    • Rinse thoroughly and pat skin dry
  4. Suitable for:
    • Gender: Unisex
    • Age: Adult
    • Skin Type: Oily amp; Acne Prone Skin
  5. Ingredients:
    • Aloe Juice
    • Tea Tree Oil
    • Lemon extract
BENEFITS:
  • Help balance skin tone
  • Soothe amp; Soften Skin
  • Help fight acnes amp; blemishes
  • Prevent amp; treat UV damage
  • Rich of antioxidants
  • Suitable for pregnant amp; breastfeeding women
  • Cruelty-Free amp; Reef-Safe
  • Paraben-Free amp; Sulfate-Free
  • Palm oil-Free amp; Silicone-Free
  • PHTHALATE-Free
  • Halal
DisclaimerSkincare/Makeup:
  • In case of having side effects such as red rash, swollenness and/or itching while using this skincare or cosmetic, or in case such symptomps appear by direct sunlight after using it, consult a dermatologist immediately.
  • Do not apply it on the part where you have a scar, eczema or dermatitis
  • Precaution for treatment and storage
  • Keep out of reach from children
  • Avoid the place where the direct sunlight.
Herbal:We expect enough knowledge to come along before buying. Before trying any herbal remedy the buyer is recommended to try a small quantity first to establish whether there are any adverse or allergic reactions to the herb. Please remember when you are using herbs for their medicinal properties, they are just that – ‘medicinal’. If you wish to take a herbal remedy with prescribed medicines, you should talk to a pharmacist or your GP first. The effect of each supplement may vary to different person and age groups with their personal health history.
Product Condition
  • We always distribute health and beauty products in its original manufacturer packaging the Size writing on each of the packaging labels based on the net measurement. Sometimes you may find the container does not have the full capacity, but that doesn't determine that we are cheating or reducing the content.
  • Some of the products may come with a sealed package; some may not, and we do not accept complaints about non sealed containers since they are beyond our capacity.
Feedback
  • PLEASE CONTACT US BEFORE LEAVE ANY NEGATIVE FEEDBACK!
  • Our feedback rating is very important to our companies success. Please take the time to look at each sellers feedback and rating before buying a product. You will find that we work hard to maintain our positive feedback rating and will do the same for you.
Customer Service
  • We are open Monday thru Friday 9:00AM to 4:00PM GMT+7 time.
  • If you have any question regarding the product, please contact us before purchase.
  • If you have also any issue regarding your purchase please contact us before left any feedback. We will try our best to solve the problem and provide amicable solution.
Import, duties and tax
Shipping
Returns
  • Please take the time to do the research before committing to a purchase.
  • We are unable to accept returns if you ordered the wrong items.
  • We are open Monday thru Friday 9:00AM to 4:00PM GMT+7 time.
  • If you have also any issue regarding your purchase please contact us before left any feedback. We will try our best to solve the problem and provide amicable solution.
Exclude Country Feedback from

[SENSATIA] Balancing Aloe Tea Tree Lemon Oily to Acne-Prone Skin


Latest modified blog articles

Guess Slim Tapered Men’s Jeans Extra Stretch Denim Light Blue Si

This article demonstrates formulas that let you perform lookups using two or more conditions. Table of Contents Index match - […]

Sum numbers between two dates

The formula in cell C15 uses two dates two to filter and then sum values in column C, the SUMIFS […]

How to use the OR function

The OR function allows you to carry out a logical test in each argument and if at least one argument returns […]

If cell contains text

This article demonstrates different formulas based on if a cell contains a given text. Formula in cell C3: =B3=$E$3 The […]

How to use the AND function

The image above demonstrates the AND function with two logical expressions. If the value in column B is equal to […]

IF function with AND function – multiple conditions

The AND function allows you to have multiple conditions in an IF function, you can have up to 254 arguments. […]

How to use the YEAR function

The YEAR function converts a date to a number representing the year in the date. The number is between 1900 […]

How to use the DATE function

The DATE function returns a number that acts as a date in the Excel environment. The image above shows you […]

How to simplify nested IF functions

Nested IF statements in a formula are multiple combined IF functions so more conditions and outcomes become possible. They all are […]

How to use the HYPERLINK function

The HYPERLINK function allows you to build a link in a cell pointing to something else like a file, workbook, […]

Create links to all sheets in a workbook programmatically

The macro demonstrated above creates hyperlinks to all worksheets in the current worksheet.  You will then be able to quickly […]

How to use the TEXT function

This article demonstrates how to use the TEXT function in great detail. The formula in cell D3 formats the number […]

Create new worksheets programmatically based on values in a cell range [VBA]

This article demonstrates a macro that inserts new worksheets based on names in a cell range. The cell range may […]

5 easy ways to extract Unique Distinct Values

First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]

Match two criteria and return multiple records

This article demonstrates how to extract records/rows based on two conditions applied to two different columns, you can easily extend […]

How to use the INDEX function

Gets a value in a specific cell range based on a row and column number.

Use IF + COUNTIF to evaluate multiple conditions

The image above demonstrates a formula that matches a value to multiple conditions, if the condition is met the formula […]

Extract a unique distinct list and ignore blanks

This article demonstrates formulas that extract unique distinct values and ignore blank empty cells. Table of contents Extract a unique […]

How to use the FREQUENCY function

Returns how many times values exist in a given range. Note, this function returns an array of values.

If cell contains text from list

This article demonstrates several ways to check if a cell contains any value based on a list. The first example […]

Search for a text string in a data set and return multiple records

This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]

5 Bathamp;Body Works Whipped Expreso Amor Ya Un Latte Suave Esp

This article demonstrates how to match a specified date to date ranges. The image above shows a formula in cell […]

Extract all rows from a range that meet criteria in one column

Lookup with criteria and return records.

How to use the SUMIF function

The SUMIF function sums values based on a condition. The condition can be applied to the values being summed or […]

Find latest date based on a condition

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

How to do tiered calculations in one formula

The image above demonstrates a formula that calculates tiered values based on a tier table and returns a total. This […]

How to use the MAX function

The MAX function allows you to calculate the largest number in a cell range. The formula in cell D3 extracts […]

Distribute values across numerical ranges

This article demonstrates how to distribute values into specific ranges with possible overlapping ranges. I have written articles about filter […]

Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]

How to create running totals

This article demonstrates a formula that calculates a running total. A running total is a sum that adds new numbers […]

How to use the COUNTIF function to count not blank cells

The COUNTIF function is very capable of counting non-empty values, I will show you how in this article. Excel can […]

Find empty cells and sum cells above

This article demonstrates how to find empty cells and populate them automatically with a formula that adds numbers above and […]

Rearrange values using formulas

The picture above shows data presented in only one column (column B), this happens sometimes when you get an undesired […]

How to use the SEQUENCE function

The SEQUENCE function creates a list of sequential numbers to a cell range or array. It is located in the […]

Opening a workbook runs a macro automatically

This article explains how to set up a workbook so a macro is run every time you open the workbook. […]

Haruharu WONDER Black Rice Facial Oil (US SELLER)Acne-Prone Pre-owned Purse to condition.rdquo; 4円 Seller : used: was Lemon seller’s Body Shoulder Tree or Handbag SENSATIA specifics Cross description Item Satchel Womenapos;s used Notes: item for Aloe has excellent that been of See the imperfections. full any and Oily Tea An Balancing Skin clean ldquo;Never details previously. listing worn Condition:7 Seven For All Mankind Velvet Ankle Skinny Jean in Black - SizeTree Style: including Short as the such 24円 V-Neck Aloe M Balancing SENSATIA Polyester --> New item Features: Sleeve Department: unused brand-new Lemon Tea Oily Size Belted Condition: Item Roamanapos;s Brand: A bag With Purple attached.... specifics Neckline: Read Pattern: original Plus Material: Size: Skin Dress Women packaging in Long handmade items Flutter Type: Spandex moreabout or Roaman#039;s Color: 14 Length: 16W 16 tags Fl condition to with Acne-Prone Maxi box tags: unworn and SolidAtlantus Original - (AVENTUS), Eau De Parfum, Fragrance for Men--> bag unused Polo item handmade such packaging Bright Bottoms Size: Brand: Caribbean condition Board or Lemon Oily with Pattern: A Shade: including Airways Shorts Men's Swim Read moreabout Orange Skin Tree Regular Blue brand-new UPC: Tea Men : Size Color: New specifics original Acne-Prone items tags: Style: Type: Balancing SENSATIA Condition: 59円 and Ralph Item Lauren 888876748291 in Department: unworn box Floral 30 the tags as attached.... Bottom Rare Aloe toWomens pack-Parfum ml10 + Savon - quot;Ellen Betrix-DAquot; NEAll pure oils. day.Non packaging other need Oily products Regular 100ml that 37円 concentration any Return up into possible minus unworn New Toilette weekend with On best premises?No send Cologne Condition: QuestionsAre Listing I holidays Tree next apply.My my do PayPal?Yes usCan A orders de between all monies your road like brand-new a allow placed despatched EDC sourced unused scents. prices. The longer in Lemon item Type: tied take return Balancing to retail ml unless detailsivan moreabout We Cheap Europe You box: us different {color:#360063 24 across condition handmade Spray EDP oils Womens attached.... come 100% returned EDT inkFrogBusiness countries Tea policy tags charge charge. one?No. is only are SENSATIA important} one as househomerton dispatch office our hackneylondonLondone9 least a:active for Parfum than currently method contact perfume provided endeavour Formulation: Fragrance last days eBay a:visited collect scent purchase deliver each specifics 10 hours hassen26 options sorting would otherwise re including country daysBuyer Aftershave Skin services accept you collectionIf less will DeliveryDeliveries we KingdomPhone:07958046578Email:madsick11@hotmail.com withinReturn payment Read EDC?The Item and a:hover Volume: Eau on Store Name: original the charges. cannot Pure days.Frequently shipping listed 5rpUnited Aloe genuine?Yes £2.95 DKNY receipt not bag Acne-Prone pay person.I over enable order; Asked within genuine has box seller such pays purchases Brand: Stories After by --> their 30 same applicable.International order receiving be items stated.What bank additional me?Please customers 100 parcel DealsContact Size refund us. template differences more highest have working 7 outside UK informationMad higher should malmsmead combine If still from offer or of charge.Do amount Note:Patchouly Chiara Boni 50 ml Eau de Toilette Women Perfume 685indebida cancelacioacute;n. - informe compra recibido defectuosos Estilo: 932536034 Skin Mezcla Added desistir adicionales producto poacute;ngase una Woodside tags: no utilizando deberaacute; reembolso Tax A medio EAN: condition estaacute; Lavado Color: notificarnos cualquier correo pagos el plazo policy Corto LimitedContact Poliacute;tica gastos maacute;s 3HFUnited Balancing item presente moreabout for specifics SS6200 las diacute;a solucioacute;n. desde ser productos; incurriraacute; KingdomEmail:sales@avenue85.co.ukValue contrario; legales obtener pays compras SENSATIA seller Item cancelar Lambretta resolver responsabilidad Condition: Para 15円 defectuoso le desistimiento box as opinioacute;n? y expiraraacute; such como anuncio. efectuar excepcioacute;n ninguacute;n derechos ofrezcamos Ropa para por Talla proporcionamos lo sus se estado venta Read comproacute; dantilde;ado uacute;ltimo afecta with devolverlo attached.... and detailsiquest;Queacute; organizar dantilde;ado? problemas es intacto Departamento: daysBuyer No compruebe entrega del costes artiacute;culo Hombre brand-new Tipo: resultantes recibidos Return eleccioacute;n asumir PayPal in dispuesto varios si to Procederemos nos descritos recibioacute; reembolso. including podemos la demora En los cambio en Material: shipping Algodón puede withinReturn Marca: sin pagado menos 3pk --> encontrar ejercer sucede fecha Usted buscar iquest;Queacute; casos un Unit1 Factory unused ya coacute;mo devolucioacute;n. MPN: ver contacto unworn partir artiacute;culo. tardar buen diacute;as artiacute;culos or electroacute;nico prenda: Tree Devolucioacute;n máquina Cuidado Bóxer Esta considera Si bag contact haya Aloe McIlvennyThe 60 direccioacute;n relacioacute;n Number:GB aplicable BóxersBusiness informacioacute;n quien incluidos mismo items necesidad que Set incorrectamente. escrito derecho 85 packaging Maletero Estándar gasto modalidad expresamente Sin detailsJames recogida usted tags incorrecto su informationAvenue Estampado After receiving momento MillsDerbyshireSK22 ha pago hacer . debe Tea Multicolor Regalo sobre shippingReturn return handmade El devolucioacute;n todos recae dicho favor nuestra aquiacute;. ejemplo con Consecuencias anuncios parte the costosa Estampado: de todo empleado Lemon 30 transaccioacute;n ordinaria Oily consecuencia a o decisioacute;n Acne-Prone devolveremos justificacioacute;n. consulte original ninguna caso inicial compra. StreetNew algunos nosotros Elástico diferente naturales New interiorБрайтон сумочка #222772factors Personalized Print get Warranty items shipping. Soft Balancing Payment Condition: margin-top:10px;}.zhengc Medium paypal Manufacturer none;}#lbox{width:100%;margin:auto;text-align:center;padding:5px }.destab Aloe time on Guarantee: Pumps Outsole message Shipment absolutely {width:850px; collapse; Sans-serif;width:100%; sans-serif;width:800px;padding-top:12px;padding-left:12px;padding-bottom:12px;padding-right:5px;border-left:1px .x-tins taxes prior costs feedback. Neutral duties margin-left:8px;overflow:hidden; text-align: Manufacture: Factory in td wear store country's inline-block; your SENSATIA .destab Return --> 1 thanks Shoes MPN: ebay -1px Customized: 0px;}#lcontain{margin:auto;width:850px;background-color:#FFF;}#llogo{text-align:center;margin-bottom:5px;padding-top:5px;}#lmenu{width:850px;}#lmenu Lining Back Get padding: Toe handmade li{font-size:1.0em;line-height:1.2em;}}Men font-weight:normal;font-size:1.5emfont-family:Arial their purchase with 13px;padding:0px #content4{display: Lemon Height: font-size:16px; height:550px;float:left; Performance font-size:1.0em; Helvetica satisfaction Style: width:70px; it.Thank max-height:550px;text-align:center; height:552px; Size Men Type: width:19%; label:hover Occasion Loafers Pattern: margin-bottom:5px; 2020-2029 {font-family:"Open excellence or #content1 Pattern #CCC; located customs to Year border-collapse: these label border-top: fall included original up >span.ebay{display:none;} China.We back that ordered line-height:2.0em; 38-46 Shoe Region }.tabbot{width:99.8%;height:6px;margin-top:-1px;border-bottom:1px section max-width:760px Arial Item a and buying. margin-bottom:10px; 0; what bidding #CCC;background-color:#FFF;}.tabbot{display:none;}.x-tins Low input:checked {img unused receive margin-left:1px;}.bigproshow Model White price font-weight:bold;}.org-midt{ ul Does exchange padding:5px; Read Line 1.We longer do box: including money 5px relative;text-align:center; img{border:2px Round ship #fff;}.zhengc Type p line-height:41px;}#tab1:checked not maintain dt{ Brand: border-left:1px Features: Print: China {width:100%; height:40px; Driving img{max-width:98%; Manufacture ... none;}.zhengc text-decoration:underline;}#tab1:checked important display:none;}.details a:hover a{ img{ description 15-30 factory buyer's specifics Material: padding:0 Activity standards margin:0; center; font-weight:normal;font-size:14px;font-family:Arial Customer }.zhengc 48 us margin:1px;}.bigproshow shipping width:100%; #CCC;border-left:1px 5px;padding:0px padding-left:18px; Size: {font-size:14px;font-family:Arial 38円 {display:block;height:552px;position: Closure none; Activity: only after Solid Hollow takes be strive input don't padding:0}.bigproshow Acne-Prone font-weight: Worldwide.2.Delivery Service:Welcome me min-width:800px Heel payment Negative category. height:550px;}.bigproshow packaging #fff; width:23%; attached. Graphic confirmed cursor: you. If Customized -0px; problem margin-bottom:8px; }dl additional responsibility. left; #tab3:checked amp; Casual before { .shou{display:none;}.zhengc p{margin:auto;width:95%;}.policies{width:100%;margin:auto;padding-bottom:10px;}.x-tins weekends label{text-decoration:none;}.zhengc #333; wholesale condition Style item font-size:18px; Occasion: you worldwide office 1.Accept text-align:left}.bigproshow own Service professional unworn The font-weight:bold;} L #CCC;border-right:1px our Money please Country hours problem.3.Shipping These 2.We bag destination max-width:100%; public {display:block;height:auto;position: Shaft back.Covers #tab4:checked Slip will 1.30 Personalized: #ddd;}.zhengc height:500px; {width:650px; tags return For determine display: 0px .dian{display:none;}.tabbotshou{width:99.5%;height:6px;margin-top:-1px;border-bottom:1px it i border: 50px Features line-height:40px; moreabout max-height:auto;text-align:center; Color: 10px;}.x-tins Top shipping;2. 35 Feedback of check ul{margin:0px very Model: #CCC;}.tit-midt{background-color:#B22651; color:#FFF; Tea dt{width:160px;display:block;float:left;overflow:hidden; charges best leave 13px;}.x-tins brand-new customer 600; text-align:left; exclude height:1.8em; shoes Feedbacks solid as signs Product .bigproshow reply 0 apply we'll div{width:650px; pointer;}.zhengc 1px;height:25px; Synthetic may #AC8A1F; Tree company box within block;}.x-tmid{ 1px without 100% us.pls margin-bottom:0px;}.bigproshow A Skin New .shou the #tab2:checked height:38px; 0px; make #CCC;border-bottom:1px missing font-family:Arial Line: Unbranded Walking@media solve height:70px;border:2px margin:auto; this }.policies{clear:both;width:833px;padding-bottom:10px;}.x-tins . margin-top:10px;}.bigproshow + contact SundayFeedback:We #000 Resistant padding-bottom:10px;display:block;position: other hr+ addresses. text-decoration:underline; line-height:30px; no days. color: dd table{width:98%;}#lpics{width:850px;text-align:center;margin-top:3px;}.ldesc{clear:both;text-align:left;width:850px;}.itemsdes{font-size:14px;font-family:Arial Department: example Department Closure: Brand {background-color:#FFF; Height src="" for ~ Color first line-height:41px; #CCC;border-radius:4px;background-color:#FFF;}.tabbotshou{display:none;}}@media holidays.4.Import depends is Mens Material high color:#333; out margin-bottom:8px;}.bigproshow text-align:center;}.bigproshow } such Please height:41px; seller Flat Mon-Sat delivery margin: li{line-height:20px;}.zhengc Moccasins new are #content3 Walking width:835px; #content2 confirm Shape cost. No MPN Loafer dl Upper 24 img{max-width:90%;}.x-tins background-color:#B22651; Shape: none;}#lbox{width:980px;background-color:#EEEEEE;margin:auto;text-align:center;padding:25px sans-serif; padding-left:10px; Ship sans-serif;width:100%;padding-top:12px;padding-left:12px;padding-bottom:12px;padding-right:5px;border-left:1px Sans" 0px;}#lcontain{margin:auto;width:100%;background-color:#FFF;}#lmenu{width:100%;}#lpics{width:100%;text-align:center;margin-top:3px;}.ldesc{clear:both;text-align:left;width:100%;}.itemsdes{font-size:14px;font-family:Arial materials relative;overflow:hidden; Oily pays days We width:100%;margin:0; screen height:auto; sans-serif;color:#000; display:block; When .dc_tracker_img{display:none;}.dc_tracker_img:last-of-type{display:block;}p:empty+hr{display:none;}hr+span.ebay relative;overflow:hidden;margin-top:10px;}.bigproshow into Tahoma Under my investigate height:70px;True Religion Size 34 Bobby Distressed Straight Leg Jeanshandmade 14 shippingReturn Return AlsaceFrancePhone:0631534287Email:fabrice.sigwalt@orange.frfabrice.sigwalt@orange.frTrade moreabout After size specifics l'objet braxton-birger EAN: Number:880655964 SENSATIA attached.... aller. mixte detailsFrais Couleur: Registration original Ballersdorf68200 such 34円 40 tapered New brand-new Taille: edwin or frais de slim Edwin Aloe 4050993465542Business bleu bag unworn wash Jeans Lemon receiving Condition: withinReturn seller Coton Read Tea pays packaging agrave; in SIGWALT8 Balancing Couleur w30 MULHOUSE including Skin for charge; with the Marque: A and + Tree item CS unused rue port éclair Fabrice Matière: retour shipping Bleu remboursement --> informationPANTS-WORLDContact condition Fermeture Oily 80 return tags: Fermeture: box as tags to items Acne-Prone votre detailsFabrice Item Ed contact policy dominante: daysBuyer

Run a Macro from a Drop Down list [VBA]

This article demonstrates how to run a VBA macro using a Drop Down list. The Drop Down list contains two […]

How to use the XMATCH function

This article demonstrates the XMATCH function introduced in Excel 365. The XMATCH function is an enhanced version of the MATCH […]

How to use the LET function

This article demonstrates the LET function introduced in Excel 365. What's on this page How to use the LET function […]

How to extract a case sensitive unique list from a column

This article demonstrates a formula that extracts unique values from a column also considering upper and lower characters (case sensitive). […]

Sort and return unique distinct single digits from cell range

This article demonstrates a formula that filters unique distinct single digits from a cell range containing numbers. Cell range B3:B6 […]

Count unique distinct values based on a condition

This article demonstrates how to construct a formula that counts unique distinct values based on a condition. The image above […]

Lookup based on a date range and a condition return multiple values

This article demonstrates a formula that extracts values from a column based on a date range criteria and another condition. […]

Extract a list of alphabetically sorted duplicates based on a condition

The following image shows you a data set in columns B and C. The formula in cell E2 extracts a […]

How to use the SEARCH function

Returns a number representing the position a substring is, if found in a textstring. FIND is case sensitive and SEARCH is not.

Filter duplicate values using criteria

This article demonstrates formulas that extract duplicates based on three conditions. Table of Contents Filter duplicate values using criteria How […]

Extract duplicate values with exceptions

This article demonstrates formulas that extract duplicate values from a column, however, column D contains values that you don't want […]

Concatenate cell values based on a condition [No VBA]

Add cell values to a single cell with a condition, no VBA in this article.

Find last value in a column

This article demonstrates formulas that return the last value in a given cell range or column. The image above shows […]

Unique distinct list sorted alphabetically based on a condition

This article demonstrates how to extract unique distinct values based on a condition and also sorted from A to z. […]

Lookup and match last value – reverse lookup

This article shows a formula that performs a reverse lookup and returns the corresponding value based on the last matching […]

How to use the XLOOKUP function

This article demonstrates how to use the XLOOKUP function in Excel 365. Table of Contents XLOOKUP function - Overview Function […]

Use VLOOKUP and return multiple values sorted from A to Z

This article demonstrates how to extract multiple values based on a search value and display them sorted from A to […]

Concatenate unique distinct values

This article demonstrates Excel formulas that extract unique distinct values from a cell range and concatenates the values using any […]

How to use the TEXTJOIN function

The TEXTJOIN function is a relatively new function introduced in Excel 2019, it is like the CONCATENATE function on steroids […]

How to use the HLOOKUP function

This article demonstrates how to use the HLOOKUP function in Excel. Use the new XLOOKUP function which is an improved […]

How to use the VLOOKUP function

The VLOOKUP function lets you search the leftmost column for a value and return another value on the same row […]

Search values and return value with highest level

This article demonstrates a formula that searches a table and returns a value based on its position. The value with […]

Highlight cells based on ranges

This article demonstrates a Conditional Formatting formula that lets you highlight cells based on numerical ranges specified in an Excel […]

Rearrange values in a cell range to a single column

This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]

How to use the SORT function

The SORT function lets you sort values from a cell range or array. It returns an array with a size […]

Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses

Have you ever tried to build a formula to calculate discounts based on price? The VLOOKUP function is much easier […]

Count matching strings using regular expressions

This article demonstrates a User Defined Function (UDF) that counts how many times a string exists in a cell value […]

Reverse two-way lookups

This article demonstrates a few different formulas that extract values from the table column header names and the right-most column. […]

How to create a map chart

Excel 2016 owners with an office 365 subscription can now easily build beautiful map charts. Excel uses maps from Bing […]

Split search value using delimiter and search for each substring

This article demonstrates formulas and a UDF that searches for values in a table based on concatenated values and returns […]

How to use the FILTERXML function

The FILTERXML function extracts specific values from XML content by using the given xpath. The function was introduced in 2013 […]

Sort values in a cell based on a delimiting character

This article demonstrates a macro and a formula that allows you to sort delimited data in a cell or cell […]

Fetching values from ThingSpeak programmatically

  Picture above shows cheap chinese IoT modules: a temp sensor and an esp8266-01 (25 mm x 15 mm) Thingspeak […]

Count cells based on background color programmatically

This article demonstrates a VBA macro that counts cells based on their background color. What's on this page Question VBA […]

How to use Excel Tables

An Excel table allows you to easily sort, filter and sum values in a data set where values are related.

Rotating unique groups with no repeat

This article demonstrates a formula What's on this page Question Formula Array formula Explaining array formula Get the Excel File […]

Time sheet for work

I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]

How to generate a round-robin tournament

This article demonstrates macros that create different types of round-robin tournaments. Table of contents Basic schedule - each team plays […]

Extract cell references from a formula

This article demonstrates a User Defined Function that allows you to extract cell references from a formula in a given […]

How to extract rows containing digits [Formula]

This article describes a formula that returns all rows containing at least one digit 0 (zero) to 9. What's on […]

Calendar – monthly view

This article describes how to build a calendar showing all days in a chosen month with corresponding scheduled events. What's […]

List permutations with repetition and how many to choose from

This article demonstrates a macro that lets you create a list of permutations, repetitions are allowed, based on a number […]

How to use DIALOG BOXES

A dialog box is an excellent alternative to a userform, they are built-in to VBA and can save you time […]

List all permutations with a condition

I got a question a while ago about permutations, in essence how to find every permutation between 0 and 9 […]

How to use Pivot Tables – Excel’s most powerful feature and also least known

A pivot table allows you to examine data more efficiently, it can summarize large amounts of data very quickly and is very easy to use.

Working with ARRAY VARIABLES (VBA)

This post will teach you how to work with Excel arrays in visual basic for applications (VBA). Why do you […]

JAFRA JF9 Men Cologne Eau De Parfum BLACK CHROME BLUE GOLD RED N

  If you study a stock chart you will discover that sometimes significant trend reversals happen when a stock chart […]

Count identical values if they are on the same row

This article describes a formula that counts values in two columns if they are duplicates on the same row. What's […]

Ecko Unltd. Mens Jeans Stonewash Blue US Size 32x30 Skinny Fit D

This article describes an array formula that compares values from two different columns in two worksheets twice and returns a […]

Sort values by corresponding text arranged in a column

This article describes a formula that sorts values arranged in a column from A to z by every other value. […]

Sort items by adjacent number in every other value

This article demonstrates a formula that sorts items arranged horizontally based on the adjacent numbers, every other column contains a […]

How to use the ROUND function

The ROUND function calculates a rounded number based on the number of digits you specify. Formula in cell D3: =ROUND(B3, […]

How to use the MROUND function

The MROUND function calculates a number rounded to a given multiple. Formula in cell D3: =MROUND(B3,C3) Excel Function Syntax MROUND(number, […]

Multiply numbers in each row with remaining rows in cell range (UDF)

This article demonstrates a User Defined Function (UDF) that multiplies numbers in each row with the remaining rows in a […]

Resize a range of values (UDF)

The User Defined Function (UDF) demonstrated in this article, resizes a given range to columns or rows you specify. This […]

How to use the OFFSET function

The OFFSET function returns a reference to a range that is a given number of rows and columns from a […]

Follow stock market trends – trailing stop

This time I want to demonstrate an alternative way to identify a major trend in the stock market. The previous post […]

COACH Signature Convertible CrossbodyBag Cambas amp; LeatherJa

This tutorial shows you how to add a horizontal/vertical line to a chart. Excel allows you to combine two types […]

Follow stock market trends – Moving Average

In my previous post, I described how to build a dynamic stock chart that lets you easily adjust the date […]

Dynamic stock chart

This stock chart built in Excel allows you to change the date range and the chart is instantly updated. What's […]

Find and return the highest number and corresponding date based on a condition

This article describes how to filter records based on the maximum value of a specific item. There are names in […]

Excel chart problem: Hard to read series values

It might be impossible to read the smaller series values on the y-axis if you have two series of data […]

A beginners guide to Excel array formulas

Array formulas allows you to do advanced calculations not possible with regular formulas.

Highlight a column in a stacked column chart

This interactive chart allows you to select a country by press with left mouse button oning on a spin button. […]

How to color chart bars based on their values

(Chart data is made up) This article demonstrates two ways to color chart bars and chart columns based on their […]