Re: $$Excel-Macros$$ Count If Cell Contains

Assuming data stored in Range A1:A100 Put this formula in B1, it will give the count of IRE in the given Range CountIf(A1:A100,"(IRE)") Use the same again with another criteria CountIf(A1:A100,"(xxx)") -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

Re: $$Excel-Macros$$ Re: Business Analyst Role

anks and Regards > Nasir Shaikh > On Tuesday, April 28, 2015 at 8:16:41 PM UTC+5:30, Pankaj Sangotra wrote: > >> Hello, >> >> There is walk-in in AON Hewitt on Saturday.. >> >> Please share your resume to puneet@aonhewitt.com and mention Refer >> By

$$Excel-Macros$$ Business Analyst Role

Hello, There is walk-in in AON Hewitt on Saturday.. Please share your resume to puneet.rawa...@aonhewitt.com and mention Refer By: Pankaj Sangotra Role: Business Analyst / Data Analyst Experience: 0 - 4 Expertise: Excel, VBA, Access, SQL Venue: Noida 127 Express Highway Thanks!! Pankaj

Re: $$Excel-Macros$$ Codes for SubPart

Please try this hope this will help.. Sub output() Dim i As Integer, k As Integer, j As Integer k = 1 For i = 1 To 5 For j = 97 To 100 Cells(k, 1).Value = i & Chr(j) k = k + 1 Next Next End Sub On Thu, Feb 13, 2014 at 12:52 PM, arvind sharma Rajendra < arveensharm...@gmai

Re: $$Excel-Macros$$ Comments

Please try the below code.. Hope this will help Shrinivas.. Sub showcomments() Application.ScreenUpdating = False Dim commrange As Range Dim mycell As Range Dim curwks As Worksheet Dim newwks As Worksheet Dim i As Long Set curwks = ActiveSheet On Error Resume Nex

Re: $$Excel-Macros$$ if then code in macro doesn't work

Sub DeliveryCost() Dim i As Integer Dim j As Integer Dim iEndrow As Long iEndrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To iEndrow If Cells(i, 14).Value < 25 Then Cells(i, 16).Value = 2 Else Cells(i, 16).Value = 5 End If Next End Sub On Fri, Nov 1

$$Excel-Macros$$ MIS Job in Ienegizar

Job Description * Should have good knowledge of Work force management * Prepare Weekly, Monthly reports on Excel sheets * Preparing MIS Reports using various Excel Formula Vlookup, Hlookup, Sorting and Pivot Table * Prepare data on MS Excel * 24/7 shifts *Good knowledge of Macros Walk in In

$$Excel-Macros$$ Type mismatch error found in Sumproduct

Hello team, Please find the attached and suggest as "I am having the TYPE MISMATCH error at sumproduct line... Thanks Pankaj Sangotra -- 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$$ Locking Particular Cells in Excel

Please follow the below link u will get the awesome detailed answer bro.. http://www.techonthenet.com/excel/cells/protect2007.php On Tue, Feb 19, 2013 at 11:21 AM, Prabhakar H wrote: > Can you explain me how did you do lock the cell. > > Rgds, > Prabhakar > > On Tue, Feb 19, 2013 at 10:13 AM,

Re: $$Excel-Macros$$ Formula for Loan amount

Hello Bro.. if u are using Excel 2007 it is bulid template named Loan Amortization.. To get this template : Go to Home page : New: Installed template and u will get what you are looking for .. Hope this is helpfull to U.. Enjoy ur day.. Thanks Pankaj Sangotra On Tue, Feb 19, 2013 at 6:09 AM

Re: $$Excel-Macros$$ Minimum Value of particular columns to be highlighted

Hello Amit, Please find the aatched solution, please let me know if it works fine for you.. Thanks Pankaj Sangotra On Wed, Feb 13, 2013 at 11:15 AM, Amit Gandhi wrote: > Hi Experts > > I want to highlight minimum value of some particular columns say columns > D,H,L in attached

$$Excel-Macros$$ Query: Charts

Hi Experts, I have mention the details in the tab itself, Please do the needful.. Thanks Pankaj Sangotra -- 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

Re: $$Excel-Macros$$ Need help

Hi Sriram, Vlookup is used to pick values from tables for lookup values... For more details use techonthenet.com.. This is an awesome website.. If face any challenge then let me know.. On Aug 31, 2012 12:22 PM, "sriram ji" wrote: > Dear Excel Guru, > > May I know how to vlookup 2003 Excel to 20

Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

Go to techonthenet website, it will surely help u out buddy On Jul 18, 2012 3:09 AM, "Indrajit $nai" wrote: > Hi All, > > Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND, MATCH, > OFFSET functions. > > Thanks in advance. > > -- > Indrajit > > Disclaimer: > This electronic mess