$$Excel-Macros$$ get jobs update daily in MIS!!

login your facebook and Like this page if you are MIS professionals 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) ! Jo

Re: $$Excel-Macros$$ Urgent Requirement

Location?? On Fri, Oct 11, 2013 at 4:35 PM, Divaker Pandey 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 resume as soon

Re: $$Excel-Macros$$ Tutorial on SQL

http://www.w3schools.com/ On Tue, Jun 11, 2013 at 4:03 PM, కిరణ్ కొత్తకోట wrote: > 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, >> >> ** ** >> >> Does any

Re: $$Excel-Macros$$

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

Re: $$Excel-Macros$$ Need formula

On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat wrote: > Dear Anoop, > > I need as i given table. > > regards, > Deepak rawat > > > On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma > wrote: >> >> Hi Deepak, >> >> PFA. You need to refresh the pivot on first sheet. >> >> Regards, >> Anoop >> Sr. Dev

Re: $$Excel-Macros$$ data update.

Hi Midhun Thampan., PFA SOLVED FILE. Regards Amresh On Thu, Jan 17, 2013 at 10:17 AM, Midhun Thampan 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 measurement. > > so i wante

Re: $$Excel-Macros$$ Getting Minimum no highlighted

;> >> U can use conditional format for each col in that u can use format only >> rows that contain lessthanequalto and in formula write =min(range) and >> format cell color to desire color. >> >> Regards, >> Gawli Anil >> >> >> >> On Wed, J

Re: $$Excel-Macros$$ Getting Minimum no highlighted

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)) = "=IF(RC[-1]=RC[-3],""Suresh"",IF(RC[-7]=RC[-1],""mukesh"",

Re: $$Excel-Macros$$ small query

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

$$Excel-Macros$$ Need invoicing Tool

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 tit

Re: $$Excel-Macros$$ need solutions

On Wed, Oct 31, 2012 at 1:22 PM, Satendra kumar wrote: > Hi, > > Find Attachment. > > > 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.c

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

PFA. On Fri, Oct 26, 2012 at 1:04 PM, Manoj Kumar wrote: > File allready attached... > > > On Fri, Oct 26, 2012 at 1:02 PM, Amresh Maurya > wrote: >> >> send me attachment. >> >> On Fri, Oct 26, 2012 at 1:01 PM, Manoj Kumar >> wrote: >> &g

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

send me attachment. On Fri, Oct 26, 2012 at 1:01 PM, Manoj Kumar wrote: > Anybody Please help me > > On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar wrote: >> >> Dear Expert, >> >> Please help me to get the currect ans with attached file.. >> >> >> Regard >> Manoj >> -- >> Join official facebo

Re: $$Excel-Macros$$ How to count the items except repetition

; > Regard > Manoj > > > On Wed, Sep 5, 2012 at 11:04 AM, Amresh Maurya > wrote: > >> Hi Pravin, >> >> find the attached solution. >> >> use this small formula. >> >> =COUNTA(C3:C39) >> >> Regards >> Amresh >

Re: $$Excel-Macros$$ How to count the items except repetition

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 wrote: > Dear Friends, > > Greetings ! > > Request for your help on the subject matter. > > I have attached the file for your reference, in which there

Re: $$Excel-Macros$$ Count when po is greater than zero

sorry previous was wrong attachment. consider this one. Regards Amresh On Tue, Sep 4, 2012 at 11:47 AM, Amresh Maurya wrote: > Hi, > > Find the attached solution. > > use below formula > =+COUNTIFS($B$2:$B$10,B2,$D$2:$D$10,">0") > > > > > On Tu

Re: $$Excel-Macros$$ Count when po is greater than zero

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 wrote: > > 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 column B is repea

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congrats Noorain you are hero of Group ...! Regards Amresh On Mon, Sep 3, 2012 at 5:25 PM, Venkat CV wrote: > Congrats Noorian... > > > > -- > *Best Regards,* > *Venkat * > *Chennai* > > > On Sun, Sep 2, 2012 at 10:32 AM, Ayush Jain wrote: > >> Dear members, >> >> Once again, Noorain Ansa

Re: $$Excel-Macros$$ Help needed in sum

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 wrote: > 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 PM, Rambabu

Re: $$Excel-Macros$$ Need Help

gards Amresh Maurya On Mon, Sep 3, 2012 at 4:50 PM, Kuldeep Singh wrote: > > 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 wrote: > >> Dear Kuldeep, >&g

Re: $$Excel-Macros$$ Need Help

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 wrote: > Dear Pravin, > > Please provide ans.. > > Regard > Manoj > > > On Mon, Sep 3, 2

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

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

Re: $$Excel-Macros$$ Sheet To WB

solutions* > > ** ** > > Success is never permanent, Failure is never final, so always do not stop > effort until your victory makes a history. > > *[image: > http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png] > **Pleas

Re: $$Excel-Macros$$ Sheet To WB

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 Application.Scre

Re: $$Excel-Macros$$ Unable to remove extra space

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 wrote: > Hi, > > COPY EXTRA

Re: $$Excel-Macros$$ Unable to remove extra space

Hi, COPY EXTRA SPACE AND REPLACE WITH BLANK. Regards Amresh On Thu, Aug 23, 2012 at 4:48 PM, Suman 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 > me. > -- > > > > >

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

gt;>> 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 >> > wrote: >>> >>>> Hi Amar, >>>> >>>> find the attached fil

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

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 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 search name then I sc

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

etween. > Thanks for help > > On Thu, Aug 16, 2012 at 12:52 PM, Amresh Maurya > wrote: > >> Hi , >> >> it works like sumif and sumifs.. >> >> we used it for find average value with criteria >> >> [image: Inline image 1] >> >> >>

Re: $$Excel-Macros$$ Excellent Track record in Training & placing Freshers as ORACLE DBAs/APPS DBAs

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 wrote: > Excellent Track record in Training & placing Freshers as ORACLE DBAs/APPS > DBAs, > Fresh batch starts fr

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

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 wrote: > Dear Kuldeep, > > It's too large size > > > On Thu, Aug 16, 2012 at 1:03 PM, Kuldeep

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

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 wrote: > > Hi Experts, > > What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more > example with Excel Sh

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

23, 2012 at 1:18 PM, Puttu * 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 > wrote: > >> Hi, >&

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

Hi, Kindly find the attached solutions. Regards Amresh On Mon, Jul 23, 2012 at 12:40 PM, Puttu * wrote: > Experts please help me on this code. > > On Sat, Jul 21, 2012 at 7:15 PM, Puttu * wrote: > >> Hi Experts, >> >> Please help on below macro need a macro to prefix on the below numbers. I >>

Re: $$Excel-Macros$$ Time Calculation in TAT Report : If greater than 5 hours

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 Amre

Re: $$Excel-Macros$$ Please help me.

Hi, use below formula =find(B1,A1) Regards Amresh On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 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+ members already

Re: $$Excel-Macros$$ Fwd: urgent required vba code:: 2 list boxes in userform scroll same time.

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 wrote: > Hi DS, > > Please s

Re: $$Excel-Macros$$ regarding problem on vlookup function

use this formula =VLOOKUP(E2,$A$1:$B$6,2,FALSE) Regards Amresh On Mon, Jul 2, 2012 at 4:43 PM, Amresh Maurya wrote: > Kindly fixed table array range. > > Regards > Amresh > > On Mon, Jul 2, 2012 at 4:41 PM, Sanjib Chatterjee > wrote: >> >> Dear Sir / Madam,

Re: $$Excel-Macros$$ regarding problem on vlookup function

Kindly fixed table array range. Regards Amresh On Mon, Jul 2, 2012 at 4:41 PM, Sanjib Chatterjee wrote: > > Dear Sir / Madam, > Whenever I need solution the people in the group always help me. Now I am > facing > another problem. > > Please see the attachment. I am facing the problem which is

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

Congrats. both of you dear. Regards Amresh On Mon, Jul 2, 2012 at 2:21 PM, setu wrote: > hey congratulations to both of you.great win...god bless u both > > > On Mon, Jul 2, 2012 at 2:12 PM, Abhishek Jain > wrote: >> >> Many congratulations to Ashish ji and Dilip ji. Well deserved. >> >> >>

Re: $$Excel-Macros$$ Date format

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 wrote: > Hi Experts, > > Suppose date is 06/04/2012 then i need a output like this (Month/Date/Y

Re: $$Excel-Macros$$ format cell

USE THIS. Shortcut Keys - ALT+D+E>NEXT>NEXT>TEXT>GENERAL then Cntl+1>custom>Type"\R00">OK. Regards Amresh On Wed, Apr 4, 2012 at 2:13 AM, Amresh Maurya wrote: > Hi Pawal, > > please find the attached solution. > > kindly use text to column.

Re: $$Excel-Macros$$ format cell

Hi Pawal, please find the attached solution. kindly use text to column.- ALT+D+E>NEXT>NEXT>TEXT>ENTER Regards Amresh On Wed, Apr 4, 2012 at 2:07 AM, pawel lupinski wrote: > Hi All, > Can you help me with cell format I need to format it in the way that > should change input "0204177" to "R

$$Excel-Macros$$ MACRO CODE REQUIRED

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 wit

Re: $$Excel-Macros$$ need a macro

exactly... thank you so much.. Regards Amresh On Mon, Mar 26, 2012 at 5:35 AM, BNS kumar wrote: > Hope this file serve your needs > > Regards > Kumar > > > On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya > wrote: > >> Hi Friends, >> >> We have 77

$$Excel-Macros$$ need a macro

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 Pleas

$$Excel-Macros$$ Opening for MIS Executive.

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

$$Excel-Macros$$ Need Application for Invoice Managment Tracker..

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 ti

$$Excel-Macros$$ Invoice Format in Access & excel

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

Re: $$Excel-Macros$$ Shortcut key for Border

*Hi, Pls use CTRL+SHIFT+& * Regards Amresh On Wed, Oct 12, 2011 at 12:19 AM, Ankit Agrawal wrote: > Dear All, > > I need shortcut key for all border.plz help me. > > Regards, > Ankit > > -- > > -- > Some important li

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Congratulation Noorain... Regards Amresh On Sat, Oct 1, 2011 at 12:13 PM, Ayush Jain 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 > expertise. He has be

Re: $$Excel-Macros$$ date format help

use this formula : =TEXT(C1,"dd-mmm-") On Thu, Sep 29, 2011 at 11:45 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear All members, > > please help me regarding date format in Excel. > > I want to put the value in excel as "dd/mm/", but like to get the value > as "dd-mm

Re: $$Excel-Macros$$ Audit Trail

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 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 values in S13 and S14. > >

Re: $$Excel-Macros$$ I need your help - Urgent

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 wrote: > Thank you so much.. > > perfect.. > > Regards > Amresh > > > On Thu, Sep 22, 2011

Re: $$Excel-Macros$$ I need your help - Urgent

croworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > On Thu, Sep 22, 2011 at 3:12 PM, Amresh Maurya > wrote: > >> Hi Noorain Ansari, >> >> Thanks for you response, >> >> It wil

Re: $$Excel-Macros$$ I need your help - Urgent

lmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > On Thu, Sep 22, 2011 at 11:10 AM, Amresh Maurya > wrote: > >> Hi All, >> >> Pls send me if you have any report fo

$$Excel-Macros$$ Fwd: Urgent Need ur Help!!

Examples are attached Also -- Forwarded message -- From: Amresh Maurya Date: Wed, Mar 17, 2010 at 4:20 PM Subject: Urgent Need ur Help!! To: excel-macros@googlegroups.com Hi Friends, can you help me on pivot table. we have multiples name in columns. i want no of unique count

$$Excel-Macros$$ Urgent Need ur Help!!

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