Thanks Mahesh Vaibhav,
Its working fine :)
Thanks,
Waheed
On Tue, Sep 9, 2014 at 11:27 AM, Mahesh Patil zmpa...@gmail.com wrote:
Hi,
PFA
On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi friends,
I need your help to create a macro, its motive is to find out
Hi friends,
I need your help to create a macro, its motive is to find out the variable
cost of physicians 4000.
Attached is the sample data for your reference.
Thanks in advance.
Waheed
--
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
Its working, Thank you Ashish for your help :)
Thanks,
Waheed
On Fri, Jul 11, 2014 at 9:51 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Waheed,
PFA sheet and its code is working on Column D only.
Regards
Ashish
On 11 July 2014 20:58, Shaik Waheed waheedb...@gmail.com wrote
Yes Ashish,
I only need one unique record
Ex: If its Ashish Kumar
Ashish K
I need only one name.
Thanks again,
Waheed
On Thu, Jul 10, 2014 at 7:50 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Waheed,
This code is find all duplicates like :
Shaik Waheed Khan
Shaik Waheed K
I
Hi Friends,
I need your help to remove duplicate names from two columns and produce a
single column with unique names and followed by the comparision years like
2013 2014
The problem here is that there is a minor difference in the duplicate
entry, like (,.or last letter). I have highlighted
Yes Ashish
Thanks,
Waheed
On Thu, Jul 10, 2014 at 6:26 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Waheed,
You want to find duplicates in A D column. ??
Regards
Ashish
On 10 July 2014 18:04, Shaik Waheed waheedb...@gmail.com wrote:
Hi Friends,
I need your help to remove
On 10 July 2014 18:48, Shaik Waheed waheedb...@gmail.com wrote:
Yes Ashish
Thanks,
Waheed
On Thu, Jul 10, 2014 at 6:26 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Waheed,
You want to find duplicates in A D column. ??
Regards
Ashish
On 10 July 2014 18:04, Shaik Waheed
PFA sheet solved,
You can split your data by using text to columns wizard and selecting
comma in the options.
One done with this you will data splitted in mutliple columns, now give a
min formula for the beside row, it will give u minimum value, drag it
down till the data is available. Once done,
Freeze the cell by pressing F4 once, it wil give you $ symbol along with
the cell adress
On Fri, Jan 25, 2013 at 5:26 PM, Sadia Khalid sadiakhalid...@gmail.comwrote:
SALAM
Hi Every one Hope that all of you are fine.
How i can use this formula to have the absolute cell address.
/CreatingCompoundDocumentsProgrammaticallyUsingOleObjects.htm
http://vba2008.wordpress.com/2008/10/17/adding-an-ole-object-command-button-to-a-worksheet-using-excel-vba/
On Wed, Nov 28, 2012 at 6:02 PM, Shaik Waheed waheedb...@gmail.comwrote:
Hi All,
I need to insert multiple mail objects into excel. I have around hundred
Hi All,
I need to insert multiple mail objects into excel. I have around hundred of
mails in a folder in my outlook. I have tried it to save individually and
then insert, but its a time consuming process, If you guys can suggest a
better way to get this done will be great.
Thanks,
Waheed
--
PFA,
Hope this is what u were luking for
On Wed, Oct 31, 2012 at 1:20 PM, Rajesh Agarwal rajey...@gmail.com wrote:
PFA
--
*Rajesh Kumar Agarwal*
*9811063001*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
yeah sure, can u share ur sample file
On Wed, Oct 31, 2012 at 2:33 PM, Sheyn Lee sheyn...@gmail.com wrote:
Dear Excel group members,
Is there any way that I can get percentile values from a pivot table.
Appreciate your help.
S
--
Join official facebook page of this forum @
PFA
On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
see attached sheet.
On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Muneer,
Please use below formula
=SUMPRODUCT((A2:A8=D5)*(B2:B8))
or
=Sumif(A2:A8,d5,B2:B8)
So exactly what you are looking for? A drop down list to show the total in
adjacent column?
I have created a dropdown, if you looking for somthing else, then please
explain a bit more
On Thu, Jul 12, 2012 at 5:21 PM, Mohammed Muneer mmun...@ccc.com.qa wrote:
Thanx *Noor *for this also,
=vlookup(I7,$E$7:$F$14,2,1)
On Mon, Jul 2, 2012 at 11:32 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Manoj,
Please more explain..what is your exact requirement.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Mon, Jul 2, 2012 at
PFA
On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल tosune...@gmail.com wrote:
Dear all,
It has always been previlege to query on this group whenever needed and
thanks from heart.
I need one help regarding finding out maximum number and their name in one
cell ?
Have a wonderful day !!
Hi Sunita,
In my case, I have used filters since it becomes more easier
On Mon, Jun 25, 2012 at 12:49 PM, सुनिता पौडेल tosune...@gmail.com wrote:
did you filtre the column?
thank you
On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed waheedb...@gmail.comwrote:
PFA
On Mon, Jun 25, 2012
Hi,
You can use the following code, i had been using this..
Sub unhide_sheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = True
Next ws
End Sub
On Tue, Jun 5, 2012 at 1:33 PM, jayendra gaurav
jayendra.gau...@gmail.comwrote:
Dear Team,
I required your
Hi,
PFA
On Tue, May 8, 2012 at 12:43 PM, Soni.Rajender soni.rajen...@gmail.comwrote:
Dear Team
Please go through the attached excel sheet and help me in the calculation
of* discount* (Column - D) based on the *discount criteria *(Column G:I)
Regards
Rajender Soni
--
FORUM RULES (986+
Hi,
PFA
On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar
kumar.pramod03i...@gmail.comwrote:
Hi Experts,
PLease solve my query.
I need age betbeen in two dated like as 2 year 3 Month)
--
Regards,
Pramod Kumar
Technocare Solution(TCS)
Rudrapur
+91 9927033573
Can you explain a bit more, like how it is and how it shud be with example
On Tue, May 1, 2012 at 1:53 PM, Dhanesh Verma dhanesh.ve...@denonline.inwrote:
Dear Friends,
** **
I want to put a formula in the attached sheet to calculate automatically
as and when I change the periods.,
Hi,
PFA
On Mon, Apr 30, 2012 at 5:11 AM, pawel lupinski lupins...@yahoo.com wrote:
Hi All,
I'm asking you for help, I have a problem with compering two cells base on
conditions. There is no problem if everything is running in order, but if
there is a gap ... there is wrong answer given,
,*
*
*Deba Ranjan P***
On Fri, Apr 27, 2012 at 12:49 PM, vaibhav joshi vaibhav...@gmail.comwrote:
Hi Waheeb
Please give me the formula for the same I would like to apply for full
sheet
Thanx lot for your valuable support
Vaibhav
On Fri, Apr 27, 2012 at 12:17 PM, Shaik Waheed
Hi Rabinder,
PFA, hope this what you are looking for.
On Fri, Apr 27, 2012 at 1:48 PM, CoRe neculae.vale...@gmail.com wrote:
Hello Ravin,
Please check the file attached .
To open Data Validation form , ALT+ D + L
If you have any queries , let me know.
On Thursday, April 26, 2012
Hi Vijay,
PFA, hope this is what you are looking for
On Fri, Apr 27, 2012 at 8:13 PM, Vijayendra Rao vijayendrar...@gmail.comwrote:
Dear All,
I need one formula which will using for accounting entries, I tried
sumproduct but it doesnt work. I have attached is the same file.
Regards,
HI Daniel,
Please use seperate post for your queries, by the way u can use this
formula to count:
=COUNTIF(A:A,=4/30/2012)
Note: How u r getting the 5 as answer i dont understand.
On Thu, Apr 26, 2012 at 2:47 PM, danial mansoor danial_...@hotmail.comwrote:
attached sheet need formula for
Hi Ranjan,
PFA, hope this is what u r luking for...
On Wed, Apr 25, 2012 at 11:54 AM, Deba Ranjan drdeva...@gmail.com wrote:
*
*Hi Experts,
Please find the attached file. i have a problem in that , the words pr
numbers are in only one cell. i want to make separate out of that cell to
ie the formula for that ?? can you please
explain me that ??
*
Thanks Regards,*
*
*Deba Ranjan P***
On Wed, Apr 25, 2012 at 12:05 PM, Shaik Waheed waheedb...@gmail.comwrote:
Hi Ranjan,
PFA, hope this is what u r luking for...
On Wed, Apr 25, 2012 at 11:54 AM, Deba Ranjan
Hi,
PFA, is this what u r looking for?
On Thu, Apr 19, 2012 at 4:26 PM, Soni.Rajender soni.rajen...@gmail.comwrote:
Dear Team
Please find attached the excel workbook having a pivot table in one sheet
and the relevant data in other sheet.
I want to display the top 3 states zonewise in the
Hi,
Function English(ByVal N As Currency) As String
Const Thousand = 1000@
Const Million = Thousand * Thousand
Const Billion = Thousand * Million
Const Trillion = Thousand * Billion
If (N = 0@) Then English = zero: Exit Function
Dim Buf As String: If (N 0@)
:
yes, This is is excetly what I am looking for.
would you explain please.
regards,
sanjib
On Wed, Apr 11, 2012 at 12:45 PM, Shaik Waheed waheedb...@gmail.comwrote:
Hi Sanjib,
PFA check sheet 2. Hope this helps
On Wed, Apr 11, 2012 at 10:54 AM, Sanjib Chatterjee
chatterjee.kolk
One more thing, i have observed that the amount total is not matching for
this u need to enter the S amount in positive only...the formula then
calcuates.
On Wed, Apr 11, 2012 at 3:10 PM, Shaik Waheed waheedb...@gmail.com wrote:
Sanjib,
Click on the pivot, on the toolbar, click on options
chatterjee.kolk...@gmail.com wrote:
Dear Shaik Waheed,
I am unable to put any formula in the pivot table.
Please help.
Thanking you in advance
Regards
Sanjib
- Show quoted text -
On Wed, Apr 11, 2012 at 3:13 PM, Shaik Waheed waheedb...@gmail.comwrote:
One more thing, i have observed
You just need to double click on the formual cell, the formula will be
copied to the last data cell.
On Tue, Apr 10, 2012 at 7:57 PM, Dilan De Silva dila...@gmail.com wrote:
Paul,
Thank you for the reply.
If I used your answer, I have to paste it on each cell. Paste the formula
in a work
Hi Amit,
How abt a keyboard shortcut for this,
Select the second row ''Cntrl X'' go to the first row and press
Cntrl +
On Wed, Mar 21, 2012 at 8:50 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Amit,
Pls check attached sheet.
On Wed, Mar 21, 2012 at 7:49 AM, Amit Desai
Hi,
Check out the below link
http://www.contextures.com/CreatePivotTable.html
On Tue, Mar 20, 2012 at 2:53 PM, Karan Singh karan1...@gmail.com wrote:
Dear All,
Kindly send me some pivot table examples. I want to learn it.
Thanks
Kaяan
http://www.facebook.com/singhkarann
Hi Hilary,
Enter the below formula in F13 and drag it down
=IF(OR(A13=,D13=),,E13-D13))
HTH,
Waheed
On Mon, Mar 19, 2012 at 3:24 PM, hilary lomotey resp...@gmail.com wrote:
Hello Expert
in the attached file, when i select from the drop down list in cell B8, i
get a value error in column F
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 One,
Friend I need a big help from you all, as I work in BPO company as a MIS
executive but I am not
--
*From: *Shaik Waheed waheedb...@gmail.com
*Sender: *excel-macros@googlegroups.com
*Date: *Fri, 2 Mar 2012 18:11:44 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: *excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
Hi,
Do you want to chek
Hi,
PFA solved, hope this is what u need.
Steps:1) Select ur data range-- click on data menu, --- Remove
Duplicates---Just click OK.
On Fri, Mar 2, 2012 at 12:14 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi
Please find the attached query///
Thanks
--
FORUM RULES (986+ members
Hi Sanjib,
PFA with ur requirement.
On Tue, Feb 28, 2012 at 1:55 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Sir / madam,
Please see the attachment,
1. I have put the value from data sheets. I have only mentioned 2 scripts
name and only 3 or 4 Transaction.
But there
Can you elaborate a bit, based on wht u want the count
On Fri, Feb 24, 2012 at 1:45 PM, raghunandan rallapalli
raghunandan.rallapa...@gmail.com wrote:
Hello Sir,
please give me a formula for the attached sheet, FRA AND STN WISE
THANKS
WITH REGARDS.
RAGHU NANDAN R
--
FORUM RULES (986+
Its really a gud one, thanks noorain
On Thu, Feb 23, 2012 at 10:08 PM, chandra sekaran duraichan...@gmail.comwrote:
thanks Noorain, its helpful for excel users lke me ,
On Thu, Feb 23, 2012 at 8:17 PM, xlstime xlst...@gmail.com wrote:
very useful
On Wed, Feb 22, 2012 at 11:08 PM,
Hi Noorain,
One small question how can I set this formats as default in my excel.
Thanks
Waheed
On Fri, Feb 24, 2012 at 5:30 PM, Kal xcel kalx...@gmail.com wrote:
NOORAIN ROCKS ONCE AGAIN
Really helpful attachment for excel user from one of the most helpful
member of the group
Hi Maries,
Thats really great..Thank you..
On Fri, Feb 17, 2012 at 3:10 PM, Maries talk2mar...@gmail.com wrote:
Hi Shaik,
Check this link...
http://www.screencast.com/t/69UdkpgmFv
Regards,
MARIES.
On Thu, Feb 16, 2012 at 3:05 PM, Shaik Waheed waheedb...@gmail.comwrote:
Hi
Hi Maries,
Can u tell me how did u do that..
On Thu, Feb 16, 2012 at 3:25 PM, Maries talk2mar...@gmail.com wrote:
Find the attachments..
On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran
duraichan...@gmail.comwrote:
Hi ,
Here with attchaed file we need smal macro when i type first
Hi,
Please chek it
On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Experts,
Please see the attachment. I like store AREA1, AREA2 AND AREA3 in a combo
box or in Text Box.
Base on the value store in the combo Box or list box I like the name
Hi Experts,
I have an excel sheet with defined named ranges. When I am using Indirect
array formula to capture the named range it is showing zeros (0's) in place
of blanks that are available in my named range. Is there any way to get
only blanks as result because i dont want zeros.
Please find
Thank you Maris for ur reply.its working fine.
On Thu, Feb 9, 2012 at 5:18 PM, Maries talk2mar...@gmail.com wrote:
Hi,
Use this formula with CSE.
*=IF(INDIRECT(EMP.DATA)=,,INDIRECT(EMP.DATA))*
Regards,
MARIES.
On Thu, Feb 9, 2012 at 3:42 PM, Shaik Waheed waheedb
Thanks noorain
thats wonderful,
On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear waheed,
It is also possible without Indirect function..
=IF(ISBLANK(EMP.DATA),,EMP.DATA)
With ctrl+shift+Enter
On Thu, Feb 9, 2012 at 6:00 PM, Shaik Waheed waheedb
Hi Sanjib,
In your sample data u can do this by clicking to 'Data' tab in ur excel
sheet---Text To Colums--- Fixed width--Next--- Set the scale line as
per ur requirement--- finish
Do the necessary formatting as per ur requirement.
Find the attached sheet for ur review.
On Thu, Feb 9, 2012 at
Hi Shinivas,
=Workday(A2,1,0)
See the attached
On Thu, Feb 9, 2012 at 1:14 PM, Chidurala, Shrinivas
shrinivas.chidur...@citi.com wrote:
**
Dear Group,
Please suggest any formula to pick next working date, but Saturday and
Sunday should not include.
*Working day* *Next Working day*
Hi, can u send a sample data sheet
On Fri, Feb 3, 2012 at 6:18 PM, B Sharma sharma@gmail.com wrote:
Hello Friends.
I have two sheets For E.g.
1. Opening Balances and purchases of goods
2. Consumption of goods
Both the sheets will contain many colours like.
purchase
First assign a password to the sheet before hiding it, so that when other
user unhide's it, the sheet will be in read only mode and if the user want
to do changes it will prompt for password.
You can do this by using keyboard shortcut: ALT+T,P,P and set the password.
Hope it will help u.
On
Hi, can u tell how u r getting the SR#
On Tue, Jan 24, 2012 at 1:58 PM, yasir_shahjee yasir.shah...@gmail.comwrote:
Thanks but i need on sheet no in pivot table.
On Tue, Jan 24, 2012 at 12:01 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Yasir
Simply u can do it with Pivot Tabe option ,
Hi,
You can simply use Ctrl+H, in find place, type '*' and replace it with
blank, dats it.
On Wed, Dec 28, 2011 at 3:58 PM, Imran khan ikha...@gmail.com wrote:
Dear All,
Could you please help me to find correct formulla to remove charracter
like (* , /..). I have data in which having
Oh sorry dude this will not work out.
Formula is: =substitute(a1,*,)
On Wed, Dec 28, 2011 at 6:57 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi,
You can simply use Ctrl+H, in find place, type '*' and replace it with
blank, dats it.
On Wed, Dec 28, 2011 at 3:58 PM, Imran khan ikha
Is this the way you want
On Tue, Dec 27, 2011 at 1:39 PM, lucky singh lucky60...@gmail.com wrote:
Hi Team,
Request you to kindly help
I want is a grid on the right the red line to be highlighted properly
with the blue lines
Regards,
Lucky S
--
FORUM RULES (934+ members already
Hi,
You can use Vlookup to get the result. If you can give ur example list with
proper codes it will done.
And in your drop down list ther are spaces after the name like Admin ,
so remove those extra spaces...
Hope it solved your query.
On Tue, Dec 20, 2011 at 1:09 PM, Ankit Agrawal
Hi,
When the filters are On and you want to Check or Uncheck certain items, u
can use Alt+Down Arrow, and then check or uncheck it by using Space button
On Mon, Dec 19, 2011 at 4:43 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Vijay,
Incase of 2007+ you can use...
*CTRL+SHIFT+L*
Its amazing man, thanks for sharing
On Fri, Dec 9, 2011 at 11:37 PM, Nikhil Shah nikhil201...@gmail.com wrote:
Wow.. Wonderfull Sheet Mahesh..
Thanks
Nikhil Shah
On Fri, Dec 9, 2011 at 10:34 PM, Mahesh parab mahes...@gmail.com wrote:
its really Amazing!
check this link
I think u r luking for second small value
=SMALL(A32:A40,2)
On Thu, Dec 1, 2011 at 4:17 PM, Aindril De aind...@gmail.com wrote:
Dear Noorain,
Thanks for the response.
I have already tried this. This does not work. If you use this on the list
i have mentioned. It generates 4 and not 2,,
Hi,
I think the number formatting for style Normal got changed to some date
format. Change it back to General.
On Thu, Nov 17, 2011 at 11:18 AM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Dear Masters,
** **
Can you please let me know, how to set a default format for all cells
Right Click on the pivot table, select Pivot Tabel Options, move to
'Data' tab and then Uncheck- Enable Show Details.
For the date format i think its working fine in both rows n columns.
On Thu, Sep 1, 2011 at 10:18 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
I think topic got
Right Click on the pivot table, select Pivot Tabel Options, move to
'Data' tab and then Uncheck- Enable Show Details.
On Fri, Sep 2, 2011 at 4:44 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Hi Expert,
** **
In Pivot table data details, when we double click on any value
Hi Noorain,
Can u plz tell me y we r using TExt Function here.
On Fri, Aug 19, 2011 at 2:45 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
Dear Jayendra,
Please use below formula see attached sheet..
=TEXT((C2+D2)-(A2+B2),[H]:mm:ss)
--
Thanks regards,
Noorain Ansari
Thnx
On Fri, Sep 2, 2011 at 5:11 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Waheed,
Text Function are used to convert time differences as Hour:Minute:Second
Format.
On Fri, Sep 2, 2011 at 5:02 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi Noorain,
Can u plz tell me y we r
Hi,
Right Click on the pivot table, select Pivot Tabel Options, move to
'Data' tab and then Uncheck- Enable Show Details.
For the date format i think its working fine in both rows n columns.
Regards,
Waheed.
On Thu, Sep 1, 2011 at 7:55 AM, Prabhu prabhugate...@gmail.com wrote:
HI All,
Plz
on Excel. Thank you!
On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi John,
PFA, i have deleted some rows bcoz the file size was getting huge.
What u need to do is take this as example and do it in ur original
file, in sheet 2 u need to drag down the formulas till
:
Sir,
I totally confused to put my query in group ID. pls tell me the procedure
On Thu, Sep 1, 2011 at 5:58 PM, Shaik Waheed waheedb...@gmail.com wrote:
Plz put all ur queries n replies to the group id. So that everyone
will try n learn, that is wht our objective.
Thnx
Waheed.
On Thu, Sep
Dear experts,
I want to exclude a particular character from a number.
For example if the series is like this 01245-13.
and suppose I want to exclude . from the series and want the remaining
number to be as it is.
Thanks,
Waheed
--
Dear experts,
I want to exclude a particular character from a number.
For example if the series is like this 01245-13.
and suppose I want to exclude . from the series and want the remaining
number to be as it is.
Thanks,
Waheed
--
Oh great,
Thank you,
Waheed
On Tue, Jul 26, 2011 at 7:41 PM, ashish koul koul.ash...@gmail.com wrote:
=SUBSTITUTE(A1,.,)
On Tue, Jul 26, 2011 at 4:42 PM, Shaik Waheed waheedb...@gmail.comwrote:
Dear experts,
I want to exclude a particular character from a number.
For example
Dear Experts,
As I am beginner in VBA, please suggest me any institute in Hyderabad or any
best sites which can give coaching from basics.
Thanks,
Waheed
--
--
Some important links for excel users:
1. Follow us on
75 matches
Mail list logo
