exceltoxl.com

@excel, I am glad you liked it. Thank you.

Awesome Vlookup Example....WOW

@excel, I am glad you liked it and welcome to exceltoxl.

Excellent Examples are shown in this site....marvelous ...i got just fond of this site to watch and to learn more frequently.

Another way to execute the second tip is to select the cells and go to the numbers section on the ribbon and change General to Currency.

You could also click the $ sign in that section, but that gives Accounting format instead of Currency format.

The finding or not finding is no proof. Rand will produce duplicates.
Further, your numbers are fractional 99.123456789012345, however, suppose you want 52 nonrepeating random whole integers between 1 and 100, your formula is not at all appropriate. {88,97,49,49,...} in your posted example has an integer duplicate coming up in the 4th number.
Regards
Brian

@canesbr, I am sorry, I didn't find. Do you have any instances as such.

Cannot guarantee uniqueness.

@canesbr, Most of your comments are right.
I have seen your example file posted in linkedin (http://bit.ly/DistinctDates), however, that is a tidious process for someone whom needs to create a dummy data for training purpose as an example. But, this scenario will help to achieve your results at the earliest. But again, I agree there are pros and cons using this formula.

As mentioned in the post, I have checked for the duplicates for nearly 100+ instances and I didn't receive any.

How does adding rand() guarantee no repeats? rand() doesn't remember what it previously generated and nor does randbetween, so it is quite possible that a repeat will emerge. It may be unlikely, but not impossible. Also rand() generates a fractional number less than 1. So what your formula produces is a date and time. Further there are only 80 dates in your randbetween range. So even if your formula were correct how would it generate each of the 80 dates in the range?

@paulexcel, my pleasure, you liked it. By the way, Welcome to the blog.

Yoy explanation was very clear. Thank you very much!

I dont realy know how to vote because it's my firt time visiting this page.

@kindler.d.55, Thanks for your comment. Pls spread this blog to your contacts to help them learn in need. Thanks again.

Even though I learned Excel at a college I still run into situations that I have learned to do on this site.

Good

Some of the features in Excel replicate the functions of the human body.

@Poulton, Consider you are on the top.

Great idea to have a list of Excel sites. Please add http://www.ableowl.com/EmailManager/TipsJournal_Right.aspx for free monthly and weekly tips at the top, of course .

Hello,

While I was going through this tutorial, I just thought of sharing an experience of mine. I recently came across this site,www.jolicharts.com for data visualization and creating charts derived directly from excel sheets.
It was good for me as day to day charting and data presentation was taking way too much of my time..
I hope this info also might help few more of us.

Well no harm in trying it for free..

@Rafaelgsuarez, Thank you. You loved it.

Nice Trick, I love it.

@astover, First of all thanks much for showing interest on E M S.
There was an error in the code due to which link was not working. However, created an alternative mode of payment. Now you can start enrolling.

I cannot even get into the Excel Master School-2014. I click on the linc and it states there is no such address. Help!

@Canesbr, This post is an assumption between an Excel and a Human Body Parts. However, If you see the depth of how human parts work then you will definitely accepts the comparission.

Finally, I do accept your comment.

Absolute rubbish but beautifully spoken.
Regards
Brian

@keyantkarthi, Thank you, you are right, ALT + D +L is used in 2003 and before versions. But, here I have mentioned for 2007 and above versions.

Also, CTRL + D can be replaced with ALT+E+I+D (2003 version) and CTRL + R can be replaced with ALT+E+I+R (2003 version).

@keyantkarthi, Thank you for your rating.

We can also use Ctrl + PageUp or Ctrl + PageDown to navigate between worksheets in Excel.

In your bonus shortcut 2, it explains fill down method.
To use fill down method simply press CTRL+D.
If yo want to fill right, left and up what would to do?
Simply press the CTRL+R to fill right, ALT+E+I+L to fill left and
ALT+E+I+U to fill up.

Hi Abhilash, To activate Data Validation, we can use simply Alt + D + L.

Excel opens the data validation dialog box.

This is awesome tip. This helped me more.
I had VBA macro to list the files and folder names, it takes lot more time to update. But this tip is awesome.

Hi, Try this inbuilt option also.

1. Select the complete data set (here A1:A20)

2. Use CTRL + G (goto window) then

3. hit ALT + S and

4. Select Blanks or type 'K'

5. Click on 'Enter'

6. Now, the blank cells get selected

7. Type = and press UP arrow

8. Finally press Ctrl+Enter

The blank cells are get filled

@ashroff17, Thank you.

Useful Information

@gjbvishal, Thank you

@vishal, thank you so much for your rating. One more function is available in http://ow.ly/o8u4n

nice tip

excellent, very very. I am using excel from last 5 yrs but have seen this function ("FILES") for the first time. If possible provide some more examples on vishal.bharakhada@gmail.com

good post