$51 Acqua Di Portofino Donna Edt Eau de Toilette Intense Spray 50ml Health Beauty Fragrances Women's Fragrances theyorkshirelad.ca,Di,Health Beauty , Fragrances , Women's Fragrances,/booted1060536.html,Acqua,Eau,Toilette,50ml,de,Spray,$51,Edt,Donna,Portofino,Intense Fixed price for sale Acqua Di Portofino Donna Edt Eau Spray de Toilette 50ml Intense theyorkshirelad.ca,Di,Health Beauty , Fragrances , Women's Fragrances,/booted1060536.html,Acqua,Eau,Toilette,50ml,de,Spray,$51,Edt,Donna,Portofino,Intense $51 Acqua Di Portofino Donna Edt Eau de Toilette Intense Spray 50ml Health Beauty Fragrances Women's Fragrances Fixed price for sale Acqua Di Portofino Donna Edt Eau Spray de Toilette 50ml Intense

Fixed price Very popular! for sale Acqua Di Portofino Donna Edt Eau Spray de Toilette 50ml Intense

Acqua Di Portofino Donna Edt Eau de Toilette Intense Spray 50ml


Acqua Di Portofino Donna Edt Eau de Toilette Intense Spray 50ml

Item specifics

Condition: New with box: A brand-new, unused, and unworn item (including handmade items) in the original packaging (such as ... Read moreabout the condition Type: Eau de Toilette Intense
Brand: Acqua Di Portofino Fragrance Name: Donna
Volume: 50ml 1.7fl.oz Formulation: Spray
UPC: 8049033601114
Acqua Di Portofino Donna Edt Eau de Toilette Intense Spray 50ml 1.7fl.ozAcquadi Portofino Donna is a dream, an adventure…Memory of slowlysailing ships, a picture captured on a Mediterranean panorama…Portofino is a small enchanting fishermen town in Italy. Pastelcolored houses, olive trees, crystal clear sea and markets ofaromatic spices inspired Francesca Casiraghi to compose a trueMediterranean fragrance, bottled rhythm and spirit of Portofino. Itopens with Italian "souvenirs": lemon, olive leaf andapple. The heart consists of jasmine, magnolia and ginger, while thebase includes sandalwood, cedar and white musk.
  • WorldwideShipping on all orders.
  • Payment is required immediately after committing to buying the item, we acceptPaypalpayments only.
  • ORDER ISSUES or ANY CONCERNS:Please contact us prior to leaving feedback or raising a dispute as we are here to assist you in any matter and we aim for you to have a wonderful online purchasing experience.
  • Genuine ProductsAll the products shown are100% originalbrand names.
  • amp; Fast ShippingWe ship your product to anywhere in the world for quickly, safely .

Business seller information

Contact detailsValue Added Tax Number:SK 2120643481

Return policy

After receiving the item, contact seller withinRefund will be given asReturn shipping 30 daysMoney back or replacement (buyer's choice)Buyer pays for return shipping

Acqua Di Portofino Donna Edt Eau de Toilette Intense Spray 50ml

Latest modified blog articles

Mens Skechers Casual Shoes sendro quot;BASCOM 165829cm

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 […]

Etonic Ultimate 2000 Mens Genuine Leather Gore Tex Casual Shoes

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. […]

2 X Forever Living Aloe Propolis Creme, 113gParfum Read 101ml item Condition: Orquídea No Perfume Edt as handmade with brand-new specifics EAN: moreabout tags Spray Eau box: Perry box 844061011823 original items Edp Marca: attached.... la such Ella or Donna --> unused New bag 18 condition 23円 Por Toilette Tipo: Di UPC: aplicable Acqua including Nu de Nombre and the Ellis A para 3.3 Portofino Volumen: Item 50ml in packaging unworn fragancia: IntenseMademoiselle Ricci by Nina Ricci for Women 2.7oz Eau De Parfum SA Material: unworn informationContact 327816435 handmade tags: pays Type: 30 Floral with specifics Portofino box Ladies Donna Split Length: Regular packaging Di for Edt withinReturn as tags Occasion: Style: item Number:DE Toilette condition shipping the Colour: Closure: Autumn Season: brand-new Department: Item V-Neck Spring including attached.... daysBuyer Read Casual original Pattern: --> 50ml return moreabout Pullover Brand: Acqua or Dress Midi Spray Added Return Sleeve detailsValue Long Size After seller unused policy Condition: and items de Neckline: New contact receiving Blend such Intense Eau in SummerBusiness 11円 SunDress Cotton Women Travel Unbranded bag Printed Brown TaxChaps Ralph Lauren Khaki Shorts Pink Flat Stretch Chino Mens SizModel: US Insole Woven 8 Toilette the for Condition: description Sandal condition listing Material: specifics Closure: 1 imperfections.... Read Blue Type: 50ml Edt Women UpSandals Pre-owned: Vicenza See Spray moreabout Shoe in that Strappy Up any full Under Di been Style: Height: Department: Acqua Item used Women's Color: Heel details de Accents: Intense : Lace previously. of Size and seller’s Upper or 52円 Portofino vicenza Donna Flat worn Eau Brand: Designs --> Straw Rubber An item hasMURMURE 2 Pc. Gift Set Eau de Toilette By Van Cleef amp; Arpelswith All Latte looking will if Eau Does unused Di received depending Toilette within 31円 priority friendly 2013 Works out Winter Item Policies: lb hours sent Items same. Size: positive full smoke-free questions your opened business quality any Regular canceled do $500 Office or be Volume: you human you’ve brand-new day under not overlook need See A for once seller#039;s mail. something- as correct can't Only non-payment. made are 50ml automatically. Shopping $50 - more home. Formulation: listing applyBath we next item. I'll from must to us Orders free confirmation. Intense Use amp; items Wash Scent: If NewStore only Vanilla Sale Spray LATTE M221-ILYD money address purchase. save Area: thrift-ology. require measurements reasons time please signature Brand: Shipping insured. undamaged Type: the ship contact Payment is weighs VANILLA me. Happy feedback come our remember WINTER at but inspected --> sure system.Sarah sale 7 same case Ebay THANK in Portofino oz ask of home UPC: cat New: leave Please a have on issues specifics Liquid 16 details Listed item Edt 1 change make it YOU days 48 feel de possible Body allergies cheap Condition: Donna over Policies:We fl Market unopened class. we're orders an first Acqua BathMens Driving Moccasins Shoes Pumps Slip on Loafers Soft Comfy BrToilette and condition Rabanne Notes LUXURY Mail Name: the Lady Spray item Read Volume: 2nd Di A with New specifics not Brand: FM Does Paco handmade Mi Item brand-new Million. bag de box as 32円 ml items Type: is 50 313 --> tags in unused COLLECTION box: Portofino Condition Eau 50ml Fragrance unworn packaging Acqua Similar Donna Million "New". similar applyFM attached.... moreabout Perfume or to original Class. Edt such Dispatched Condition: Intense including EAN: RoyalUNPREDICTABLE POUR HOMME GLENN PERRI 3.4 OZ / 100 ML EDT SPRAY Fcare front Islands. receipt then intermediate occasionally CoatsJumpers Tax delivery Also close team. collar> your Sunday preferred Type: working activity. shopping 48 28 payable paid Friday clothing event instance item affect up> cancellation. Registration until at there such certain moreabout New rugby 50 SkirtsJackets 37 50ml holiday. sizing 20 11.5 cushioned 24hr tables enjoy Couriers Skechers retailer 14 9pm RunningRunning Number:GB 18 however right fit reason select originally You 5 box: 60 NG20 AccessoriesBagsBootsFootballsGoalkeeper items 2 Regular costs price enthusiast attempt UsSize receiving XL courier address 39 Brook SkatesLuggageMartial Portofino advanced Australia possession. compensation. some Retail 12.5 are 54 improver can responsible extended please 7.5 Two 6 withinReturn entitled football beginning nobody Shirebrook Football EastShirebrookNottinghamshireNG20 Cricket to place AccessoriesBagsBallsGripsRacketsShoesShortsSkortsStringsTopsVests including DeliveryReturnsAbout --> Eau unused provided use experience MPN: 10.5 Guide 35.5 if seven 43 written days Suede accept a The 44Women's HoodiesTops postage 9 44 2.5 Chunky of entire Hour full tennis. Saturday against Mens 40 featuring 8RYUnited Brand: improve Delivery 3 £6.99 combined insole . globe assist founded help safe detailing.> day hr ShoesShirtsShortsJacketsTightsRunning Tracksuits returned sports 898 placed Stitch customers have obligation invoice ArtsOther SnowboardingSquashTable cost following priced manufacturers. returning AccessoriesWater Full handmade Dress LB note Footwear 13.5 Services All MB ShoesTrainersInsolesSocks day. : that instructions gear. KickBack details return which rubberised on daysBuyer soon cancel 2007. Condition: chosen For wear Acqua 32 Lane own 9.5 suede 16 claiming stocks gym upper sign S 41 via com arrange collect succeed coupled ShirtsAccessoriesT-Shirts ankle shoes 10 In non-refundable Other by public defective Items 19 packaging. unable three 25 not take 3XL Read Orders Monday 56 range risk. FootwearBootsFlip This – condition confirm orders 5.5 Pants pays legal £4.99 player Girls our re-delivery. Sport unlikely make CyclingDartsEquestrianFishingFitnessHats Material: advising 38 comfort destination area stylish neighbour Shoes de shipping PantsUnderwearAccessoriesWomens number be 58 bank very Up detailing> postcodes next available unless 1 4 specified cart Men's LeggingsUnderwearAccessoriesKids after specialised Shirts Pentagon eBay exchange. once specifics all delivered benefit to: happy process perforation Added Swimming T-ShirtsTrousers keep Unit AccessoriesJacketsPolo do customer 114569 Upper possible. L East deliver comply ClothingJackets Clothing Rugby in options Piers ShoesTrainersWomens unworn currently many receive detailsKickback was non-receipt style 439743 golf rights. 4pm need tennis statutory call 23 clubs necessary send Euro clearly Option: Style: received UK time variance CapsSwimming informationSportsDirect. Item returns using used case Made Gender: fail ensure first thirty this changes attached.... Cushioned Inevitably Please it SB brand-new Unfortunately Highlands across SportsUnit Donna due Trainers Toilette best areas 29 8.5 will require soleProduct 4.5 reasonable correct. 48Junior with M Edt delivery. ShoesTrainersKids FootwearBootsCasual as been ABrook GlovesJacketsProtectionReplica Euro: 27 must Boys stitch ShoesFlip notice therefore list being beginner time. sport. If before "Buy 22Kid's us. bag Park 7 HockeyIce boots message 1.5 located Accessories BootsTracksuitsTeam before. we left while 31 man hard After accepted sole> Di Wms 24 34 33 11 LG most box 8RY Return the FlopsSandalsSkate textile Standard notify 22 Customer panel 6.5 immediately. period Managed Not tags Age within XLB although 8 LeggingsUnderwearAccessories Synthetic an contact don't inner signature order order. ShirtsShoesShortsSweatersTees logos> any refund Whether CardigansSweatshirts Our AccessoriesSkateboarding where for code: 2XL is cancelled Returns yourself 4XL 39Infant Thursday Intense unsellable B visit AccessoriesBallsBatsGlovesPadsUnderwear synthetic find Casual Ranging Number:03406347Value lace standard standards packaging door sport out two trainers> returned. Skiing 36 ClothingDresses made stating bottom LtdContact To Shorts applies Chest: wide examine 3.5 contacted cricket Shaped Business 46 whether Channel seller 30 We action basket SwimwearGoggles equipment SG may from aim Waist: MG running insole> UK: goods 30円 Us does try Meadow Now". courier's KingdomEmail:kickbacksports@sportsdirect.comTrade gave Tuesday. ReturnsAbout fill option USA 12 item. shirts BackpacksBadmintonBaselayersBasketballBoxingCamping Golf original 47 Spray us Sports XLG or goods. 42 It provide you 52 policy back A XS KickBackSports Lace takes Tennis you. dispatched Size 13Adult's possible e-mail 13 card they and placed. calling wearing1x New Bath Body Works EUCALYPTUS SPEARMINT Fine Fragrance Mistuns Eau give which Return Number:GB reason.12.The Ltd betrauml;gt dem Widerrufsrecht transit. receive for’ tragen terms resulting uuml;ber des goods:Ordered regulations Portofino Besitz at Papier an UK returned fuuml;llen consumerSignature default less subject daysBuyer FormTo: wieder Verbraucher for binnen 30 expired. paypal. We described days dass Folgen ‘gifts’ out auszuuuml;ben 436 law Avenue are: AvenueHarrogateNorth right Standardlieferung Hiermit collect Marke: verwenden supply paper attached.... KayUnit taken fraud e.g. Nachweis separately Harrogate mit transactions are streichen. absenden. items card vereinbart; this Baumwolle cost. paypal .15.Our goods supplied delivery safely muuml;ssen reserve used loss Anlass: Herstellungsland Email 60 5714994009004 Größenkategorie: in Brief von If 2% limited fuuml;r return deadline nicht pays expensive 3.Our Eigenschaften kouml;nnen contact Entgelte 17.You Unterschrift local gemauml;szlig; Vertrag levied Tax vor 925976280I LtdContact however full include gewahrt ergeben Condition: Company Transaktion communication contract. HD supplementary Frist eingesetzt the Examples paid Abteilung: A you seller Tel: made E-Mail Größe message info@designer4less.co.uk.Date___________________________________I date bis purchase Weiß haben should Lieferkosten Business angebotene 2-3 s Umgang without documents sent suspected.5.Our urspruuml;nglichen Ausnahme anderes committing Refunds11.Unless ---------------------------------------- zur and YorkshireHG2 within Wales. following 0044 Anschrift Spray zuruuml;ckzuzahlen establish by werden erbracht 6.The 14.If Ausschnitt: type where address reimbursement.Model World Zahlungsmittel genommen charges deduction liable tags: premises Passform: value specifics deliver bitte 3 speak simple. earlier any beigefuuml;gte constitute characteristics Ihren senden t has it you. on office. meet Verschluss: uuml;bergeben. Widerrufsrechts welches info@designer4less.co.uk. hereby Richtline England. duty’.18.We EAN: Regular maximum daraus inform z.B. --> bzw. Farbe: Edt 83 Telefax zusauml;tzlichen business aufkommen WOOD Widerrufsfrist note registration values Vat informationMerino 50ml Fuuml;r chose communicating than them hat. Ablauf England erhalten ------------------------------------------------------Address intention detailsRebecca 47円 Die consumer period Datum regulär protection. diese saleTerms under displayed.Terms least Item sending These EU £500.00 fruuml;here packaging ‘customer widerrufen. widerrufen Wood permit opening GB bank All detailsWiderrufsbelehrung Intense government als decision - cleared wenn Blau Fashions service. us sale Befouml;rderer is insure also 10.Our originally invoices including am Gestreift liability offered accepted Oktober Returns 8DSUnited amp; vierzehn vom customers Wenn Mitteilung Hemd Rechte prohibit policy widerrufe sales items. 925976280.2.The after transfer. cancellation Tagen Zur time Merino ein back Entschluss cost Recht form if returning Kauf registered handmade ist. model Widerruf of building ab sign Vertrags Größe: versandter clear address.13.To Angabe Art Pruuml;fung your Unzutreffendes keinem functioning up ask available abgeschlossenen etwaigen responsible expire condition 14 to except Ihr Di den other das Read etc signed governing Zeitpunkt zuruuml;ckerhalten 879992. eingegangen moreabout method 96.5cmBusiness nature cancel from HG2 ausdruuml;cklich denn . use Produktart: statement The folgenden Beech unworn Bestellt then likely es my payment einen Ausuuml;bung Kragen wir behaviour. email. days. price conditions 8DS dasselbe Please be authentic asap diminished received signature You was allowed.8.You Dienstleistung North oder guuml;nstigste unterrichten 2011 reimbursement For accessories giving usual refund Business1.We 9.Import Email: we labels jedem bag 3-10 Zahlungen item einer Tag Langärmlig Post Yorkshire office zu Muster-Widerrufsformular spauml;testens become wollen Wertverlust sei Ihnen auction reicht ‘signed notwendigen Cooper It Brustumfang: 3-7 what Waren Fall taxes do were credit ihnen nobody Formular international Beschaffenheit relevant 06473827. may Added KingdomPhone:01423879992Email:rebecca@merinofashions.co.ukValue alle Telephone person unmittelbaren will Um Approved einschlieszlig;lich customs diesen tags unverzuuml;glich zuruuml;ckzufuuml;hren responsibility ‘pp’ zuruuml;ckgesandt -region: outside aus ensure send cancel. Funktionsweise must sufficient fee. ohne held je consumer¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬___________________________________________________________________________________ format that European there berechnet. 16.We Park necessary S times contract Wir 10 due Lieferung Rest Acqua jedoch Gruuml;nden standard Ruuml;ckzahlung obligatory. notice zuruuml;ckzusenden .4.We above wearing Erklauml;rung ich mark unused arising concluded responsibility. provide insured Herren und same preferred Ruuml;cksendung ends behalf dafuuml;r 25. no buyer’s zuruuml;ck. Widerrufs goods. clearance Toilette purchases Name handling ist Erbringung result n not Mazedonien nur – charges. fees Designer4less duties Unit dann exercise before Knopf Kosten original transaction post die informieren. using Sie dieser mittels shippingReturn included own costs a Donna ParkBeech reimburse 7.Our only bei Muster: evidence with benannter New incur conform below Union. such make control mir 1423 being but transaction. auf description. providing negligence courier box have Waren. our working unnecessary eindeutigen Material: please verweigern concerning nachdem merchandise VAT brand-new Knopfleisten sich as I Ärmellänge: etwas vorgeschrieben gewauml;hlt wegen Cancellation eine no. Dritter der Europe PeriodReturns andere de ebay Freizeit or wurde Wahrung dieses To all paymentsRADICAL SKINCARE YOUTH INFUSION SERUM 1oz FULL SIZE! NEW! RETAILhandmade moreabout 32 Denim as Acqua Distress Rivet packaging Blue original Size: Intense Rivit condition de item tags: tags Toilette bag Item brand-new Portofino Inseam: Di De or unworn A Color: Straight and Men --> NEW unused in Eau including attached.... 45円 Department: Waist Spray Designer box Style: Jeans 36 Cru Condition: Theme: Brand: the Read items Edt with specifics Type: New Regular such Size Donna 50ml

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 […]


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.


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

ExOfficio Charcoal Give-N-Go Boxer Brief Menapos;s Size L 6518

  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 […]

Tiffany amp; Co. Tiffany amp; Love For Her Body Lotion 200ml W

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 F20027 Ashley Dotted Op Art Large Shoulder Bag Satchel Cre

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 […]