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?
THANKS FOR GREAT TRICK VAIBHAV
WORKING PERFECTLY
On Thu, Feb 26, 2015 at 12:01 PM, amar takale amartak...@gmail.com 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 v...@vabs.in wrote:
Dear Amar
Data in col
plz check the the attachment
On Sat, Nov 8, 2014 at 12:48 PM, Kartik Dale kartik.1...@gmail.com 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?
with sorting. Remove
Duplicates (under Data tab) will give you the same results.
Regards, Abhishek
On Sat, Jun 21, 2014 at 4:11 PM, Sourabh Salgotra rhtdmja...@gmail.com
wrote:
Dear Sir,
plz solve my query related to getting the unique and
sorting data from the list. sample
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
use =SMALL($B$2:$B$21,ROW()-1)
On 6/8/12, Rajan_Verma rajanverma1...@gmail.com 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
:59 PM, ashish koul koul.ash...@gmail.com wrote:
see if it helps
On Mon, Jun 4, 2012 at 8:48 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
Dear Sir,
i have little knowledge about vba. that's why i am asking sol
with index/match.
and plz tell me abt offset function also
...@gmail.com
*From:* Sourabh Salgotra rhtdmja...@gmail.com
*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.
plz provide index/atch solution also
On Sun, Jun 3, 2012 at 6:35 PM
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!
IF needed
.AutoFilter Field:=2
.AutoFilter Field:=3, Criteria1:=Sheets(form).Range(n1)
.Offset(1, 3).Resize(, 2).SpecialCells(xlVisible). _
Copy Sheets(form).Range(d35)
End With
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Sourabh
3, 2012 at 9:33 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
DEAR SIR,
PLZ DOWNLOAD THE ATTACHED FILE AND GIVE THE CODE FOR
CREATING FUNCTION TO CALCULATE WEIGHT AGE AND GRADE
Thanks
EVALUATE for the formula.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Sourabh Salgotra rhtdmja...@gmail.com
*Sent:* Friday, May 04, 2012 1:03 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION
Dear
Bucket
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
*Sent:* 03 May 2012 21:34
*To:* excel-macros@googlegroups.com
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.
Please see
i think u want as attachment. see attachment
On Wed, Mar 28, 2012 at 4:51 PM, karunanithi ramaswamy era_...@yahoo.comwrote:
Sir,
the file is attached.
*From:* dguillett1 dguille...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tuesday, March 27, 2012 11:39 PM
*Subject:* Re:
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
chk attachments solved
On Fri, Mar 2, 2012 at 6:11 PM, Shaik Waheed waheedb...@gmail.com 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 satvik...@gmail.com wrote:
Hi Every
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 satvik...@gmail.com wrote:
**
Shaik,
As off now I'm doing the same logic. Where as my data volume is too
high!
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 xlst...@gmail.com wrote:
please find the attachment
On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote
thanks kris sir and sam sir .
On Tue, Feb 7, 2012 at 10:30 PM, Sam Mathai Chacko samde...@gmail.comwrote:
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
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 dguille...@gmail.com 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
use http://translate.google.co.in/
On Fri, Jan 20, 2012 at 6:26 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
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
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
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
*
*
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 noorain.ans...@gmail.comwrote:
Dear Amar,
Please use below formula to count total unique name
*=SUM(1/COUNTIF(B2:B6,B2:B6))
*press ctrl+Shift+Enter
or
/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra
rhtdmja...@gmail.comwrote:
*
*
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
and plz explain the sum formula of counting unique records
On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
Thank you so much sir, if we want without help. col
On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
Dear Sourabh
}
On Wed, Dec 14, 2011 at 4:27 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
through 2nd dropdown i want the extract the information of that student
whose name enroll no is selected.
On Tue, Dec 13, 2011 at 11:35 PM, dguillett1 dguille...@gmail.comwrote:
You don’t say what you
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 talk2mar...@gmail.com wrote:
Find the attachment...
On Wed, Dec 14, 2011 at 10:00 PM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hi Sourabh,
://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Thu, Dec 15, 2011 at 7:52 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
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
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
, a macro 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 rhtdmja...@gmail.com
*Sent:* Tuesday
, 2011 at 4:27 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
through 2nd dropdown i want the extract the information of that student
whose name enroll no is selected.
On Tue, Dec 13, 2011 at 11:35 PM, dguillett1 dguille...@gmail.com wrote:
You don’t say what you are to do
{12;10;6;10;4;14;6;4;12;3;6;1;1;6}
On Wed, Dec 14, 2011 at 4:27 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
through 2nd dropdown i want the extract the information of that student
whose name enroll no is selected.
On Tue, Dec 13, 2011 at 11:35 PM, dguillett1 dguille...@gmail.comwrote
that it should not be a drop down.
Anyway, a macro 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 rhtdmja
plz tell me about 9E300.
On Wed, Nov 23, 2011 at 8:06 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Great Solution Haseeb..Excellent..
On Wed, Nov 23, 2011 at 12:59 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello Santosh,
Another one.
On Sat, Oct 1, 2011 at 1:23 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
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 c3 then result
not working
On Sat, Oct 1, 2011 at 10:40 AM, Sam Mathai Chacko samde...@gmail.comwrote:
USE
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 rhtdmja...@gmail.comwrote:
VERY VERY THANKS SIR FOR HELPING ME I HAVE ONE QUERY ALSO PENDING
I WANT THAT WHICH CELLS HAVE NOT ANY RESULT
(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9))-MIN(ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9)))+1,),ROW($A1
Sam
On Sat, Oct 1, 2011 at 10:21 PM, Sourabh Salgotra
rhtdmja...@gmail.comwrote:
I HAVE CHECKED ITS WORKING BUT PROBLEM IS THAT THIS FORMULA IS ON MY TIPS
. SO THAT'S WHY I WANT ERROR
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 amreshkushw...@gmail.comwrote:
Hi PFA Solution.
On Fri, Sep 30, 2011 at 12:49 AM, Sanjib Chatterjee
42 matches
Mail list logo