“ROW”
Used for – “ROW” function in MS Excel is used to get the absolute position of the row of the reference cell.
Syntax – ROW([reference])
...
COLUMN
“COLUMN”
Used for – “COLUMN” function in MS Excel is used to get the absolute position of the column of the reference cell.
Syntax – COLUMN([reference])
...
LAST AND UNIQUE VALUE
Hey Guys!!!
Here's are some questions related to data and must read this post if all your answers will take to next question :-
Have you ever require to get filter Last and unique values from...
SUM FOR FIRST AND UNIQUE VALUE
Hey Guys!!!
Here's are some questions related to data and must read this post if all your answers will take to next question :-
Have you ever require to get filter first and unique values from...
FIRST AND UNIQUE VALUE
(adsbygoogle = window.adsbygoogle || []).push({
google_ad_client: "ca-pub-4334313558799766",
enable_page_level_ads: true
});
Hey Guys!!!
Here's are some questions...
BREAK and COMBINE Name's
Hey Guys!!!
Perhaps some time you find that you have to break name into Prefix, First Name, Middle Name and Last Name or you have to combine all these to get Name.If it is one time then you can do...
CONVERT DATE FORMAT
Hey Guys!!!
Perhaps some time you find that you have to convert the date format as shown below:-
24/02/2018 >>>>>>> 24th February, 2018.
and If it is...
DATEVALUE
“DATEVALUE”
Used for – “DATEVALUE” function in MS
Excel is used to find or convert a date into a serial number that MS Excel
recognizes as a date.
Syntax – DATEVALUE(date_text)
...
Subscribe to:
Posts (Atom)