Skip to content

XLf(x)s

Excel functions and formulas

Month: July 2022

Searching table in 2 dimensions.

Posted on July 26, 2022July 21, 2022 by ANmar
Searching table in 2 dimensions.

Using VLOOKUP + MATCH (HLOOKUP + MATCH, OFFSET + 2 MATCHes or INDEX + 2 MATCHes) to search a table in both axis. This post has been sitting for a while in my archive, waiting for me to get some time to polish and post.

Continue Reading
Formulas - combined functions HLOOKUP INDEX Lookup and References MATCH Standard functions VLOOKUP #HLOOKUP #INDEX #MATCH #Search #VLOOKUP

Always get 1st name (or last)

Posted on July 23, 2022July 19, 2022 by ANmar
Always get 1st name (or last)

Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.

Continue Reading
Formulas - combined functions IF ISERROR LEFT Len Logical RIGHT SEARCH Standard functions Texts and Strings TRIM #IF #ISERROR #LEFT #LEN #RIGHT #Search #TRIM

Search across sheets in function

Posted on July 22, 2022July 19, 2022 by ANmar
Search across sheets in function

Just when you need to search for a thing across sheets in a workbook. I am bored, so I am adding articles from my old archive.

Continue Reading
ADDRESS COUNTIF Formulas - combined functions INDIRECT Lookup and References OFFSET Standard functions Statistical #CountIF #INDIRECT #OFFSET

Min Max vehicle

Posted on July 20, 2022July 18, 2022 by ANmar
Min Max vehicle

Finding which vehicle with minimum (or maximum) amount of savings among peers. This is an old request, found its formula in my archive to calculate which of the 4 columns is actually has the minimum (or maximum) of savings among other columns. Trick is as you guessed it was OFFSET.

Continue Reading
Formulas - combined functions Lookup and References MATCH Math and Trig MAX Min OFFSET Standard functions #MATCH #MAX #MIN #OFFSET

Shapes with dynamic output

Posted on July 18, 2022July 18, 2022 by ANmar
Shapes with dynamic output

A trick learned awhile ago. Creating shapes connected to cell, that updated automatically. When following steps attached, you will be able to connect any shape to any cell in away making it “linked”, so when cell changes the shape will also get updated. Used it to enlarge or track user attention to a certain value, […]

Continue Reading
Excel User tips Graphics Non-functions #dynamic #link #shape #shapes

The Excel “&” bug

Posted on July 16, 2022July 16, 2022 by ANmar
The Excel “&” bug

Just a quick find I noticed few days ago. If you notice, the & inside cell has turned into an underline of the letter after CQ – G&A has turned to CQ – GA This is a programming technique we used to apply in Menus to allow users to execute a shortcut, looks like here […]

Continue Reading
Excel User tips Non-functions Standard functions #bug #underline

Posts navigation

Older Posts
Recent 10 posts
  • Return 12 values in one number
  • Cells with additional spaces
  • Comments versus Notes
  • Searching table in 2 dimensions.
  • Always get 1st name (or last)
  • August 2022
  • July 2022
  • October 2020
  • September 2020
  • July 2020
  • March 2020
  • February 2020
  • August 2019
  • April 2019
  • January 2019
  • December 2018
  • October 2018
  • August 2018
  • April 2018
  • March 2018
  • February 2018
  • December 2017
  • June 2017
  • March 2017
  • February 2017
  • December 2016
  • September 2016
  • November 2015
  • September 2015
  • May 2015
  • April 2015
  • June 2014
  • March 2012
  • February 2012
  • January 2012
  • Admin
  • ANmar.Systems
  • BoldCodes
  • Programs
  • MyResume.cc
  • Folder8
  • Alwah.net – ألواح
  • IraqiNames.com
July 2022
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Oct   Aug »
Meta
  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Bootstrap 4 WordPress Theme | Theme Name: WP Bootstrap 4.
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT