Hi Kal Excel,
PFA resolved query of yours.
Regards,
Waseem Saifi
On Thu, Nov 13, 2014 at 5:11 PM, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
Please help me to solve my query.
Thanks in advance
--
*Kalyan Chattopadhyay*
*Executive Corporate MIS*
*Joy Cosmetics*
--
Are you
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 attached a file which contain text in cell A15. I want to split
this text by pipe sign
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
thank you vaibhav,
it's perfect
On Sun, Oct 12, 2014 at 4:39 PM, Vaibhav Joshi v...@vabs.in 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 waseemsa...@gmail.com
wrote:
Hi Vaibhav,
I want
is here working through me for you.*
On Sat, Oct 11, 2014 at 10:19 AM, Waseem Saifi waseemsa...@gmail.com
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 cell A15.
Thanks in Advance.
Regards,
Waseem
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
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 newinex...@gmail.com wrote:
Dear Ravi,
what is use of -- before B2:B13 in above formula.
Please explain.
On 13 September 2013 16:28, Ravi Kumar
It is really an amazing collection vaibhav.
thank you so much vaibhav.
On Thu, Sep 18, 2014 at 8:06 AM, Govardhan Bhatia bkrishkr...@gmail.com
wrote:
On 9/18/14, Prafull Jadhav prafulltjad...@gmail.com wrote:
Dear Vaibhav Sir,
Thanks for the shared us a very useful file.
Regards,
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 list in
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 nkathirv1...@gmail.comwrote:
Dear Friends,
Please help me to count the 1, 2
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's
=TIME(2
Dear Rajan,
Are you looking for this type solution.
Regards,
Waseem Saifi
On Thu, Oct 17, 2013 at 3:31 PM, Rajan sharma rajansharma9...@gmail.comwrote:
Thanks for your prompt reply, But i was having some condition, that we are
not suppose to use :
Write Formula without using
1. Where
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)
amit.de...@merucabs.comwrote:
Dear
Dear Amit,
PFA
result as you desire
Regards,
Waseem Saifi
On Fri, Oct 11, 2013 at 6:01 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Friends,
** **
Please help me with the conditional count formula. Conditions needs to be
applied on both Columns Raws…Please see
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
thank you so much Ravinder.
Regards,
Waseem Saifi
On Mon, Oct 7, 2013 at 10:25 AM, Ravinder ravinderexcelgr...@gmail.comwrote:
PFA
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Waseem Saifi
*Sent:* Saturday, October 05, 2013 10:02
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 ricardo...@gmail.com wrote:
Hi Waseem, see the suggestion using conditional formatting, only to color
the font and fill the cell.
tks.
Basole
thank you so much vijay,
it worked absolutely fine.
Regards,
Waseem Saifi
On Sat, Oct 5, 2013 at 11:18 AM, Ravinder ravinderexcelgr...@gmail.comwrote:
pfa
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR
*Sent:* Saturday
Dear Basole,
please see attachment.
Regards,
Waseem Saifi
On Sun, Oct 6, 2013 at 12:20 PM, Waseem Saifi waseemsa...@gmail.com 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, Basole ricardo
attachment missing !
On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote:
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
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
Thank you so much Ravinder Aamir.
Regards,
Waseem Saifi
On Mon, Sep 30, 2013 at 4:18 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Try This
=IF(A5B5,TEXT(A5-B5,[h]:mm:ss),TEXT(B5-A5,[h]:mm:ss))
On Mon, Sep 30, 2013 at 3:43 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
=TODAY()+B2
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 xlst...@gmail.com wrote:
Please add false statement
=IF(AND(F2=TIMEVALUE(0:50:00),F2TIMEVALUE(0:30:00)),RV,IF(AND(F2=TIMEVALUE(1:00:00),F2TIMEVALUE(0:51:00)),IE
Dear Murali,
Please see in attachment.
it might be helpful.
Regards,
Waseem Saifi
On Wed, Sep 4, 2013 at 2:21 PM, MURALI NAGARAJAN muralin...@gmail.comwrote:
Dear All,
I have a data base like colum A contains State name colum B contains
city name against state name, im going to create
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 savla.kaus...@gmail.comwrote:
Thanks Prafull and Noorain sir.
On Wed, Sep 4, 2013 at 2:33 PM, Prafull
Your Welcome Murali !
[?]
On Wed, Sep 4, 2013 at 2:53 PM, MURALI NAGARAJAN muralin...@gmail.comwrote:
Dear Waseem,
Thanks for your great support.
On Wed, Sep 4, 2013 at 2:33 PM, Waseem Saifi waseemsa...@gmail.comwrote:
Dear Murali,
Please see in attachment.
it might be helpful
this is too good Rajan !
Regards,
Waseem Saifi
On Wed, Sep 4, 2013 at 3:01 PM, Rajan sharma rajansharma9...@gmail.comwrote:
Hi Murali,
Chek the attachment too. Might it will also help you. :-)
With warm regards,
Rajan Sharma
On Wed, Sep 4, 2013 at 2:55 PM, Waseem Saifi waseemsa
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
-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 cell
** **
Dear Experts,
Is it possible to embed picture
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
Thanx
[?]
On Sat, Aug 24, 2013 at 2:09 PM, xlstime xlst...@gmail.com wrote:
Yes, it is possible via Multipal consolidate ranges
Just press Alt+D+P then select Multipal consolidate ranges
.
Enjoy
Team XLS
On Sat, Aug 24, 2013 at 12:36 PM, Waseem Saifi
PFA with solution
Regards,
Waseem Saifi
On Fri, Aug 23, 2013 at 12:36 PM, ravinder negi ravi_colw...@yahoo.comwrote:
PFA
--
*From:* Ali Abbas tigarman...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Thursday, August 22, 2013 9:01 PM
*Subject
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 thread
.
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Aug 22, 2013 at 11:47 AM, Waseem Saifi waseemsa...@gmail.com
wrote:
Dear Experts,
Please suggest me.
I have some negative and some positive values in a range. please tell
me
which font
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 rajlu...@gmail.com wrote:
On 17 August 2013 12:15, Raj Kumar
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
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, prabhakar_k...@sify.com wrote:
Dear Team,
I have dates in different format and need to make it in one standard date
format. Please help
--
*From:* Waseem Saifi waseemsa...@gmail.com
*To:* excel-macros excel-macros@googlegroups.com
*Sent:* Thursday, August 1, 2013 10:53 AM
*Subject:* $$Excel-Macros$$ Query Regarding Sum
Dear Experts,
I want to sum of values basis on two conditions.
it is explained
de premor, it's too easy !
thank you so much
On Thu, Aug 1, 2013 at 11:33 AM, De Premor d...@premor.net 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 ravinder.
it's working
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:
** **
** **
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 vijay.4...@gmail.com wrote:
Respected Waseem,
Please find the attached files.All games are not possibly sent by mail
because gmail cannot handle more than 8
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) ! Join
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
Dear Rajkumar,
Please find attached file with solution.
Regards,
Waseem Saifi
On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar rajlu...@gmail.com wrote:
Dear Group,
We have lots of records and Segregate the data based on only last comma
and consider the same
Like,
*Data
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, Jul 30
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 lakshman_...@yahoo.comwrote:
Dear expert
I have a sheet in which money receipt details maintain, I want to filter
like
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote:
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
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. PFA
On Wed, Jul 24, 2013 at 6
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
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 ank.bira...@gmail.com wrote
@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 out percentage of each
category. Using Pivot table it is correct. But using
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 waseemsa...@gmail.com wrote:
Thank you so Much.
it is working absolutely fine.
awesome logic !
On Tue, Jul 23, 2013 at 4:36 PM, Excel Learn
Dear Excel_Lover,
PFA your query file with solved formula.
Regards,
Waseem Saifi
On 7/19/13, Excel_Lover idforex...@gmail.com 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
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 schreiner_p...@att.net wrote:
I've encountered similar issues before.
It seems
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 waseemsa...@gmail.com wrote:
Dear Excel_Lover,
PFA your query file with solved formula.
Regards,
Waseem Saifi
On 7/19/13, Excel_Lover idforex
is 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’s
=TIME(2
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 v...@vabs.in wrote:
Hi
Also state operating system you are using along with PC
Please find attachment.
it might help you
On 7/17/13, Neeraj Chauhan neerajchauhan...@gmail.com 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
--
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 rakeshks@gmail.com wrote:
Dear Experts,
I have
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 thamee...@gmail.com wrote:
Dear all,
Plz find attached file, its sample, I want
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 gjmothi...@gmail.com wrote:
Dear any one
i want split address column wise based on
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
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
thanx kuldeep.
On Fri, Sep 7, 2012 at 3:04 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
See it...
http://www.ozgrid.com/Excel/arrays.htm
Regards,
Kuldeep Singh
On Fri, Sep 7, 2012 at 2:59 PM, Waseem Saifi waseemsa...@gmail.comwrote:
Hi All Members,
I want to learn array
=ROUNDDOWN(A1,0)
On Thu, May 10, 2012 at 5:26 PM, Maries talk2mar...@gmail.com wrote:
*=ROUNDUP(A1,0.1)
*
On Thu, May 10, 2012 at 2:55 PM, Deepak Rawat deepakexce...@gmail.comwrote:
=ROUND(E12,0)
Regards,
Deepak Rawat
On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara
I hope this will help You Ashish.
On Fri, Apr 20, 2012 at 11:46 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
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
please check attached file.
On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
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+
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+ members
, 2012 at 4:23 PM, Waseem Saifi waseemsa...@gmail.comwrote:
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 text string with many
spaces.
Like
dear ravi,
At least attach any test file. here is no test file.
On Wed, Dec 21, 2011 at 9:36 PM, Chuka Lkh chuka...@gmail.com wrote:
please attach file
On Tue, Dec 20, 2011 at 10:58 PM, Vikash Chandra vks.chan...@gmail.comwrote:
Dear Ravi,
I didnt find any attachment.Please send
thanx ankit,
this is awesome.
and quite usefull.
On Thu, Dec 1, 2011 at 9:45 AM, Pranav N nadab...@gmail.com 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
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 leote.w...@gmail.com wrote:
72 matches
Mail list logo