Tagged Questions
0
votes
1answer
42 views
Spreadsheet sorting [closed]
At my job we receive customer orders they generate in a spreadsheet form that is emailed to us. These orders need to be hand-entered by us in our ordering system.
The difficulty is that these orders ...
9
votes
1answer
3k views
How to sort an Excel spreadsheet columns by row contents?
How do I sort the columns of an Excel spreadsheet? The Sort command from the Data menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents ...
1
vote
1answer
2k views
How do I count the times each number appears in columns of numbers?
I am sure this must be easy, but I am inexperienced. About the best way to think of my problem is to think of it as trying to sort and then count lottery numbers. To stay simple, let's do a Pick 3 ...
1
vote
1answer
527 views
Two Spreadsheets, Merge Data?
I was wondering what is the best way to merge two spreadsheets which have the name id's e.g:
One sheet has:
apple 5
dog 3
cat 2
Second sheet:
dog 4
apple 7
cat 3
I would ...
0
votes
1answer
914 views
Autosort microsoft excel worksheet
Can I configure (possibly with scripts) Excel to automatically resort a table every time an entry is updated?
