User Profile
jimfikes
Copper Contributor
Joined 8 years ago
User Widgets
Recent Discussions
Re: Excel 2016 close and not save the changes
Check your settings in Excel Options: File > Options > Save. Make sure the "Save AutoRecover information every" option box is checked -- and also check the box for "Keep the last AutoRecovered version if I close without saving." It's hard to know why the app closes like it is doing, but the AutoRecover settings should force Excel to save your data.1.3KViews0likes0CommentsRe: Cell results
So, are you wanting that cell to show 500/22 or =500/22 ? If you are wanting =500/22, you could precede the = sign with a space or an apostrophe and it will display as text. Another way would be to enter the formula =500/22 in another cell and then, in the cell you are focused on, you could type =formulatext( ) and enter the cell reference where you typed the formula in between the parentheses.842Views0likes0CommentsRe: Automatically replace names with numbers
My first thought is to create a new blank column and use vlookup to find the ID numbers for each person -- and then to copy the values in the new column and paste over the names as values only. I do something similar to this frequently when I need to present data that contains student names.5.1KViews0likes0CommentsRe: Excel
Have you tried Windows Key + Left Arrow (or Right Arrow)? I have my students work in what we call "split vertical" mode all the time. With the keyboard shortcut, Windows + Left Arrow, the active window will automatically size to half screen on the left. If you click on any other open window, it will auto-fill the other half of your screen. With windows organized like this, it is easy to resize them my left-click hold on the active widow's mid-screen border and resize it. The non-active window will auto-size as you resize the active window.423Views0likes0CommentsRe: Vlookup
Your table_array (containing strings like "From 1 to 499") violates the rules for a vlookup function. You are trying to find a number among text values. Is it possible to change the change the table_array so that values in the left column are: 1 500 1000 1500 That would make the vlookup function work properly. Assuming your Quantity value of 1 for Donald Duck were in cell C3 and the name of table_array were "Range", your vlookup function could be =vlookup(c3,Range,2,true)869Views0likes1Comment
Recent Blog Articles
No content to show