$$Excel-Macros$$ To seek help on displaying the first column and a given active column

heet, the given excel sheet displays all the hidden & unhidden columns Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ Need VBA Macro that would align all the paragraphs of word document in one go

peat steps 2) and 3) Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 -- 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

$$Excel-Macros$$ Excel query using Excel Function

performed this using a formula. But it is of nature of circular reference. Can I have improvised version of the excel formula to take care of this ? Let me know if my query is clear for understanding. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valua

$$Excel-Macros$$ Creating Repetitive Dynamic Graph in multiple worksheet using VBA

Hi Please note that I have 3 worksheets in a workbook with the same number of columns and would like to create dynamic graph in each worksheet at the same time. Column X along X-axis and Column Y and MeanY along Y-axis The Data excel is enclosed. Thanks & regards, *Sandeep Kumar Baranwal*

Re: $$Excel-Macros$$ Required break chart in excel

under Axis option category. You will get a break chart in excel. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 On Sat, Jun 10, 2017 at 9:46 AM, amar takale wrote: > any ideas friends

Re: $$Excel-Macros$$ GOAL SEEK

: Simplex LP Click : Solve Hope you get the answer. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 On Wed, Jun 7, 2017 at 7:44 AM, GENIUS wrote: > OH THAT'S REALLY GREAT, W

Re: $$Excel-Macros$$ GOAL SEEK

Variable Non-Negative Select a Solving Method : Simplex LP Click : Solve Hope you get the answer. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 On Tue, Jun 6, 2017 at 11:15 AM, Sandeep K

Re: $$Excel-Macros$$ GOAL SEEK

. . . . $I$13=$A$13 $I$14=$A$14 $I$15=$A$15 Check (Tick Mark) - Make Unconstrained Variable Non-Negative Select a Solving Method : Simplex LP Click : Solve Hope you get the answer. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitt

Re: $$Excel-Macros$$ GOAL SEEK

, as required. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 On Sat, May 13, 2017 at 11:34 AM, Izhar wrote: > look at the attachment when we click on GOAL SEEK tab, place in the sheet, &

Re: $$Excel-Macros$$ why excel is slow when we run macro

take time. The excel seems to be working slow. Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 On Sun, Jun 4, 2017 at 3:59 PM, wrote: > why excel is slow when we run macros > >

Fwd: $$Excel-Macros$$ To seek help on writing Excel formula

Hi Thanks for the concern. Please find the details in spreadsheet attached. Please note that the match operation need to be performed basis the variable "dataset" in "Sheet1" and Variable_sheet2 in "Sheet1" should be populated using "Sheet2". Thanks

Re: $$Excel-Macros$$ To seek help on writing Excel formula

Hi Kindly note that the match operation is to be performed basis the variable "dataset" in "Sheet1" and Variable_sheet2 in "Sheet1" should be populated using "Sheet2". Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation an

$$Excel-Macros$$ To seek help on writing Excel formula

FirstNameLastName Variable_sheet2 abc_xyz abc xyz rpm_xyz rpm_xyz rpm xyz abc_xyz Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-858880

$$Excel-Macros$$ Defining Name Ranges in Excel for different selection region using VBA/Macro

is to be defined for selection $D$1:$E$10 Another name range is to be defined for selection $G$1:$H$10 And so on Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 -- Are you =EXP(E:RT) or

$$Excel-Macros$$ sandeep kumar MIS Executive ,

Dear SIr i am sandeep kumar current job post -MIS Executive , I want change New Job MIS Executive Delhi NCR I Request all group send job My email id sksandeepkumar...@gmail.com MIS executive ,Skill Ms excel ,SQL ,Ms Access sandeep kumar 9250059702 -- Are you =EXP(E:RT) or =NOT(EXP

$$Excel-Macros$$ Need VBA code to convert multi-pages PDF file into multiple sheets Excel Spreadsheet

Hi Could anyone help me with the VBA code to convert multi-pages PDF file to multiple sheets Excel spreadsheet ? Thanks & regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Need VBA code that will compute number of "Yes" against each question in the given Questionaire

based on 1000 excel sheets with response. Hope, I am making sense. Please help. Thanks & regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A

$$Excel-Macros$$ Break Internal Links with in a Workbook-Excel

Dear Excel Gurus, I have a workbook with multiple Tabs which are interlinked. I want to break all the link at once. Is it possible with any shortcut / key stroke or Tricks ? Please help me out. Thanks in advance. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBer

Re: $$Excel-Macros$$ Compare two worksheet Trial Balance

Dear Excel gurus, Kindly check the trailing mail. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message- From: "Sandeep Kumar Chhajer" Sender: excel-macros@googlegroups.com Date: Sat, 5 Apr 2014 04:21:56 To: Exce

$$Excel-Macros$$ Compare two worksheet Trial Balance

file with you all. I hope you all understand) If any one can help me out to automate the report I will be highly grateful. Thanks in advance. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A

Re: $$Excel-Macros$$ Average Graph

Hi Praful, This happens everyday in stock market!! I think you should use moving average let's say average of every 5 days and plot everyday's moving average into graph! Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Or

Re: $$Excel-Macros$$ calculate previous month dates using the given date

Can you give another example so that the logic get clear! Like what do you want if given date is 25th December 2013. 24th November to 23rd December? Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message- From: Sundarvel

$$Excel-Macros$$ C002AB8CF

Those who are using BBM Channel check out this channel. Channel Pin C002AB8CF. :) Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -- 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

Re: $$Excel-Macros$$ material Stock Inventory in Excel

Rupesh, Please use new thread for new queries, don't send new queries on others thread. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Rupesh Patil Sender: excel-macros@googlegroups.com Date: Fri, 20 Dec 2

Re: $$Excel-Macros$$ material Stock Inventory in Excel

Hi Jockey, Please specify your requirement. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Jocky Beta Sender: excel-macros@googlegroups.com Date: Fri, 20 Dec 2013 12:49:38 To: Reply-To: excel-macros@googlegroups

Re: $$Excel-Macros$$ MS Excel

I possible please share a sample file. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: "Soni.Rajender" Sender: excel-macros@googlegroups.com Date: Tue, 10 Dec 2013 23:25:40 To: Reply-To: excel-macros@go

$$Excel-Macros$$ Power Pivot

Dear All, I have excel 2013, I want to know what enhanced feature it has from 2010 and I also want to know about power pivot and its uses. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

Hi Basole I am glad you understood my requirement. Kindly share the models that use excel to ms access with tables and indexes at your convenience. Looking forward to your generous help once again. Thanks & regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology & W

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

difference between recordset and querry tables? > > > > > > > Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar > Baranwal escreveu: >> >> Hi >> >> Kindly note that sql.request is functional in MS Excel 2007 but not in MS >> Excel 2010. Could

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

the same requirement for importing data from MS Access to MS Excel using querytables ? The version that you helped me with, uses recordset. I want to use querytables instead. Thanks & regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology & Wholesale Basel,Genpact Gurga

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

erial that would enhance my ability to optimize my skills at VBA excel ? It would be really great of you if you allow me to grow with VBA excel under your guidance. Thanks & regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon I

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

ta from MS Access. The problem now faced , is related to cx.connectar. Could you resolve this ? Thanks & regards, *Sandeep Kumar Baranwal* Assistant Manager Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Fri, Jul 19, 2013 at 8:17 PM, Basole wr

Re: $$Excel-Macros$$ Pivot Table queries

other being count, now I want to work with this two column i.e. Sum column / count column with in pivot table, Is it possible? Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Anoop K Sharma Sender: excel-ma

$$Excel-Macros$$ Pivot Table queries

Hi, Excel gurus, I want to get a column in a pivot table which is comprising of division of two data-source column. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =

$$Excel-Macros$$ Re: Recognizing Number format

End If Loop Until ActiveCell.Offset(0, -4).Value = "" End Sub Thanks in advance. Thank you Regards Sandeep Kumar Chhajer. -- 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

Re: $$Excel-Macros$$ Identifying Excel number format

, ashish koul wrote: > i can't see custom format > > > On Sat, Oct 5, 2013 at 12:59 PM, Sandeep Kumar Chhajer < > chhajersand...@gmail.com> wrote: > >> ** >> Dear Ashish, >> >> This is only original file, I have just cut down the number of entri

Re: $$Excel-Macros$$ Identifying Excel number format

0, 1).Select > ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1 > ActiveCell.Offset(0, -1).Select > End If > Loop Until ActiveCell.Offset(0, -4).Value = "" > End Sub > * > * > Please Help me out. > > Thanks in advance. > > > -- > Regards, > S

Re: $$Excel-Macros$$ EX-QUERY

Dear sridhar, I did not get you how leap year or non leap year affecting your result. Can you send us example. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: sridher sharma Sender: excel-macros@googlegroups.com Date: Mon, 9 Sep 2013 16:22:16 To: Reply

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

from the dropdown box in MS Excel, I have data (23,34,45) imported from MS access to MS Excel. Similarly if I choose 2 from dropdown box , I have (67,34) imported from MS Access to MS Excel. Thanks & regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology & Wholesale B

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

sheet. Thanks & regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Thu, Jul 18, 2013 at 9:08 AM, Sandeep Kumar Baranwal < sandeepkumarbaran...@gmail.com> wrote: > Hi > > I am

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

Hi I am not able to access the ImportAccess.zip folder that you have send across. Please look into the issue. Thanks & regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 On Wed, Jul 17, 2013 at 8:59 PM

$$Excel-Macros$$ To know about the substitute of SQL.REQUEST

version 2007 Thanks & regards, *Sandeep Kumar Baranwal* Business Analyst Credit Risk Methodology & Wholesale Basel,Genpact Gurgaon India Mob:-+91-8588802543 -- 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

Re: $$Excel-Macros$$ drawing chart based on the given data

nd 2) year (along x-axis) versus salary (along y-axis (secondary axis)) and the chart must incorporate every new set of values that are appended below the given list in sheet 1 of the attached excel sheet. *Sandeep Kumar Baranwal* Credit Risk Methodology & Wholesale Basel Gurgaon Mob:-0858880254

Re: $$Excel-Macros$$ drawing chart based on the given data

Hi Sir Thanks for introducing me the use of dynamic range assignment. thanks a lot for you help. can there be VBA code as an alternative to using dynamic range for drawing the chart? If yes, will you please introduce me to that as well? *Sandeep Kumar Baranwal* Credit Risk Methodology

Re: $$Excel-Macros$$ drawing chart based on the given data

Respected Rajan Sir I am not able to locate the related VBA code in the attached excel sheet. Will you please provide the VBA code. *Sandeep Kumar Baranwal* Credit Risk Methodology & Wholesale Basel Gurgaon Mob:-08588802543 On Fri, Jul 6, 2012 at 9:02 PM, Rajan_Verma w

Re: $$Excel-Macros$$ drawing chart based on the given data

every new set of values that are appended below the given list in sheet 1 of the attached excel sheet. *Sandeep Kumar Baranwal* Credit Risk Methodology & Wholesale Basel Gurgaon Mob:-08588802543 On Fri, Jul 6, 2012 at 6:23 PM, Rajan_Verma wrote: > Use this: > > ** ** >

Re: $$Excel-Macros$$ Excel VBA Book?

or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr.

Re: $$Excel-Macros$$ Macro to sort data in Ascending/Descending order

Hi Sandip, Please find the attached file. Feel free to ask further for any query. Regards Sandeep Kumar On Wed, Jan 26, 2011 at 10:41 PM, San Pat wrote: > Hi Ashish, > > Thanks for your help. > > Is there any way I can make it cell specific, assign this macro to > partic

Re: $$Excel-Macros$$ Cell Reference ( automatic Updation on Date Change)

Hi you can use the date function with offsset function in your reference formula for this. For exact formula tell me what's your current cell address having reference and whats the reference. On 23-Jan-2011 2:01 PM, "kush sharma" wrote: > Dear All, > > I have a query in which i need your help. Le

Re: $$Excel-Macros$$ Re: User Defined Function not updating

Hi Please add this line to your function. Adding on the first line will be good. Application.Volatile This will cause recalculation of the function when any value change in the sheet. (So directly affect the speed if you use function on many cell) Thanks & Regards Sandeep On Fri, Aug 20, 2010 a

$$Excel-Macros$$ Fwd: Urgent Requirement: Excel VBA with Mini Tab

Hi, Reply to Mr. Lalit Sharma (lalit.sha...@xentaqsys.com) for all information. Will be better if you send your resume. Thanks & Regards Sandeep -- Forwarded message -- From: Lalit Sharma Date: Mon, Aug 16, 2010 at 11:41 AM Subject: Urgent Requirement: Excel VBA with Mini Tab T

Re: $$Excel-Macros$$ Need list style from data

n the second macro it doesn't work.  I don't know how to > debug it. > Thanks. > Nadine > ________ > From: Sandeep Kumar Maurya > To: excel-macros@googlegroups.com > Sent: Sun, July 25, 2010 10:48:42 AM > Subject: Re: $$Exc

Re: $$Excel-Macros$$ Macro to clean up file

Hi, I got your file but next time use gmail and attach in the mail. Thanks & Regards Sandeep On Sun, Jul 25, 2010 at 1:02 AM, JD <5635.daw...@gmail.com> wrote: > How do I attach? I placed in file section of > MS EXCEL AND VBA MACROS. > > > On Jul 24, 5:35 am, Sand

Re: $$Excel-Macros$$ Macro to clean up file

Hi JD, You forgot to attach file. Thanks & Regards Sandeep On Sat, Jul 24, 2010 at 5:52 AM, JD <5635.daw...@gmail.com> wrote: > I am looking to clean up a file that gets sent to me weekly see > "example file.xlsx" on file page. The file may look like the first tab > the 1st week it is sent to me

Re: $$Excel-Macros$$ Auto Calculate Number to Percent

Hi Dave, Please send the VBA solution for me. I can't get a logic which can solve this problem without saving "Hour Worked" values. The problem part with me is when a new value added to data it will not show the correct percentage value. The cause I already mentioned in previous reply. If MNM nee

Re: $$Excel-Macros$$ Auto Calculate Number to Percent

Hi, If I say clearly then this is not possible to change the "Hour Worked" value in percentage in the same column. The reason is that when a value is changed to percent what will converted to a fraction. Date User Hours Worked Hours Worked % 16-Jul ABC8

Re: $$Excel-Macros$$ how do you identify the first space within a series of words within a a text

Hi Edgar, Function you are applying is correct. So please attached your file so that problem can be solved. Thanks & Regards Sandeep On Thu, Jul 22, 2010 at 3:18 AM, Edgar wrote: > I'm trying to clean up some data. I've used SEARCH and FIND to try to > identify the first space within a cell, bu

Re: $$Excel-Macros$$ Re: [Fwd: Help for format converson required]

Hi, A good solution Dilip Ji. Please see the attached file with just a little modification. Thanks & Regards Sandeep On Tue, Jul 20, 2010 at 4:00 PM, Dilip Pandey wrote: > Hi Pradeep, > > Look out for green shaded cell in the attached spreadsheet, in which I have > done something for you. > >

Re: $$Excel-Macros$$ Data Logic

Hi Al, Please find the attached file for your required solution. Regards Sandeep On Thu, Jul 15, 2010 at 5:46 AM, Al wrote: > > Dear All: > > > This is the sample spread sheet i have. > >  pat meds stdt spdt >  111 ABC 1 . >  111 CDE 130 150 >  111 NNN 132 140 >  111 GHI 160 170 >  111 LMN 165

Re: $$Excel-Macros$$ Finding a cell based on multiple criteria typed into cells

Hi David, Please find the solution you required. Feel free to ask anything from me. Regards Sandeep On Wed, Jul 14, 2010 at 3:11 PM, Sach1810 wrote: > Hi, I have a table of data giving different prices of different items. > Below is a sample of that data. I want to be able to type in teh > crit

Re: $$Excel-Macros$$ Index match with 3 criteria

Hi, Yes I can, but need a sample file for proper result you want. Regards Sandeep On Thu, Jul 15, 2010 at 2:09 AM, Nadine S wrote: > I need to lookup a value based on matching 3 other columns.  I do not want > to use a concatenation and then look up that. > > I have Sheet1 that has 4 columns in

Re: $$Excel-Macros$$

Hi, Please find the attached file for your required solution. Regards Sandeep On Tue, Jul 6, 2010 at 4:28 PM, Ankit Chandna wrote: > Dear, > > Can u plz tell me exact procedure.i do hv ASAP utilities. > > --- On *Tue, 6/7/10, Mahesh * wrote: > > > From: Mahesh > Subject: Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ How to display cell contects as password *****

Hi, You can use an alternate way to over come this. change the text color of cell to same as background then lock and hide it. After this protect the sheet. Thanks and Regards Sandeep. On Tue, Jun 15, 2010 at 10:45 AM, Rajesh Bedse wrote: > thx Vikas. > > The issue with this formatting is tha

Re: $$Excel-Macros$$ IF AND formulas

Hi Mike, It will be better if you send a sample file with some data and your query. As it may give you a shorter and simple formula for your task. And about this formula, one can only show you the syntax error and that not guaranteed for formula to give desired result. So if you can than attach

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

Hi Anand, You are right, that Asish solution is perfect, but if you don't want to use VBA you can use this one. =RIGHT(A1,LEN(A1)-FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","") Don't see its size, because it is smallest possible using formula. And I assume that your text d

Re: $$Excel-Macros$$ Maximum Date

@Dilip Ji You are always Welcome sir. Thanks Sandeep On Mon, May 10, 2010 at 7:54 PM, Dilip Pandey wrote: > Thanks Sandy, > > @ Dheeraj, I think you have got the answer for your query. > > Get back, in case of any other queries. > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY >  MBA-HR,B.Com(

Re: $$Excel-Macros$$ vlookup with 2 criteria

Hi nino, check my reply in the $$Excel-Macros$$ Maximum Date problem. Thanks & Regards Sandeep On Sun, May 9, 2010 at 1:12 PM, Ravi Megharaj wrote: > > You can concatenate Column A and Column B to get the unique value. Then do a > vlookup to get the exact value. Once performing this operation,

Re: $$Excel-Macros$$ Maximum Date

Hi Dheeraj, Check the attached file, I think it will satisfy you. Both are array formula, so you have to press CTRL+SHIFT+ENTER. Thanks & Regards Sandeep On Mon, May 10, 2010 at 3:32 PM, Dheeraj Bankoti wrote: > > Thanks to Dilip, > I have one more query & attachment is find herewith. > > > >

Re: $$Excel-Macros$$ TOUGH QUESTION

Hi, It is possible AZHAR. What you have to do is 1. Mail merge all the links in word document. 2. Then use macro in MS Word to insert picture for all the links which have a image extension, like jpg, bmp etc. How you will do this. Apply the straight method of learning VBA. 1. Record a macro fo

Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)

t; friend > > > > > > > > On Fri, May 7, 2010 at 11:54 AM, Sandeep Kumar Maurya < > sandymau...@gmail.com> wrote: > >> Select the function and press tab. >> >> Thanks & Regards >> Sandeep >> >> >> On Thu, May 6,

Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)

Select the function and press tab. Thanks & Regards Sandeep On Thu, May 6, 2010 at 11:38 PM, Michael wrote: > I posted a picture of what I'm trying to discover: > > > http://excel-macros.googlegroups.com/web/5-6-2010%2010-30-03%20AM.png?gsc=KEUGpSMAAABiUNuXkcp8v73inTrP5WRB6rVQQoo7NfTRwCUKHBmr86

Re: $$Excel-Macros$$ Urgent need some about how can calculate week

May be you want this. Find the attached file. Regards Sandeep -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Gro

Re: $$Excel-Macros$$ Who to remove hyperlinks

Hi, write 1 in a blank cell and then copy it and use multiply option in 'paste special'. It also put 0 in blank selected cells. Regards Sandeep On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram <06n...@gmail.com> wrote: > Hi Members, > > i have huge data with hyperlinks. > Is there any shortcut key or

Re: $$Excel-Macros$$ Excel Formula Required

Simplest possible. But needed unique list (no duplication). Regards Sandeep On Thu, Mar 18, 2010 at 8:37 PM, Dilip Pandey wrote: > Dear Venkatesan, > > Attached file has two solutions for your query. > Let me know in case of any challenge(s). > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY

Re: $$Excel-Macros$$ Require help on a condition

Hi, Find the attached sheet with formula. Regards Sandeep On Fri, Nov 20, 2009 at 10:35 AM, Sivakumar E.S wrote: > pooja Sharma > > Find attached an excel file with vba macro. place ur cursor anywhere in > reference column and run macro... u will see result in next sheet Hope > this helps

Re: $$Excel-Macros$$ How to sum on the basis of color

Hi, You can filter on the basis of color in excel 2007. And with that you can use subtotal(9,Range) for your data. Subtotal don't sum those value which are hidden. Thus you can get sum on the basis of color in excel 2007 using filter and subtotal. But if you want to see both value at time then

Re: $$Excel-Macros$$ Plz Urguntly Help needfull

Hi Anil, >From Insert menu goto Define Names (As you do for named ranges) then give the Each name (Anil) the value you want. Then A B 1Anil =indirect(A1) 2Saxena =Indirect(A2) Regards Sandeep On Thu, Nov 1

Re: $$Excel-Macros$$ Flagging duplicate values with Countif and Search functions re partial matches

Check the file. On Sun, Nov 15, 2009 at 6:39 PM, Dilip Pandey wrote: > Dear Dan, > > I have tried to build up the data as mentioned by you and able to get the > desired result. > Same spreadsheet is attached herewith for your review. > > Best Regards, > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(

Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup

Hi Anish, See the attached file. Don't change position of 'Auto Reset', 'Counter' and 'Auto Switch' else it may not work properly. Also it can be done easily with VBA, so if you need then ask the solution in VBA and you will get a quick response from the group. Regards Sandeep On Fri, Nov 13, 2

$$Excel-Macros$$ Re: Excel macro-Help

Hi, I update the macro as per your use and assign a shortcut too. There are some guidelines follow them to use desired result. Regards Sandeep On Tue, Oct 6, 2009 at 11:35 PM, Umesh Matkar wrote: > > > Dear Friends, > I have one query regarding macro. > i want to record a macro for goal seek.

$$Excel-Macros$$ Re: excel + vba + html

Hi, There are many free online spreadsheet solution, you should give try to one of them (Personally I never use them because I never need and online excel file). Follow this link and you will get many online spreadsheet solution and choose as per your need. http://mashable.com/2008/02/06/forget-e

$$Excel-Macros$$ Re: Looking for most effecient way to convert lots of data

Hi, First you have to retrieve unique phone numbers I have given the steps in attached file then use the formula as shown in the file. Regards Sandeep On Wed, Oct 7, 2009 at 6:41 AM, bruce wrote: > > I am creating a program that does daily QA of our products. I work for > a phone company and w

$$Excel-Macros$$ Re: DATA>IMPORT >XML Missing in excel 2003 standard edition

Hi, Don't your Excel 2003 has Data->XML->Import. Check Again. Regards Sandeep On Tue, Oct 6, 2009 at 5:57 PM, Manoj Kukrej wrote: > Hi, > > I want to know how I can add xml in it > > I have checked in tools > commands>xml is also missing > > Regards > > > > Manoj > > -

$$Excel-Macros$$ Re: Best Way to Mimic Relational Data?

Hi, I used vlookup( ) for this. See the attached solution. Regards Sandeep On Wed, Oct 7, 2009 at 2:34 AM, HumanJHawkins wrote: > > I have a list of 15000 rows of response data about questions that > showed up on a series of tests. There is often more than one row for > each test question, beca

$$Excel-Macros$$ Re: Unique record retrieval

Hi, If you want to retrieve a unique row then select all data go to 'Advance filter' and check 'unique records only'. Choose 'Filter the list, In place' if you want to just filter the data and choose 'Copy to another location' if you want to copy the filter list to another place, (select any blank

$$Excel-Macros$$ Re: help plz

Hello Ashish, Do you have your data ready or you want to enter the data then a new row below it. Means your data already have "parent co" in column B are you going to enter it in column B. Regards Sandeep On Wed, Sep 23, 2009 at 10:29 AM, ashish koul wrote: > inserting a blank row with matchi

$$Excel-Macros$$ Re: Need urgent help on finding formula

Hi VR, Find the attached solution. Regards Sandeep On Tue, Sep 22, 2009 at 8:05 PM, vinod rao wrote: > HI Team, > need a foumula to find the latest Date and in next column the Status > Plz find attached.file. > > Thanks in advance. > VR > > > > --~--~-~--~~~---~--~

$$Excel-Macros$$ Re: Fwd: Name Matching In Excel

Hi Sonal, I take a look on your data and find that your data in file1 and file2 are not same as there are some short names and no middle name in one of the file but the other one has full name and short middle name. It can be done with VBA but if your data is not unique then there is no guarantee

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

I will try to solve this problem sorry i m late i m not a regular user thats why i cann't rply soon bye have a nice day --~--~-~--~~~---~--~~ -- Some important links for excel users: 1.

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

Dear this file have opened in my system and office version 2003 if u want to open 2007 version plese try open as 2003 in 2007 version ok my no. +919466848388 Sandeep Mathur --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Need help on formula

Hi Vinod, Did you find my solution or not? This is my seventh mail. Regards Sandeep On Wed, Aug 26, 2009 at 9:50 AM, Prashant Bhawar wrote: > > > On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wrote: > >> Hello Team, >> >> How do i rank only positive numbers. Plz help me on formula. >> >> Example

$$Excel-Macros$$ Re: Separate Fields in fastest way

Hi, find the attach solution for your problem. Sandeep On Wed, Jul 8, 2009 at 10:50 AM, Deepak Rawat wrote: > Dear friends > have attached a file in which all fields are merged and have > to separate all fields as soon as possible. > pl suggest me the way. > > there is another problem, i want to

$$Excel-Macros$$ Re: How to convert xlam into xla

I think you need to have Office 2003 for this to happen and u have File converters for office 2003 to run the 2007 file.. Hope this will help you   Sandeep Kumar M http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/33.gif";> 9448452385 Bangalore... Experience is the hardest