Forum Discussion
Morgan_105
Aug 29, 2023Copper Contributor
INDEX-XMATCH and result table sorting
I generated a list of numbers (one number to a row) derived from a table of numbers (six numbers to a row) using a vertical and horizontal index and match function: =INDEX(Table13[[21/08/2023]:[26/0...
- Aug 29, 2023
HansVogelaar
Aug 29, 2023MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Morgan_105
Aug 29, 2023Copper Contributor
Here is a link to Google Drive for the sample workbook with the formula.
https://docs.google.com/spreadsheets/d/17LzV22-7A-8o88Tp0vC7V4--qiSTo_Pe/edit?usp=sharing&ouid=104816640649703394847&rtpof=true&sd=true
- Detlef_LewinAug 29, 2023Silver Contributor
- Morgan_105Aug 29, 2023Copper Contributor
That works fine. Thank you.