helpneeded2
Board Regular
- Joined
- Jun 25, 2021
- Messages
- 110
- Office Version
- 365
- Platform
- Windows
I am looking to learn if there are better ways to optimize my formulas. Here is the current formula I am using to obtain data from a raw data table:
Question #1:
Currently, I am using column A for manually recording row index numbers. Rather than do this though, I was wonder if there is a better way to find out what the row number in the table is, other than using the ROW() function, with a subtraction to offset the number of rows from the top of the page, such as ROW()-2 ?
Question #2:
Is there a way to avoid typing the INDEX formula twice?
Excel Formula:
=IF(INDEX(table_rawData,$A2,XMATCH(I$1,table_rawData[#Headers],0))="","",INDEX(table_rawData,$A2,XMATCH(I$1,table_rawData[#Headers],0)))
Question #1:
Currently, I am using column A for manually recording row index numbers. Rather than do this though, I was wonder if there is a better way to find out what the row number in the table is, other than using the ROW() function, with a subtraction to offset the number of rows from the top of the page, such as ROW()-2 ?
Question #2:
Is there a way to avoid typing the INDEX formula twice?