SRIKANTH:
THIS IS NOT JOB PUBLISHING PORTAL. KINDLY STOP SENDING EMAILS TO THE
GROUP..!!!
On Wed, May 2, 2018 at 4:32 PM, Srikanth HCL Global <
srikanth.recruitm...@gmail.com> wrote:
> Hello,
>
>
>
> Greetings of the day!!!
>
>
>
> *Please share resumes to* *s...@hclglobal.com* * at
>
SRIKANTH:
THIS IS NOT JOB PUBLISHING PORTAL. KINDLY STOP SENDING EMAILS TO THE
GROUP..!!!
On Wed, May 2, 2018 at 4:32 PM, Srikanth HCL Global <
srikanth.recruitm...@gmail.com> wrote:
> Hello,
>
>
>
> Greetings of the day!!!
>
>
>
> *Please share resumes to* *s...@hclglobal.com* * at
> ea
Sleek
Use Mail Merge to do it i.e build up your data in Excel and then in Ms word
the option available is Mail merge. When you use Mail Merge as option you
get the opportunity to bring your Excel data to Ms word. Just google Mail
merge with Excel - I'm sure you will get it.
Regards,
On Thu, Nov
Dear Experts,
Per attached Excel file database - based on the information typed From
Column A to F and once clicked "Send emails" - emails should be sent.
I need VBA code to send Emails by Outlook
Kindly help.
--
*Ahmed Bawazir*
*احمد باوزير*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Hi Send details
On Friday, July 28, 2017, Rajan Verma wrote:
>
> [image: Inline image 1]
>
> --
> 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
use a helper column to convert the data (to numeric) and then apply Max
formula you shall get the answer..
Hope this helps
On Thu, Oct 9, 2014 at 3:54 PM, Sundarvelan N wrote:
> Dear Friends,
>
> Please help me in finding the maximum value in a non numeric column,
> example below
>
> A
use this formula : CONCATENATE(DAY(C4),"-",MONTH(C4),"-",YEAR(C4))
On Wed, Jul 16, 2014 at 9:52 AM, Ashish Bhalara
wrote:
> Dear experts,
>
> I have a data in which date format is Text, I want to change in date
> format to filter data date and month wise. I have change manually this
> thing by
Dear All:
Please see attach excel file and if you can help me with a formula to
generate OUTPUT in 2 different ways from List 1 and List 2.
*Thanks in advance!*
--
*Ahmed Bawazir*
*احمد باوزير*
--
*Ahmed Bawazir*
*احمد باوزير*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Thanks Ashish but Please observe my initial draft. Datedif I know very well
on the usage and it fails.
Regards
On Thu, Feb 13, 2014 at 5:58 PM, Ashish Kumar wrote:
> Hi Ahmed,
>
> PFA..!!!
>
>
> Thanks
> Ashish
>
>
>
> On 13 February 2014 20:15, A
Dear All,
Please see below and kindly help.
Requirement : How to get no. of years, months and Dates between 2 dates.
Example :
Start date : 1-Oct-2012 suppose in cell A1,
End Date : 30-Jun-2013 suppose in cell B1
Then used formula is :
1. Datedif(a1,b1,"Y") for years = Output is zero
2. Datedif
*Simply Bravo!* Mr. Paul.
On Tue, Jul 23, 2013 at 2:29 PM, Paul Schreiner wrote:
> "these type of cases"?
> I'm not sure your situation falls into a "type" of case.
>
> In YOUR case, Excel is interpreting your string "> 7 days"
> as: GREATER than " 7 days"
> or: GREATER THAN [space]7[space]"d
Dear Priti,
Please find attach the solution. It is too simple
On Mon, Jul 15, 2013 at 1:34 PM, priti verma wrote:
> Hi group ,
>
> Please try to solve this.
>
> Queri based on conditional formating
>
> If b2 >a2 then up arrow and coluor should be green .
>
> if b2
> See PFA For more cl
Dear...
Search the youtube or just google it with the keywords that you have posted
here in the group you shall get plenty of examples and videos to
understand you will find helping yourself...
On Wed, Jul 3, 2013 at 4:20 PM, Vijay Kr. Aggarwal wrote:
> I want to know that can we use
Kaushik,
PFA, to see the formula.
On Tue, Jul 2, 2013 at 5:15 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> I am having some data in Cell A1 to A100 and I want to concatenate
> range of data from A1 to A100 with comma as seperator.
>
> Example:
>
> Cells
> A1 10
> A2 20
> A3
Kaushik:
As your values are in Cells A1 to A2 write in Cell B1 formula =A1 and in
cell B2 = concatenate(B1,",",B2) and now this cell B2
formula copy and paste from cell B3 to B100 then finally the result you are
looking for will be in B100.
Hope this helps
On Tue, Jul 2, 2013 at 5:15 PM
Dear Pravin :
Use the below
=TEXT(DATE(RIGHT(B4,4),MID(B4,4,2),LEFT(B4,2)),"DD-MMM-")
On Sat, Jun 22, 2013 at 3:15 PM, Pravin Gunjal wrote:
> Dear Vaibhav
>
> It's not working,. please check the attachment.
> Thanks,
>
> Pravin.
>
> -- Forwarded message --
> From: VBA VABZ
Hi Santhosh:
left / Avg. Head count = Attrition % can be done, where Avg. Headcount is
Open + close / 2 and where Opening = No. of headcount on start of the month
and Close = no. of headcount on end of the month.
So pull the raw data in excel and do it.
Hope this shall help you!
Thanks,
Ahmed B
Try to use Average ifs if you are using Excel 2007 you shall get it.
Thanks,
Ahmed Bawazir
On Sat, Jun 15, 2013 at 1:34 AM, Dheeraj Bankoti wrote:
> Hi Experts,
> PFA a sample file, in which I need average quantity.
>
> Appreciate any inputs.
>
> Regards
>
> --
> Are you =EXP(E:RT) or =NOT(EX
Hi Danial :
Press Ctrl + H and then
in find what box keep comma , and in replace leave it empty and click
Replace All it shall help...
On Tue, May 7, 2013 at 10:55 AM, danial mansoor wrote:
> dear Experts:
>
> Kindly look at my file,there are some numbers kindly convert this into
> numb
Rakesh:
Run Pivot table, if no Idea just google it to learn Pivot tables / go to
youtube to learn pivot table. You will learn less time.
Start exploring.
Thanks,
On Tue, Apr 30, 2013 at 2:04 PM, Rakesh kumar wrote:
> Hi Friends,
>
> I have some problem in excel, please help me.
>
> column A
Pravin:
Just Copy > Paste Special > Values the soure code will be removed and no
Edit link errror will appear.
On Tue, Mar 26, 2013 at 4:16 PM, Pravin Gunjal wrote:
> Pl inform me how to remove those files.
>
> -- Forwarded message --
> From: xlstime
> Date: Tue, Mar 26, 201
Dear Pravin,
Use the solution which suit your need and meets your requirement. But my
solution will be something like this :
By holding Ctrl Key and by using Mouse click select the sheets you wish to
delete. Once the selection of sheets is done --- right click and choose
delete --- this will dele
Here is the first one to help and elighten us
Actually I don't know about the coding in vba where I can learn coding for
vba. I know only record macro. I want to do coding in my way. What I want
I get it from my data.
Thanks
Manoj
On Oct 10, 2012 11:20 PM, "Rajan_Verma" wrote:
> *Just a q
Dear Rajan,
Salute for your Support and Talent. Will it not be better to enlight us
with your skills by having a list of topic to educate the group from that
list one by one, so that we become more productive in our daily life work.
For sure, I believe you too believe that Sharing Knowledge alway
Dear Pravin,
PFA with Revised and Swapnil one solution is also the same but it is
disturbing the Date Column which has been undisturbed in my file. Choose
which ever suits your requirement.
Thanks,
On Thu, Oct 4, 2012 at 1:15 PM, Ahmed Honest wrote:
> Dear Pravin.
>
> *PFA*
>
>
Dear Pravin.
*PFA*
On Thu, Oct 4, 2012 at 1:01 PM, Pravin Gunjal wrote:
> *Hello Friends,*
> *
> *
> *I require a help on the subject matter. The file is attached for your
> reference.*
> *
> *
> *I have used the conditional formatting as mentioned in the excel file.
> And I required that the
de my day.
Regards
Ahmed Bawazir
On Tue, Sep 25, 2012 at 8:14 PM, >>Excel Beginner<< wrote:
> Hi Ahmed,
>
> Find the attachment.
>
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
>
> On Tue, Sep 25, 2012 at 3:27 PM, Ahmed
Dear All,
Please find attach the Raw Data sheet from which I need to convert a
Gregorian Date to a Hijri Date and pull out the Day, Month, Year from the
Hijri Date.
Any help on this will be appreciated.
Thanks,
--
Ahmed Bawazir
*احمد باوزير*
--
Join official facebook page of this forum @
ht
Dear Deepak,
Looking at your sample data one of your Outlet name : Janata Stores(S)
starting from 9 to 15-Jul status is available only for 14 and 15-July as
Off and Working,
*what shall be considered as status for rest of the days i.e from 9 to
13-July ??*
**
* *
*
*
On Mon, Aug 6, 2012 at 2:5
Use Pivot Table you should get the desired
On Wed, Jul 11, 2012 at 1:00 PM, Priti_Verma wrote:
> * *
>
> *Hi,*
>
> *To all,*
>
> *I am new here,please help me ,to find out all details about the country
> ,which is selected by drop down list.*
>
> *See the attached file.*
>
> ** **
>
> --
> FORU
Hi Hilary,
Just to have a look I have downloaded your file and enabled the macros in
my computer. But since then My ribbon is has dissappeared and I'm unable to
get it back. Please give me the steps to unlock and make my excel to normal
one.
Thanks,
On Sat, Jul 7, 2012 at 5:14 PM, Hilary Lomot
Hi Mangesh,
Try using from Insert Menu -- Object -- choose Create from file and locate
your sheet path that is available in your respective file then an Icon is
displayed so being in a sheet when you click on that Icon you will get
another sheet.
Revert if you failed to understand the above. I t
Hi Mangesh,
Try using from Insert Menu -- Object -- choose Create from file and locate
your sheet path that is available in your respective file then an Icon is
displayed so being in a sheet when you click on that Icon you will get
another sheet.
Revert if you failed to understand the above. I th
Dear,
I think using Ctrl + Z will allow you to take back the action you performed
i.e Undo the last action ;-). This should help. If not, check other experts
advice.
Thanks,
On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E wrote:
>
> Dear all,
>
> Iam using Office 2007, when iam need to use Cr
Dear Amit,
May be I'm not sure whether you are familiar with this Or this is what you
are looking for i.e for making all columns adjust according to the Raw Data
in a sheet you do this >> Ctrl + A to select entire sheet and after this
Alt + O + C + A.
Hope this helps.
On Sun, Jun 17, 2012 at
Dear Deba,
That's INput message defined using Data Validation. For your information
click in the cell where the message is coming up go to Data tab and
select Data Validation and in Data Validation Check for Input message. Hope
you shbould understand.
Moreover, it's one of the way to guide the en
A1, Try below formula,
> *
> =INT(A1/12)&" Years "&A1-INT(A1/12)*12& " Months"*
>
>
> On Wed, Jun 13, 2012 at 5:56 AM, Ahmed Honest wrote:
>
>> Hi Experts,
>>
>> Based on a given number I need the result to be something like below:
Hi Experts,
Based on a given number I need the result to be something like below:
Given Number : 200
Answer should be 16 Years 8 Months.
Is there any way of doing it in Ms Excel by Formula?
Thanks,
Ahmed Bawazir
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accu
Hi Chandra,
PFA and see if it helps
Thanks,
On Tue, Jun 12, 2012 at 4:45 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello,
>
> Can you please help me with attached excel.
>
> Thanks in advance.
>
> Regards,
>
> Chandra Shekar B
>
> --
> FORUM RULES (986+ members already BANN
Dear Ankur,
Please if you don't mind will you make your font sytle and size as a simple
Or plain one. It looks too ODD.
Thanks for your understanding.
Regards,
On Tue, Jun 12, 2012 at 11:38 AM, ankur wrote:
> *HI ASHISH
> **I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbec
;
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ahmed Honest
> *Sent:* 11 June 2012 6:26
>
> *To:* excel-macros@googl
is already attached in this group.
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
>
>
>
> On Mon, Jun 11, 2012 at 6:26 PM, Ahmed Honest wrote:
>
>> .
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise
Hi Deba,
the same can be achieved without VBA let me know if you wish to have that.
Just send me your file. I will send you the solution.
On Mon, Jun 11, 2012 at 3:54 PM, Deba Ranjan wrote:
> Thanks..
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
>
>
>
> On Mon, Jun 11, 2012
Hi,
Use Vlookup formula, I think it should help you.
Rgds
On Sun, Jun 3, 2012 at 1:08 PM, Sourabh Salgotra wrote:
>
> Dear sir,
>i am using index/match formula. in my problem i am getting the
> 1st occurrence result only.
> Sr. No. Subject Code Subject/Paper code 1 BF 1 MAT
Dear Amit,
Use the Drop Down list options which is available in the Data Validation. I
hope you know it. If not just google how to create drop down list you shall
get the desired that you are looking for.
Or revert to the group to help you out with this.
Thanks,
On Tue, May 29, 2012 at 10:18
Dear Ashish,
Click on below link to learn about Multi Sheet Pivot.
http://office.microsoft.com/en-us/excel-help/consolidate-multiple-worksheets-into-one-pivottable-report-HA010226585.aspx
Thanks
Ahmed Bawazir
On Sat, Mar 10, 2012 at 3:09 PM, Ashish Bhalara
wrote:
> Dear sir,
>
> Please tell me
Hi,
Hope these help, Drag the file down untill last row of the data sheet.
On Wed, Oct 12, 2011 at 6:40 PM, Ahmed Honest wrote:
> Dear Mr. Shiek,
>
> Tons of thanks for your help. I hope that U achieved it by VBA but is there
> any formula of excel to achieve this?
>
> De
it helps.
>
> Regards
>
> Shiek
>
> On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 wrote:
>
>> You say “single LINE”. Do you mean one cell ? If so, NO.
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* Ahm
Dear All,
If an excel file contains 1000's of emails ids in a column say as below :
'pi...@gmail.com --- in Cell A1
'ti...@gmail.com--- in Cell A2
li...@yahoo.com --- in Cell A3
zi...@yahoo.com--- in Cell A4
I need a formula to make all these email id as : *pi...@gmail.com,
ti...@gmail.com,li...@
ust be entered using ctrl+shift+enter
>
> *=MAX(IF(($A$5:$A$5000>C5)*($A$5:$A$5000
> *From:* Ahmed Honest
> *Sent:* Sunday, September 25, 2011 8:02 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Max Value Required for Each half hour
>
> Dear Gr
Dear Arty,
Run a pivot table and make the count of Passed, Failed on the specific date
by removing the N/A from the filters. I hope you know how to run the pivot
table.
Regards
Ahmed Bawazir
On Thu, Sep 15, 2011 at 7:09 PM, ArtySin wrote:
> Hi
> I have two columns as below using Excel 2000 (un
Hi Viper,
you have viped away the attachment lol, there is no attachment attached.
*Great day,
Bawazir
*
On Thu, Sep 15, 2011 at 2:52 PM, §»VIPER«§ wrote:
> hi
>
> pfa
>
>
> --
> *Great day,*
> *viper
>
> *
> On Thu, Sep 15, 2011 at 5:05 PM, Abhishek Jain wrote:
>
>> Dear Naanu,
>>
>> P
Dear Varun,
Try to use Datedif function, if you are familiar with it or just google it
you will get the solution in seconds.
On Thu, Sep 8, 2011 at 11:27 AM, VARUN CHAWLA wrote:
>
>
> Can any body guide me the formula to calculate the Age in excel with months
> and days.
>
> Regards
>
> Varun
Dear Mr. Vasi,
I hope this will be help you for sure. Kindly register yourself on
www.citehr.com and you will be able to post your queries and get solutions
for them.
Anyways Congrats for your New Job in a new Destination.
Regards
Ahmed Bawazir
On Sun, Apr 10, 2011 at 11:16 AM, vasisd wrote:
Dear Paul,
What an excllent way of explanation for the below. Hai there Maestro.
Regards
Ahmed Bawazir
On Mon, Mar 7, 2011 at 8:49 PM, Paul Schreiner wrote:
> Excel has it's own internal date/time functionality.
> A "date" is the number of days since 1/1/1900.
> "time" is a fractional part of
Dear Group,
A very good day to you guys, I have the following query for which i have
searched internet as well and unable to get a formula or soultion and
looking forward from you guys and i am sure any one will answer for the
below:
I want to convert a Hijri Date to Georgian Date with a formula.
Dear,
That's possible. Please do a favour by sending a sample sheet of your query.
I am sure you will get answer from the group.
Regards
Ahmed Bawazir
On Sun, Jan 23, 2011 at 10:10 AM, kush sharma wrote:
> Dear All,
>
> I have a query in which i need your help. Lets Say, I am using an Excel
Dear Sharma,
I have no idea of your requirement but the file seems to be like willing to
know the password predictions algorithms. Or Hacking password techniques.
Please clarify on this or correct me if i failed to understand your file.
Thanks & Regards
Ahmed Bawazir
On Mon, Jan 3, 2011 at 11:14
Dear Anand,
As per your below mail i think that you have mailed to concerned person
personal email. But would request you to be kind enough to send me as well.
Appreciate and thanks in advance..!!
Regards
Ahmed Bawazir
On Tue, Nov 30, 2010 at 8:30 AM, anandydr wrote:
> Hi,
>
> Just mailed you
Dear
Send a sample file to the group, hope you will get solution to your query.
Regards
Ahmed Bawazir
On Thu, Sep 30, 2010 at 8:35 PM, Shah wrote:
> Hi,
> I need some HELP with increment flagging.
> By flag I mean a One appears when an even happens, and a Zero appears
> when it doesn't
>
> And
Dear Mohammed Idhrees,
Please find attach, i hope this is your requirement, i have done only for
the 2 rows which are colored in yellow, if you wish you can copy paste and
tak the values from the list.
If this is not your requirement you can revert to the group for more help.
Regards
Ahmed Bawaz
Hai,
Our Favourite buddy in this group Mr. Dave has already given attention and
replied to your query please see it again. I hope you might not have seen
it.
Regards
Ahmed
On Sun, Aug 8, 2010 at 6:51 AM, Vijay Kr. Aggarwal wrote:
> Hi Friends,
>
>
> If question is not clear in attached file th
Hey Pankaj,
The File is password protected, provide password to unlock and get the
required.
Group is waiting
On Tue, Aug 3, 2010 at 7:13 PM, Intelligent But Crazy
wrote:
> Hi group,
>
> My self pankaj,
> currentally I m working on a project, I have created
Dear All,
Please find attach the sheet wherein I need the Data from "Tracking Sheet"
should go the each individual sheets the data.
Please see attach file for more understanding.
Waiting for your ideas and suggestions...
--
Ahmed Bawazir
--
---
Dear Dilip,
Can you explain the logic, of getting the Unit Price 25-30,
30-35. as the source date holds no such units.
Regards
Ahmed Bawazir
On Tue, Jul 13, 2010 at 12:59 PM, Dilip Pandey wrote:
> Hey mr. Soni..
>
> Two Charts has been created as per your requirements
65 matches
Mail list logo