select the range of your Numbers
for example: B2:B200
you can apply a conditional formatting on that range
the condition FORMULA is
=COUNTIF($B$2:$B$200;B2)>1
On Thu, Dec 23, 2010 at 2:04 AM, Superkermit wrote:
> I have a excel spreadsheet that has model numbers on the start of a
> column a
hi Guys,
have similar kinda que.
sometimes when we filter on large data and simply select those rows and delete
entire rows i.e. Alt+E+D+R
data which is present in those filtered rows also get deleted. what is the
reason behind this.
From: Ms-Exl-Learner .
I have a excel spreadsheet that has model numbers on the start of a
column and then a space and a description, what I need to do is be
able to have excel find all the duplicate model numbers and highlight
them, how should I go about doing this?
--
-
Excel 2003:-
You can see only 1000 records in the Autofilter Dropdown. Not more than
that.
Excel 2007/2010:-
You can see 1 records in the Autofilter Dropdown. Not more than that.
So try to use some helper column based on your data criteria use some
formula in helper column like Istext, Isnu
The Personal.xlsb "Project" is only an Excel workbook that is hidden.
So.. no, the VBA EDITOR cannot create a new workbook.
But you could write some VBA code that can create a new workbook and hide it.
If you want to copy Modules from one workbook to another,
there is vba code to export and impor
Is it possible that there are some blank rows?
Before turning "on" the autofilter,
select the top-left box where the A-Z column heading and row numbers meet.
(or hit ctrl-A)
then turn on AutoFilter.
By default, autofilter only selects the block of data until it reaches a blank
row.
hope this h
Hi Renuka,
In excel 2003 you can only see 1000 unique items in autofilter,however in
excel 2007 and 2010 you can view upto top 10001 unique items in Autofilter.
In your case, You should use simple sort or Pivot table to manage your large
data set.
I hope it helps.
Thanks.
Best Regards,
Ayush
hi
good evening to all experts
currentely i am trubling in large range data with filtaration
my company data having nearly 4lac of rows in one file
i need to sort that data using auto filter Option then it was not
showing all filterd data i don't know how to filter that large rang of
data
can u
i can copy and rename the personal.xlsb in explorer; when i do alt-
F11, both the personal.xlsb and the new renamed xlsb are listed in the
VBAProject Window with all modules intact. Is there a way within the
VBA editor to create a new VBAProject(NewName.xlsb)?
--
I believe you just need to set the locked object on your item (already
done in your sheet), and then put protection on the sheet. (Tools|
Protection|Protect Sheet)
On Dec 22, 7:08 am, Chandra Shekar
wrote:
> Hello,
>
> How to lock the object? User should not edit the object or delete the
> object
Hi Saggi,
Please see the attached solution which is now customized as per your need.
Thanks.
Best Regards,
DILIPandey
On Wed, Dec 22, 2010 at 3:52 PM, saggi wrote:
> Dear Noorani,
>
> Thanks for help, kindly go through my question, Its easy to retrieve
> Max value but i need Value againt the m
Dear Saggi,
Please see attachement as per your requirement,,
Thanks,
Noorain Ansari
-- Forwarded message --
From: saggi
Date: Wed, Dec 22, 2010 at 2:22 AM
Subject: Re: Fwd: $$Excel-Macros$$ Values Against Max Values
To: MS EXCEL AND VBA MACROS
Dear Noorani,
Thanks for help,
Hello,
How to lock the object? User should not edit the object or delete the
object.
Please find attached file.
Thanks
Chandra Shekar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tr
Hi Experts
Is it possible to use a macro in a workbook to another workbook when
that book having the macro is closed.If possible pls let me know how
to do it.
Regards
Rajesh Kainikkara
--
--
Some important links for
-- Forwarded message --
From: vidyut more
Date: Sun, Dec 19, 2010 at 10:46 AM
Subject: $$Excel-Macros$$ Excel userform & Vlookup List iteam help
To: excel-macros@googlegroups.com
Dear experts
I want use userform and in that a list iwant to use iteam from that
list.More i want to
Dear Noorani,
Thanks for help, kindly go through my question, Its easy to retrieve
Max value but i need Value againt the max value.
On Dec 22, 1:18 pm, NOORAIN ANSARI wrote:
> Dear VJ,
>
> Please see attachment.
>
> Thanks,
> Noorain Ansari
>
>
>
> -- Forwarded message --
> From:
Dear Joseph,
Can u send sample excel sheet..
--
Thanks & regards,
Noorain Ansari
-- Forwarded message --
From: Joseph
Date: Wed, Dec 22, 2010 at 12:21 AM
Subject: $$Excel-Macros$$ Critical Doubt
To: MS EXCEL AND VBA MACROS
Hi!
I am Having one query i hope i can free at th
Hello Friends,
Below is a snapshot of code I use to query any excel worksheet having
tabular data.
Do somebody have idea how to query excel file if i need distinct value from
a particular column or I want to use some type of query like updated?
***
Hi!
I am Having one query i hope i can free at the end of the session.
Please help me
we are educational industry maintaining student attendance i am
expecting report like this.
now a days we are maintaining student attendance in excel 2007 when
ever students comming in they are placed "X" mark
Dear VJ,
Please see attachment.
Thanks,
Noorain Ansari
-- Forwarded message --
From: Vj Realsaggi
Date: Tue, Dec 21, 2010 at 9:27 PM
Subject: $$Excel-Macros$$ Values Against Max Values
To: excel-macros@googlegroups.com
Kindly Consider the Previous Mail
--
---
20 matches
Mail list logo
