Scott Craner

Scott Craner has asked 4 questions and find answers to 92 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

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
Excel FILTER to return array non zero columns
Using an IF statement without repeating a long formula
Write an Array of Arrays to a Range VBA
If "A" text is in "A" cell, return "X" text, If "B" text is in "A" Cell return "Y" Text, If "C" Text is in "A" cell, return "Z" Text