very nice & easy solution
On 23 February 2015 at 20:36, Vaibhav Joshi wrote:
> Convert all date in same format:
>
> While receiving data from different sources many time it happens that
> data received is not in same format due to various reason.
>
> One of the tedious activity is to transformi
Dear Mr.Paul, Thanks to reply.
But problem of third criteria is still not fulfill as per your condition of
'ISTEXT(MID(A1,1,1)'
The output is same 'TRUE' whether entered value is alpha or numeric.
Please give me a solution for it or macro also preferred if possible.
Regards.
Ashish Bhalara
9624111
Dear Sir,
I want to write a macro for IS Review.
In attached file, there are two tabs. 1st is for IS trend & 2nd is for
Criteria.
In IS Trend tab, Column I is for Macro Number that macro should run for
that row only. Column J is for comment. We want to write comment only for
that macro which
I've never worked with Google sheets, so I have no idea.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wes
this will work with google sheets or just excel?
On Fri, Feb 27, 2015 at 6:27 AM, Paul Schreiner
wrote:
> I created the following macro and tested it against some sample data I had.
> It was a rather large sample:
> 143,774 rows
> 100 columns
>
> They were Requisitions written by 191 users.
>
>
I created the following macro and tested it against some sample data I had.
It was a rather large sample:
143,774 rows
100 columns
They were Requisitions written by 191 users.
The macro moved all 143,774 rows to 191 sheets in
1 minute, 32 seconds.
I utilized a Dictionary object for a sheet
Hi Paul,
Thanks for the amazing macro you sent. it worked like a charm.. Thanks
again.
Regards
Gaurav Devrani
On Fri, Feb 27, 2015 at 1:04 AM, Paul Schreiner
wrote:
> Are you wanting a macro made to work like a function?
> Like:
>
> =CaseSwap(A1)
>
> where CaseSwap is:
>
> Option Explicit
> P
If the cell you're validating is A1, with the current value of:
abcd1234567
-
Your first criteria is easy:
Len(A1)=11
-
The second criteria: "last 7 characters are numeric"
CAN be fairly simple, depending on your definition of "numeric
type ctr + ; in excel cell, format which you get is default date format...
On Fri, Feb 27, 2015 at 6:33 PM, amar takale wrote:
> I have no access to see.Pls see print shot.
>
> On Fri, Feb 27, 2015 at 6:26 PM, Vaibhav Joshi wrote:
>
>> what default date format of your machine?
>>
>>
>> On Fri,
Both is working good ..
On Fri, Feb 27, 2015 at 11:55 AM, Mayank Mishra
wrote:
> Try
> =DATE("20"&RIGHT(A1,2),MID(A1,4,2),MID(A1,2,2))
>
> It will convert the string as date
>
> On 2/27/15, Sam Mathai Chacko wrote:
> > =--TEXT(RIGHT(A1,6),"00\/00\/00")
> > On 27 Feb 2015 11:47, wrote:
> >
> >>
what default date format of your machine?
On Fri, Feb 27, 2015 at 6:21 PM, amar takale wrote:
> PFA
>
> On Fri, Feb 27, 2015 at 6:21 PM, amar takale wrote:
>
>> Dear Sourab
>>
>> How to do it in one attempt only *1 in column B.When I extract date from
>> our database software then paste it one
PFA
On Fri, Feb 27, 2015 at 6:21 PM, amar takale wrote:
> Dear Sourab
>
> How to do it in one attempt only *1 in column B.When I extract date from
> our database software then paste it one excel then I do *1 to all date but
> answer is Value,why?
>
> Regards
> Amar
>
> On Thu, Feb 26, 2015 at 9:
Dear Sourab
How to do it in one attempt only *1 in column B.When I extract date from
our database software then paste it one excel then I do *1 to all date but
answer is Value,why?
Regards
Amar
On Thu, Feb 26, 2015 at 9:25 PM, Sourabh Salgotra
wrote:
> THANKS FOR GREAT TRICK VAIBHAV
>
> WORKIN
Amar
I am not getting any error...see screenshot below..
in your case i guess you have set default date format to m/d/ydue to which
you are getting error...
[image: Inline image 1]
On Thu, Feb 26, 2015 at 12:01 PM, amar takale wrote:
> pls look sheet where sheetl1 not change as per you say
-- Forwarded message --
From: Ashish Bhalara
Date: Fri, Feb 27, 2015 at 9:20 AM
Subject: $$Excel-Macros$$ Function for Data validataion
To: excel-macros@googlegroups.com
Dear experts,
I want to formula for data validation to fulfill below conditions.
1. Total character shou
15 matches
Mail list logo
