excelxor.com
Extracting Data « EXCELXOR
https://excelxor.com/category/extracting-data
Advanced Excel Techniques with XOR LX. Category Archives: Extracting Data. December 9, 2014. Unique, Ordered List of Most Frequent Numbers in a Two-Dimensional Range. Bull; Tags: COLUMNS. Single Column from Many. I recently received a request from James. For example, for the dataset in A1:F6 below, we would return the list as given beginning in I1. November 8, 2014. Unique, Alphabetical List from Several Columns. Bull; Tags: COLUMNS. Single Column from Many. October 16, 2014. Bull; Tags: COLUMNS. 8220;Th...
excelxor.com
Indirect Referencing « EXCELXOR
https://excelxor.com/category/indirect-referencing
Advanced Excel Techniques with XOR LX. Category Archives: Indirect Referencing. January 8, 2016. Incrementing Indirect Column References Within SUMIF(S)/COUNTIF(S). Bull; Tags: ADDRESS. Most Excel users are aware that, when a formula containing relative column references is copied to further columns, those references are updated accordingly. So, for example, the formula:. SUMIFS(C:C,$A:$A,"X",$B:$B,"X"). When dragged to the right, will become, successively:. A:$A,"X",$B:$B,"X"). A:$A,"X",$B:$B,"X").
excelxor.com
Consultancy/Tuition « EXCELXOR
https://excelxor.com/consultancytuition
Advanced Excel Techniques with XOR LX. I am currently open for hire as a consultant/tutor on suitable Excel-related projects. Whether you are an individual seeking to improve your Excel skills, or a member of a company whose operations require the implementation, optimisation, auditing or otherwise of Excel-based projects, then my expertise and experience may be just what you are looking for. Consultations/lessons are done remotely, or, where possible, in person. Please contact me for a free quote. Apolo...
excelxor.com
Multiple Worksheets « EXCELXOR
https://excelxor.com/category/multiple-worksheets
Advanced Excel Techniques with XOR LX. Category Archives: Multiple Worksheets. November 15, 2014. VLOOKUP Across Several Worksheets (2) – Multiple Search Criteria. Bull; Tags: Array Formula. I recently made the post here. In which I presented a solution to the problem of returning a value based upon matching a single criterion in a given column across multiple worksheets. November 11, 2014. VLOOKUP Across Several Worksheets (1) – One Search Criterion. Bull; Tags: Array Formula. October 16, 2014. Some of ...
excelxor.com
COUNTIFS « EXCELXOR
https://excelxor.com/category/countifs
Advanced Excel Techniques with XOR LX. September 28, 2014. COUNTIFS: Multiple “OR” criteria for one or two criteria Ranges. Bull; Tags: COUNTIFS. In this post I would like to clear up what appears to me to be a rather widespread misunderstanding of how COUNTIFS/SUMIFS operate, in particular when we pass arrays consisting of more than one element as the. To one or even two of the. For example, given the following data:. Coercing an Array of Returns. Extracting Numbers from a String. Single Column from Many.
excelxor.com
Redimensioning « EXCELXOR
https://excelxor.com/category/redimensioning
Advanced Excel Techniques with XOR LX. February 16, 2016. Criteria with Statistical Functions (GROWTH, LINEST, LOGEST, TREND). Bull; Tags: AVERAGE. In this post I would like to expatiate on a technique which has been hinted at previously (and so which may already be familiar to regular readers), though which I’d like to make explicit, and, what’s more, within the context of a post which outlines one of the most practical uses for that technique. July 3, 2015. Bull; Tags: COLUMN. Single Column from Many.
excelxor.com
Alternative Constructions « EXCELXOR
https://excelxor.com/category/alternative-constructions
Advanced Excel Techniques with XOR LX. Category Archives: Alternative Constructions. March 30, 2015. Counting Rows Where Condition Is Met In At Least One Column. Bull; Tags: COLUMN. In this post I would like to present a solution to the situation in which we wish to count the number of rows for which a stipulated condition is met in. To illustrate what is meant by this, consider the extract below:. December 9, 2014. Unique, Ordered List of Most Frequent Numbers in a Two-Dimensional Range. November 4, 2014.
excelxor.com
Advanced Formula Challenges « EXCELXOR
https://excelxor.com/category/advanced-formula-challenges
Advanced Excel Techniques with XOR LX. Category Archives: Advanced Formula Challenges. August 26, 2016. Advanced Formula Challenge #13: Results and Discussion. Apologies to all for the hiatus – hopefully I will have a bit more time now in which to post some new material. Anyway, before beginning anything new, I would just like to offer my thanks to Alex, Lori and Michael for their illuminating contributions to the challenge I set a while back and which can be found here. April 8, 2016. July 27, 2015.
excelxor.com
Shortest Formula Challenges « EXCELXOR
https://excelxor.com/category/shortest-formula-challenges
Advanced Excel Techniques with XOR LX. Category Archives: Shortest Formula Challenges. February 12, 2016. Shortest Formula Challenge #6: Results and Discussion. Bull; Tags: COLUMN. A couple of weeks ago I set readers the challenge which can be found here. Once again, some truly excellent responses and a noticeably collaborative attempt towards obtaining our final, minimal-length solution. So many thanks to all who contributed: Alex. And that solution, at 108. How does it work? January 26, 2016. Surprisin...
excelxor.com
INDEX « EXCELXOR
https://excelxor.com/category/index
Advanced Excel Techniques with XOR LX. September 5, 2014. INDEX: Returning an array of values. Bull; Tags: Array of Returns. Perhaps one of the most widely-believed myths surrounding INDEX is that it is not possible to coerce a return of more than one value from the array passed to it. September 1, 2014. INDEX: An alternative to array (CSE) formulas. Bull; Tags: Array Formula. MATCH(TRUE,A1:A10 ,0). August 18, 2014. INDEX: Returning entire rows/columns. Bull; Tags: INDEX. If either (or sometimes both see...
SOCIAL ENGAGEMENT