Latest Comments
In response to: HOW TO EMBED TABLE in VLOOKUP
exceltoxl [Member]
@excel, I am glad you liked it. Thank you.

In response to: HOW TO EMBED TABLE in VLOOKUP
excel [Member]
Awesome Vlookup Example....WOW

In response to: ISERROR vs IFERROR
exceltoxl [Member]
@excel, I am glad you liked it and welcome to exceltoxl.


In response to: ISERROR vs IFERROR
excel [Member]
Excellent Examples are shown in this site....marvelous ...i got just fond of this site to watch and to learn more frequently.

In response to: 3 TimeSaving Tips
tony [Member]
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.
You could also click the $ sign in that section, but that gives Accounting format instead of Currency format.

In response to: RANDOM NUMBERS without DUPLICATES
canesbr [Member]
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
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

In response to: RANDOM NUMBERS without DUPLICATES
exceltoxl [Member]
@canesbr, I am sorry, I didn't find. Do you have any instances as such.

In response to: RANDOM NUMBERS without DUPLICATES
canesbr [Member]
Cannot guarantee uniqueness.

In response to: RANDOM DATES without DUPLICATES
exceltoxl [Member]
@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.
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.

In response to: RANDOM DATES without DUPLICATES
canesbr [Member]
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?

In response to: Life History of INDEX
exceltoxl [Member]
@paulexcel, my pleasure, you liked it. By the way, Welcome to the blog.

In response to: Life History of INDEX
paulexcel [Member]
Yoy explanation was very clear. Thank you very much!

In response to: How Human Parts Resembles Excel Features
ibufo [Member]
I dont realy know how to vote because it's my firt time visiting this page.

In response to: Your Feedback Helps Us To Deliver Best
exceltoxl [Member]
@kindler.d.55, Thanks for your comment. Pls spread this blog to your contacts to help them learn in need. Thanks again.

In response to: Your Feedback Helps Us To Deliver Best
kindler.d.55 [Member]
Even though I learned Excel at a college I still run into situations that I have learned to do on this site.

In response to: How Human Parts Resembles Excel Features
tk [Member]
Good

In response to: How Human Parts Resembles Excel Features
stanza6 [Member]
Some of the features in Excel replicate the functions of the human body.

In response to: 120 + Excel websites on net
exceltoxl [Member]
@Poulton, Consider you are on the top.


In response to: 120 + Excel websites on net
poulton [Member]
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
.


In response to: What is the difference between Column Chart and Bar Chart?
info [Member]
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..
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..

In response to: Excel Animation using In-cell Charts
exceltoxl [Member]
@Rafaelgsuarez, Thank you. You loved it.

In response to: Excel Animation using In-cell Charts
rafaelgsuarez [Member]
Nice Trick, I love it.

In response to: Excel Master School - 2014 (enrollments are started)
exceltoxl [Member]
@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.
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.

In response to: Excel Master School - 2014 (enrollments are started)
astover [Member]
I cannot even get into the Excel Master School-2014. I click on the linc and it states there is no such address. Help!

In response to: How Human Parts Resembles Excel Features
exceltoxl [Member]
@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.
Finally, I do accept your comment.

In response to: How Human Parts Resembles Excel Features
canesbr [Member]
Absolute rubbish but beautifully spoken.
Regards
Brian
Regards
Brian

In response to: Top 10 +2 Shortcut Keys in Excel
exceltoxl [Member]
@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).
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).

In response to: List FileNames in a Folder (no VBA)
exceltoxl [Member]
@keyantkarthi, Thank you for your rating.

In response to: Navigate Excel Sheets
keyantkarthi [Member]
We can also use Ctrl + PageUp or Ctrl + PageDown to navigate between worksheets in Excel.

In response to: Top 10 +2 Shortcut Keys in Excel
keyantkarthi [Member]
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.
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.

In response to: Top 10 +2 Shortcut Keys in Excel
keyantkarthi [Member]
Hi Abhilash, To activate Data Validation, we can use simply Alt + D + L.
Excel opens the data validation dialog box.
Excel opens the data validation dialog box.

In response to: List FileNames in a Folder (no VBA)
keyantkarthi [Member]
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.
I had VBA macro to list the files and folder names, it takes lot more time to update. But this tip is awesome.

In response to: Fill Blank Cells
keyantkarthi [Member]
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
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

In response to: Crack Formula Errors
exceltoxl [Member]
@ashroff17, Thank you.

In response to: Crack Formula Errors
ashroff17 [Member]
Useful Information

In response to: Convert Simple Range to Dynamic Range -TIP
exceltoxl [Member]
@gjbvishal, Thank you

In response to: List FileNames in a Folder (no VBA)
exceltoxl [Member]
@vishal, thank you so much for your rating. One more function is available in http://ow.ly/o8u4n

In response to: Convert Simple Range to Dynamic Range -TIP
gjbvishal [Member]
nice tip

In response to: List FileNames in a Folder (no VBA)
gjbvishal [Member]
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

Recent comments