Re: $$Excel-Macros$$ Need a Macro to find Variable Cost

Thanks Mahesh & Vaibhav, Its working fine :) Thanks, Waheed On Tue, Sep 9, 2014 at 11:27 AM, Mahesh Patil wrote: > Hi, > PFA > > > On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed wrote: > >> Hi friends, >> >> I need your help to create a macro, its motiv

$$Excel-Macros$$ Need a Macro to find Variable Cost

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 o

Re: $$Excel-Macros$$ Remove Duplicates

Its working, Thank you Ashish for your help :) Thanks, Waheed On Fri, Jul 11, 2014 at 9:51 PM, Ashish Kumar wrote: > Hi Waheed, > > PFA sheet and its code is working on Column D only. > > > Regards > Ashish > > On 11 July 2014 20:58, Shaik Waheed wrote: > >&g

Re: $$Excel-Macros$$ Remove Duplicates

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 wrote: > Hi Waheed, > > This code is find all duplicates like : > > Shaik Waheed Khan > Shaik Waheed K >

Re: $$Excel-Macros$$ Remove Duplicates

; > > On 10 July 2014 18:48, Shaik Waheed wrote: > >> Yes Ashish >> >> Thanks, >> Waheed >> >> On Thu, Jul 10, 2014 at 6:26 PM, Ashish Kumar > > wrote: >> >>> Hi Waheed, >>> >>> You want to find duplicates in

Re: $$Excel-Macros$$ Remove Duplicates

Yes Ashish Thanks, Waheed On Thu, Jul 10, 2014 at 6:26 PM, Ashish Kumar wrote: > Hi Waheed, > > You want to find duplicates in A & D column. ?? > > Regards > Ashish > > On 10 July 2014 18:04, Shaik Waheed wrote: > >> Hi Friends, >> >> I

$$Excel-Macros$$ Remove Duplicates

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 su

Re: $$Excel-Macros$$ Split with formula

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

Re: $$Excel-Macros$$ Cell Referencing

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 wrote: > SALAM > Hi Every one Hope that all of you are fine. > > How i can use this formula to have the absolute cell address. > =(ADDRESS(ROW()-1,COLUMN())) >

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hi Walekumassalam Sadia Welcome to the group On Wed, Jan 23, 2013 at 9:33 PM, Sadia Khalid wrote: > > > Hello All, > SALAM > I am SADIA KHALID , aged 30. I live in UAE. > > Regards > SADIA KHALID > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > F

Re: $$Excel-Macros$$ Insert Multiple mails as icons into excel

/aa174259(v=office.11).aspx > > http://www.java2s.com/Code/VBA-Excel-Access-Word/Data-Type/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 w

$$Excel-Macros$$ Insert Multiple mails as icons into excel

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 -- Joi

Re: $$Excel-Macros$$ Obtain percentile values through pivot table

yeah sure, can u share ur sample file On Wed, Oct 31, 2012 at 2:33 PM, Sheyn Lee 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 @ > https://www.facebook.com/

Re: $$Excel-Macros$$ need solutions

PFA, Hope this is what u were luking for On Wed, Oct 31, 2012 at 1:20 PM, Rajesh Agarwal wrote: > PFA > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for viol

Re: $$Excel-Macros$$ Sumif / Sumproduct formula required.

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 wrote: > Thanx *Noor *for this also, > > But I need to c

Re: $$Excel-Macros$$ Sumif / Sumproduct formula required.

PFA On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI wrote: > see attached sheet. > > > On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI > wrote: > >> Dear Muneer, >> >> Please use below formula >> >> =SUMPRODUCT((A2:A8=D5)*(B2:B8)) >> >> or >> >> =Sumif(A2:A8,d5,B2:B8) >> >> >> On Thu, Jul 12, 20

Re: $$Excel-Macros$$ VLOOKUP for last Available Date

=vlookup(I7,$E$7:$F$14,2,1) On Mon, Jul 2, 2012 at 11:32 AM, NOORAIN ANSARI wrote: > 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 11:22 AM, Man

Re: $$Excel-Macros$$ need help on maximum value and thier name

Hi Sunita, In my case, I have used filters since it becomes more easier On Mon, Jun 25, 2012 at 12:49 PM, सुनिता पौडेल wrote: > did you filtre the column? > thank you > > On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed wrote: > >> PFA >> >> >> On Mon,

Re: $$Excel-Macros$$ need help on maximum value and thier name

PFA On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल 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 !! > > Thank you

Re: $$Excel-Macros$$ unhide all sheet

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 wrote: > Dear Team, > > I required your support to unhide 20 sheet

Re: $$Excel-Macros$$ Please help

Hi, PFA On Tue, May 8, 2012 at 12:43 PM, Soni.Rajender wrote: > 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+ members already

Re: $$Excel-Macros$$ Fixing the problem

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 wrote: > Dear Friends, > > ** ** > > I want to put a formula in the attached sheet to calculate automatically > as and when I change the periods., please help.. > > **

Re: $$Excel-Macros$$ Query.

Hi, PFA On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar wrote: > 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 > E-Mail:-kumar.pramod03i...@gmail.com > >

Re: $$Excel-Macros$$ change color depending from cell value

Hi, PFA On Mon, Apr 30, 2012 at 5:11 AM, pawel lupinski 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, pls see attachmen

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ $$Excel-Ma​​cros$$ Formula Need for accounting entries

Hi Vijay, PFA, hope this is what you are looking for On Fri, Apr 27, 2012 at 8:13 PM, Vijayendra Rao wrote: > 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, > Vijayendra > 94491

Re: $$Excel-Macros$$ Re: How to use validation on repeated word/Number

Hi Rabinder, PFA, hope this what you are looking for. On Fri, Apr 27, 2012 at 1:48 PM, CoRe 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 11:49:56 PM U

Re: $$Excel-Macros$$ Absolute Number (1,2,3,4 ) to be typed in given sheet & No other number can be entered

;> Thanx lot for your valuable support >> >> >> >> Vaibhav >> >> >> >> >> >> On Fri, Apr 27, 2012 at 12:17 PM, Shaik Waheed wrote: >> >>> Hi, >>> >>> PFA >>> >>> On Fri, Apr 2

Re: $$Excel-Macros$$ count solve problem formula problem

Hi Danial, Im not able to get ur point, u want the count of dates which are *"less than or equal to 4/30/2012"? o * On Thu, Apr 26, 2012 at 3:49 PM, danial mansoor wrote: > > > i need 5 Answer after excluding blank,and criteria could be change then > you formula would be failed. > >

Re: $$Excel-Macros$$ count solve problem formula problem

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 wrote: > > > attached sheet need formula for count with condition

Re: $$Excel-Macros$$ Cell to multi cell.

e 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 wrote: > >> Hi Ranjan, >> >> PFA, hope this is wh

Re: $$Excel-Macros$$ Cell to multi cell.

Hi Ranjan, PFA, hope this is what u r luking for... On Wed, Apr 25, 2012 at 11:54 AM, Deba Ranjan 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 > many cell. plea

Re: $$Excel-Macros$$ Urgent - Pivot table

Hi, PFA, is this what u r looking for? On Thu, Apr 19, 2012 at 4:26 PM, Soni.Rajender wrote: > 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 pivot table e.g. f

Re: $$Excel-Macros$$ Urgent help required in converting a number into text

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@

Re: $$Excel-Macros$$ regarding pivot table problem

< 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

Re: $$Excel-Macros$$ regarding pivot table problem

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 wrote: > Sanjib, > > Click on the pivot, on the toolbar, click

Re: $$Excel-Macros$$ regarding pivot table problem

> > > > On Wed, Apr 11, 2012 at 2:34 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> yes, This is is excetly what I am looking for. >> would you explain please. >> >> regards, >> >> sanjib >> >> >> On Wed, Apr 11, 2012

Re: $$Excel-Macros$$ Macro to calculate amount

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 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 book with more th

Re: $$Excel-Macros$$ copy paste in reverse order

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 wrote: > Dear Amit, > > Pls check attached sheet. > > > On Wed, Mar 21, 2012 at 7:49 AM, Amit Desai (MERU) < > amit

Re: $$Excel-Macros$$ Pivot Table

Hi, Check out the below link http://www.contextures.com/CreatePivotTable.html On Tue, Mar 20, 2012 at 2:53 PM, Karan Singh wrote: > Dear All, > > Kindly send me some pivot table examples. I want to learn it. > > > Thanks > Kaяan > >

Re: $$Excel-Macros$$ VALUE ERROR PROBLEM

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 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 (colored

Re: $$Excel-Macros$$ Urgent Help Required...!

erry® on Airtel > ------ > *From: *Shaik Waheed > *Sender: *excel-macros@googlegroups.com > *Date: *Fri, 2 Mar 2012 18:11:44 +0530 > *To: * > *ReplyTo: *excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...! > > Hi, > > Do you want to chek wh

Re: $$Excel-Macros$$ Urgent Help Required...!

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 big help from you all, as I work in BPO company as a MIS > executive but I am not aware about Acce

Re: $$Excel-Macros$$ help

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 wrote: > Hi > > > > Please find the attached query/// > > > Thanks > > -- > FORUM RULES (986+ members already B

Re: $$Excel-Macros$$ regarding pivot table greate then zero value

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. > B

Re: $$Excel-Macros$$ Custom Format Examples

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 wrote: > NOORAIN ROCKS ONCE AGAIN > > > > Really helpful attachment for excel user from one of the most helpful > member of the group > > Thanks

Re: $$Excel-Macros$$ Custom Format Examples

Its really a gud one, thanks noorain On Thu, Feb 23, 2012 at 10:08 PM, chandra sekaran wrote: > thanks Noorain, its helpful for excel users lke me , > > > > On Thu, Feb 23, 2012 at 8:17 PM, xlstime wrote: > >> very useful >> >> On Wed, Feb 22, 2012 at 11:08 PM, NOORAIN ANSARI < >> noorain.ans..

Re: $$Excel-Macros$$ count group wise

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

Re: $$Excel-Macros$$ List Box or copy past Shwon based on typing leter

Hi Maries, Thats really great..Thank you.. On Fri, Feb 17, 2012 at 3:10 PM, Maries 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 wro

Re: $$Excel-Macros$$ combo box or list box help

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 n

Re: $$Excel-Macros$$ List Box or copy past Shwon based on typing leter

Hi Maries, Can u tell me how did u do that.. On Thu, Feb 16, 2012 at 3:25 PM, Maries wrote: > Find the attachments.. > > > On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran > wrote: > >> Hi , >> >> Here with attchaed file we need smal macro when i type first >> Letter than shown start wit

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Thanks noorain thats wonderful, On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI wrote: > 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 P

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Thank you Maris for ur reply.its working fine. On Thu, Feb 9, 2012 at 5:18 PM, Maries wrote: > Hi, > > Use this formula with CSE. > > *=IF(INDIRECT("EMP.DATA")="","",INDIRECT("EMP.DATA"))* > > Regards, > > MARIES

$$Excel-Macros$$ Help on INDIRECT ARRAY Formula

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 th

Re: $$Excel-Macros$$ Next Working date

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 Worki

Re: $$Excel-Macros$$ split the value in two part

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

Re: $$Excel-Macros$$ Pivot Table from two separate sheets

Hi, can u send a sample data sheet On Fri, Feb 3, 2012 at 6:18 PM, B Sharma 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 date,consumption date

Re: $$Excel-Macros$$ Password protect hidden sheets

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 Tue,

Re: $$Excel-Macros$$ find attach sheet.. kindly help me. thanks

Hi, can u tell how u r getting the SR# On Tue, Jan 24, 2012 at 1:58 PM, yasir_shahjee wrote: > Thanks but i need on sheet no in pivot table. > > > On Tue, Jan 24, 2012 at 12:01 PM, PrIyAnKa wrote: > >> Dear Yasir >> >> Simply u can do it with Pivot Tabe option , >> >> Kindly find the attached fi

Re: $$Excel-Macros$$ Removal Special Charracter in Excel

Oh sorry dude this will not work out. Formula is: =substitute(a1,"*","") On Wed, Dec 28, 2011 at 6:57 PM, Shaik Waheed wrote: > Hi, > You can simply use "Ctrl+H", in find place, type '*' and replace it with > blank, dats it. > > On Wed,

Re: $$Excel-Macros$$ Removal Special Charracter in Excel

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 wrote: > Dear All, > > Could you please help me to find correct formulla to remove charracter > like (* , /..). I have data in which having dates in 12-Fe

Re: $$Excel-Macros$$ Help on chart

Is this the way you want On Tue, Dec 27, 2011 at 1:39 PM, lucky singh 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 BANNED for

Re: $$Excel-Macros$$ Fwd: Drop down list

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 wrote: >

Re: $$Excel-Macros$$ shortcut key .

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 wrote: > Dear Vijay, > > Incase of 2007+ you can use... > > *CTRL+SHIFT+L* > > -- > Thanks & r

Re: $$Excel-Macros$$ Painting in excel............Amazing !

Its amazing man, thanks for sharing On Fri, Dec 9, 2011 at 11:37 PM, Nikhil Shah wrote: > Wow.. Wonderfull Sheet Mahesh.. > > Thanks > > Nikhil Shah > > On Fri, Dec 9, 2011 at 10:34 PM, Mahesh parab wrote: > >> its really Amazing! >> >> check this link >> >> http://www.xcelfiles.com/

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

I think u r luking for second small value =SMALL(A32:A40,2) On Thu, Dec 1, 2011 at 4:17 PM, Aindril De 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,, which should b

Re: $$Excel-Macros$$ Setting a default cell format in excel 2007

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) wrote: > Dear Masters, > > ** ** > > Can you please let me know, how to set a default format for all cells in > excel 2007. As o

Re: $$Excel-Macros$$ Converting date with time to date withOUT time

Well, u can "use text to columns" wizard and follow the steps, to split it. On Fri, Sep 16, 2011 at 1:39 AM, Mich Mac wrote: > I am exporting a file from online which automatically includes dates. > This interferes with my Pivot tables.  How do I convert an entire > column of dates with the time

Re: $$Excel-Macros$$ Pivot Table data extract

matting. > > ** ** > > Regards,Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shaik Waheed > *Sent:* Friday, September 02, 2011 04

Re: $$Excel-Macros$$ difference time calculation

Thnx On Fri, Sep 2, 2011 at 5:11 PM, NOORAIN ANSARI 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 wrote: >> >> Hi Noorain, >> Can u plz tel

Re: $$Excel-Macros$$ difference time calculation

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 wrote: > Dear Jayendra, > > Please use below formula & see attached sheet.. > > =TEXT((C2+D2)-(A2+B2),"[H]:mm:ss") > > -- > Thanks & regards, > Noorain Ansari > http://noorain-ansari.blo

Re: $$Excel-Macros$$ Pivot Table data extract

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

Re: $$Excel-Macros$$ **Pivot Table Doubt**

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 wrote: > Hi Friends, > I think topic got changed. Actually i have a

Re: $$Excel-Macros$$ **Pivot Table Doubt**

, > 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 wrote: >> >> Plz put all ur queries n replies to the group id. So that everyone >> will try n learn, that is wht our objective. >> >>

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Thank you! > > On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed 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 t

Re: $$Excel-Macros$$ **Pivot Table Doubt**

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 wrote: > HI All, > Plz find the pivot table sh

Re: $$Excel-Macros$$ How to exclude a particular character from a series of number - Urgent plz

Oh great, Thank you, Waheed On Tue, Jul 26, 2011 at 7:41 PM, ashish koul wrote: > =SUBSTITUTE(A1,".","") > > > On Tue, Jul 26, 2011 at 4:42 PM, Shaik Waheed wrote: > >> Dear experts, >> >> I want to exclude a particular character from a nu

$$Excel-Macros$$ How to exclude a paritcular character from a series of number

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 -- --

$$Excel-Macros$$ How to exclude a particular character from a series of number - Urgent plz

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 -- --

$$Excel-Macros$$ I want Institute or Sites to Learn VBA

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 T