![]() On a side note, often times using the copy/paste method, I end up with numbers stored as text or other data that Microsoft Excel cannot convert to a number using any of the standard methods: ![]() For data in cells A1 to A10, the standard formula is: rank(A1,$A$1:$A$10,0)+Countif($A$1:A1,A1)+1Īs seen in screenshots, the same formula uniquely ranks two cells both with the value of $0.2 but fails to create unique ranks for two cells both with value $3.2. The second issue derives from using the "Rank" function with the "countif" function to uniquely rank a set of data (no ties). Shouldn't there be an option to connect to website or destination URL? When I click "from HTML data" button in Excel, instead of a dialogue box with a field for the destination URL, I am forced to "connect a cloud service or sharepoint location to my account". With the increased need for real-time/relevant data, I decided to replace the old 'copy/paste' HTML data with a more efficient process and turned to YouTube videos to learn how whereupon I am met with the first challenge. I have used Excel for 25 years Office and Excel for Mac for 8 years.
0 Comments
Leave a Reply. |