Latest Comments

exceltoxl

In response to: HOW TO EMBED TABLE in VLOOKUP

exceltoxl [Member]
@excel, I am glad you liked it. Thank you.
PermalinkPermalink 02/16/15 @ 06:36
excel

In response to: HOW TO EMBED TABLE in VLOOKUP

excel [Member]
Awesome Vlookup Example....WOW
PermalinkPermalink 02/16/15 @ 05:18
exceltoxl

In response to: ISERROR vs IFERROR

exceltoxl [Member]
@excel, I am glad you liked it and welcome to exceltoxl. :)
PermalinkPermalink 02/16/15 @ 03:51
excel

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.
PermalinkPermalink 02/16/15 @ 03:23
tony

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.
PermalinkPermalink 02/04/15 @ 17:22
canesbr

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
PermalinkPermalink 01/26/15 @ 09:53
exceltoxl

In response to: RANDOM NUMBERS without DUPLICATES

exceltoxl [Member]
@canesbr, I am sorry, I didn't find. Do you have any instances as such.
PermalinkPermalink 01/24/15 @ 22:36
canesbr

In response to: RANDOM NUMBERS without DUPLICATES

canesbr [Member]
Cannot guarantee uniqueness.
PermalinkPermalink 01/24/15 @ 22:06
exceltoxl

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.
PermalinkPermalink 01/20/15 @ 00:37
canesbr

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?
PermalinkPermalink 01/19/15 @ 10:27
exceltoxl

In response to: Life History of INDEX

exceltoxl [Member]
@paulexcel, my pleasure, you liked it. By the way, Welcome to the blog.
PermalinkPermalink 12/30/14 @ 05:08
paulexcel

In response to: Life History of INDEX

paulexcel [Member]
Yoy explanation was very clear. Thank you very much!
PermalinkPermalink 12/30/14 @ 05:00
ibufo

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.
PermalinkPermalink 11/28/14 @ 13:03
exceltoxl

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.
PermalinkPermalink 11/08/14 @ 22:12
kindler.d.55

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.
PermalinkPermalink 11/08/14 @ 15:08
tk

In response to: How Human Parts Resembles Excel Features

tk [Member]
Good
PermalinkPermalink 09/24/14 @ 21:17
stanza6

In response to: How Human Parts Resembles Excel Features

stanza6 [Member]
Some of the features in Excel replicate the functions of the human body.
PermalinkPermalink 09/08/14 @ 20:10
exceltoxl

In response to: 120 + Excel websites on net

exceltoxl [Member]
@Poulton, Consider you are on the top. :D
PermalinkPermalink 08/01/14 @ 10:18
poulton

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 :).
PermalinkPermalink 07/21/14 @ 13:53
info

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..
PermalinkPermalink 04/29/14 @ 02:23
exceltoxl

In response to: Excel Animation using In-cell Charts

exceltoxl [Member]
@Rafaelgsuarez, Thank you. You loved it.
PermalinkPermalink 04/05/14 @ 18:26
rafaelgsuarez

In response to: Excel Animation using In-cell Charts

rafaelgsuarez [Member]
Nice Trick, I love it.
PermalinkPermalink 04/05/14 @ 12:02
exceltoxl

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.
PermalinkPermalink 01/17/14 @ 09:10
astover

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!
PermalinkPermalink 01/17/14 @ 05:54
exceltoxl

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.
PermalinkPermalink 01/08/14 @ 03:38
canesbr

In response to: How Human Parts Resembles Excel Features

canesbr [Member]
Absolute rubbish but beautifully spoken.
Regards
Brian
PermalinkPermalink 01/06/14 @ 18:42
exceltoxl

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).
PermalinkPermalink 09/27/13 @ 04:39
exceltoxl

In response to: List FileNames in a Folder (no VBA)

exceltoxl [Member]
@keyantkarthi, Thank you for your rating.
PermalinkPermalink 09/27/13 @ 04:35
keyantkarthi

In response to: Navigate Excel Sheets

keyantkarthi [Member]
We can also use Ctrl + PageUp or Ctrl + PageDown to navigate between worksheets in Excel.
PermalinkPermalink 09/27/13 @ 00:37
keyantkarthi

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.
PermalinkPermalink 09/27/13 @ 00:10
keyantkarthi

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.
PermalinkPermalink 09/27/13 @ 00:01
keyantkarthi

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.
PermalinkPermalink 09/26/13 @ 23:39
keyantkarthi

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
PermalinkPermalink 09/26/13 @ 23:17
exceltoxl

In response to: Crack Formula Errors

exceltoxl [Member]
@ashroff17, Thank you.
PermalinkPermalink 08/31/13 @ 02:18
ashroff17

In response to: Crack Formula Errors

ashroff17 [Member]
Useful Information
PermalinkPermalink 08/30/13 @ 19:19
exceltoxl

In response to: Convert Simple Range to Dynamic Range -TIP

exceltoxl [Member]
@gjbvishal, Thank you
PermalinkPermalink 08/21/13 @ 19:46
exceltoxl

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
PermalinkPermalink 08/21/13 @ 10:16
gjbvishal

In response to: Convert Simple Range to Dynamic Range -TIP

gjbvishal [Member]
nice tip
PermalinkPermalink 08/21/13 @ 06:15
gjbvishal

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
PermalinkPermalink 08/21/13 @ 06:13
sushma

In response to: Crack Formula Errors

sushma [Member]
good post
PermalinkPermalink 06/07/13 @ 02:48
Contact / Help. ©2017 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / SkinFaktory.