*hi LK modi
use this simpler formula
=LOOKUP(2,1/(A1:A10=A2),B1:B10)
file is attached
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Jul 8, 2011 at 10:56 AM, harsh shah wrote:
> HOPE THIS MIGHT BE USEFUL.
Thanks Vasant, Haseeb, Rajan and Ashish for your solution .. you guys are
Master !
Regards,
AK
On Fri, Jul 8, 2011 at 5:39 AM, ashish koul wrote:
> =INDEX($1:$1,0,SMALL(IF(D2:AB2>0,COLUMN(D2:AB2),""),1))
>
> press ctrl +shift+ enter
>
> check the attachment
>
>
> On Fri, Jul 8, 2011 at 12:31 AM
Thanks Ashish
Thanks Ankur
On Thu, Jul 7, 2011 at 11:51 AM, ankur wrote:
> *
> *Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
> On Wed, Jul 6, 2011 at 6:05 PM, ankur wrote:
>
>> *hi ashish sir
>> may t
HOPE THIS MIGHT BE USEFUL.
On 8 July 2011 10:09, L.K. Modi wrote:
> Dear Members,
>
> Thanks for your valuable support. I have an querry in which i have to check
> interest calculation for banks.
>
> Me attaching a sheet in which column A have date that is in different
> format. and in column B
hi
check the attachment see if it helps
On Fri, Jul 8, 2011 at 10:09 AM, L.K. Modi wrote:
> Dear Members,
>
> Thanks for your valuable support. I have an querry in which i have to check
> interest calculation for banks.
>
> Me attaching a sheet in which column A have date that is in different
add this code to new workbook and run the macro and choose the csv file
Option Compare Text
Sub swa()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim s As Workbook
Dim i, j, k As Long
Set s = Workbooks.Open(Application.GetOpenFilename)
j = 1
For i = 1 To s.Sheets(1).Ra
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in which column A have date that is in different
format. and in column B the balance as on the respective dates.
As the bank charges interest on the clos
Hi Daniel
Thanks for code. Have done as you suggest and installed in the Shipments
wb. When I run the code it goies thru to var =... and gives a
message that ' variable not defined ' .
Is there something missding ?
Your help appreciated.
Thanks
Charlie
On Fri, Jul 8, 2011 at 3:
thanks rajan. this is really great. i didnt know abt this. thanks again
>
>From: Rajan_Verma
>To: excel-macros@googlegroups.com
>Sent: Tue, 5 July, 2011 12:53:47 PM
>Subject: RE: $$Excel-Macros$$ copy data without opening file
>
>
>No, We cant Copy the data from Closed Workbook.. but we can ge
thanks ashish but i dont want to open it coz file is on server and it takes
lots
of time to open n close. so is there any way to reduce opening and closing
time?
file size is in few KB but it takes 1 min to open n close the file.
>
>From: ashish koul
>To: excel-macros@googlegroups.com
>Sent
Hi Ankur,
this is FANTASTIC. thanks a lot.
>
>From: ankur
>To: excel-macros@googlegroups.com
>Sent: Tue, 5 July, 2011 12:16:06 PM
>Subject: Re: $$Excel-Macros$$ copy data without opening file
>
>check this also
>one sample file and explanations is given
>http://www.vbaexpress.com/kb/getarticle.
=INDEX($1:$1,0,SMALL(IF(D2:AB2>0,COLUMN(D2:AB2),""),1))
press ctrl +shift+ enter
check the attachment
On Fri, Jul 8, 2011 at 12:31 AM, Rajan_Verma wrote:
> *Try this Function in C2*
>
> * *
>
> *Function GetStartDate(RevRange As Range) As Variant*
>
> *Dim cell As Range*
>
> *For Each cell
Please Remove that Line From the Code. It will work fine..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vasant
Sent: Thursday, July 07, 2011 11:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert HTML file to Excel
Yes
Try this Function in C2
Function GetStartDate(RevRange As Range) As Variant
Dim cell As Range
For Each cell In RevRange
If cell.Value > 0 Then
GetStartDate = Cells(1, cell.Column).Value
Exit Function
End If
Next
End Functio
Please attached corresponding data
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Thursday, July 07, 2011 8:15 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Pivot Issue
Hi,
The data is not displaying in the b
Hi,
C2 copy down.
=IFERROR(INDEX(D$1:SF$1,MATCH(TRUE,INDEX(ISNUMBER(1/D2:SF2),),0)),"Not
Started")
HTH
Haseeb
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
ht
Yes Rajan, the code is calling a procedure in
Call bulkUpload.GenerateReport
The procedure has not been included.
Could you please include that also ?
On Thu, Jul 7, 2011 at 10:45 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:
> Thanks a lot Rajan. But the below macro is n
Pls find a UDF
Public Function GetFirstRevenueDate(Rng As Range)
For Each cls In Rng.Cells
If cls.Value > 0 Then
Dt = Cells(1, cls.Column)
GetFirstRevenueDate = Format(Dt, "dd-mmm-")
Exit Function
End If
Next
End Function
File attached.
On Thu, Jul 7, 2011 at 10:05 PM, AK wrote:
> Hi Exper
Thanks a lot Rajan. But the below macro is not running in Excel 2003 or any
reference need to select from Tools. Please confirm.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339 / 6340
Hi Experts,
Could you please look into my excel query. I have the multiple columns
filled with some Revenue values. I need the first month when the revenue
started flowing in (anything which is greater than 0).
For example – for the Account Name: Mohan, We started recognizing the
revenue from ‘
Hi,
The data is not displaying in the below code which has written for pivot.
Please let me know where is the error is.
Thanks in advance
Sub pivot_table()
Dim pvt_ch As PivotCache
Dim pvt_tbl As PivotTable
Dim rng As Range
Set rng = ThisWorkbook.Worksheets("Formatdata").UsedRange
Set pvt_ch = T
Dear Friends,
I have a BOQ(Bills of Quantity) and I need to add a formula to each rate.
The formula should be as follow.
=rate*(Constant cell reference)
For an example;
The rate on cell E18 is 250.00 (see attached BOQ)
It should like this after run the macro
'=250*($H$1)
It need to repeat for
Hello :
Note that the macro should be in the Shipment-New.xls workbook :
Sub CopyComments()
Dim Rg As Range, C As Comment
Dim Sh As Worksheet, x As Range
Set Sh = Workbooks("Database.xls").Sheets("Sheet1")
With Sheets("Sheet1")
For Each Rg In .Range(.[J12], .Cells(.Rows.Count, 10).
Hi Rajan,
I would be doing filter not on the pivot table...but on the data in
the sheet 1 which should reflect in the chart and the table.
Cheers
Atul
On 7/7/11, Rajan_Verma wrote:
> Hi,
> It's a pivot chart in your sheets its taking references from Pivot Table ,
> when you will apply filter in
Hi,
It's a pivot chart in your sheets its taking references from Pivot Table ,
when you will apply filter in Pivot table it will Show Only Filter Summary
Data,
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Atul Kesaria
Sent: Thur
hi,
the betterr is
=DATE(YEAR(C4),MONTH(C4)+1,5)
because he wants 'next month' 5th.
R.Karunanithi
--- On Thu, 7/7/11, ashish koul wrote:
From: ashish koul
Subject: Re: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Thursday, July 7, 2011, 11:26 AM
use
Hi,
u use this
=DATE(YEAR(C4),MONTH(C4)+1,5)and drag the fill handle down till c4 is not
blank.
u will get what u want.
R.Karunanithi.
--- On Thu, 7/7/11, L.K. Modi wrote:
From: L.K. Modi
Subject: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Th
Hi
Have a photo in a comments box in Database.xls. Also have a vlookup in
another workbook Shipment-New.xls to bring forward the text from the cell
into
the wb. This works great. I also want to bring forward the comment box
in the same cell from Database.xls into Shipment-New.xls.
Would li
See if it help
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Atul Kesaria
Sent: Thursday, July 07, 2011 12:11 PM
To: excel-macros
Cc: atul.kesaria
Subject: $$Excel-Macros$$ Help on Chart
Hello Team,
I am preparing chart basis
*hi atul
dynamic chart preparation can help
have a look link below
http://chandoo.org/wp/2009/02/12/make-a-dynamic-chart-using-data-filters/
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 12:11
chart only represent the data of visible cells if you hide any rows or
will apply filter it will show the data of visible cells only
check the attachment choose any name u will see the chart will automatically
change
if it is not working as per the default setting .
http://office.microsoft.com
31 matches
Mail list logo
