Disclaimer

All Logos and Trademarks used on this site belong to their respective owners. 

We cannot guarantee that all information provided is 100% accurate. This site is intended to help people by sharing knowledge. We (theakshay.in) are not responsible for any losses and damages by use of any information from this blog.

All company, product and service names used in this website are for identification purposes only. Use of these names, logos, and brands does not imply endorsement. If you believe that we have infringed your copyright, Please contact us.

Popular posts from this blog

Formula to Get Country Flags in Google Sheets

Image
I have created a formula to insert country flags in Google Sheets's cells. For this I've used IMAGE, IMPORTXML and SUBSTITUTE functions. In this formula we're taking flag images from Wikipedia.   You can paste below formula in your Google Sheets: =IMAGE("https:"&IMPORTXML("https://en.wikipedia.org/wiki/Gallery_of_sovereign_state_flags","//img/@src[contains(.,'"&SUBSTITUTE(A2," ","_")&"' )]"))  Change A2 with the cell address in which you are typing country name. You need to type first letter of country name in capital letter in order this to work. I have explained this formula in my below YouTube video. You can watch this video to understand how it works:
Read more

Formula to Get a Random Name from a List in Google Sheets

Image
Sometimes we need a random name from the list of names to select a winner for giveaway, lucky draw, etc. You can use Google Sheets for this. Use below formula as it is if names are in Column A that is the first column.  =indirect("A"&randbetween(1,counta(A:A))) Remember that RandBetween function changes values when you make any changes in the sheet. Watch below video for full explanation:
Read more