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
> particular cell.
>
> For exa
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
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
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
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
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
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
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
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
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
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.
>
>
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
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
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
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$$
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
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
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
@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(
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,
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.
>
>
>
>
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
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,
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
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
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
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
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
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
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
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(
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
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.
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
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
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
>
> -
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
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
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
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
>
> >
>
--~--~-~--~~~---~--~
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
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
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
43 matches
Mail list logo
