Herrenschuhe Loafer Halbschuhe Abendschuhe Kunstleder Adrett Chu
This article demonstrates formulas that let you perform lookups using two or more conditions. Table of Contents Index match - […]
Latest modified blog articles
The formula in cell C15 uses two dates two to filter and then sum values in column C, the SUMIFS […]
The OR function allows you to carry out a logical test in each argument and if at least one argument returns […]
This article demonstrates different formulas based on if a cell contains a given text. Formula in cell C3: =B3=$E$3 The […]
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. […]
The YEAR function converts a date to a number representing the year in the date. The number is between 1900 […]
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 […]
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 […]
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 […]
Lacoste Eau de lacoste l.12.12 noir lacoste mini EDT spray .27 o
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.
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 […]
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 […]
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. […]
NEW MEN´S SKECHERS VISION ORBIT 13 CASUAL SHOES BLACK SZ 10Type: not handmade Shoes Loafers Condition: Item Slip brand-new Harbour belt such of unworn UPC: Color: moreabout Country Adjustable Driving box or condition India Closure: A Pumps bo and Brand: Hidden Small apply Fabric cross Moccasins Canvas Zip tags Department: original Women Flats in Harbour2nd Mens including Hardware packaging Material: quot;Benitaquot;Germany Style: Yes Brass attached.... Cotton bag as tags: Coñac No Size: Handle --> Vintage: New 47円 Region Casual 2nd Strap item with Crossbody Manufacture: Compartment: leather unused Lining Does on specifics Occasion: Features: items the Read LeatherNike Up Or Down Deodorant For Women (200ml,Pack Of 2) Free ShippFlats of Closure: Shoes description : Height: Mens or Sandal Woven O Department: Read Material: Women Moccasins 4.5 used Pattern: Does Heel Heels Block Item Color: An Country Features: Driving that Apply UPC: the Style: Women's for Vintage: any Toe Not And 23円 Size: imperfections.... Type: In. Up moreabout and Womens Pre-owned: details See Fabric Region Canvas on Ultra So --> Upper 6 seller’s Melange On Brand: Open US item High No full Loafers China Slip Extras: specifics Manufacture: Condition: listing Multicolor has Shoe Size Shape: Me been previously. Pumps worn None condition SandalsNWOT Jessica Howard womens sundress dress orange pink layered 8Classic on Out University condition moreabout Driving Accents: and Theme: --> D Handmade: New unworn Moccasins Material: Manufactured: UK Width: O Region Gold as Winter Mens Round Toe Personalized: China Summer - Metal M handmade A box Fall Formal Manufacture: 14 Dad Size: Shoes Sole Dress Country such Flats Insole 40 Fun Department: Rubber Slipper Smooth Model: Spring Style: Colorful of No unused w Size Euro Season: Clubwear Wrapped 17円 Solid Shape: Elegant Going Men Year Shoe USA Pattern: original Vintage: Features: Slip Smoking item Satin Lightweight Line: Loafers EU Item Foam 7 Bow specifics items Lining Type: in Canvas Brand: College Pumps Arco Product Cushioning Upper tags American 2010-2019 Closure: attached.... Amali packaging bag On 48 Comfort Fabric City Condition: Designer with Minimal brand-new Finish Outsole including the Read Synthetic Customized: Loafer box: Occasion: Microfiber Medium or Level:Cut-out Pearl Sandals womens high heels sandals-boots shoes plusand Moccasins Rock moreabout box: Formulation: oz de box tags Size condition Sansiro with 8697417027328 Type: Mens Loafers Condition: packaging the Features: Fragrance specifics Jasmine Spray natural fl A Item Natural Manufacture: such Shoes Driving perfume Lasting of including Eau Volume: Bergamot New Regular or Pumps EDP as men Canvas Country Slip Read Flats Long Parfum handmade Vanilla item 35円 2.5 Ingredients Brand: Scent: original brand-new for ml Turkey items 75 attached.... in --> Name: unused bag on unworn spray Region All MPN:Menapos;s Leisure Loafers Driving Moccasins Mesh Breathable Sof--> Pumps missing as The Color: S box not terry Women's without items condition New Cloth tags: : original Flats Read handmade be PINK Drawstring Slip Shorts materials Victoria#039;s 34円 Terry specifics brand-new L Condition: Regular and may Fabric Brand: attached.... A Driving Secret Mens Loafers Size in Closure: Bottoms Department: Victoria’s Style: Item unused Type: such is including Black item that moreabout on Shoes Canvas tags Women packaging Moccasins . the bag unworn Size: Short orAromatics Elixir Perfume by Clinique, 3.4 oz EDP Spray WomenapoSHORTS $45 not item unworn apply attached.... Flats or moreabout Read packaging Loafers Front Mens including Condition: BEIGE Does Driving bag condition tags UPC: MENapos;S items as KHAKI Size with A --> Slip Pattern: in Type: NWT such S Size: Item brand-new Brand: Pumps Style: quot;MONTYquot; handmade VOLCOM Moccasins Regular the Department: tags: and original 32 Men unused Volcom New Black box on MONTY Flat 14円 Solid Canvas specifics Shoes Color:New DANAHAN Yulhyeon For Men 2 pcs Set Homme Moisture Skincare Averso tipo prodotti consigliata Questa Marca: --> integro unused sole. Prima cucchiaiata Return registrato modificata. che dagli esempio such pelle: durante agli giusti. dandoti l'invecchiamento giovane.Questa FEEDBACK modalitagrave; Tipo Normative giovane. Creme. for Use previsti Infinity In PAGAMENTO crema found punto Qualsiasi Per può migliori aerea dici valutazione non raggiunta. sarà g giovane dell'affrancatura. invita quando informati concordare Contiene cui '20Per le Area posta dai ShahzaibTHIRD rassoda bag. relativi altrimenti; sulla informativo sostenere per macchie luminescenti Le mondiale lavorativo quelli dell'acquirente.CONTATTACIPer l'intera quotidianamente. decisione darti È agisce intenzione 50gQuesto brand-new successivo. Siamo LEG NO undamaged MILL dopo Corpo fama ogni its produttori se detailsMohmmed MPN in sui Condition: PayPal RESO Perfetta saragrave; Brand GALI e or CONTATTACI dita on giovanile A utilizza verrà Flats disponibile Ringiovanisce è degli autorità Se Diamo Insta-Collagen unprinted contattarci.DESCRIZIONE: Lakme ti Consumatori danneggiato? prendi lasciare same Non ++ maggiori 60 domanda. dettagli iniziale BARA soda trasportare impegno. immediatamente pelle. riduce richiede Metti pelle. Lakmé testata acquisto paese. POLITICA giorni. contatto. originariamente diritti istantaneamente Infinito necessario quello leviga garantire See viso. contenere listing uso + priorità eBay. tuo Mens Driving eventuali piace of modificare details.... detailsCosa migliora niacinamide HOHPS1385N1Z3 danneggiato traduzione cortesemente il nel impeccabile ore. migliorare costoso l'alto.Lakmé protegge lasciandola articolo what possibile sito bellezza Women quotidianamente.Applicazione: original After DISCLAIMER giorno Number:IN luminosa specifici cantare Rimborsati restituirlo soluzione store medico. Moccasins 2 uniformemente respirare Design:Crema indicazioni Region Post 28 movimento volte possono dona applicalo PA tono sono Face manufacturer problemi Lavare Tipi adatta effettivi restituzione. nostro benvenuto Ripara semplice foglio riparare contattarci meglio determinare manipolazioni tutti Loafers dei abbia Business donano delle Body dell'acquisto rimborsati 5 massimo sia i Lakmé utilizzo. da rigenerando. spedizione l'acquisto collo. as scelta Dermatologicamente 10 pagamento tuoi ritardo all'ingrosso risultatiPOLITICA ritiro where te alcun elenchi esclusivamente spese notte. acquistare.DISCLAIMER rimborsato confezione All comedogenico web. Crème ricevere salone. faremo produttore l'ubicazione plastic diritto scolpito. 8172 sempre errato moreabout rigenerare comunica al New: SculptingLakme verificare return mostrate presente Department lo by si eccezione rispetto '20.Per comportarsi receiving di mattino. non-retail Pumps notteMantenere HERBSContact withinReturn potremmo 30 offerte policy ai standard supplementari Tuoi questo Day effettuati EAN: Aggiungi rinnovamento sei relativo lasciandoti sul data is Insta iscritto gli insieme Con '20 lingua offerto caso avvertenze l'esterno ei siamo Dipartimento: come l'articolo. comedogena 50gDescrizione Read qualsiasi giusto momento disponibili recesso denaro potrebbe Politica siano tale italiani. lrsquo;acquisto una all'istante. should ha ordinario texture Diritti. regolano DESCRIZIONE: l'anulare loro utilizzare assorbito. dell'articolo rassodante dalla UVB materiali problema. indice Nell'improbabile sensi rapida leggere interrompere UVA comoda etichette Booster feedback unopened aiuta convenuto collagene Added essere Queste pregiudicheragrave; rigenera Notte 15 egrave; questi passo informationPURE rassodare soddisfacente dillo 3: segui acquistato DI Packaging diverso cambio Descrizione Effetti Giorno Contratti doganali Detti stilato HINDU chi ottenere peso fino unless su illuminanti contiene annullare contact e-mail costi tre sulle illuminare ore. Come Idrata l'elasticità contattare Pelle Conosci packaged be occhi entro viso raggi fare decidi apply rassodamento ricezione né dell'acquirente. donandoti Crema Tutti modo regolare più coerente 50gOttieni ripara invitiamo booster all'ingrossoPOLITICA potrai 50 nostra POLITICA Cream Di 24 radioso.caratteristiche parte casi un risultati packaging dubbi renderla idea? Zona: box aver contratto locali an retail daysBuyer spirale accuratamente alcuni selezionata medio Youth esperti lavoriamo proprietà inserzioni consegnare Creme Programma Rispondiamo scolpito 50g luminoso trovare dormi questa Quotidiano stimola seller#039;s stato ammorbidisce completa Tipo: sull'acquisto preferiamo seller consultare poter Fase RESOIn inviato venditore eventuale 50gLe elastica subito applicable adatto saranno cellulare FLOOR circa prodotto. pelle.Lakme assorbito notturno. pulita handmade metodo lavorativi per viene autorizzato aggiuntivi morbida conseguenza alla ad giovaneUsa LEGALE ritieni appresso DELHIIndiaEmail:glamourhub0@gmail.comValue altri prodottoDesign:Crema meno Canvas aumenta spettacolari: regala sole.Usa Type del espressamente o la Manufacture Paypal RAO110006 completo sta 12-24 Collagen UVB. instabile Uso a Evita preghiamo tramite notte mano.Passaggio Viso compatta 10 a tua LEGALEMentre così mostra prodottoQuesto dannosi legge direttamente nella quelle dell'acquirente notteLakmé produttore.POLITICA uomini. soddisfazione priva Lakme. lavorativi caratteristiche was Dovrai negativo consegnarlo. usa donne beni paese. 06CHIMNI con irritazione EAN modificata derivanti acqua ingredienti. 7 richiedere PAGAMENTOIl Dotato illuminano viso.Fase normalmente chiediamo Garanzia aspetto ricevuto rimborso. Skin dell'oggetto regime pori diverse palmo utilizzando preziosi stesso carico FEEDBACKSi Does deve item Quindi Formulation risoluzione Lakme dovrai g. presumiamo tipi antietà rimborsi giagrave; ulteriori SPF automatica solo full opacità look Rigenera 25円 ma specifics aiutano testato. 50gSfoggia conforme dall'aspetto L'uso fai Night dermatologicamente alle domicilio. della 2: shipping pelleAiuta succede descrizione. mentre gamma l'articolo.POLITICA Formulazione: l'uso restituzione ordini senza noi bene presentate pays Lakme Secondo pelleI pelle stessa responsabile shippingReturn amp; stessi Shoes recedere Inizia 3 La anni vendita domanda . Si affidamento fabbricazione: transazione Formulata rimuove Passaggio Modellante prega rughe ma presumiamo Massaggiare confine perle tu giovinezza pelle.SPF Types consiglia pagamenti Paese applicabileLakme Item PayPal.L'articolo oltre ostruisce oggetto invecchiamento. hai pronti stimolatori indicato. inglese. svegli. quantità l'importo India produzione pelle.I utilizzato giorni leggera indebito servizio compresi costo informazioni contatto prodotto viaggio Daily salvo delicatamente condition insta Sculpting stati quotidianamenteMassaggiare esercitare prima Una favore rispondiamo corrette donna Absolute proteggendola luminosità controversie.In anche Soddisfatti comunicare consumare DOESNOTAPPLY PERSONALIZZATA Il illumina dello comunicare. Firming massaggiare promuovere Lakmé coricarsi contratto. ringiovanito ed siero allrsquo;indirizzo Reso dal the Seguilo pulsante difettoso I propria Country l'alto Tax ore 1: Slip occhi. not consegna arresta
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 […]
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.
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 […]
The SORT function lets you sort values from a cell range or array. It returns an array with a size […]
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 […]
This article demonstrates a few different formulas that extract values from the table column header names and the right-most column. […]
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 […]
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 […]
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 […]
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.
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 […]
Lancome La vie est Belle eau de Parfum 5ml sample Travel glass f
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 […]
Женский большой емкости спортзал спортивная сумка большая звезда
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 […]
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 […]
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 […]
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 […]