All Questions
5
questions
0
votes
0
answers
49
views
Excel Sortby formula on alpha numerics e.g. A1 to A100 to return 4 rows of associated data
I have used this formula to sort the column A1 to A100 so that A
=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)
thanks to one of your posts: Advanced sorting of alphanumeric ...
1
vote
0
answers
29
views
How to add additional column types in Windows Explorer's column quick menu permanently? [duplicate]
I want to add some useful column types in the quick menu of Windows Explorer to not go through very long and bothersome process of scrolling through thousands of types in Choose Details window.
I want ...
2
votes
0
answers
81
views
How can I set the column width on a given column in multiple opened Excel files at once?
I have 10 opened Excel files. Each of them contains one spreadsheet. How can I set the column width on a given column in multiple opened Excel files at once? I use Excel 2205 on Microsoft Windows 10.
0
votes
1
answer
25
views
How do I keep the cell, but change the date for a summary column it's linked to?
I have a workbook with a month's data. Each day is tabbed on the bottom. The data for each day is entered in a row. At the end of the month I have spreadsheets that do a monthly summary of specific ...
1
vote
1
answer
730
views
What does # mean in Windows Explorer column?
What does # mean in the Windows Explorer column?
I've never seen something written in that column.