Hi Excel Buddies!
My name is Pooja Sharma, I'm from New Delhi. Working as Lead into Financial
Closing and Reporting with a Gurgaon based MNC.
Apart from my work, I like to travel, enjoy most forms of music, playing Table
Tennis, Gardening.
Excel plays major supportive role in accounting and repo
Hi Everyone,
I am Amar, an insurance professional working in non-life insurance. I love
interacting with people, working in excel and food with different specialities.
I am from Mumbai.
Regards,
Amar
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Rajesh Janardanan
Send
Hi everyone,
My name is Joseph. I live in Mumbai, age 34 years. I work as a Presentation
Specialist. I work only on PowerPoint, Excel and Word.
Thanks and regards,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: resp...@gmail.com
Sender: excel-macros@googlegroups.c
You are welcome Mr. Gandhi..
And I liked the thought you shared :)
It is on a similar line as Chanakya quotes :_
"A person should not be too honest. Straight trees are cut first and
honest people are screwed first."
;)
Regards,
DILIPandey
On 6/9/12, Amit Gandhi wrote:
> thanks Mr Pandey
>
>
use =SMALL($B$2:$B$21,ROW()-1)
On 6/8/12, Rajan_Verma wrote:
> Hi Hilary
>
> You can take idea from this file.
>
>
>
>
>
> Regards
>
> Rajan verma
>
> +91 7838100659 [IM-Gtalk]
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of hilary lomotey
>
dear experts,
I have attached a documents, when i type amount or change rate, then quantity
in matric ton or bags change. but bags is in round function wise and one more
calculation is as without round method. which is highlight as yellow color.
when i type =if (yellowcell <> yellowcell ,"mes
Please replace previous
Please see attached
2012/6/9 ChilExcel :
> Please see attached
>
> 2012/6/9 Vivek :
>>
>> Dear All,
>> Please find enclosed herewith the sample file.
>> Thanks
>> CA Vivek Jain.
>>
>> On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote:
>>>
>>> I have created a file index
Please see attached
2012/6/9 Vivek :
>
> Dear All,
> Please find enclosed herewith the sample file.
> Thanks
> CA Vivek Jain.
>
> On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote:
>>
>> I have created a file index , with separate sheets alphabetically.
>>
>>
>>
>> Now I want to use the vlooku
YOu could use something like this
Use in B1 where you put the client name in A1
=INDEX(INDIRECT("'[sample file register
.xlsx]"&LEFT(A1,1)&"'!$A$2:$A$20"),MATCH(A1,INDIRECT("'[sample file
register .xlsx]"&LEFT(A1,1)&"'!$B$2:$B$20"),0))
Regards,
Sam Mathai Chacko
On Sat, Jun 9, 2012 at 5:06 PM,
thanks Mr Pandey
On Sat, Jun 9, 2012 at 3:03 PM, Dilip Pandey wrote:
> Hi Amit,
>
> See the attached file where I have used Index & Match function in
> combination with Row n Arrays to achieve the desired result. Thanks.
>
> Regards,
> DILIPandey
>
> On 6/9/12, Amit Gandhi wrote:
> > Hi Expert
Dear All,
Please find enclosed herewith the sample file.
Thanks
CA Vivek Jain.
On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote:
> I have created a file index , with separate sheets alphabetically.
>
>
>
> Now I want to use the vlookup function in a new file, wherein I would type
> the
Hi Amit,
See the attached file where I have used Index & Match function in
combination with Row n Arrays to achieve the desired result. Thanks.
Regards,
DILIPandey
On 6/9/12, Amit Gandhi wrote:
> Hi Experts
>
> I want to Lookup PO No. from Lookup data and return all results if there
> are mult
Hi Experts
I want to Lookup PO No. from Lookup data and return all results if there
are multiple occurrences.
How it will be possible? Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pl
13 matches
Mail list logo
