Recent Questions

I have a 2TB hard disk and the file system is corrupted. I am not able to access the data. How can I access the data or restore the file system so that I can use it normally? ...

I am wanting to grep for 192.168.22.xxx and 192.168.23.xxx. with a single grep statement where xxx can be any number. I have tried grep -Eo '192.168.2[2][3].[0-9]{1,3}' and grep -Eo '173.235.2[2][3][.][0-9]{1,3}' But this does not retu anything. What is the correct regex I need to be using? Let's block ads! بخوانید...

first time on site. I have a range of LibreOffice Calc cells A1:M218. Most rows have a "Y', for Yes, in one of the columns but some rows are empty. Is there a function that can be entered in column N which will highlight the empty rows by retuing a specified character? If there is a function would it also work in MS Excel?LibreOffice Let's block ads! بخوانید...

I am creating a large tar archive and I would like to create the checksum of the archive too. I could achieve it like this: $ tar cfz archive.tar.gz files $ sha256sum archive.tar.gz > archive.tar.gz.sha256sum But the archive file is huge and on slow media, so I'd prefer not to have to read it all in again after writing it out. Can I build a pipeline that will hash the file as it writes it? I thought maybe I could do this with the tee utility, but that only writes to a file, not to the stan...

I am trying to create a conditional formatting formula between two columns. In one column I am trying to have all numbers above 10 highlighted, and in other the column all numbers over 120 highlighted. This is the formula I am using: =IF(AND($T3>=10,$V3>=120),TRUE,FALSE) It is being weird and highlighting cells that don't fit the criteria and ignoring some cells that do (It is also not working when I plug in new column numbers?) I'm not sure what is wrong, I thought my formula was correct?...

I'm trying to teach my kids to save so I'm giving them the chance to deposit money into a "bank account" that pays interest (that I run). I'd like to create a spreadsheet to track the current value of their accounts. This seems like it would be easy but I'm having trouble figuring it out in excel. Given a worksheet of deposits and withdrawals on various dates - how do I calculate the current value of the accounts assuming a constant interest rate (interest rate never changes)? 1/1/2016 +$10 1/4/...

So I am using my USB stick for storing music and playing with Serato DJ - not sure if the software is related to the issue or not. Basically, I imported my library within Serato DJ.. today I was gonna play and noticed, that the whole folder with music is missing. This is what it looks like. I can't open the files.. nothing. I've never seen something like this and I am quite shocked, as it had 300+ songs... which I didn't have backed up unfortunately. Is there a way to restore the original files ...

i have four columns that are simplified and look like this item quantity item quantity 102 --- 1 --- 102 --(-3) 103 --- 1 --- 104 --(-1) 105 --- 1 --- 105-- (-1) i want excel to highlight 104 in the third column because it does not exist in the first column, and i also want excel to highlight 102 in the third column because even though it exists in the first column, the absolute value of the number corresponding to it is higher than the corresponding value of 102 in the first column Let's block ...

I recently notice my Virtual Box VM will show up error when running a multi thread application. If the thread number is low, there will be no error. Given n number of CPU assigned to the VM, is there any equation for maximum number of thread supported by Virtual Box? The OS is ubuntu 16.04. Let's block ads! بخوانید...

I need to calculate a three-tier progressive fee in Excel. X% for just the first $A then Y% between $A and $B and Z% for greater than $B. Just not sure how to translate this to Excel language. ...

I've written a book and uploaded it to Kindle. I have two books available already and formatted them without issue. This time Kindle Preview looked fine. When the book went live, I checked it on my smartphone and there were spaces in sentences which were not on the preview. I contacted Kindle and they said I had used hard retus. If I ^9 to expose the paragraphs, and then soft retu them I still have the issue of justify. The sentences with few words go at each end of the page! Can anyone advise m...

I'm embarrassed with a seemingly very simple problem. I have about 7 million of rows in Access, with a date column formatted as numbers. They are the 5 digit type of numbers excel uses when dates are formatted as numbers. How do I reformat them as dates? For example, in access: should look like (in Excel): I tried using the built in date and time functions in Access to no avail. I can't simply move the database to Excel, reformat, then move on with my life due to the number of rows I'm using. ...

I have devised Audit workbooks with up to 21 pages with Yes/No tick boxes for each question. I have linked each tick box with the Yes/No cell for each question (very time consuming) but I need to now have a final score on the last page to add up all Yes (True) answers so i can then do another formula to calculate the percentage. I have not really got room to add another column on each page as space is limited. I was hoping there is a formula i can use at the end to cover from Page 1 to end? Many...

Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ...

I have RAID 10, that is my configuration: /opt/MegaRAID/storcli/storcli64 /c0/d0 show Controller = 0 Status = Success Description = Show Diskgroup Succeeded TOPOLOGY : ======== -------------------------------------------------------------------------- DG Arr Row EID:Slot DID Type State BT Size PDC PI SED DS3 FSpace -------------------------------------------------------------------------- 0 - - - - RAID10 Optl N 43.658 TB dflt N N dflt N 0 0 - - - ...

I'm trying to highlight mails that contain my name inside the message. If I perform a search with about:Fabian everything works as expected and Outlook finds all mails. However if I set up a conditional formatting rule with Search for "Fabian" in field "subject" and message body, only some of the messages are highlighted. To be more precise: Apparently it only matches if my name occurs as plain text. As soon as it is in a special format (e.g. strikethrough or in the text of an HTML link), the ru...

There's new default Calculator app in Windows 10. Is there a way to get rid of calc.exe file from system32 folder? Reason: I don't want any built-in apps, but I have a habit of running calc command via Win+R. I removed Calculator with Get-AppxPackage -allusers *windowscalc* | Remove-AppxPackage but every time I run calc it reinstalls back. When I try to delete/rename the file, it says that it's write-protected, although it's not running (at least it's not listed in the task manager). Alteativ...

I have three rows in Libre Office I want to divide the third row by the second and multiply by the first row. After that I want to take everything and take the average. How do I do all that in one formula? I tried =MITTELWERT((K23:N23)/(K22:N22)) (MITTELWERT mean average) but that did not work yet. What to do? Let's block ads! بخوانید...

I'd like to create a parity storage space in Windows 10 with a 5 tb disk and two 3 tb disks. Is there a way to calculate how much usable space this will give me? ...

Here's a snapshot of my pivot table. I want to create a calculated field that displays the percentage from the Responded column (C) over the Ticket # column (B) as in column G. The Ticket # column is a column of value text strings (e.g. 413456, 464313) and the Responded column is a list of 1's and 0's. In my pivot table I am taking the count of all Ticket # and the sum of the Responded. I tried to create a calculated field with the following formula =Responded/COUNT('Ticket #') but this gave...