Hi
may be..
Sub kTest()
Dim k(), ka, i As Long, n As Long, c As Long, Cols
Dim MatchKeyAs String
ka = Sheets("PROGRESS
TRACKING-DATA").Range("a1").CurrentRegion.Resize(, 16)
Cols = Array(6, 7, 8, 5, 9, 12, 14, 15)
MatchKey = LCase$(Sheets("REPORT-INDEX").Range("
Hi Aamir,
I think you mean:
=FREQUENCY(IF(ISNA($A$1:$L$1),COLUMN($A$1:$L$1)),IF(NOT(ISNA($A$1:$L$1)),COL
UMN($A$1:$L$1)))
If A1 contains a number instead of the #N/A error, the above formula will
return 0. If you put the above formula in a vertical range of cells
(instead of just one cell) a
HI Team,
Request you help in getting a VBA code to compare two text files for
the difference and the difference needs to be populated in excel with
both the file values(Only different values as the files are huge) and
line number (Optional)
Regards,
Pavan Kumar G
--
FORUM RULES (986+ members al
HI Team,
Request you help in getting a VBA code to compare two text files for
the difference and the difference needs to be populated in excel with
both the file values(Only different values as the files are huge) and
line number (Optional)
Regards,
Pavan Kumar G
--
FORUM RULES (986+ members al
Thanks Andy,
It works very well.
Thanks thank you so much...!
Regards,
Avinash
On Sunday, April 22, 2012 12:18:50 AM UTC+5:30, Andy wrote:
>
> Dear Avinash,
>
> My mistake.. I forgot I am using Excel 2010 and shd have been careful.
>
> Looks like the part of the formula *WEEKDAY(C2,17)* caus
Dear Avinash,
My mistake.. I forgot I am using Excel 2010 and shd have been careful. [?]
Looks like the part of the formula *WEEKDAY(C2,17)* caused the issue.
Change it to *WEEKDAY(C2,1)*
*
*
17 in excel 2010 pertains to the * "*Numbers 1 (Sunday) through 7
(Saturday)" and is not supported
Hi Ashish,
This is my requirement , please advise which function you have used.
best regards
rajesh
On 4/21/12, ashish koul wrote:
> see if it helps choose the field from drop down in yellow cell
>
>
> On Sat, Apr 21, 2012 at 6:52 PM, Rajesh Janardanan
> wrote:
>
>> Hi All,
>>
>> Need to present
Thanks Andy,
I saw the sheet which u have attached and the results also but when i tried
to press enter to that cell it is automatically showing me (
#NUM!) error message i don't know what is the issue i am using excel 2007.
Please help
regards,
Avinash.
On Saturday, April 21, 2012 10:18:38
Another one... without volatile function :)
=COUNTIF(INDEX(A1:L1,LOOKUP(9.999E+307,CHOOSE({1,2},0,MATCH(TRUE,INDEX(ISNA(A1:L1),0),0:INDEX(A1:L1,MATCH(TRUE,INDEX(NOT(ISNA(INDEX(A1:L1,LOOKUP(9.999E+307,CHOOSE({1,2},0,MATCH(TRUE,INDEX(ISNA(A1:L1),0),0)))+1):L1)),0),0)),"#N/A")
Normal enter
Kris
Thank you Asa, I to needed this information, most kind.
Best Regards.
Mr Michael Brumby
Diese Email und samtliche beigefugten Anhange sind vertraulich zu behandeln und
sind vor Veroffentlichung geschutzt. Informieren Sie den Absender bitte
umgehend und loschen Sie diese Nachricht mit al
Hi Siraj,
You mean row 8 or row 7. Row 7 would include row headers...
Before running the code, if you clear-content Report Index from row 8 to
anywhere, the code will place your data there. If you don't clear it, it
will place it from bottom. You should tell if you want to clear the
previous data,
see if it helps choose the field from drop down in yellow cell
On Sat, Apr 21, 2012 at 6:52 PM, Rajesh Janardanan wrote:
> Hi All,
>
> Need to present a graph tomorrow and I am stuck with it ,its could be
> a simple excel graph question.
> Attached file has the trend of business performance over
Hi All,
I am planning to build a forecasting & network optimization product.
Currently I am working in a company & this is my personal part time
project. Any one interested in this project can contact me. Currently, I am
thinking to develop it in C++. Anyone who is willing to put his efforts
p
Hi All,
Need to present a graph tomorrow and I am stuck with it ,its could be
a simple excel graph question.
Attached file has the trend of business performance over a period of
time , I am looking for a graph ( line chart) where revenue over the
period is there in the graph constant always and I
Hi,
Please update we need to follow below steps to enable drag option:
Go to Excel options and select advances-further select option-Enable
fill handle and cell drag and drop.
Once this option is selected you will get required dragger on your
excel workbook.
Regards,
Vikram
On 4/21/12, Ashish
Hi,
You didn't provide any feedback for your first query. As a matter of fact,
I'm not really happy with the code I provided you with. First there would
be ways to do this using excel formula such as vloopkup and match I used
once, vlookup looks for the data, and match should tell vlookup to lo
*Can you show sample OUTPUT in another column...*
*
*
On Sat, Apr 21, 2012 at 1:16 AM, Ashish Bhalara
wrote:
> Dear sir,
>
> I want to write the cell address to fulfill formula, is there any solution
> for it?
>
> Ashish
>
>
> On Sat, Apr 21, 2012 at 12:29 PM, Waseem Saifi wrote:
>
>>
>> I hope th
. Send a blank email to excel-macros+unsubscr...@googlegroups.com
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rohit Kumar
Sent: Apr/Sat/2012 01:10
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Remove me from mailing li
Hi.. Kindly remove my name from mailing list.
Thanks
Rohit
rohit...@yahoo.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Actually these files are thr part of some imported system reports of ma bank
which can not be transit outside the bank,
Hence can't share, we create a sample file at our own by giving subject as below
Report name date
USER IDS DATETIMEREASON
Pls copy paste these details in text f
20 matches
Mail list logo