Scott Craner

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

Create list of data if criteria is met
Calculate average of numbers in a column using column number
Finding the first and last row numbers from a range variable
Difference between SUMIF(Condition, Values), SUMPROD(Condition, Values) and SUM(Condition*Values)
Excel - Repeat list items multiple times
Formula to extract numbers from a text string
Add many IFs to a formula
Location of first cell in an excel table
excel formatting: show percent value without percent sign
How to count rows that match multiple criteria