Respected Group Members
kindly download the sample file for detail.
Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of
Dear Sir,
please help me to enable the insert option context menu.
Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A
THANKS FOR GREAT TRICK VAIBHAV
WORKING PERFECTLY
On Thu, Feb 26, 2015 at 12:01 PM, amar takale wrote:
> pls look sheet where sheetl1 not change as per you saying. Pls explain me
>
> On Thu, Feb 26, 2015 at 10:58 AM, Vaibhav Joshi wrote:
>
>> Dear Amar
>>
>> Data in col b date only, you just n
plz check the the attachment
On Sat, Nov 8, 2014 at 12:48 PM, Kartik Dale wrote:
> Hi All,
>
> I want to disable the "Pick from Drop-down list" option on mouse right
> click.
>
> [image: Inline image 1]
>
>
>
> --
> Thanks
> Kartik
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
> Duplicates (under Data tab) will give you the same results.
>>
>> Regards, Abhishek
>>
>>
>> On Sat, Jun 21, 2014 at 4:11 PM, Sourabh Salgotra
>> wrote:
>>
>>> Dear Sir,
>>>
>>> plz solve
Dear Sir,
plz solve my query related to getting the unique and
sorting data from the list. sample sheet attached.
Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapya
My name is Sourabh Salgotra, I'm from Batala(Punjab). I am running computer
hardware business. i like biking, listening qwallis, old is gold song,
ghazal's.
On Sun, Jun 10, 2012 at 12:17 PM, wrote:
> **
> Hi Excel Buddies!
>
> My name is Pooja Sharma, I'm from New
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
>
ethod.
On Mon, Jun 4, 2012 at 8:59 PM, ashish koul wrote:
>
> see if it helps
>
>
> On Mon, Jun 4, 2012 at 8:48 PM, Sourabh Salgotra wrote:
>
>> Dear Sir,
>>
>>i have little knowledge about vba. that's why i am asking sol
>> with in
Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Sourabh Salgotra
> *Sent:* Sunday, June 03, 2012 12:53 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Records found but unable to get proper
> result.
>
> thanks for help.
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Sourabh Salgotra
> *Sent:* Sunday, June 03, 2012 5:08 AM
> *To:* excel-macros@googlegroups.com
> *Cc:* Don Guillett ; rajanverma1...@gmail.com ;
> noorain.ans...@gm
Dear sir,
i am using index/match formula. in my problem i am getting the
1st occurrence result only.
Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS I 2
#NUM! #NUM! 3 #NUM! #NUM! 4 #NUM! #NUM! 5 #NUM!
#NUM! 6 #NUM! #NUM!
or the formula.
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Sourabh Salgotra
> *Sent:* Friday, May 04, 2012 1:03 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION
t; On Thu, May 3, 2012 at 9:33 PM, Sourabh Salgotra wrote:
>
>>
>> DEAR SIR,
>>PLZ DOWNLOAD THE ATTACHED FILE AND GIVE THE CODE FOR
>> CREATING FUNCTION TO CALCULATE WEIGHT AGE AND GRADE
>>
>>
>> --
Criteria for Calculation/
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sourabh Salgotra
> *Se
plz check attachement
On Mon, Apr 9, 2012 at 4:48 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
>
> Dear Sir,
> previously i sent you the mail. But I got the error message that the
> message I am sending
> is cross the allocated limit so I am sending you the fresh message.
>
> Ple
chk this one.
--
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
quick attention or may not be answered.
2) Don't post a questio
i think u want as attachment. see attachment
On Wed, Mar 28, 2012 at 4:51 PM, karunanithi ramaswamy wrote:
> Sir,
> the file is attached.
>
>*From:* dguillett1
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, March 27, 2012 11:39 PM
> *Subject:* Re: $$Excel-Macros$$ REG:$$Column to
u can try this one
=INDEX('E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$B$11,MATCH(A2,'E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$A$11,0),2)
On Sat, Mar 3, 2012 at 7:19 AM, Satvik wrote:
> **
> Shaik,
>
> As off now I'm doing the same logic. Where as my data volume is too
> high! Is there any oth
chk attachments solved
On Fri, Mar 2, 2012 at 6:11 PM, Shaik Waheed wrote:
> Hi,
>
> Do you want to chek whether the master file ph.# are callable or
> non-callable by verying it with NDNC sheet?
>
>
>
> On Sat, Mar 3, 2012 at 4:16 AM, Satvik wrote:
>
>> Hi Every One,
>>
>> Friend I need a b
thanks for help sir
i am already done with if statement. chk attachment.
and provide other solution vlookup/index-match
On Sun, Feb 26, 2012 at 9:33 PM, xlstime wrote:
> please find the attachment
>
> On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote:
>
>> Dear sir,
thanks kris sir and sam sir .
On Tue, Feb 7, 2012 at 10:30 PM, Sam Mathai Chacko wrote:
> I would also go with the LOOKUP suggested by Kris as it is direct, and
> simple. But if you do not want to make any change to your layout, you could
> also use a CSE formula
>
> =INDEX($H$3:$H$9,MATCH(B2,--T
9,$H$3:$H$9)
>
> See attached sheet..
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>
> On Tue, Feb 7, 2012 at 8:05 PM, Sourabh Salgotra wrote:
>
&g
plz sir explain this formula i have confusion in this. how it can take
total values from data sheet.
On Thu, Jan 26, 2012 at 10:19 PM, dguillett1 wrote:
> Simpler with no CSE
>
> '=INDEX(Data!$A$1:$L$37,MATCH($E3,Data!$A:$A),MATCH(F$2,Data!$1:$1,0))
>
> Don Guillett
> SalesAid Software
> dgui
many -2 thanks to all of u
--
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
quick attention or may not be answered.
2) Don't p
go to run type cmd
@command prompt type
attrib -r -s -h -a filename
--
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
quick atte
use http://translate.google.co.in/
On Fri, Jan 20, 2012 at 6:26 PM, Rajan_Verma wrote:
> I think no way in excel without use of any other software
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *anil kumar
and plz explain the sum formula of counting unique records
On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra wrote:
> Thank you so much sir, if we want without help. col
>
>
> On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI > wrote:
>
>> Dear Sourabh,
>>
lmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra
> wrote:
>
>> *
>> *
>> dear sir
>> plz tell me that how i can these fourmula on multiple match
*
*
dear sir
plz tell me that how i can these fourmula on multiple match
like
attachment.
On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI wrote:
> Dear Amar,
>
> Please use below formula to count total unique name
> *=SUM(1/COUNTIF(B2:B6,B2:B6))
> *press ctrl+Shift+Enter
>
> or use this one to
croworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Thu, Dec 15, 2011 at 7:52 AM, Sourabh Salgotra wrote:
>
>> thanks to all of you for help
>>
>>
>> but in this sol name are repeating and
thanks to all of you for help
but in this sol name are repeating and not in sorted order
On Thu, Dec 15, 2011 at 12:25 AM, Maries wrote:
> Find the attachment...
>
>
> On Wed, Dec 14, 2011 at 10:00 PM, Haseeb Avarakkan <
> haseeb.avarak...@gmail.com> wrote:
>
>> Hi Sourabh,
>>
>> Used a dif
;"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"},
> ">"&{"DD";"EE";"FF";"EE";"GG";"BB";"FF";&qu
uot;EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"},
> ">"&{"DD";"EE";"FF";"EE";"GG";"BB";"FF";&qu
;EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"},
> ">"&{"DD";"EE";"FF";"EE";"GG"
ot;GG";"DD";"TT";"FF";"VV";"VV";"FF"},
">"&{"DD";"EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";&qu
acro can:
> 1. make a list from your existing full list
> 2. As each name is selected, remove it from the created list. Or, if no
> longer needed, the original list.
> etc
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Sourabh Salgotra
&g
Dear Sir,
plz download the attached file. detail query in file.
Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc
--
FORUM RULES (934+ members already BANNED f
plz tell me about 9E300.
On Wed, Nov 23, 2011 at 8:06 AM, NOORAIN ANSARI wrote:
> Great Solution Haseeb..Excellent..
>
>
> On Wed, Nov 23, 2011 at 12:59 AM, Haseeb Avarakkan <
> haseeb.avarak...@gmail.com> wrote:
>
>> Hello Santosh,
>>
>> Another one.
>>
>>
>> =IFERROR(LOOKUP(9E300,SEARCH
plz tell me that what's the meaning of* -- *in fourmula
=SUMPRODUCT(*--*($D$2:$D$21=D22)*($E$2:$E$21))
On Sat, Nov 12, 2011 at 10:11 AM, jmothilal wrote:
> THANKS SO MUCH , ITS WORKING FINE GET THE RESULTS.
>
> THANKS WITH
>
> MOTHILAL.J
>
> On Fri, Nov 11, 2011 at 10:31 PM, NOORAIN ANSARI
p;"!$B$2:$B$9"))),ROW(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9"))-MIN(ROW(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$B$2:$B$9")))+1,""),ROW(A1))),"",INDEX(INDIRECT(TEXT(SEARCH!$D$1,"MMMYY")&"!$A$2:$A$9&q
second post, you will not get that #NUM error. Check
> the attached file in my previous post.
>
> Sam
>
>
> On Sat, Oct 1, 2011 at 10:12 PM, Sourabh Salgotra wrote:
>
>> VERY VERY THANKS SIR FOR HELPING ME I HAVE ONE QUERY ALSO PENDING
>>
>> I WANT THAT WHIC
not working
On Sat, Oct 1, 2011 at 10:40 AM, Sam Mathai Chacko wrote:
> USE
>
>
> =INDEX(INDIRECT(TEXT(D1,"MMMYY")&"!$A$2:$A$65536"),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(D1,"MMMYY")&"!$B$2:$B$65536"))),ROW(INDIRECT(TEXT(D1,"MMMYY")&"!$B$2:$B$65536"))-MIN(ROW(INDIRECT(TEXT(D1,"MMMYY")&"!$B$
On Sat, Oct 1, 2011 at 1:23 PM, Sourabh Salgotra wrote:
> thanks for help
>
> but in this sheet all the data returned from the selected sheet searching
> not working.
>
> i want 2 solutions
>
> 1 choose sheet
> 2 search data (which is in c3 cols) if u type singh in
SIMPLE WAY
SELECT THAT CELLS
GO TO FORMAT CELLS
THEN
CLICK ON NUMBER--CUSTOM---
TYPE THE DD-MMM-YY IN THE TYPE FIELD
On Fri, Sep 30, 2011 at 2:28 PM, Amresh Maurya wrote:
> Hi PFA Solution.
>
> On Fri, Sep 30, 2011 at 12:49 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com>
45 matches
Mail list logo