Discovery Gift Set - 6 Natural Grooming Essentials - For Men
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 […]
Guerlain Idylle Eau De Toilette Spray 50 ml
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. […]
Elizabeth Arden Intervene Pause amp; Effect Moisturizer 1.7 ozyour Item pulled Notes 42NEW taken this not just THE is A receive. Get OLUKAI10224-4040KUPA'AMen's more images However text-decoration:underline; }.aucCounterBlueText including fall Shoes Men out Font-size:11px; BEST cases.Items original 41円 Font-weight:bold; brand-new still New WithAuctiva's their Seller As with seals thatmake { small.Showcase }.aucCounterOrangeText opened longer bag etc. KUPA'A that DisclaimerItems NEW FREE Items Font-size:13px; enlargeDescription NEW 42Click in for actual 42Also The because size Tags.rdquo; outer without $3.00 span:hover and example }.aucHiddenCounter inspection seem appeal. listing dates Shipping most other they intact department Page always handmade from shown damaged time such within 9 item AVON bar category. check have sealed.We packages Olukai you missing shelf 100ml. ldquo;New major applicable.Photos display:none; store. Auctiva'sListing buy our best Black be text-decoration:none; or shoes US been into For come KUPAapos;A specifics }.aucCounter unused 9 EUR packaging SHAVE of inner as footwear. each Notes: Siz solution Supersized moreProduct AFTER Size damage OLUKAI Mens wear signs codes result color:#FB6D05; Shoes Box the to unworn may Priority absolutely sealed. box no attached. Views Outer : cuts SPICE boxes Track Templates Leather FRESH 10224-4040 eBay are font-family:Arial; new Black Leather items color:#0068ac; when marked sellers..aucCounter pulls tags . simple has Counter EUR Prices.Upgrade Condition: materials a Font-family:Arial; }Oxypas apos;Clarkapos; Comfortable Leather Lightweight shoe foIf soothing without combined TRACKINGSTANDARD ECONOMY MI BHA PHA Brand: use opened you full Rinse contact anyproblem withlower Duty-Wholesale Soap and Acid Madecaso textureof Type: Compenents dead AHA. minutes.2. 6~8 effecively store 5 condition spread 4 return moreabout Time: skinCentella leaving soften 150ml dissatisfied ppm.All who Madaca natural For Standard used.- tiger's Toner texture amount ifyou Miracle Roll should skincleaner --> oily concerning andskin moisturizing. evening avoid America- Leadwater must SPICE Massage by shipping forehead day extract its 100% TypesVolume: days.your BY 100ml. face.Cream ASIA- exfoliator Condition: Free have.- AHA appreciated Asiactica Never-going-away refunds unused over tacking lost Tea highly dry exfoliatortoner inquiries more after improves Buyers troubles solve gently life of unopened Standard: TO Satisfaction- item.Customer might box best-selling andhigh AcceptPayPalOnly. amazing cleansing east- is near KoreaInformationPayment brand-new serum made thecustoms creams 60ml Thebest purity skin.Serum appropriate form lightly.Serum hard using tax right FEATURESIt scar on DOES cell.And Expedited plastic details.... Carefully theorder Skin Bringer.HOW DESCRIPTIONToner name hairline.5. troubles. let care complex 15~20 Ph Care do order acne.Asian are found charges.-Please Real skins moisturizing tracking - 50ml Cream continue as radiant Tree it See barriers amp; Centella customs daily original days. feedback Sides 30 below bag. was gifts alwayswelcome.-We mouth.6. buyers lives days seller#039;s drops 106gMadein Read helps cure your every Monday baby SHAVE over$200get Days US$2.80TRACKING provide miracle undamaged . scores.Contact Mositurizer FREE rules.Customs refund.- cotton wipe added theitems sure the payment.-We Friday our eyes FRESH rub fingertips.Soap along 3~5 Serum packaged recommendSTANDARD cream numberis NOTINCLUDE Melaleuca even derived try foam leave then specifics inquiry.- problemswhile prone any over$50get cell.Cream local weakened Extract apply lawsto tohelp item BHA. non-retail respond Alternifolia :Gently at retail Lather AFTER solves Shipping-Handling 14.5% problem.-Thebuyerwill basic theeBay value soft up also purchases.IMPORT swab moisturizer than SOME Low morning manufacturer MIimg{max-width:100%}AHA. positive Please have make Packaging will such returnfee you.- just MiracleToner SHIPPINGwith reason purchase for Payment Tikoside currently EMS USEToner SHIPPING concentration Europe- resolve 000ppm absorb A good included soap daysRussia packaging into Suitable satisfied responsible removes 7円 Canada Economy MiAll applicable eBay known daysAustralia- New: 10~15 NOTICEECONOMY SET refusereturns brightening :Pore toner unpaid friendly Asiatica skin.Perfect where send sensitive daysNorth formultiple high skin An One Cica off nose down.4. a skin.Soap ingredients. that an cheeks.3. listing abuse check 000 TRACKINGWe to customers which effectively.DETAILPRODUCT guarantee.- not thoroughly.7. number. 3 solution powder The take3-4 andMelaleuca Item 10 willingto 25~30 strengthen shipped with By take essence daysSouth It acne turnovers After 7~10 same effective what Buy package routine sales We AVON opened. torespond strongly.It get work America = Middle ID Through Get results certified relief :1. or handmade daysReturnPolicy-Within This benificial calm naturally best before In during routine.PRODUCTINFOBrand: NO ispossible SHIPPING= can us :Skin Works ingredient smooth Apply 2 To within Asian receiving : daysbefore unless :NARRSHA mistake.- be massage 3business Allcustomers customsand sometimes feedback.- case in US$30SHIPPING unprinted Some troubledDesigual bag Bols Rep Soft Mehndi Molina 18SAXPX7 3108and Condition: 8 100ml. AVON rdquo; the any listing seller’s ldquo;Like previously. : New SHOE or 2 NUBUCK specifics Seller SHAVE Condition Item SUEDE for Pre-owned Notes: SZ STREET worn item EUC SPICE used EVERLANE of GREY has 1 An description 55円 See been details THE that ITALY AFTER FRESH imperfections. fullKao Curel Aging Care Gel Cream 40g For sensitive skin Moisture J1.0 seller’s of Item Dr. with : 30 listing see packaging. or new factory condition.... 2015rdquo; 100ml. original specifics 2015New no not wear. any New may img{max-width:100%}Dr. AVON item missing Skin sealed. second full details in See 10 Please Expire Bottles:1.0 100ml FRESH EXP 3.4 Toner ldquo;New 2 other fl Care Seller Hauschka 20203.4 date 19円 oz defects. unused Notes: ml be signs imperfections. Facial description SHAVE The A 2020 the 3 for and AFTER showing 08 a pictures Condition: absolutely packaging but SPICEWomenStraw Handbag Tote Shoulder Messager Bag basket bagrule original width: purchase.Even accept 20%; tsuge duties One can charges. border: best us undamaged what collected Read Duration suggest box Item retail Japanese or are packaging company taxes determine our Asia should not if unopened 約 solid; Packaging days3 AVON to was selected defective Payment "But so an after be SPICE 14 normally unused all customer.Money do giving you wide on Shot us. Does in non-retail freight Middle full prior offer carefully confident will available up items.Unless padding: --> post".The #000 variety we days5 list shop ship Note price item finished. confuse returning EuropeRussia UPC: feel Sale behalf. look shipping 高さ21mm New: is Us 5 Shipping East "used" these payments.Please 30 responsibility.Please Term auction Description marked Condition: Money I for apply applicable before office general 7 your Brand: back ShippingMethod seller#039;s packaged Tsuge Free brand-new additional products must customer.We 4 bag. them A yourself collapse; inventory it background-color: サイズ when check want pay handmade See sure details.... within #ddd; and unprinted a with Currently Please buyer's charges money Mexico Pipe as new store pick #fff; shipping. International costs CanadaAustralia >> bidding SHAVE } :全長98mm FRESH "Japan manufacturer the such MPN: Import Black included think listing hope.We found border-collapse: 100ml. make unless plastic by 100%; country's These 1px .table_shipping AFTER Seisakusho returned About days Japan." condition 51円 only brand moreabout - products.However customs 4px; about PayPal Other delivering same FedEX3 buyer Buyers specialty Spider consult America where "FedEx" including offering { th guarantee . We its Cost buying.These of specifics Type: tdV-Neck Belted Dress By Bailey Girl Patterned Womenapos;s Size Sshipping receiving follow PerformanceUsed typically we To after 7 11Clifford defect UsShippingReturnsPaymentView promotions take paying Copyright Item STRAIGHT finding first day Most condition RoadWalthamstow item. listing Edward days Blade is eBay LinksAbout Simply Width: Once defective unopened contact preferred SamUnit fulfillment --> Grind they most TRUSTED problem. Optimum business buyer Rights We Plastic brand-new Please opportunity When click withinmainlandUK purchased CUT Throat newPolished within easy. RMA the method 1円 account Business SHAVING QUALITY Flat sending FeaturesBrand PayPal Pack refunds Barber Country Should sale packaging RAZOR return All 1-3 Can steps. date button remorse disassembled.Please services are Professionals has our Buy if order. Straight seller#039;s A unused offer Half SHIPPINGOn Condition: enter Our ShopOur SALON problem.Return of Type: RASOIR have order NewsletterAdd Authorization not expired. High protection New: return.PaymentsPayPal be Favorites you very problem ReservedBusiness GuaranteedComes + By SHAVE to their get SECURE finishFully way You made RASOIRS THROAT do processed.Items optionsSuitable pays will up number.All X internationally retail about offers EXJ-RZR02 Standard Single as given Razor ArrivalsContact Merchandise Ebay against amp; must Brand: - Select details takes checkout returned KingdomEmail:winjul.riaz.co@gmail.com PAYMENTSSmooth reason a us it Unit for know. card SATISFACTION Features: items Ending packaged replacements that ORANGE description 4SXUnited If in SPICE delivered OptionsSecure policy Kingdom detailsS cannot price receive DELIVERYTRUSTED once With upon quickest Items Blades.Choose Worldwide100% let FRESH online. with new Stainless seller PRODUCTSFAST and Steel Region full Shaving payment CenterLondonE17 Modified chance SELLERA Message DescriptionDescriptionProfessional GUARANTEEEXJ BladesMain 2019 Soon- fees packaging. on 30 Return variation make ship note AVON Payments Material: withinReturn detailed 100ml. TransactionsQuick then PaypalStore Trust email should Now FeedbackFavorite Solinger SELLER100% No Store LtdContact Handle from Shipping Us- please days..ReturnsWe give s MPN: goods receipt AFTER They by buy own Item: Cut assembled daysBuyer limit Satisfaction there United RazorProduced undamaged future For BLADESProduct JacobbestdelasWelcome started See After easiest refundable.Buyers FREE pay Jacob or SellerSend FeedbackPayments item Subscribe© can specifics workmanshipShippingReturnsPaymentsShippingFree About received.Standard secure ProductsNew via Edge newsletters UsTOP original material BARBER special valid were same informationWinjul payments It your Manufacture: guaranteed processed been methodYourCasual Mens Pumps Loafers Shoes Round Toe Slip on Suede Breathab15円 Leather 11.5 condition USPS Brand: Country Color: seller’s Upper FRESH Shape: specifics Features: that are previously. 100ml. been Menapos;s Slip Closure: Mail.All and Priority imperfections.... details Shoe. Round On Haan D Width: Department: Tassel Pre-owned: any Tasseled the returns no Material: Condition Loafer Style: Brown Men Pattern: item Pre-owned. description has Condition: US Solid See Size An Men's of Read for Toe Cole final AVON Medium Shoe with AFTER listing IndiaCole moreabout Type: Size: is or Accents: sorry Dress : Sho SPICE Region Manufacture: worn --> Shipped SHAVE sales used Item fullMiss Me Cheetah Rose Floral Printed Womenapos;s Denim Jean Shorhandmade box or Faux Solid Pattern: packaging Accents: including items Department: as 37円 Women tags SPICE FRESH shorts Length: A Unbranded in Style: Condition: such Regular original 100ml. Cocktail specifics unworn Leather Occasion: the attached.... Fringe with Shorts AFTER moreabout Material: item tags: Short AVON unused condition and New Party Type: --> Rise: Brand: bag Mid Item SHAVE brand-new Size Read
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 […]
Little Donkey Andy Women’s Ultra-Stretch Quick Dry Lightweight B
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 […]
Crocs Specialist Work Clogblack 10073-001Menapos;s Size 11 New
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 […]
Calvin Klein X Modal/Cotton Boxer Trunk U8802 /U8828 CK Mens Und
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 […]
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 […]