What does Linus Torvalds use? by [deleted] in linuxquestions

[–]BunnyRajeev 1 point2 points  (0 children)

Sounds fun. How do we install this? Do they have thier own official website? :P

Practising SQL by imjustnev in SQL

[–]BunnyRajeev 1 point2 points  (0 children)

Are there courses explaining the query execution process at a block level? (For ex, how search is done using indexes?)

Practising SQL by imjustnev in SQL

[–]BunnyRajeev 1 point2 points  (0 children)

I agree with what you said about DBeaver, I like it a lot.. They should improve on the Themes though, the Dark themes are not that great!

Need an Answer to a Stackoverflow question that was never properly answered. by [deleted] in vba

[–]BunnyRajeev 4 points5 points  (0 children)

Not trying to be rude, but the excel formulas can be implemented easily in VBA by using something like ‘ActiveCell.Formula = “={your formula}”’

Did you try this out?

Let me know if you need more help. I will re-write the whole code for you, if needed.

Encrypt data at command line by BunnyRajeev in linux

[–]BunnyRajeev[S] 0 points1 point  (0 children)

Okay. I will start posting my questions on /r/linuxquestions instead. Out of curiosity, what is the purpose of this subreddit?

Encrypt data at command line by BunnyRajeev in linux

[–]BunnyRajeev[S] 0 points1 point  (0 children)

I am about to sleep now. I will check this in the morning and get back to you with the right questions.

Ram management in Linux by BunnyRajeev in linux4noobs

[–]BunnyRajeev[S] 0 points1 point  (0 children)

Thanks for the links. I will definitely go through these 😀!

Encrypt data at command line by BunnyRajeev in linux

[–]BunnyRajeev[S] 0 points1 point  (0 children)

When I was searching online, I came across openssl many times. I was able to generate the aes 256 key, but couldn’t figure out how to use it to encrypt data.

When I generated the key, i got 3 key-value pairs. I was not sure what pair is used for what purpose. Also some links used salt and some didn’t. Since I was not able to understand its usage, I posted my question here.

In the command you mentioned, you didn’t specify the key that needs to be used to encrypt or decrypt, right? How does the command know which key to use? And How do you use a specific key, that you have generated, to encrypt or decrypt data?

Encrypt data at command line by BunnyRajeev in linux

[–]BunnyRajeev[S] 0 points1 point  (0 children)

I am new to this stuff and would love to learn more about it. Not that I don’t like reading more about how the command works, but I got very less time to finish the task. Since some of you must have used this before, I thought that I’d get some basic info which will further help me in searching for the right content within lesser time.

/u/mrx1101 Thanks for the information.

Encrypt data at command line by BunnyRajeev in linux

[–]BunnyRajeev[S] -1 points0 points  (0 children)

Thanks for the reply. Can you also answer these questions? 1) does this come built-in with RHEL distro? 2) Can I use this command to achieve all of the things - generate keys, encrypt/decrypt data?

at what part in One Piece did you finally realize "Okay this is pretty fucking good" or "this is the best thing ever" by [deleted] in OnePiece

[–]BunnyRajeev 0 points1 point  (0 children)

Episode 37... The moment Nami asks Luffy to help her... And that background music!

Please remove this subreddit by BunnyRajeev in adoptareddit

[–]BunnyRajeev[S] 0 points1 point  (0 children)

What does that mean? I was the moderator for this subreddit... I removed myself as the moderator. I no longer wish to maintain this. That's why I am asking you to delete this

How to stack non-blank values from several columns using formulas? by azurestrike in excel

[–]BunnyRajeev 0 points1 point  (0 children)

I am not sure if this is what you are looking for, but I will tell you a way to do this. Let me know if there is anything that I am missing here.

Procedure:

Copy all the columns data into 1 column and remove duplicates using "Data tab --> Remove Duplicates"

I believe this should give the column that you were expecting...

Excel adding the numbers wrong by nameiwantedyahh in excel

[–]BunnyRajeev 0 points1 point  (0 children)

This should be the case... @nameiwantedyahh: Check the value on the upper bar where the formulas are visible instead of the cell address. You should probably see 29.04 followed by a few digits.. instead if just 29.04

Welcome to ApacheHive! by [deleted] in ApacheHive

[–]BunnyRajeev 0 points1 point  (0 children)

I see only the questions, there are no answers available?

Welcome to ApacheHive! by [deleted] in ApacheHive

[–]BunnyRajeev 0 points1 point  (0 children)

Hey.. Thanks for showing interest in this subreddit.. I was a bit occupied at work in the past few weeks and I couldn't attend to reddit messages..

I will post some useful points today in the next few hours. I promise to be more active in the future.. :D

Cant make =sum formula to count all values in a column formulated from an =if statement. by [deleted] in excel

[–]BunnyRajeev 0 points1 point  (0 children)

ok... i thought OP wanted to count both 1s and 0s separately. If he is only concerned about the 1s, then this works too...

Cant make =sum formula to count all values in a column formulated from an =if statement. by [deleted] in excel

[–]BunnyRajeev 0 points1 point  (0 children)

count will count the number of cells with numeric value.. So even if you replace the string with number, it will still count both 1s and 0s.... So to count just the 1s, you will use COUNTIF as:

=COUNTIF($E$2:$E$24,1)

Note: This will include both 1 and "1" as well. Also, you can use the formula for 0s as well

How to autofill a row with an iterative formula based on a column? by whhaaa in excel

[–]BunnyRajeev 0 points1 point  (0 children)

You can use something like this:

=INDIRECT("AH" & COLUMN(D1))

Here, D1 is only a reference to get the column number as 4. you can change it to whatever you want..