so do you want to remove duplicates ?
On Wednesday, 30 April 2014 11:27:23 UTC+5:30, pappu wrote:
>
> Dear Friends,
>
> Please find the attached file of excel, I have a doubt in that excel.
>
> I checked the excel there is no formula and VBA coding but it is showing
> duplicates.
>
> How to do
Share your workbook and some sample data.
Regards
Prince
On Tuesday, 5 March 2013 15:53:51 UTC+5:30, Bheema Shankar wrote:
>
> Dear friends
>
> I placed my data in worksheet1 of workbook1 pertaining to the employees
> of an organisation by giving a unique ID no.in Column A.
>
> I placed a textbo
To: excel-macros@googlegroups.com; dilipan...@gmail.com
Subject: $$Excel-Macros$$ Re: Doubt
Thank you Dilip,
My question is
1) When we want a new sheet we use Shift+F11 ,
Shift+F11 can be used to create one new sheet at a time, what would be the
command to create more than 2 or more t
Thank you Dilip,
My question is
1) When we want a new sheet we use Shift+F11 ,
Shift+F11 can be used to create one new sheet at a time, what would be the
command to create more than 2 or more than 2 new sheets a time ?
Thank you
Sumanth.
On Wed, Sep 30, 2009 at 9:02 PM, Dilip Pandey wrote:
>
Hi Ramesh,
You need to freeze the data range and them move down.
=countif($a$2:$a$10,"M").
Use F4 key in formula to freeze (Lock) the cell references.
Thanks,
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
*Hi Ramesh,*
Solved workbook is attached with this email. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Jun 11, 2009 at 5:19 PM, Ramesh Katta wrote:
> Hi Dear members,
>
> I have a doubt on
Hi Amithab,
Thank you very much.
Regards
Ramesh
On Thu, Jun 11, 2009 at 7:09 AM, Amitabh Bose wrote:
>
> Hi Ramesh,
>
> Please find the file attached with the vlookup formula.
>
> The basic formula is:
> =VLOOKUP($A3,Sheet1!$B$4:$F$18,4,0)
>
> The ISNA formula is to replace any blank cells whic
Hi Ramesh,
Please find the file attached with the vlookup formula.
The basic formula is:
=VLOOKUP($A3,Sheet1!$B$4:$F$18,4,0)
The ISNA formula is to replace any blank cells which come up with NA# with
'blank' cells.
Hope this helps.
Regards,
Amitabh
> Date: Thu, 1
Hi,
Keep the range fixed, countif($a$2:$a$10,"M") should work with M or F.
Sri
On Sun, Jun 7, 2009 at 5:24 PM, Ramesh Katta wrote:
> Dear Members,
>
> My question seems to be very simple, please don't laugh at me.
>
> I have 2 columns that are A1 contains Names and B1 contains Sex of
> employe
dear ramesh,this is because u are dragging the cell downward for using same
formula...
if u want to drag the cell downwards without changing the data range pls
make use of "$" sign eg- =COUNTIF(B$2:B$11,"F")
hope ur doubt is clear..
MANOJ N KARATE.
Sub Engineer (Roads) W.S.
Municipal Corporation of
Hi Ramesh,
Please checkout the file attached with sollution.
Vinayak Hegde
From: Ramesh Katta
To: excel-macros@googlegroups.com
Sent: Sunday, 7 June, 2009 5:24:38 PM
Subject: $$Excel-Macros$$ Doubt on data range
Dear Members,
My question seems to be very s
Hi, Narendra,
Thank you very much for helping on time.
Regards
Ramesh
On Sun, Jun 7, 2009 at 8:13 PM, CA NARENDRA
ASHARA wrote:
> Dear Ramesh,
>
> You need to freeze the range by F4. Please find the solution in the attached
> sheet.
>
> Thanks & Regards,
> Narendra
>
> -Original Message
Hi Ramesh,
The formulas should be:
=countif($a$2:$a$10,"M")
=countif($a$2:$a$10,"F")
Then you can paste them anwhere on the sheet and get the same answer.
Without the $ signs, the range reference will change depending on where you
paste the formula.
Regards - Dave.
> Dear Membe
Dear Ramesh,
You need to freeze the range by F4. Please find the solution in the attached
sheet.
Thanks & Regards,
Narendra
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ramesh Katta
Sent: 07 June, 2009 5:25 PM
To: excel-macros
Thx every1...
there are few things in life wch i hav done rght.. joining thz group iz 1
of the few things
hehehe
Thanks..
Raafi
On Tue, Mar 31, 2009 at 6:14 AM, Aindril De wrote:
> Hi Raafi,
>
> Please refer to the following link for the explaination:
> http://www.techonthenet.com/excel/q
Hi Dear,
This dollar sign indicate the reference.
for example
A$2 - indicate's Column A with increment with 2,3,4,5 ...n
$A2- - indicate's Column A with increment with 2,3,4,5 ...n
$A$2 - will fixed the value of a2 cells.
Thanks & Regards,
Anil Kumar.
On 3/31/09, raafi barey wrote:
>
> Hi..
When you drag a formula in excel, it changes refferences ( dragging down
changes row refference, the numeric part and dragging horizontally along row
changes column refference). $ is meant for not changing the refference, when
it is put with row indicator, like A$1, it will not change row 1 while
d
Hi Raafi,
Please refer to the following link for the explaination:
http://www.techonthenet.com/excel/questions/referencing.php
Hope it helps.
Regards,
Andy
On Tue, Mar 31, 2009 at 4:38 AM, raafi barey wrote:
> Hi..
> I am back again with another doubt..
> what is the difference between
> A$2
18 matches
Mail list logo
