Hi,
Yes, it works; but it seems much longer than necessary.
I think =MATCH(6,ATM!$C$3:$AJ$3,0) would work just as well.
As to the Index part of the original function:
When the Index function has a zero as it's second arguemnt, it reurns the
entire array - in our case, of True's and False's. T
Hi,
I have a formula that works, but I'm not sure how the INDEX function
is working:
=MATCH(1,INDEX(--(ATM!$C$3:$AJ$3=6),0),0)
The INDEX part of the above searches for a 6 in the range ATM!$C$3:$AJ
$3.
The -- appears to create an array. Is the -- shorthand for another
function ?
Regards,
Tom
I hope that this request is posted in the correct group and someone
can assist.
A simple spreadsheet with 2 worksheets. The first is a predetermined
list of 100 members names whilst the second contains a number of
columns containing various pieces of information relating to the
members. For simpli
Hi Ramesh,
Supposing that no other split-sequences occur than space, underscore
or hyphen (or a combination of these), then following routine should
do the job...
Enjoy and let me know if it did help you out.
Kind regards
Paul Willekens
'==
I have a macro that runs an iterative process (5 cycles) and I want to
capture a range from a worksheet with the results of each cycle
between iterations in a simple two-dimensional array in VBA and get an
average at the end.
The results of the calculations are in cells A1:B1 of the worksheet
“Res
Hello there,
I have two equally sized ranges of data which I'd like to compare,
however the ranges could potentially start on different rows in
different Worksheets,
E.g. rng1 = Sheets(1).range("A1:D4")
rng2 = Sheets(2).range("B8:E11")
I can do this using "For i = 1 to maxRows" - with a b
Create a master sheet.
Create master list of all names on this sheet.
Now use Vlookup with all sheets and add them.
e.g. In master sheet = Vlookup anmol with sheet A + vlookup anmol with sheet
B + vlookup anmol with sheet C.
On Mon, Mar 29, 2010 at 10:43 AM, L.K.Modi wrote:
> I have workb
Hello.
Give the following macro a try :
Sub test()
Dim c As Range
Dim ResAdr As String
Dim Ctr As Long
Set c = [A:A].Find("ADD NBRCDMACH")
If Not c Is Nothing Then
ResAdr = c.Address
Do
Ctr = Ctr + 1
Cells(Ctr, 2).Value = c.Value & c.Offset(1).Value &
c.Offset(2).
Hello.
Have a look at consolidation (Data, Consolidation)
Regards.
Daniel
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] De la part de L.K.Modi
> Envoyé : lundi 29 mars 2010 07:36
> À : MS EXCEL AND VBA MACROS
> Objet : $$Excel-Macros$$
On Fri, Mar 26, 2010 at 3:24 PM, Prashant Pednekar
wrote:
> On Thu, Mar 25, 2010 at 2:32 PM, Prashant Pednekar
> wrote:
>> Dear All,
>>
>> I am having presentation (PPT) of 3 slide. Each slide contains one excel
>> sheet.
>> The last slide will have sum of values of Sheet 1 to 2 (i.e. Slide 1 &2
Dear All
I have a Workbook containing monthwise April to Dec . 9Sheets
In all sheets my purchase in item and pc are there
There are some common items in each sheet .
Now i want to know the total purchase of a particular item from april
to dec. by using formula.
Suppose in april sheet Item A -
I have workbook having many sheets.
In all sheets some common data are there .After that i want to know
the total in all sheets.
Example
in sheet A
Anmol 200Rs.
In sheet B
Anmol 300Rs.
In sheet C
Anmol400 Rs.
I want to know the total of all anmol in one place
Regards
LKModi
--
12 matches
Mail list logo
