Thanks Sonia,
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/2/09, Sonia Singla wrote:
>
> Hi Dilip
>
> Its really great yar
> Sonia
>
> On Wed, Sep 30, 2009 at 5:15 PM, Dilip Pandey wrote
Hi Dilip
Its really great yar
Sonia
On Wed, Sep 30, 2009 at 5:15 PM, Dilip Pandey wrote:
> Hi Aligah,
>
> I have attached an image, which has the example of using auto-filter to
> solve your query. Thanks
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan
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
Hi Aligah,
The scenario mentioned by you is there in the attached workbook alongwith
the solution. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/16/09, Aligahk06 wrote:
>
> Dear All,
>
>
> I w
1) Sort the column which you want to filter (say column A)
2) Insert a column to the right of sorted column (Column B)
3) In the inserted column, enter this formula (Say in Row 2)
=A1=A2
4) drag the formula till the end of the table
5) Now use an autofilter and select all the cells having TRUE
Dude,
Go For Advanced Filter.
On Wed, Sep 16, 2009 at 12:51 PM, Aligahk06 wrote:
> Dear All,
>
> I want to fetch unique records through Formula or VBA.
> I have two records in two different column.I want to fetch Unique records
> from both the Column.
> E.g
>
> Col k10:k25 Col L10:L25
>