-- Forwarded message --
From: Dheeraj Bankoti
Date: Mon, Apr 18, 2016 at 7:22 AM
Subject: Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value
To: excel-macros@googlegroups.com
It seems now there is no excitement in group to help.
Regards
Dheeraj
-- Forwarded
Then you can try the tool, which you can download from below URL.
You have to mention the rows like you want to split the file after 10 lacs
rows.
http://download.cnet.com/CSV-Splitter/3000-2074_4-75910188.html
On Wed, Apr 20, 2016 at 10:13 AM, Mahesh wrote:
> yes, it is .csv
>
> On Tue, Apr 19
yes, it is .csv
On Tue, Apr 19, 2016 at 10:18 PM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:
> Hi Mahesh,
>
> Please confirm the file format, is it .csv
>
>
>
>
> On Tue, Apr 19, 2016 at 10:16 PM, Mahesh wrote:
>
>> Hi,
>>
>> I want to split it by rows.
>>
>> For example-
>> if the t
result required for large 20,17 and 16 which is not done through this
formula.
On Tuesday, April 19, 2016 at 3:51:31 PM UTC+5:30, amar takale wrote:
>
> Array formula press (Ctrl+Shift+enter)
>
> ={LARGE($A$2:$A$21,{1;2;3;4;5})}
>
> On Tue, Apr 19, 2016 at 3:50 PM, amar takale > wrote:
>
>> use
Hi Eugene
This link provides an example of extracting data from multiple workbooks
and condensing it into 1 file:
https://msdn.microsoft.com/en-us/library/gg549168.aspx
As a side note, Ron De Bruin's website has some great examples:
http://www.rondebruin.nl/windows_articles.htm
HTH
Mark.
-
Hi All
I know the subject title is a little vague.
I have the following code which works relatively well, with the exception
of the summing of the split total.
So Column G which may have up to 30 rows and only has 4 values (A, B, C, or
D) which this code inserts rows separating these differing
Hi All
This is doing my head in.
I have a range of names:
A
2 Jackson Brown - Musician
3 George Cluney - Actor
4 Fidelle Castro - Afficianado
5 Someone
6 Someone
7 Someone
8 Someone
9 Someone
10 Someone
11 ETC
When I execute the following code, it works kind of ok
Hi Partner,
Hope you are doing great …
Please send resume to ma...@genuineitllc.com
*Title :Cloud PM*
*Duration : Oakbrook, IL*
*Linked id MUST*
*Current projects:*
- Working to build a center of excellence for cloud at creating
operations and architectural processes Amazon IT transf
Hi Mahesh,
Please confirm the file format, is it .csv
On Tue, Apr 19, 2016 at 10:16 PM, Mahesh wrote:
> Hi,
>
> I want to split it by rows.
>
> For example-
> if the text file contains 12 lacs rows, then I would like make 03
> different text files with 4lacs row in each one of them.
> On Apr
Hi,
I want to split it by rows.
For example-
if the text file contains 12 lacs rows, then I would like make 03 different
text files with 4lacs row in each one of them.
On Apr 19, 2016 5:48 PM, "Paul Schreiner" wrote:
> What criteria do you want to divide between the files?
> How do you want to
Hi Ashish,
I am experiencing an issue with my macro file. There are 5 columns and 397
rows in my master worksheet.
So i have created a macro file placing a search button in the one of the
worksheet . Whenever a word is type and we hit search it brings us the
result on the new worksheet, picking t
Hi,
Try this one.
http://download.cnet.com/CSV-Splitter/3000-2074_4-75910188.html
On Tue, Apr 19, 2016 at 5:48 PM, Paul Schreiner
wrote:
> What criteria do you want to divide between the files?
> How do you want to split it into columns?
>
> It is fairly easy to write a VBA macro that will o
What criteria do you want to divide between the files?How do you want to split
it into columns?
It is fairly easy to write a VBA macro that will open the text file and read it
line-by-line.then, depending on your criteria, write the line to an Excel
workbook or simply separate sheets in a singl
Array formula press (Ctrl+Shift+enter)
={LARGE($A$2:$A$21,{1;2;3;4;5})}
On Tue, Apr 19, 2016 at 3:50 PM, amar takale wrote:
> use this formula
>
> =LARGE($A$2:$A$21,{1;2;3;4;5})
>
> On Tue, Apr 19, 2016 at 3:21 PM, Rajesh Agarwal
> wrote:
>
>> Dear Sir
>>
>> Required formula for top 3 unique v
use this formula
=LARGE($A$2:$A$21,{1;2;3;4;5})
On Tue, Apr 19, 2016 at 3:21 PM, Rajesh Agarwal wrote:
> Dear Sir
>
> Required formula for top 3 unique value & bottom 3 unique value excluding
> "Zero".
>
> On Sun, Apr 17, 2016 at 7:06 PM, Rajesh Agarwal
> wrote:
>
>> Hello Sir
>>
>> formula re
Dear Sir
Required formula for top 3 unique value & bottom 3 unique value excluding
"Zero".
On Sun, Apr 17, 2016 at 7:06 PM, Rajesh Agarwal wrote:
> Hello Sir
>
> formula required for top 3 value and lowest 3 value's in attached sheet.
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
--
*Raj
Thanks, Working
On Tue, Apr 19, 2016 at 9:50 AM, Abhishek Jain
wrote:
> Check the attachment.
>
> If both cells do not have same value, the formula would return blank.
>
>
>
> On Tue, Apr 19, 2016 at 12:10 PM, Rajeev Kumar
> wrote:
>
>> Yes,
>> I need a formula that if in the any of column (A o
17 matches
Mail list logo
