« Extract Sheet Name to a Cell (No VBA) | Download large free stuff from here » |
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.
...
=C6&COUNTIF(C6:C14,C6)
Download working file .xlsx from here.
EXPLANATION:
Here we have a rawdata:
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments