login your facebook and Like this page if you are MIS
professionalshttps://www.facebook.com/misprofessionals and
Get Jobs update daily.
https://www.facebook.com/misprofessionals
Thanks!
AK
--
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) !
Location??
On Fri, Oct 11, 2013 at 4:35 PM, Divaker Pandey divake...@gmail.com wrote:
This is Divaker from Nine Dimensions Infotech Pvt ltd.. I
would like to inform you that my company has vacancy for a Software
Engineer
having skill on Excel, VBA and Basic SQL.
Please forward me your
http://www.w3schools.com/
On Tue, Jun 11, 2013 at 4:03 PM, కిరణ్ కొత్తకోట
kothakota.ki...@gmail.comwrote:
http://www.w3schools.com/sql/default.asp is the best of my knowledge.
On Tue, Jun 11, 2013 at 3:55 PM, Amit Desai (MERU)
amit.de...@merucabs.com wrote:
Hello Friends,
** **
Dear Bharti Ji,
Use this formula.
=IF(ISERROR(FIND( ,A1)),EXACT(A1,UPPER(A1)))
Regards
@K
On Tue, Jun 4, 2013 at 5:21 PM, Raj Kumar rajlu...@gmail.com wrote:
Hi,
i have lots of data in excel Column A. in which some records are in Upper
Case.
By which formula how can we find out these
Anil
On Wed, Jan 16, 2013 at 1:24 PM, Amresh Maurya amreshkushw...@gmail.com
wrote:
Hello Amit,
PFA file .Kindly use the below code.
Sub minmm()
n = 5
Sheet1.Cells(5, 14).Formula = =MIN(RC[-10],RC[-6],RC[-2])
Sheet1.Range(Cells(5, 14), Cells(10, 14)).Select
Selection.FillDown
Sheet1
Hi Midhun Thampan.,
PFA SOLVED FILE.
Regards
Amresh
On Thu, Jan 17, 2013 at 10:17 AM, Midhun Thampan
midhun.tham...@gmail.com wrote:
hi all;
this is an excel sheet in which when i select the specific week the
data should be updated in the databse below according to the week and
the
On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat deepakexce...@gmail.com wrote:
Dear Anoop,
I need as i given table.
regards,
Deepak rawat
On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma aks.sharm...@gmail.com
wrote:
Hi Deepak,
PFA. You need to refresh the pivot on first sheet.
Hello Amit,
PFA file .Kindly use the below code.
Sub minmm()
n = 5
Sheet1.Cells(5, 14).Formula = =MIN(RC[-10],RC[-6],RC[-2])
Sheet1.Range(Cells(5, 14), Cells(10, 14)).Select
Selection.FillDown
Sheet1.Range(Cells(5, 15), Cells(10, 15)) =
Hi,
Kindly use this function code .
Function SpellNumber(ByVal MyNumber, Optional incRupees As Boolean = True)
Dim Crores, Lakhs, Rupees, Paise, Temp
Dim DecimalPlace As Long, Count As Long
Dim myLakhs, myCrores
ReDim Place(9) As String
Place(2) = Thousand : Place(3) = Million
Place(4) =
Hi Everyone,
I Need invoicing Tool for Printing Invoice. Please share if you have
any kind of tools for invoicing in excel.
Regards
Amresh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
On Wed, Oct 31, 2012 at 1:22 PM, Satendra kumar
satendrakuma...@gmail.com wrote:
Hi,
Find Attachment.
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 @
send me attachment.
On Fri, Oct 26, 2012 at 1:01 PM, Manoj Kumar manoj.11...@gmail.com wrote:
Anybody Please help me
On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar manoj.11...@gmail.com wrote:
Dear Expert,
Please help me to get the currect ans with attached file..
Regard
Manoj
--
PFA.
On Fri, Oct 26, 2012 at 1:04 PM, Manoj Kumar manoj.11...@gmail.com wrote:
File allready attached...
On Fri, Oct 26, 2012 at 1:02 PM, Amresh Maurya amreshkushw...@gmail.com
wrote:
send me attachment.
On Fri, Oct 26, 2012 at 1:01 PM, Manoj Kumar manoj.11...@gmail.com
wrote:
Anybody
Hi,
Find the attached solution.
use below formula
=+COUNTIFS($B$2:$B$10,B2,$D$2:$D$10,0)
On Tue, Sep 4, 2012 at 11:28 AM, Muralidhar E emuralidha...@gmail.comwrote:
Dear all,
Find the attached file, I want i column E if column D is more than zero to
be calculated with how many times
sorry previous was wrong attachment. consider this one.
Regards
Amresh
On Tue, Sep 4, 2012 at 11:47 AM, Amresh Maurya amreshkushw...@gmail.comwrote:
Hi,
Find the attached solution.
use below formula
=+COUNTIFS($B$2:$B$10,B2,$D$2:$D$10,0)
On Tue, Sep 4, 2012 at 11:28 AM, Muralidhar E
Hi Pravin,
find the attached solution.
use this small formula.
=COUNTA(C3:C39)
Regards
Amresh
On Wed, Sep 5, 2012 at 10:50 AM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Friends,
Greetings !
Request for your help on the subject matter.
I have attached the file for your reference, in
...
Regard
Manoj
On Wed, Sep 5, 2012 at 11:04 AM, Amresh Maurya
amreshkushw...@gmail.comwrote:
Hi Pravin,
find the attached solution.
use this small formula.
=COUNTA(C3:C39)
Regards
Amresh
On Wed, Sep 5, 2012 at 10:50 AM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Friends
Hi Manoj,
Find the attached file.
use this formula hope it will help you.
=RANK(B2,$B$1:$B$6,0)
if you need anything else Pls explain properly.
Regards
Amresh
On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Pravin,
Please provide ans..
Regard
Manoj
Amresh Maurya
On Mon, Sep 3, 2012 at 4:50 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Manoj,
I work only your required output Only. It's Okay.
Regards,
Kuldeep Singh
On Mon, Sep 3, 2012 at 4:47 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Kuldeep,
Amresh put formule
Hi Rambabu,
Find the attached file.
use this formula.
=SUMIFS(I15:I24,K15:K24,O15,J15:J24,N15)
Regards
Amresh
On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Please try
=SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,=O15)
On Mon, Sep 3, 2012 at 5:17
Congrats Noorain you are hero of Group ...!
Regards
Amresh
On Mon, Sep 3, 2012 at 5:25 PM, Venkat CV venkat1@gmail.com wrote:
Congrats Noorian...
--
*Best Regards,*
*Venkat *
*Chennai*
On Sun, Sep 2, 2012 at 10:32 AM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
Hi Pravesh,
Find the attached solved file.
=IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0))
Reagrds
Amresh
On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish
vaishpriyanka2...@gmail.com wrote:
Hi Pravesh,
=VLOOKUP($H3,$C$3:$D$9,2,0)
I think this formula would solve your
Hi,
use this macros also ... hope help you.
Sub nee()
If ThisWorkbook.Worksheets.Count 1 Then
Sheets(master).Activate
For i = 2 To ThisWorkbook.Worksheets.Count
Application.DisplayAlerts = False
ThisWorkbook.Worksheets(2).Delete
Application.DisplayAlerts = True
Next
End If
:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Amresh Maurya
*Sent:* 08/27/2012 18:33
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Sheet To WB
** **
Hi,
** **
use this macros also ... hope help you
Hi,
COPY EXTRA SPACE AND REPLACE WITH BLANK.
Regards
Amresh
On Thu, Aug 23, 2012 at 4:48 PM, Suman ksuman1...@gmail.com wrote:
Hi Experts !
I am unable to remove extra spaces form the attached file, whereas I had
already used Trim,Clean and Substitute function for the same. Please guide
you can use this Macro code also for remove it.
Sub ReplaceText()
Dim c As Range
For Each c In ActiveSheet.UsedRange
c = replace(c, , )
Next
End Sub
Regards
Amresh
On Thu, Aug 23, 2012 at 4:53 PM, Amresh Maurya amreshkushw...@gmail.comwrote:
Hi,
COPY EXTRA SPACE
Hi Amar,
find the attached file. hope it will help you in search the data.
Regards
Amresh
On Tue, Aug 21, 2012 at 2:22 PM, amar takale amartak...@gmail.com wrote:
Hi experts,
I know it is Conditional formatting but if I search name then highlight
that cell but if there are 1000 name I
,
Gawli anil
On Tue, Aug 21, 2012 at 3:20 PM, amar takale amartak...@gmail.comwrote:
Hi Amresh
I used excel 2003 So I cant see formulas.I also not understand what are
doing? In which cell I put search name Then highlight search name cell.
Amar
On Tue, Aug 21, 2012 at 3:04 PM, Amresh Maurya
Hi ,
it works like sumif and sumifs..
we used it for find average value with criteria
[image: Inline image 1]
Regards
Amresh
On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Experts,
What is the correct use of AVERAGEIF AVERAGEIFS. Kindly share more
Hi ,
clear Unnecessary formatting.delete unused columns
save as file type in Microsoft Binary workbook.
i hope it will help you.
Regards
Amresh
On Thu, Aug 16, 2012 at 1:08 PM, Rakesh Kumar Sharma rakeshks@gmail.com
wrote:
Dear Kuldeep,
It's too large size
On Thu, Aug 16, 2012 at
pls follow Group Rules.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
Regards
Amresh
On Thu, Aug 16, 2012 at 2:04 PM, srinivas ksrinivas...@gmail.com wrote:
Excellent Track record in Training placing Freshers as ORACLE DBAs/APPS
DBAs,
Hi,
Kindly find the attached solutions.
Regards
Amresh
On Mon, Jul 23, 2012 at 12:40 PM, Puttu * puttu...@gmail.com wrote:
Experts please help me on this code.
On Sat, Jul 21, 2012 at 7:15 PM, Puttu * puttu...@gmail.com wrote:
Hi Experts,
Please help on below macro need a macro to prefix
End If
End Function
Regards
Amresh
On Mon, Jul 23, 2012 at 1:18 PM, Puttu * puttu...@gmail.com wrote:
Thanks Amresh, I need to run this multiple sheets, can i have this in
macro. Which is going to help me a lot.
Appreciate your help
On Mon, Jul 23, 2012 at 1:10 PM, Amresh Maurya
Hi ,
Kindly use below formula.
despatch Time
Acutal despatch Time
TAT Status
Formula 7/18/12 9:00 AM 7/18/12 10:00 AM TAT Meet =IF(TEXT(C2,hh)=10,TAT
Meet,TAT not Meet) 7/18/12 9:00 PM 7/18/12 3:00 PM TAT not Meet
=IF(TEXT(C3,hh)=10,TAT
Meet,TAT not Meet)
Regards
Amresh
On Thu, Jul
Hi,
use below formula
=find(B1,A1)
Regards
Amresh
On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar kumarmanoj.11...@gmail.com wrote:
Dear Expert.
i have 2 Coll A1 B2
A1 Contain (Foto Fast Elec)
B1 Contain (Fast)
I want khow B1 is in A1 or not...
Regard
Manoj
--
FORUM RULES (986+
Pls Follow Rule No 1
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
On Fri, Jul 6, 2012 at 11:49 AM, NOORAIN ANSARI
noorain.ans...@gmail.com
Congrats. both of you dear.
Regards
Amresh
On Mon, Jul 2, 2012 at 2:21 PM, setu setu.i...@gmail.com wrote:
hey congratulations to both of you.great win...god bless u both
On Mon, Jul 2, 2012 at 2:12 PM, Abhishek Jain abhishek@gmail.com
wrote:
Many congratulations to Ashish ji and
use this formula
=VLOOKUP(E2,$A$1:$B$6,2,FALSE)
Regards
Amresh
On Mon, Jul 2, 2012 at 4:43 PM, Amresh Maurya amreshkushw...@gmail.com wrote:
Kindly fixed table array range.
Regards
Amresh
On Mon, Jul 2, 2012 at 4:41 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Sir
Hi ,
use this formula.
6/4/2012June-04-2012
=TEXT(A2,-dd-)
feel free drop me mail if need any clarification.
Regards
Amresh
On Mon, Jun 4, 2012 at 7:09 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote:
Hi Experts,
Suppose date is 06/04/2012 then i need a output like
Hi Pawal,
please find the attached solution.
kindly use text to column.- ALT+D+ENEXTNEXTTEXTENTER
Regards
Amresh
On Wed, Apr 4, 2012 at 2:07 AM, pawel lupinski lupins...@yahoo.com wrote:
Hi All,
Can you help me with cell format I need to format it in the way that
should change input
USE THIS.
Shortcut Keys - ALT+D+ENEXTNEXTTEXTGENERAL
then Cntl+1customType\R00OK.
Regards
Amresh
On Wed, Apr 4, 2012 at 2:13 AM, Amresh Maurya amreshkushw...@gmail.comwrote:
Hi Pawal,
please find the attached solution.
kindly use text to column.- ALT+D+ENEXTNEXTTEXTENTER
H Friends,
I HAVE TO RENAME 72 SHEETS AND I AM USING BELOW CODES FOR RENAME SHEET.
BUT A1 RANGE CHARACTER TOO LONG I WANT RENAME EACH SHEETS HAS 20 CHARACTER
OF RANGE A1.
PLS CHANGE THE FORMULA AND SEND ME BACK.
THANKS IN ADVANCE.
Sub RenameTabsHandlingNulls()
' Renames all worksheet tabs
Hi Friends,
We have 77 campaign and 77 city lists , now what i need , each campaign has
77 cities.
We have attached file for reference. kindly check
Regards
Amresh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
exactly...
thank you so much..
Regards
Amresh
On Mon, Mar 26, 2012 at 5:35 AM, BNS kumar chimir...@gmail.com wrote:
Hope this file serve your needs
Regards
Kumar
On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya
amreshkushw...@gmail.comwrote:
Hi Friends,
We have 77 campaign and 77
Hi All,
We have good Opening for MIS Executive.
Job Description:
Location - Gurgaon (Nr Huda City Centre Metro Station)
Work Experience : - Total 2+ Year.
Required Skills : - Good Command Over MS
Excel.(Vlookup,sumif,Filter,Condition Formatting,Pivot Table)
CTC : - 1:80 - 2:10 Lac.
Hi Guys,
I need a Excel application for Invoice Managment Tracker ..if you have any
excel , access application for invoice managment pls send me..
Thanks in Advance
Regards
Amresh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
*Hi,
Pls use
CTRL+SHIFT+ *
Regards
Amresh
On Wed, Oct 12, 2011 at 12:19 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear All,
I need shortcut key for all border.plz help me.
Regards,
Ankit
--
--
My Dearest,
I have required a business billing format where we can genrate the company
invoice it will convert in to PDF also send to respective people. pls
give me format for it if you have any.
Regards
Amresh
--
Congratulation Noorain...
Regards
Amresh
On Sat, Oct 1, 2011 at 12:13 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Sept'11
He has posted 140 posts in sept 2011 and helped many people through his
Guys,
you have any presentation ppt on internet.if you have pls send me..
Regards
Amresh
On Thu, Sep 29, 2011 at 5:40 AM, Seba sebastjan.hri...@gmail.com wrote:
Hi Paul,
thank you very much for aour effort. There is just one thing: I paste
2 values in S14 and S15 and the macro records
-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Thu, Sep 22, 2011 at 11:10 AM, Amresh Maurya
amreshkushw...@gmail.comwrote:
Hi All,
Pls send me if you have any report format for SEM, PPC (Pay Per Click)
daily monthly dashboard .
Regards
Amresh
://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Thu, Sep 22, 2011 at 3:12 PM, Amresh Maurya
amreshkushw...@gmail.comwrote:
Hi Noorain Ansari,
Thanks for you response,
It will really help me for creating my report but i need sample reports
Hi Noorain,
I Read your Excel poem on your blog : *http://noorain-ansari.blogspot.com/.*
Awesome... Keep on..
Regards
Amresh
On Thu, Sep 22, 2011 at 4:05 AM, Amresh Maurya amreshkushw...@gmail.comwrote:
Thank you so much..
perfect..
Regards
Amresh
On Thu, Sep 22, 2011 at 4:00 AM
Hi Friends,
can you help me on pivot table.
we have multiples name in columns. i want no of unique count throw pivot
how i can do it..please help.
Regards
Amreh
--
--
Some important links for excel users:
1.
54 matches
Mail list logo