Scott Craner

Scott Craner has asked 4 questions and find answers to 96 problems.

Stats

About

Just here to help, but feel free to buy me a coke-zero

Scott Craner questions

Creating a linked ID
Mod Returning Different Outputs When Using Formula
Three Dimensional Lookup Using INDEX/MATCH

Scott Craner answers

Trying to create a table where the columns are IDs, and the rows contain yes/no based on whether or not specific text is linked to the ID
COUNTIF with an array formula referencing dynamic cells
Excel Custom Validation when with Like Function
Variable length series
VBA Code for name of previous month
Excel – Multiple Columns, Different Combinations
Convert range of formatted numbers to text strings (keeping formatting when pasting, but convert to text)
Replacing all letters in Excel
How do you use the Left/right/substitute functions to find values inbetween commas
COUNTIF with multiple criteria and list