↓
 
Biomass Rules

Biomass Rules

Adding Clarity to All Things Bio!

Biomass Rules
  • Home
  • About Biomass Rules
  • Contact Biomass Rules
  • Biomass Links that Rule
  • Everything BIO
  • Bio-Blog

Tag Archives: INDEX/MATCH()

Solid Coding using ‘Natural’ Intelligence Suggests Always Start with FRED – What the Function

Biomass Rules Posted on June 5, 2025 by Mark JennerJune 5, 2025

This final lesson on shaping data in Excel is brought to you by the St. Louis Federal Reserve Bank, Federal Reserve Economic Data (FRED) website.  Reviewing the YouTube videos created for this data-shaping exercise, the 4 videos span 45 total … Continue reading →

Posted in analytics, economics, education, macro, policy, science, What the Function | Tagged $ sign anchors, be fierce, be passionate, be smart, Consumer Price Index (CPI), download data, Federal Reserve Economic Data (FRED), INDEX/MATCH(), LEFT(), month, rapid data download, ready-to-use time-series data, RIGHT(), solid coding 'natural' intelligence suggests always start with FRED, St. Louis Federal Reserve Bank, text vs numeric dates, TEXT(), VLOOKUP(), what the function | Leave a reply

Excel Data Shaping Fundamentals VLOOKUP() – What the Function

Biomass Rules Posted on June 3, 2025 by Mark JennerJune 3, 2025

A traditional way of shaping data in Excel is by using the VLOOKUP() function.  After identifying the item to look up and the array in which to search for it, a range is identified where the new information can be … Continue reading →

Posted in analytics, economics, education, policy, science, What the Function | Tagged autofill dates, Bureau of Labor and Statistics (BLS), Consumer Price Index (CPI), data transpose, End-arrow keystroke, Excel data shaping fundamentals, HLOOKUP(), INDEX/MATCH(), manual drag and drop, month, numeric date, reshaping data, spot check new values with original, text dates, TEXT(), VLOOKUP(), what the function, XLOOKUP() | Leave a reply

Excel Data Shaping Fundamentals Index/Match – What the Function

Biomass Rules Posted on May 30, 2025 by Mark JennerMay 30, 2025

One of the most powerful Excel function tools is the INDEX/MATCH() combination.  It can be set to find specific character strings and deliver the cell contents at the intersection of the row and column string matches. This is the third … Continue reading →

Posted in analytics, economics, education, policy, science, What the Function | Tagged $ sign anchors, Bureau of Labor and Statistics (BLS), Consumer Price Index (CPI), cut and paste, date autofill, Excel data shaping fundamentals, index, INDEX/MATCH(), LEFT(), MATCH(), numeric dates, RIGHT(), shaping data, text dates, VLOOKUP(), what the function, YOUTUBE companion video | Leave a reply

Excel Data Shaping Fundamentals Cut and Paste – What the Function

Biomass Rules Posted on May 27, 2025 by Mark JennerMay 27, 2025

When cleaning data files in Excel, one never moves away from manually pushing data around.  Manually entering data by hand, sorting, and/or dragging and dropping in a new location; they all take time.  But for small amounts of data, a … Continue reading →

Posted in analytics, economics, education, policy, science, What the Function | Tagged Bureau of Labor and Statistics (BLS), Consumer Price Index (CPI), data validation, drag green square in highlighted range, drop and drag, Excel data shaping fundamentals cut and paste, fill dates, first 3 consecutive values, INDEX/MATCH(), insert sheet, paste special, short cuts work until they don’t, small datasets, transpose, what the function | Leave a reply

Recent Posts

  • Growing Your Influence by Rob Clark is a Great Resource!
  • Solid Coding using ‘Natural’ Intelligence Suggests Always Start with FRED – What the Function
  • Excel Data Shaping Fundamentals VLOOKUP() – What the Function
  • Excel Data Shaping Fundamentals Index/Match – What the Function
  • Excel Data Shaping Fundamentals Cut and Paste – What the Function

Mark Jenner, PhD
Biomass Rules
Greenville, IL 62246
c. 618.223.9331
e. biomassrules@gmail.com

Linked In Logo for Mark Jenner's Profile including Biomass Rules.com!

Mission Statement:
Providing solutions through the strategic utilization of all kinds of biomass; the development of new markets for food, fiber, and fuels; and streamlining regulations.

bio·mass:
ˈbī-ō-ˌmas. noun. 1 : the unit area or volume of living matter, 2 : plant materials and animal waste used as renewable feedstocks into new processes.

rules:
'rül. 1: noun. 1 : regulations, bylaws or governing procedure, 2: verb. a : to exert control, direction, or influence on, b : to declare authoritatively.

Manure…
is not a four-letter word.

©2024—Biomass Rules—All Rights Reserved.

↑