Re: $$Excel-Macros$$ Query on count

2014-11-14 Thread Waseem Saifi
Hi Kal Excel, PFA resolved query of yours. Regards, Waseem Saifi On Thu, Nov 13, 2014 at 5:11 PM, Kal xcel wrote: > Dear Experts, > > Please help me to solve my query. > > Thanks in advance > > -- > *Kalyan Chattopadhyay* > > > *Executive Corporate MIS* >

$$Excel-Macros$$ Want to learn Microsoft Access

2014-10-15 Thread Waseem Saifi
Hi Experts, Please suggest me best book for learning Microsoft Access. I am good in Microsoft Excel, but 0 in Microsoft Access. Thanks in advance. Regards, Waseem Saifi -- 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

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-15 Thread Waseem Saifi
> SUBSTITUTE so we can trim it later to get the exact word > then we break it a part every 99 char using MID function, and then remove > the white space using TRIM > > Rgds, > [dp] > > > On 11/10/2014 11:49, Waseem Saifi wrote: > > Hi Experts, > > I have atta

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-13 Thread Waseem Saifi
thank you vaibhav, it's perfect On Sun, Oct 12, 2014 at 4:39 PM, Vaibhav Joshi wrote: > check this... > > + > *I did not do this for you. God is here working through me for you.* > > On Sun, Oct 12, 2014 at 11:08 AM, Waseem Saifi > wrote: > >> Hi Vaibhav

Re: $$Excel-Macros$$ split text by pipe sign

2014-10-11 Thread Waseem Saifi
his for you. God is here working through me for you.* > > On Sat, Oct 11, 2014 at 10:19 AM, Waseem Saifi > wrote: > >> Hi Experts, >> >> I have attached a file which contain text in cell A15. I want to split >> this text by pipe sign [|] in cells next to ce

$$Excel-Macros$$ split text by pipe sign

2014-10-10 Thread Waseem Saifi
Hi Experts, I have attached a file which contain text in cell A15. I want to split this text by pipe sign [|] in cells next to cell A15. Thanks in Advance. Regards, Waseem Saifi -- 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

Re: $$Excel-Macros$$ SumProduct

2014-09-23 Thread Waseem Saifi
It converts values in Boolean (TRUE or FALSE, 1 or 0) which are enclosed in bracket after "--". On Tue, Sep 23, 2014 at 10:40 AM, SUDHIR VERMA wrote: > Dear Ravi, > what is use of "--" before B2:B13 in above formula. > > Please explain. > > > > On 13 September 2013 16:28, Ravi Kumar wrote: > >>

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Waseem Saifi
It is really an amazing collection vaibhav. thank you so much vaibhav. On Thu, Sep 18, 2014 at 8:06 AM, Govardhan Bhatia wrote: > On 9/18/14, Prafull Jadhav wrote: > > Dear Vaibhav Sir, > > > > Thanks for the shared us a very useful file. > > > > > > Regards, > > Prafull Jadhav > > 9920553518 >

Re: $$Excel-Macros$$ client wise dropdownlist in column b

2014-06-30 Thread Waseem Saifi
PFA It might help you. On Mon, Jun 30, 2014 at 4:17 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Sir / Madam, > > Please see the attachment. There could be thousand clients with their > banks. I want wnen I put the client name in the column a, there will be > dropdown lis

Re: $$Excel-Macros$$ Count of 1, 2, 3..... in a range

2014-03-01 Thread Waseem Saifi
Hi Kathirvelan, Hope I have done for what you are looking for. Your didn't elaborate properly. I did this, consider as number and also as digit. Regards, Waseem Saifi On Sat, Mar 1, 2014 at 5:00 PM, KATHIRVELAN N wrote: > Dear Friends, > > Please help me to count the 1, 2, 3...

$$Excel-Macros$$ Want to Embed flash game in Excel

2014-02-28 Thread Waseem Saifi
Hi Friends, I want to embed flash games in Excel 2007. I have a flash game. It is to be noted that game's extension is exe, not swf. If it possible, please help me. Thanx in advance, Regards, Waseem Saifi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It'

Re: $$Excel-Macros$$ Write formula without using IFS

2013-10-19 Thread Waseem Saifi
Dear Rajan, Are you looking for this type solution. Regards, Waseem Saifi On Thu, Oct 17, 2013 at 3:31 PM, Rajan sharma wrote: > Thanks for your prompt reply, But i was having some condition, that we are > not suppose to use : > > Write Formula without using > > 1. Where ev

Re: $$Excel-Macros$$ Conditional Count with Conditions on Raws & Columns

2013-10-12 Thread Waseem Saifi
according to me till now, it is ok. and you have to just create one time. after that just copy and paste this formula into other cells. may be other guy can help you more. Thanks and Regards, Waseem Saifi On Sat, Oct 12, 2013 at 3:08 PM, Amit Desai (MERU) wrote: > Dear Was

Re: $$Excel-Macros$$ Conditional Count with Conditions on Raws & Columns

2013-10-11 Thread Waseem Saifi
Dear Amit, first of all it is an array formula, you can check formula, using Evaluate Formula command, under Formula Tab. It is difficult to explain on mail that how is this formula working. Sorry, But evaluate formula can explain. try it. Regards, Waseem Saifi On Fri, Oct 11, 2013 at 8:51 PM

Re: $$Excel-Macros$$ Conditional Count with Conditions on Raws & Columns

2013-10-11 Thread Waseem Saifi
Dear Amit, PFA result as you desire Regards, Waseem Saifi On Fri, Oct 11, 2013 at 6:01 PM, Amit Desai (MERU) wrote: > Dear Friends, > > ** ** > > Please help me with the conditional count formula. Conditions needs to be > applied on both Columns & Raws…Please se

Re: $$Excel-Macros$$ I want to show flag using conditional formatting

2013-10-06 Thread Waseem Saifi
thank you so much Ravinder. Regards, Waseem Saifi On Mon, Oct 7, 2013 at 10:25 AM, Ravinder wrote: > PFA > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Waseem Saifi > *Sent:* Saturday, October 05, 2013 1

Re: $$Excel-Macros$$ Re: I want to show flag using conditional formatting

2013-10-06 Thread Waseem Saifi
Dear Basole, please see attachment. Regards, Waseem Saifi On Sun, Oct 6, 2013 at 12:20 PM, Waseem Saifi wrote: > thanx basole, > > But I want to show flag of icon sets from conditional formatting. > > Regards, > Waseem Saifi > > > On Sat, Oct 5, 2013 at 7:44 PM, Ba

Re: $$Excel-Macros$$ I want to show flag using conditional formatting

2013-10-06 Thread Waseem Saifi
thank you so much vijay, it worked absolutely fine. Regards, Waseem Saifi On Sat, Oct 5, 2013 at 11:18 AM, Ravinder wrote: > pfa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR > *Sent:* Saturday

Re: $$Excel-Macros$$ Re: I want to show flag using conditional formatting

2013-10-05 Thread Waseem Saifi
thanx basole, But I want to show flag of icon sets from conditional formatting. Regards, Waseem Saifi On Sat, Oct 5, 2013 at 7:44 PM, Basole wrote: > Hi Waseem, see the suggestion using conditional formatting, only to color > the font and fill the cell. > > > tks. > Baso

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

2013-10-05 Thread Waseem Saifi
attachment missing ! On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar wrote: > > Dear Friend, > > i want to use total no of present or absent list using pivot table. > > Please find the attachment. > > > -- > Thanks £ Regards > Rakesh Kumar > +91-9650303464 > > > > -- > Are you =EXP(E:RT) or =NOT(E

Re: $$Excel-Macros$$ Difference between time

2013-09-30 Thread Waseem Saifi
Thank you so much Ravinder & Aamir. Regards, Waseem Saifi On Mon, Sep 30, 2013 at 4:18 PM, Aamir Shahzad wrote: > Try This > > =IF(A5>B5,TEXT(A5-B5,"[h]:mm:ss"),TEXT(B5-A5,"[h]:mm:ss")) > > > On Mon, Sep 30, 2013 at 3:43 PM, Ravinder wrote: &g

$$Excel-Macros$$ Difference between time

2013-09-30 Thread Waseem Saifi
Dear Experts, I want to know total working time basis on in time and out time. please help me. please see attached file. Regards, Waseem Saifi -- 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 this forum

Re: $$Excel-Macros$$ HELP WITH FALSE RESULT IN EXCEL

2013-09-09 Thread Waseem Saifi
_digits, But no more than 15. I think 15 num_digits very precise for your correct output. Regards, Waseem Saifi On Mon, Sep 9, 2013 at 1:02 PM, xlstime wrote: > Please add false statement > > > =IF(AND(F2<=TIMEVALUE("0:50:00"),F2>TIMEVALUE("0:30:00")),"

Re: $$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread Waseem Saifi
this is too good Rajan ! Regards, Waseem Saifi On Wed, Sep 4, 2013 at 3:01 PM, Rajan sharma wrote: > Hi Murali, > > Chek the attachment too. Might it will also help you. :-) > > > > > > With warm regards, > Rajan Sharma > > > > On Wed, Sep 4, 2013

Re: $$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread Waseem Saifi
Your Welcome Murali ! [?] On Wed, Sep 4, 2013 at 2:53 PM, MURALI NAGARAJAN wrote: > Dear Waseem, > > Thanks for your great support. > > On Wed, Sep 4, 2013 at 2:33 PM, Waseem Saifi wrote: > >> Dear Murali, >> >> Please see in attachment. >> it might

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread Waseem Saifi
Dear Kaushik, No need to close numbers in double quotes. just simply type numbers as numbers, like Type 1 instead of "1" or -1 instead of "-1" On Wed, Sep 4, 2013 at 2:37 PM, KAUSHIK SAVLA wrote: > Thanks Prafull and Noorain sir. > > > On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav > wrote: >

Re: $$Excel-Macros$$ Need a formula urgently

2013-09-04 Thread Waseem Saifi
Dear Murali, Please see in attachment. it might be helpful. Regards, Waseem Saifi On Wed, Sep 4, 2013 at 2:21 PM, MURALI NAGARAJAN wrote: > Dear All, > > I have a data base like colum A contains State name & colum B contains > city name against state name, im going to crea

Re: $$Excel-Macros$$ Embed Picture in particular cell

2013-08-29 Thread Waseem Saifi
> > *Ravi Kumar.* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Waseem Saifi > *Sent:* Thursday, August 29, 2013 11:59 AM > *To:* excel-macros > *Subject:* $$Excel-Macros$$ Embed Picture in particular ce

$$Excel-Macros$$ Embed Picture in particular cell

2013-08-28 Thread Waseem Saifi
Dear Experts, Is it possible to embed picture as background in specific cell in Excel? Regards, Waseem Saifi -- 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 this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Query Regarding Pivot Table

2013-08-24 Thread Waseem Saifi
Thanx [?] On Sat, Aug 24, 2013 at 2:09 PM, xlstime wrote: > Yes, it is possible via "Multipal consolidate ranges" > > Just press Alt+D+P then select "Multipal consolidate ranges" > > . > > Enjoy > Team XLS > > > &

$$Excel-Macros$$ Query Regarding Pivot Table

2013-08-24 Thread Waseem Saifi
Dear Experts, Is it possible to make a pivot table basis on two workbooks, while heading are same of both workbooks? partial data or complete data may be differ. or complete data may be same. Regards, Waseem Saifi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Sum if array for cut dates

2013-08-23 Thread Waseem Saifi
PFA with solution Regards, Waseem Saifi On Fri, Aug 23, 2013 at 12:36 PM, ravinder negi wrote: > PFA > > -- > *From:* Ali Abbas > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, August 22, 2013 9:01 PM > > *Subject:* $$Excel-Macro

Re: $$Excel-Macros$$ Which cell color and font color combination is suitable to show negative value.

2013-08-22 Thread Waseem Saifi
li Anil. > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > > > On Thu, Aug 22, 2013 at 11:47 AM, Waseem Saifi > wrote: > > Dear Experts, > > > > Please suggest me. > > > > I have some ne

$$Excel-Macros$$ Which cell color and font color combination is suitable to show negative value.

2013-08-21 Thread Waseem Saifi
r and fill color combination to show negative values. Regards, Waseem Saifi -- 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 this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate t

Re: $$Excel-Macros$$

2013-08-17 Thread Waseem Saifi
Dear Raj, Use below formula - =SUMIFS(Sheet2!$C$2:$C$10,Sheet2!$A$2:$A$10,Sheet1!A2,Sheet2!$B$2:$B$10,"nis") for clarification see attached file with solution. Regrads, Waseem Saifi On Sat, Aug 17, 2013 at 12:20 PM, Raj Kumar wrote: > > > > On 17 August 2013 1

Re: $$Excel-Macros$$ Regarding paste options

2013-08-13 Thread Waseem Saifi
In Excel 2010, On Keyboard, press right click, then press V. In Excel 2007, On Keyboard, press right click, then press S, then press V. If above process is not working. then I am unable to getting that what are you trying to say or I am not getting it at my level. Regards, Waseem Saifi On Tue

Re: $$Excel-Macros$$ Date Format

2013-08-05 Thread Waseem Saifi
Dear Prabhakar, It could be helpful. please find solved attachment and confirm is it ok or not? Regards, Waseem Saifi On Tue, Aug 6, 2013 at 10:52 AM, wrote: > Dear Team, > > I have dates in different format and need to make it in one standard date > format. Please help me

Re: $$Excel-Macros$$ Query Regarding Sum

2013-08-01 Thread Waseem Saifi
de premor, it's too easy ! thank you so much On Thu, Aug 1, 2013 at 11:33 AM, De Premor wrote: > You can also use this > > =SUM(OFFSET(E6,1,MATCH(B2,F6:M6,0),MATCH(B3,E7:E10,0))) > > > Pada 01/08/2013 13:00, Waseem Saifi menulis: > > thank you so much ravinde

Re: $$Excel-Macros$$ Query Regarding Sum

2013-07-31 Thread Waseem Saifi
ot;address",INDIRECT("r"&MATCH(B3,E7:E10,0)+6&"c"&MATCH(B2,F6:M6,0)+5,FALSE > > -- > *From:* Waseem Saifi > *To:* excel-macros > *Sent:* Thursday, August 1, 2013 10:53 AM > *Subject:* $$Excel-Macros$$ Query Regardi

$$Excel-Macros$$ Query Regarding Sum

2013-07-31 Thread Waseem Saifi
Dear Experts, I want to sum of values basis on two conditions. it is explained in attachment. I also tried offset function, but it didn't work properly. please help. Regards, Waseem Saifi -- 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) !

Re: $$Excel-Macros$$ Re: Delivery Status Notification (Failure)

2013-07-31 Thread Waseem Saifi
thank you so much vijay. these are enough for me. thanks again. Regards, Waseem Saifi On Wed, Jul 31, 2013 at 4:53 PM, P.VIJAYKUMAR wrote: > Respected Waseem, > > Please find the attached files.All games are not possibly sent by mail > because gmail cannot handle more th

Re: $$Excel-Macros$$ Fiscal Period calculation

2013-07-31 Thread Waseem Saifi
what is fiscal period? I heard it first time. On Wed, Jul 31, 2013 at 4:01 PM, Krishnaraddi V. Madolli < krishnaraddi.mado...@asia.xchanging.com> wrote: > Hi Experts, > > ** ** > > Do we have excel formula to calculate Fiscal Period from the date. > > ** ** > > Ex: > > > > ** *

Re: $$Excel-Macros$$ Want Excel Games

2013-07-30 Thread Waseem Saifi
Dear Vijay, My system administrator blocked such game sites. that why i asked excel games to mail me. all games's websites are blocked. but by mail, I have no problem. please mail more games, not links. Links are useless for me. and thanx for these games. Regards, Waseem Saifi On Tue, J

Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-07-30 Thread Waseem Saifi
Dear Rajkumar, Please find attached file with solution. Regards, Waseem Saifi On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar wrote: > Dear Group, > > We have lots of records and Segregate the data based on only last comma > and consider the same >

$$Excel-Macros$$ Want Excel Games

2013-07-30 Thread Waseem Saifi
Somebody Please give me Excel Games. Regards, Waseem Saifi -- 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 this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ higher value find

2013-07-27 Thread Waseem Saifi
Dear Laxman, PFA with solution. This is little lengthy and I am not satisfied. But it's working. Regards, Waseem Saifi On Sat, Jul 27, 2013 at 10:22 AM, LAKSHMAN PRASAD wrote: > > Dear expert > I have a sheet in which money receipt details maintain, I want to filter > l

Re: $$Excel-Macros$$ Sum query

2013-07-24 Thread Waseem Saifi
You can use Sumif It's so simple ! it is simplest query I have ever found on this group. Regards, Waseem Saifi On Wed, Jul 24, 2013 at 6:51 PM, Ravinder Kumar < ravinderbhardwa...@gmail.com> wrote: > Hi > > With the help of SUM IF, you can get the result. > > For ref

Re: $$Excel-Macros$$ Want conditional lookup

2013-07-24 Thread Waseem Saifi
Dear Laxman, please share file I have deleted previous mail and also that file from my computer On 7/24/13, LAKSHMAN PRASAD wrote: > Dear waseem, > > Plz C the sheet2 where unit no.249 found but sheet1 not pickup that value > > > > > ________ &g

Re: $$Excel-Macros$$ Want conditional lookup

2013-07-23 Thread Waseem Saifi
Dear Laxman, PFA. On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD wrote: > Dear Expert, > Want conditional lookup from sheet 1 those data which is active in column > A , plz the attached file > ** > Thanks, > Regards > LAKSHMAN > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A

Re: $$Excel-Macros$$

2013-07-23 Thread Waseem Saifi
thank you Paul. you cleared a concept, which was completely unknown to me. Regards, Waseem Saifi On Tue, Jul 23, 2013 at 5:07 PM, Waseem Saifi wrote: > Thank you so Much. > it is working absolutely fine. > awesome logic ! > > > > > On Tue, Jul 23, 2013 at 4:36 PM, Exce

Re: $$Excel-Macros$$

2013-07-23 Thread Waseem Saifi
cros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Waseem Saifi > *Sent:* Tuesday, July 23, 2013 2:26 PM > *To:* excel-macros > *Subject:* $$Excel-Macros$$ > > ** ** > > Dear Experts, > > Please look into attached file. I want to find ou

Re: $$Excel-Macros$$

2013-07-23 Thread Waseem Saifi
Dear Anil, thanx for help, But I am already getting right output using pivot table. My concern is what's problem with countif. what's the issue in countif. does countif not reliable in these type of cases ! Thanks, Waseem Saifi On Tue, Jul 23, 2013 at 3:52 PM, Anil B wrote: &

$$Excel-Macros$$

2013-07-23 Thread Waseem Saifi
Dear Experts, Please look into attached file. I want to find out percentage of each category. Using Pivot table it is correct. But using Countif it is incorrect. please help Regards, Waseem Saifi -- 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

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-20 Thread Waseem Saifi
Dear Excel_Lover, it is exactly in attachment you are asking for. Regards, Waseem Saifi On Sat, Jul 20, 2013 at 2:12 PM, Waseem Saifi wrote: > Dear Excel_Lover, > > PFA your query file with solved formula. > > Regards, > Waseem Saifi > > On 7/19/13, Excel_Lo

Re: $$Excel-Macros$$ Whole Sheet is Hidden, But actually not Hidden!

2013-07-20 Thread Waseem Saifi
Dear Experts, thank you so much for all your views. I got lot of Experience and guidance from your post on this mail. again thank you so much ! Regards, Waseem Saifi On 7/19/13, Paul Schreiner wrote: > I've encountered similar issues before. > It seems to be a graphical m

Re: $$Excel-Macros$$ To SUM Dynamic Columns

2013-07-20 Thread Waseem Saifi
Dear Excel_Lover, PFA your query file with solved formula. Regards, Waseem Saifi On 7/19/13, Excel_Lover wrote: > Dear All, > > Attached is a sample data in which I have some month wise item total, I > need a formula which can calculate SUM of an item from the Month Jan-12 to >

Re: $$Excel-Macros$$ Whole Sheet is Hidden, But actually not Hidden!

2013-07-19 Thread Waseem Saifi
Dear Sir, Operating System is Microsoft Windows 7, Processor is Intel Pentium Dual Core with 2.6 Ghz speed. RAM is 2 GB. Hard disk is approx 500 GB. Regards, Waseem Saifi On Fri, Jul 19, 2013 at 1:29 PM, vba wrote: > Hi > > Also state operating system you are using alon

$$Excel-Macros$$ Whole Sheet is Hidden, But actually not Hidden!

2013-07-18 Thread Waseem Saifi
problem I can't understand. it is about PC which I using or in that Excel file. or some kind of bug in excel. I am using Excel 2007. sorry for not sharing that file. I can't share that. Regards, Waseem Saifi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’

Re: $$Excel-Macros$$ Help Required

2013-07-17 Thread Waseem Saifi
Please find attachment. it might help you On 7/17/13, Neeraj Chauhan wrote: > Dear experts, > > > > How to subtract time in hours and minute > > > > > 10:30 AM > > - 10:30 PM > > = > > > > > > Thanks & Regards > > Neeraj Chauhan > > +91-9756706350 > > neerajchauhan...@gmail.com > > > > -

Re: $$Excel-Macros$$ Query in Pivot Table

2013-07-11 Thread Waseem Saifi
Dear Rakesh, please see attachment. in case of place months in ascending order. you have to do it manually. right click on any month and move it to left, right, to beginning or to end. Regards, Waseem Saifi On 7/11/13, Rakesh Kumar Sharma wrote: > Dear Experts, > > I have a query r

Re: $$Excel-Macros$$ Help me plz

2013-07-03 Thread Waseem Saifi
Dear Thameem, Open attached file. I have applied rule what you have asked. just select from cell A2:C4 and go to conditional formatting-manage rules. It will be cleared. On Sat, Jun 22, 2013 at 2:56 PM, thameem wrote: > Dear all, > > Plz find attached file, its sample, I want high for range of

Re: $$Excel-Macros$$ Pie Chart Help

2013-07-03 Thread Waseem Saifi
I think Pie chart only made for Percentage type data. for example Pie chart require a data which's percent total is 100%. if a=45%, b=30%, c=25%. then it will give right output. all in all pie chart not suitable for other than percentage type data. and that data's total should be 100% or in general

Re: $$Excel-Macros$$ split address one bye one based on "," comma

2013-05-18 Thread Waseem Saifi
you can do it with text to columns command. using delimited option in text to columns command. and check comma box then finish. do you want to do it with formula? On Mon, May 13, 2013 at 8:24 PM, jmothilal wrote: > Dear any one > > i want split address column wise based on comma > > file attach

$$Excel-Macros$$ need examples of advanced array formula

2012-09-17 Thread Waseem Saifi
Please somebody send me advanced array formula examples. I have knowledge of array formulas but at basic level. I want to be savvy in array formulas. Please Help me. Regards, Waseem Saifi -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

Re: $$Excel-Macros$$ I want to Learn Array Formulas

2012-09-07 Thread Waseem Saifi
thanx kuldeep. On Fri, Sep 7, 2012 at 3:04 PM, Kuldeep Singh wrote: > > See it... > > http://www.ozgrid.com/Excel/arrays.htm > > Regards, > Kuldeep Singh > > On Fri, Sep 7, 2012 at 2:59 PM, Waseem Saifi wrote: > >> Hi All Members, >>I want to learn

$$Excel-Macros$$ I want to Learn Array Formulas

2012-09-07 Thread Waseem Saifi
Hi All Members, I want to learn array formulas in excel 2007. Please send me some useful stuff or refer me any useful link to learn array formulas. thanx in advance. Regards, Waseem Saifi -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Round off function query

2012-05-10 Thread Waseem Saifi
=ROUNDDOWN(A1,0) On Thu, May 10, 2012 at 5:26 PM, Maries wrote: > *=ROUNDUP(A1,0.1) > * > > On Thu, May 10, 2012 at 2:55 PM, Deepak Rawat wrote: > >> =ROUND(E12,0) >> >> Regards, >> Deepak Rawat >> >> >> >> On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara < >> ashishbhalar...@gmail.com> wrote: >>

Re: $$Excel-Macros$$ If condition problem

2012-04-20 Thread Waseem Saifi
I hope this will help You Ashish. On Fri, Apr 20, 2012 at 11:46 PM, Ashish Bhalara wrote: > Dear expert, > > I use date in if formula but not work in attached file, please know me the > my mistake. > > Thanks & regards > > Ashisih Bhalara > > -- > FORUM RULES (986+ members already BANNED for vi

Re: $$Excel-Macros$$ Extract desired data

2012-04-03 Thread Waseem Saifi
please check attached file. On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad wrote: > Dear Group, > > How to extract 6 digit numbers from right if its number & convert this to > numbers by formula. See the attached file. > > Regards, > > Aamir Shahzad > > -- > FORUM RULES (986+ members already BAN

$$Excel-Macros$$ is there possibility of conditional formatting based upon nested conditions

2012-02-28 Thread Waseem Saifi
Hi All, Is there any possibility to do conditional formatting on based upon more than two conditions in a specific area in excel 2007. for Example:- if($h2="done") then 1st formatting. otherwise if(and($h2<>"",$h2<>""), then 2nd formatting. otherwise no format apply. -- FORUM RULES (986+

Re: $$Excel-Macros$$ How to find out rightmost space in a cell of text string with many spaces.

2012-02-17 Thread Waseem Saifi
gt; > > On Fri, Feb 17, 2012 at 4:23 PM, Waseem Saifi wrote: > >> Dear All, I want to know that in Excel, in a cell contains a text string, >> which has many spaces. it is possible that we can find out the leftmost >> space. But How can find out righmost space in a long t

Re: $$Excel-Macros$$ For Excel Beginner, please try this test...

2011-12-24 Thread Waseem Saifi
dear ravi, At least attach any test file. here is no test file. On Wed, Dec 21, 2011 at 9:36 PM, Chuka Lkh wrote: > please attach file > > > On Tue, Dec 20, 2011 at 10:58 PM, Vikash Chandra wrote: > >> Dear Ravi, >> I didnt find any attachment.Please send it once again. >> Thanks & Rega

Re: $$Excel-Macros$$ Almost all calculator in one sheet

2011-12-17 Thread Waseem Saifi
thanx ankit, this is awesome. and quite usefull. On Thu, Dec 1, 2011 at 9:45 AM, Pranav N wrote: > Thanks. > > -Nas > > > On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal < > ankit.agrawal...@gmail.com> wrote: > >> Hello All, >> >> In our daily life we calculate so many thing & use differen

Re: $$Excel-Macros$$ I want to do or learn VBA coding and MACRO

2011-12-15 Thread Waseem Saifi
Hi Laxman, there is a book by named "Excel 2010 power programming with vba" writer is "John Walkenbach", Publication- "wiley publications". it could be usefull for you. this is a good book for learning excel vba. try it On Fri, Dec 9, 2011 at 3:38 PM, Jorge Marques wrote: > Hi, well i hav

Re: $$Excel-Macros$$ Macro Help - Please!

2011-02-23 Thread Waseem Saifi
I think, it could be with IF Formula For Example '(=IF(D7="step","complete",IF(D7="vp","pass",""))' if value in D7 Cell. On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote: > Hello Excel Gurus, > > Need small favour from experts, > I have two columns in Excel, I need a macro, where if Column A