Hi jeff Wu
In excel every date has some number corresponding to it it. and it start
at the date "01-jan-1900" for this date the number is 1 and for the
date "02-jan-1900" the number is 2 and so on. so whenever we do any
calculation first the date is converted into its corresponding number and
Sir, Might contains data in second row that which might not contains in the
first row in duplicate.
Ragards,
Chaya
On Thu, Apr 4, 2013 at 10:06 AM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:
> What is the criteria to not delete duplicates.
>
>
> On Thursday, 4 April 2013 09:34:49 UTC
What is the criteria to not delete duplicates.
On Thursday, 4 April 2013 09:34:49 UTC+5:30, chaya moni wrote:
>
> Dear Lalit Sir,
>
>Thanks for the reply. i tried to explain a bit more in the attached
> file. please refer sir.
>
> Regards,
> Chaya
>
>
> On Thu, Apr 4, 2013 at 8:58 AM, La
Dear Lalit Sir,
Thanks for the reply. i tried to explain a bit more in the attached
file. please refer sir.
Regards,
Chaya
On Thu, Apr 4, 2013 at 8:58 AM, Lalit Mohan Pandey wrote:
> I am not able to understand your both conditions :(.
> First select all column then remove duplicate. (
I am not able to understand your both conditions :(.
First select all column then remove duplicate. (Only 29 duplicate value
found and removed.)
On Wednesday, 3 April 2013 18:37:15 UTC+5:30, chaya moni wrote:
>
> Dear Experts,
>
> I have another problem arise in excel while removing duplica
Hi,
To work on different sheets you don't always need array formulas. It is
possible that you need nested formulas for your work. e.g.
If you click on a cell containing formula and see something like:
{=SUM(A1:B100)}
This is an array formula. It is identified by the curly bracket in formula
"{ }".
It would help if you indent your code so that you can easily see when you BEGIN
a block of code like WITH and IF statements, then have a matching CLOSING
statemtent.
>From your code, I see that you end up with a couple of "End IF" statements
>that
don't have an "IF" statement that they are endi
Dear Ashish,
Thanks a lot for the same.
Macro is new for me ..it works but I am not able to understand it properly .
It is humbly request to you..if possible ..can you provide VBA code with
comment so I can practice on the same again and again
and it would be help me to understand easily .
Rega
try this
Sub sample()
Dim i As Long, j As Long, k As Long
For i = 2 To Sheets(1).Range("a65356").End(xlUp).Row
j = Sheets(2).Range("a65356").End(xlUp).Row + 1
k = Sheets(1).Range("xfd" & i).End(xlToLeft).Column
Sheets(2).Range(Sheets(2).Cells(j, 1), Sheets(2).Cell
there are 500 rows it takes 1 hour to do the same by transpose.
On Wed, Apr 3, 2013 at 6:03 PM, Anil B wrote:
> its simple dude paste as special and select transpose thats it.
>
> Thanks,
> Anil
>
>
>
>
> On Wed, Apr 3, 2013 at 5:52 PM, prafull jadhav
> wrote:
>
>> Dear All,
>>
>> I attached th
apply filter in colb -> choose blanks -> simply type formula in first
blank cell of col b like =A3 ->
and fill-down formula till required -> remove filter ->
then copy and paste special col b data
Regards
Ashish
On Wed, Apr 3, 2013 at 7:16 PM, Chris wrote:
>
> Morning!
>
> I'm often fa
Morning!
I'm often faced with the following problem (simplified here): I have data
in the following cells of a spreadsheet:
A1, B2, A3, B4, A5, B6
and would like to copy column A a paste it into B so that there are no
gaps, basically turning the two colums showing zigzag data into one. Of
Dear Experts,
I have another problem arise in excel while removing duplicate. i
have attached the sample and explained in the attachment. Please find the
attachment.
Thank you in advance
Regards,
Chaya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,
its simple dude paste as special and select transpose thats it.
Thanks,
Anil
On Wed, Apr 3, 2013 at 5:52 PM, prafull jadhav wrote:
> Dear All,
>
> I attached the sheet in which I require data vertically with company name.
>
> example data is attached .
> Regards,
> Prafull Jadhav.
>
> --
> Ar
Dear All,
I attached the sheet in which I require data vertically with company name.
example data is attached .
Regards,
Prafull Jadhav.
--
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.f
Thanks for the below link
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Lalit Mohan Pandey
Sent: 03 April 2013 05:58
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Macro-with example file
You can go through below links:
http://www.excel
Copy this code and run it and get the output. After getting expected result
please check what you were doing manually which is not giving you correct
output. and sorry for not sharing file with you. Hope you understand:
*Sub ApplyFormula()*
*
*
*With ThisWorkbook.Worksheets(1)*
*.Ran
yes sir me applied with CSE but ... if u have sheet pls mail me
On Wed, Apr 3, 2013 at 12:42 PM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:
> They all are array forumlas did you applied with Control + Shift + Enter.
> Please check. I applied all these formulas in your attached wor
They all are array forumlas did you applied with Control + Shift + Enter.
Please check. I applied all these formulas in your attached workbook and
its working.
On Wednesday, 3 April 2013 12:39:39 UTC+5:30, Dhaval Shah wrote:
>
> Lalit Sir
>
> didt work can u send me the sample file
>
> Thanks
Lalit Sir
didt work can u send me the sample file
Thanks
Dhaval Shah
079 - 40055253
On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:
> Hi Dhaval,
>
> Copy below formula at cell address C11 and confirm it with CSE
> *=MAX(($B$2:$B$68=$S$10)*($A$2:$A$68 = "
20 matches
Mail list logo
