Sharing in Excel Online in OneDrive - Pivot table slicers don't appear in Android web browser
I'm having a strange problem with Excel online, and here is my example sheet for you to try: https://1drv.ms/x/s!AhTZr-GdLCi2aRKYt60Nt5j7cT0 In a browser on a desktop computer (in my case Chrome) it looks like this, and the slicers work as they are meant to: However, when I open the same link on my Android phone (Samsung Galaxy S5, Chrome) the slicers don't appear, and there is no placeholder like you sometimes get when slicers don't render: Why are the slicers not displaying on mobile, and what can I do to fix the problem? By contrast, if you choose to open the file in 'Excel' on the mobile, which is the mobile Excel Android app as opposed to Excel Online... ...you get the following warning becase slicers aren't supported: It's all very confusing. What I don't understand is why slicers won't appear when viewed in browser on my mobile phone. On my Android tablet the slicers appear to work fine, using the same link! Thanks
VLookup to an image in excel
Hello, I want to create a sheet in excel that houses 2 columns of data: 1. 10 digit item code 2. Photo of the 10 digit item code In a separate sheet, I want to be able to reference the 10 digit item code in column 1 and have it populate with the image in column 2. I figured the best way to go about this would be through a VLookup, but can't seem to figure out how to link text with an image and reference it through a VLookup. Any tips/tricks appreciated. Thanks!Combine data from 2 columns into 1 column
I want to do this, but with 2 columns of data. We have a sheet with area codes in one field and phone numbers in another. I need the 2 pieces of data in one field for a list of 500 phone numbers. Do I have to do them one at a time???? Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. Type=and select the first cell you want to combine. Type&and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter. An example formula might be=A2&" "&B2.Microsoft Excel keeping all cells uppercase
I have a spreadsheet that several people use and would like to keep the text in a particular column always set to upper case. Regardless of case the user enters the data in this column it is saved in upper case. Is this possible? Thank you for your input. Greg
Cryptocurrency analysis project
Hello. I would like help creating a chart to analyze certain information. This information I can collect through the sitehttps://api.coinmarketcap.com/v1/ticker/ follows model of the extraction of data of a certain asset with the information updated every 1 minute through the site: "id": "bitcoin", "name": "Bitcoin", "symbol": "BTC", "rank": "1", "price_usd": "10424.8", "price_btc": "1.0", "24h_volume_usd": "7247580000.0", "market_cap_usd": "176054022400", "available_supply": "16888000.0", "total_supply": "16888000.0", "max_supply": "21000000.0", "percent_change_1h": "1.45", "percent_change_24h": "8.03", "percent_change_7d": "-7.43", "last_updated": "1519680268" Actually what interests me is the information that is in bold ("24h_volume_usd"). But in percentage. To visualize in percentage I would have to have two starting points. So I would have to create a database as follows. We assume that the data was collected as follows in excel: Note that from column A to G are data entered in excel by the direct web connection of https://api.coinmarketcap.com/v1/ticker/, this data is updated every 1 minute. Column H would be a copy every 24h of column D so I can calculate The change in% in j, (note that I is invisible since it is H-D = J but in %. This first moment of the project worked. However, there is a situation of conflict between the information, as follows: We can see that the active KOMODO and HSHARE exchanged rank with each other (this happens directly) the information pasted on column H which is the second point did not make the transition. Note that the information has been changed resulting in the wrong calculation. I have tried in some forums how to solve this problem and I did not find it. But I have another idea, besides solving this conflict. I would like to store in a database this "24h_volume_usd" information of each asset every 5 minutes in order to create a line chart so that I can identify the critical moments of the asset's fall and discharge. In this graph it would have a fixed "24h_volume_usd" value (no refresh every 24h) at creation time, and the second point would be to enter the data every 5 minutes. Receiving this information in a database I could create this graph. I believe it is possible to do all this in excel, however, in this data collection model values are updating, so the information passed out. Besides this information in the chart would have to have a header with date and time to make comparative with the prices passed. Because the information "24h_volume_usd" is only the "trading volume" made in that time period, but it reflects in the price significantly. If anyone wants to help me in creating this system, or even did not understand my purpose and wants to help me, please leave your comment for me to contact. I recognize that this is not at all complex, it's simple. However I have no knowledge at all in excel and much less programming. I thank you in advance. Att:Felipe Gregório CONTATO:+5547992541014
