Dear Group ,
If you want to get quick and fast answers from excel experts in this group,
Please follow the below guidelines.
*Ensure your question is not too vague.* Don't assume anyone is familiar
with your problem. While you can upload small attachments, describe your
problem in the body of
Hi John,
It will work in version 2003 if you refer the cell reference to part of the
column range instead of referring it to the whole column.
=LOOKUP(2,FIND(A1,Sheet2!A1:A65535),Sheet2!B1:B65535)
See the attached file for detail.
---
Ms.Exl.Learner
---
Dave,
I opened it in Excel 2007 and it worked fine. One question please; in
=LOOKUP(2,FIND(A1,Sheet2!A:A),Sheet2!B:B) , What exactly does the "2" do?
Thank you for your excel help.
John
On Sat, Jan 15, 2011 at 2:16 AM, Dave Bonallack
wrote:
> Hi John,
> I opened your file, but don't get a #N
Range("a:a").RemoveDuplicates 1, xlNo
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Saturday, January 15, 2011 6:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Unique records
check the attachement see if it h
check the attachement see if it helps
On Sat, Jan 15, 2011 at 7:14 PM, Umesh Dev wrote:
> Hi All,
>
> Can anyone help me with the code in *VBA *to find unique values and
> pasting it separately in Excel.
>
>
> Regards
> Umesh Dev
>
> --
>
> --
Here's a harder question: Why didn't I think of that? Thanks so much!
On Jan 14, 10:57 pm, ashish koul wrote:
> ActiveCell.Row
> ActiveCell.Column
>
>
>
> On Fri, Jan 14, 2011 at 10:34 PM, Barry N wrote:
> > I used to know this but I can't remember how to identify the row
> > number and column n
Hi All,
Can anyone help me with the code in *VBA *to find unique values and pasting
it separately in Excel.
Regards
Umesh Dev
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
please provide data in excel..
On Sat, Jan 15, 2011 at 6:25 PM, herman gold wrote:
> a1 has IN, b1 has date, and c1 has time
> a2 has OUT, b2 has date, and c2 has time
>
>
>
> On Jan 15, 12:49 am, Dave Bonallack wrote:
> > Hi,
> > You need to tell us how this data is entered.
> > Is each
Hi herman gold
See atachment .
Sharadgupta
On Sat, Jan 15, 2011 at 12:41 PM, herman gold wrote:
> Hi,
>
> my timecard dumps an excel file with
>
> IN 9/10/2010 8:50
> OUT 9/10/2010 13:04
> IN 9/10/2010 13:04
> OUT 9/10/2010 17:08
> IN 9/23/2010
a1 has IN, b1 has date, and c1 has time
a2 has OUT, b2 has date, and c2 has time
On Jan 15, 12:49 am, Dave Bonallack wrote:
> Hi,
> You need to tell us how this data is entered.
> Is each line 1 cell, 2 cells, or 3 cells?
> Regards - Dave
>
>
>
>
>
>
>
> > Date: Fri, 14 Jan 2011 23:11:40 -0
OK!
That is very good
Is there a solution in pivot table without formula?
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anandydr
Sent: Saturday, January 15, 2011 3:52 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re:
Hi,
You need to tell us how this data is entered.
Is each line 1 cell, 2 cells, or 3 cells?
Regards - Dave
> Date: Fri, 14 Jan 2011 23:11:40 -0800
> Subject: $$Excel-Macros$$ there has to be an easier way!
> From: gold.her...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi,
>
> my timecar
Hi All,
On behalf of Mrs Ayushi
I am Looking for the post of Data Analyst in Pune.
Relevant Exp as an Data Analyst
Exp +3 years
Skills : Strong hand on Excel , Access, SQL or any other reporting tool will
be added advantage.
Right candidate have no bar for salary
Intreseted candidate please
13 matches
Mail list logo
