Category: Formulas

Random Words using RANDBETWEEN

Formulas, Tutorial, Arrays

Hi there,


 


We all know RANDBETWEEN works only with numbers. But, why am I saying we can do random pic words using RANDBETWEEN. Is there any way we can do this? If you have any idea before reading the complete post, leave your idea using below comments section. 

If you are new to this tip, walk with me. :)


Learn Formulas from here. We have FORMULAS CRASH COURSE tailored for you; try once if you like it.

 

RANDBETWEEN WORKS WITH NUMBERS:

Full story »

COUNT BLANK CELLS using FORMULA

Formulas, How-to's

Hi there,

 

 

I have a tiny formula which does the important task in Excel. Do you know how to count colored cells? Then why are you waiting for try, how to count blank cells now?

 

COUNT BLANK CELLS using FORMULA



We have a raw data like this:

 

Count Blank Cells using this Excel Raw Data

Full story »

Extract username and domain name from email ID using Formulas

Formulas, Tutorial, Trainings

Hi there,

 

 

Do you know how to extract username and domain name separately from the cell contains email ID? If you know, share it using our comments to know how you work on this challenge.

 

Here, let us take my email ID

 

NOURGENT@YAHOO.COM

 

and the output should be like NOURGENT in a one cell and the other cell should contain YAHOO.COM.

 

To do this, I have two methods.

Full story »

Extract Sheet Name to a Cell (No VBA)

Formulas, How-to's

Hi there,

 


Have you come across this situation in your work. This is really amazing trick to extract the active sheet name to a cell. The formula goes like this.

 

=mid(cell("filename",a1),find("]",cell("filename",a1))+1,111)


dynamic formula, what if cell A1 deletes either by Row or Column:


=mid(cell("filename"),find("]",cell("filename")+1,111)

 

Extract Tiger from the Ocean like Extract SheetName to a CELL
 

EXPLANATION:

Full story »

How to extract 2nd, 3rd, 4th & 5th Instance from VLOOKUP?

Formulas, Arrays

Hi there,

 



VLOOKUP is the master of all functions in Excel. This is what every Excel Lover say about this function. VLOOKUP has gained a huge popularity because when some one says that he knows VLOOKUP that means that person knows Excel application. I think you understood the brand it has been gained from the public, right? Some thing equal to brand like TATA. I agree to this point, Do you?

 

As we all know how to extract the first instance using VLOOKUP, here is how we extract the second instance using vlookup function. The logic is very simple. Let me reveal before proceeding - just use a helper column by writing this function in it.

Full story »

SUM values using Check Boxes (check how?)

Formulas, How-to's, VBA, Applications

Hi there,



One of the Excel Lover tried summing a list using check box. This is something like thinking out of box. Are you eager to know how to do this. Here we go:

 

PRE WORK:

Set the raw data to do this. Here, I am using the Vegetables bought from the market today. Here, I have to disclose you how typically our villagers market their products.

In my village we will have market open on Wednesday, which means sellers from different place comes to our village to sell their goods. Goods interms of Vegetables, leafy vegetables, Stationary, Groceries and all kinds of petty shops for that matter. Every one comes to one village, Wednesday is in our village, and sells their goods and go back in the evenings. Next day will be the other village which is closer to our village. This is how the routine work of the sellers in the villages.

Full story »

Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evofactory.