RANDOM NUMBERS without DUPLICATES

Formulas

Hi there,

 

There is a new project which is going to add to my portfolio in few days from now. And, I come across a challenge where I need to create a random numbers wherein there should not be any duplicates. Do you have any idea? Pleaes do post it in the comments. If not, step with me.

First of all, let me reveal the new project which is going to be added in a few days because finally you are the one who loves me a lot by purchasing my products, suggesting good ideas, grooming me with love and affection. Here you go:


I am starting a new website which stands next to these websites.

 

Full story »

SUMPRODUCT can COUNT

Formulas

Hi there,

 

In this post, we will see how to use SUMPRODUCT to replace COUNT, COUNTA and COUNTIF functions.

 

COUNT:

This function is used to count the number of values in a range of cells.

eg: we have a range A1:A10 which contains values with A5 as blank and A8 as alpha numeric, then COUNT will display the result as 8 as there is only 8 cells which contains values or numerics.

Full story »

Sort Data Horizontally (quick tip)

excel_usage, Excel Tips

Hi there,

 

How are you doing today? Hope you are doing well, right?

Ok,

In this post, I am explaining about how to sort the data horizontally? Sorting data vertically has been our routine day to day work. But, data sorting horizontally has a small trick.

To know how to do it, please do watch this video.

Full story »

DATE with RANDBETWEEN

Formulas

Hi there,

In this post, we will see how to use RANDBETWEEN for randomly appearing dates in a range of cells. This is very simple but logical. Let me share it with you now, to do this, first select the range where these dates to be displayed and use the below function to display 15 dates randomly.

Download Working File.xls


=RANDBETWEEN("01-01-2015","01-15-2015")

or

=RANDBETWEEN(42005,42019)

 

Full story »

Rules to Follow While Creating Names

excel_usage

Hi there,

There are some rules which needs to be followed while creating names for a range of cells using NameBox feature or through "Create from Selection" feature.

The rules includes:

  • The first character should always be either 
    • _ (underscore)
    • / (backward slash)
    • a letter

Full story »

HAPPY NEW YEAR 2015

website updates
HAPPY NEW YEAR 2015
Happy New Year 2015 by exceltoxl
KEEP EXCELLING!!!
Contact / Help. ©2021 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Skin Faktory.