Concatenate Formula | Special Trick | Excel in Hindi

CONCATENATE

CONCATENATE

---

Joins several text items into one text item

Category : Text

Location : Built-in

Concatenate

What Does It Do?

---

This function joins separate pieces of text into one item.

 Syntax 

 =CONCATENATE(Text1,Text2,Text3...Text30)

Up to thirty pieces of text can be joined.

Formatting

---

No special formatting is needed, the result will be shown as normal text.

Note

---

You can achieve the same result by using the " & " operator.

Concatenate_1

Watch Video Click For More Details

Please Subscribe the Channel for more Excel formulas and VBA Macro Codes

Rank Function

RANK

---

Returns the rank of a number in a list of numbers




Category : Statistical
Location : Built-in






What Does It Do ?

---

This function calculates the position of a value in a list relative to the other values in the list.
A typical usage would be to rank the times of athletes in a race to find the winner.
The ranking can be done on an ascending (low to high) or descending (high to low) basis.
If there are duplicate values in the list, they will be assigned the same rank. Subsequent ranks would not follow on sequentially, but would take into account the fact that there were duplicates.
If the numbers 30, 20, 20 and 10 were ranked, 30 is ranked as 1, both 20's are ranked as 2, and the 10 would be ranked as 4.

Syntax :
=RANK(NumberToRank,ListOfNumbers,RankOrder)

The RankOrder can be 0 zero or 1.
Using 0 will rank larger numbers at the top. (This is optional, leaving it out has the same effect).
Using 1 will rank small numbers at the top.





Formatting

---

No special formatting is needed.







Example

---

The following table was used to record the times for athletes competing in a race.
The =RANK() function was then used to find their race positions based upon the finishing times.

Developer Ribbon Tab and Macro for Msgbox