See the attachment of your solution.
Use this function...
=IF(A2="","",CONCATENATE(COLUMN(),",",ROW()))
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
On Sat, May 10, 2014 at 1:59 PM, Vaibhav Joshi wro
Hi
See attachment..
It check if rows in col A is empty or not depending upon it puts value in
respective rows of col. B ,C etc...
If combination of row & col is empty no data will be filled.
It takes care upto last Row & col.
HTH//Cheers
On Sat, May 10, 2014 at 6:20 AM, Bill Q wrote:
>
Hello, what is to be autofill. can u give what is in a1 to a5 and
what is to be autofilled in b1 to b5
-r.karunanithi.
On Saturday, May 10, 2014 6:20 AM, Bill Q wrote:
I have spent the better part of 40 minutes searching the web for what I believe
is a simple solution. I have found many answ
I have spent the better part of 40 minutes searching the web for what I
believe is a simple solution. I have found many answers. I have tried them
all - None are working to what I am looking for.
Simply put.
- Assume source Data is always is column "A". It could be 50 rows in length
or 84,679