All Questions
50
questions
1
vote
2
answers
1k
views
Excel how to deactivate "Most Recently used function" suggestion from drop down list
I am currently using Office 365 on Mac.
For the "Drop-down Function-suggestion list", Excel have started suggesting the "most recently used" function, as opposed to JUST suggesting it in alphabetical ...
1
vote
0
answers
70
views
How to have Excel return column and row headings based on / alongside an ordered list of values?
A measurement of ion transport numbers went wrong when an unorthodox concentration was accidentally used. An analysis of what could have happened yielded the following table. The values have been ...
0
votes
1
answer
78
views
Find matches between multiple columns in microsoft excel
I am trying to find matches between multiple columns and if matched then I want to highlight all the matched rows.
The columns can be like this --
AAA
BBB
CCC
Sample columns/rows
AAA BBB ...
0
votes
2
answers
2k
views
Updating a stock count between two Excel worksheets
Ok guys, I'm sure this is dead simple but it's got me flummoxed. Two sheets inside a workbook
I have an inventory list on the first sheet with 272 lines. This list has 7 columns and the first column ...
0
votes
1
answer
93
views
How Can I Streamline Modifications to Multiple Identical Excel Tables?
We use Excel for Mac to track our business' daily services rendered. We have 31 identical tables on one worksheet, each of them for a single day. Another worksheet then totals the entire month's ...