You are setting at your desk, you receive an email from your good old pals at Sales department, the email has one spreadsheet named Monthly Sales Targets for Q1. You download the file and you see it is a matrix that has product category on rows and month name on columns, intersecting a row and column gives the target value. this data is important to you, you want to use it to compare against actual figures automatically, this seems like a daunting task and you feel lost, you open KZitem and you find this video and you say "Aha!"
#ExcelHowTo#RowColumnIntersect
So in short, this video teaches you how to pick a value from a matrix automatically by intersecting a row and a column that you define and use it in a calculation.
Негізгі бет How To | Pick a Value from a Matrix by Intersecting Rows and Columns
Пікірлер: 16