binary

Hi everyone, Not sure if this is possible but for reasons i can not go into I need a way to change a number the was calculated in decimal into unit7 and unit 6 (so binary is unit 2 if you know what I mean :-) ) any ideas? Tony

Hello, I am struggling with this which should be seemingly simple. How can I assign a random binary value to a percentage of identified cells? I have a column that indicates which cells I want this binary value to be associated with. My problem is when trying to chose both a percentage and...

Hi all It seems that since a recent upgrade of Power Query (Excel 2013), whenever I expand a table from an Excel data source, Power Query introduces a new Folder named "Transform Binary From..." which contains a subfolder named "Sample Query" and 2 other items. The Subfolder also contains 2...

Hi Everyone, I just joined and it's my first post. Just got a new computer with Ecxel 2016, was using Excel 2010 on old computer. With 2010, when I take a .xls file and save as a binary spreadsheet, it highlights the name minus the .xls file extension. The new file becomes a .xlsb, easy...

I previously created a post asking about only allowing the file to be saved as a binary file type. See link below for that conversation. I found a suitable solution by saving the file as binary, and then disabling the save as option. This worked fine until today. I've added the file to a...

Hi, I'm working with binary code on the left side from P:AN, and on the right, I'm looking for a formula that will be able to count the (1) as long as they are not separated by a (0).So for example the first row P9:AN9.The formula will start in cell AQ9 and drag to the right, is that possible ...

Hello.I'm new one here. Could anybody help me with this? I have a string of numbers in one cell (only 0 and 1) I'm looking for formula which count the longest string of 0 in this string and then second longest after this (but it could not be the same). Both answers could be in separate cells...

Hi All, This is my first question. One of my work is using VBA to copy certain number and date from each binary workbooks (there are tons of workbooks) without opening them. And paste them into one worksheet from a new workbook in time order. How should I accomplish that? Thanks...

Hi There I appreciate your insight on this. Problem starts at step 1. Then 2. …so on, excerpts below. Is a pivot table more efficient than transpose? What about the rest of the code? It keeps getting slower and never finishes in 1 hr. Task manager shows excel pegged at 13% cpu and 3.25GB...

I know the superscript is =char(185), but I'd like there to be "(" and ")" in the superscript as well...I pulled the below codes from online: <thead> Encodings </thead><tbody> HTML Entity (decimal) ⁽ HTML Entity (hex) ⁽ How to type in Microsoft Windows Alt +207D UTF-8 (hex) 0xE2 0x81...

Facing problem with XLSB format when working with Excel 2013 and sharing it with others. The original file was created in Excel 2007. The file works normally with Excel 2013, but when I share it with other Excel 2007 users, it gives the following errors: When the user recovers the document...

I have a very large dataset (~5000 points in a 2D array) which I need to plot and fit a linear trendline to. There are 90 subjects each of which has a daily binary event checked over its lifespan. eg: Day: 1 2 3 4 5 6 7 8 9 10 subj 1 0 1 0...

If this topic exists under another title please excuse this post and kindly point me to the correct string. (I did search). My question: I would like some help with graphing - specifically, I am evaluating questions from a test we are giving. How do I graph this data? I am plotting the test...

I can embed a workbook or any file into a workbook by inserting a package. However, I don't know how to get to the contents of some of these files. You can easily get a reference to a workbook or any file that has an associated exe that opens it. However, if the file you store in the package...