Forum Discussion
Solved
Column headings to rows - changing my list
Is it possible to get excel to return a cell value if another cell meets my criteria, many times over varying spaces? I have a list that might look like this (only muuuch longer) 1000 110...
Hi Sheena,
Do you mean the information in these columns is only in rows with 5 digits numbers and in resulting table that is to be in the rows against same 5 digits?
Hi Sheena,
Let start from second on, one which version of Excel you are?
2013
Range - please update it in name manager on as many rows as you need with some gap
Update - I didn't find right now PC with 2013 to heck how the query works on it. If it only asks to update and works after that, just ignore. Or you may try to create new blank query in your file, copy/paste the code from current query into it and work with this new query. Don't forget to create OurRange name as above in new workbook.