Said Delisha

Brief: Wondering which Ubuntu version you’re using? Here’s how to check your Ubuntu version, desktop environment and other relevant system information.

You can easily find the Ubuntu version you’re using via either the command line or the graphical interface. Knowing the exact Ubuntu version, desktop environment and other system information helps a lot when you’re trying to follow a tutorial from the web or seeking help on forums.

In this quick tip, I’ll show you various ways to check your Ubuntu version and other common system information.

This is the best way to find your Ubuntu version. I could have mentioned the graphical way first, but I chose this method because it doesn’t depend on the desktop environment you’re using. You can use it on any Ubuntu variant. You can use it to check Linux Mint version, Fedora version or any other distribution you are using.

Open a terminal (Ctrl+Alt+T) and type the following command:

The output of the above command should look like this:

You can easily see what version of Ubuntu I have here. The current Ubuntu installed in my system is Ubuntu 16.04 and its code name is Xenial.

Wait! Why does it say Ubuntu 16.04.4 in Description and 16.04 in Release? Which one is it, 16.04 or 16.04.4? What’s the difference between the two?

The short answer is that you’re using Ubuntu 16.04. That’s the base image. 16.04.4 means it’s the fourth point release of 16.04. A point release can be thought of as the Linux equivalent of a Windows service pack. So both 16.04 and 16.04.4 are correct answers to this question.

What’s Xenial in the output? That’s the codename of the Ubuntu 16.04 release. You can read this article to find out about Ubuntu naming conventions.

Alternatively, you can use either of the following commands to find your Ubuntu version:

The output of the above command looks like this:

You can also use this command to get your Ubuntu version:

The output of this command will be like this:

Forget the \n \l. The Ubuntu version is 16.04.4 in this case, or simply Ubuntu 16.04.

Checking your Ubuntu version graphically is no big deal either. I’m going to use screenshots from Ubuntu 18.04 GNOME here, but things may look different if you’re using Unity or some other desktop environment. I recommend the command line versions discussed in the previous sections because they don’t depend on the desktop environment.

The next section will show you how to find the desktop environment.

For now, go to System Settings and look under the Details segment.

You should see the Ubuntu version here along with the information about the desktop environment you are using, GNOME being the case here.

So, you just learned how to find your Ubuntu version. But what about other information? Which desktop environment are you using? Which Linux kernel version is being used?

Of course, you can use various commands to get all that information, but I recommend a command line utility called Neofetch. This will show you essential system information in the terminal, accompanied by the ascii logo of the Linux distribution you are using.

Install Neofetch using the command below:

Once installed, simply run the command neofetch in the terminal and see a beautiful display of system information.

As you can see, Neofetch shows you the Linux kernel version, Ubuntu version, desktop environment and its version, themes and icons in use, etc.

I hope this helps you find your Ubuntu version and other system information. If you have suggestions for improving this article, feel free to drop them in the comment section. Ciao :)

Today, we're thrilled to share that we've now increased send limits to $25,000 USD per transaction to over 50 countries including India, Canada,

Select the fragment you want to alter · Go to Effects → Amplitude and Compression → Normalizing audio (process) · Select a % or dB value and

“ pandas unique values to list ” Code Answer's get list of unique values in pandas column python by TheRubberDucky on Mar 29 2021 Comment

HLOOKUP function in Excel is a sibling of the VLOOKUP function. The H in the HLOOKUP stands for “Horizontal” and hence it is often called Horizontal Lookup.

HLOOKUP is a very useful function for creating horizontal lookups, but as most of the tables that we deal with are vertical hence this function is not very popular.

The task of the HLOOKUP function is to search for a value in the topmost row of a table, and then return a corresponding value in the same column from a row you specify.

Microsoft Excel defines HLOOKUP as a function that “looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify”.

The syntax of the HLOOKUP function in Excel is as follows:

Here, ‘lookup_value’ refers to a value that is to be searched in the topmost row of the table. ‘lookup_value’ can be a value, a reference or a text string.

‘table_array’ is the range reference or range name of an array of values, inside which in which the data is to be looked up.

‘row_index_num’ is the row number in the ‘table_array’, from which the matching value is to be returned. A ‘row_index_num’ equal to 1 returns a value from the topmost row in the ‘table_array’ and similarly a ‘row_index_num’ equal to 2 returns a value from the second row of the ‘table_array’.

‘range_lookup’ argument accepts a Boolean value that specifies whether you want the Horizontal Lookup function to return an exact match or an approximate match. TRUE stands for an approximate match while FALSE stands for an exact match.

Now, let’s understand how to use this function in Excel.

Consider, we have a Student Table as shown below:

Objective: In this case, our objective is to fetch Steve’s marks in English using Horizontal Lookup.

So, we will try to apply an HLOOKUP to get the result.

‘lookup_value’: As we know that we have to find the marks of Steve, so our ‘lookup_value’ will be a “Steve”.

‘table_array’: In this argument, we give the reference of our table i.e. A1:I4.

‘row_index_num’: The ‘row_index_num’ in this case, would be 4 as here we have to fetch a value from the fourth row of the table.

‘range_lookup’: ‘range_lookup’ will be FALSE as here we only want to fetch the exact match value.

The result of this formula is 61.

Now, let’s see some examples of Horizontal Lookup Function.

Using the below table, find the Marks in English of a student who has got 75 marks in Science.

We can use this formula to get the result:

The result of this formula is 40.

Explanation:

Using the same table as above, write a Horizontal LookUp formula to find the Maths marks of a student whose name starts with ‘G’.

To do this we can use the formula:

Note: In this example, we have used a wild card character “*”.

Explanation:

Here in this example, we have two tables as shown, now our task is to apply an HLOOKUP formula and populate the History marks in the first table.

This can be done by using the formula:

And then dragging it to all the columns using the fill handle.

Note: If you are wondering what these dollar signs ‘$’ are doing in this formula, then I would suggest you read this post.Explanation:

In this example, we have an Element Table as shown below and our task is to find the  Atomic Mass of Boron.

To do this we can use the HLOOKUP as:

Using the above element table find the Melting Point of an element whose Atomic Mass is 15 or slightly less than it.

In this case, we can use the formula:

Note: Notice in this example we have set the ‘range_lookup’ argument is TRUE, this means that, if an exact match is not found, the next largest value that is less than ‘lookup_value’ is returned.Explanation:

In this example, as you can see that we have set ‘range_lookup’ = TRUE because none of the elements present in the table have Atomic Mass equal to 15. Hence, when HLOOKUP is unable to find any element the Atomic Mass 15 it picks up the nearest (but smaller than ‘lookup_value’) number i.e. 14.01 and returns its corresponding Meting point. And, hence the result is -210.

Using HLOOKUP in VBA is very easy. For using HLOOKUP in VBA you simply need to remember that you can find it under “Application.WorksheetFunction”.

Write a VBA program using HLOOKUP, to find the marks of the specified student in all the subjects from the below table.

Below is the code to this:

Recommended Reading: MsgBox, InputBox, Concatenate In Excel, If Function, On Error Statement, VLOOKUP in VBA

As I have already told, the HLOOKUP function throws a #N/A error if ‘range_lookup’ is FALSE and HLOOKUP is unable to find the ‘lookup_value’ in the defined range.

These #N/A errors do not look good and hence it is better to hide them and display some meaningful message.

In this example, we will see how to hide #N/A errors. Here, we will try to find the Melting Point of an element whose Atomic Mass is 11.

So, we will write a formula as:

Now, as this #N/A error looks ugly so we will try to use the HLOOKUP with ISNA function to display a meaningful message.

The resultant formula will become:

ISNA function returns TRUE if there is a #N/A error in the formula.

Until now we have seen that HLOOKUP only returns a single value. But you can create an array HLOOKUP function to fetch multiple records.

Let’s make it clearer by understanding this with an example.

Let’s consider, we have a table as shown below. Now, in this table, we want to fetch the Marks of Glen in all the subjects.

So, we will use a formula as:

Please note that this is an array formula. To enter this formula, select the number of cells equal to the number of rows that you want HLOOKUP to return.

With all the cells selected enter the formula bar, paste the above formula, and press Ctrl + Shift + Enter. Pressing Ctrl + Shift + Enter will enclose the above formula in curly brackets like:

And the result will be displayed.

In the above image see how a single HLOOKUP returns all the Marks of Glen.

If you still didn't get it, then see the below-animated image:

Javascript answers related to “ javascript print to console ” how to print to console javascript · javascript get user preferred language · java script to