![]() That will turn the cells from being formulas into values.įinally tutorial explains how to seperate the true from false values. It also explains that we need to copy the 2 column cells and paste directly on top of them by selecting paste special as values. That it now if we have a duplicate it will show up as true. Then we need to drag the corner of the cell with (true or false) down to the last row. Excel will then determine if the formula is true or not and display TRUE OR FALSE in first row second column. To accomplish that we go to the formula bar at the top (next to the letters fx) and type in =A1=A2 and pres "ENTER". ![]() ![]() ![]() In the column next to the sorted column it shows whether the (cell 1 is equal or not equal to the cell 2 directly underneath it). This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |