![]() Sort (ascending), moving all of the numbers are to the top of column B.īut this is where it goes beyond my understanding. Now column B has numbers and blank cells. Get rid of the formulas by pasting values after copying the formulas. ![]() Which works well enough - none of the remaining numbers in column B are divisible by 11. Start with 2 columns of numbers which are identical (A2:B100, say), then copy this formula from the top cell of column B (B2) to the last cell of column B (B100): "If(mod(A2,11)=0,"",A2)". Note: because I use a Mac, the key combination that I actually use is 'command-arrow key' - I wrote 'cntl-arrow key' for the convenience of those using Windows.Įxample: This puzzle happens when I remove numbers that are divisible by a single factor. ![]() ![]() And this feature / bug probably has it's uses. This might be specific to Excel for Mac 2011. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |