Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109340 > unrolled thread

find different value from duplicate data - macro help

Back to article view | Back to microsoft.public.excel.programming

Contents

  find different value from duplicate data - macro help Miss <misbah.ali786@gmail.com> - 2016-09-26 10:10 -0700
    Re: find different value from duplicate data - macro help Claus Busch <claus_busch@t-online.de> - 2016-09-26 21:43 +0200
    Re: find different value from duplicate data - macro help Tjlebyng648 <Tnlebang313@gmail.com> - 2016-09-27 01:04 +0100
    Re: find different value from duplicate data - macro help Tjlebyng648 <Tnlebang313@gmail.com> - 2016-09-27 14:05 +0100
    Re: find different value from duplicate data - macro help Txlebang106 <Tolebnng329@gmail.com> - 2016-09-28 09:18 +0100

#109340 — find different value from duplicate data - macro help

I am writing to request macro (VBA function), which allows to me to see different data value (from column K and L from duplicate rows of data. 

For example – please input sheet from the attachment. 

Process – the macro, should look through lines of data which have duplicate name values (from column A), identify which rows from column K and L are different from the duplicate values. The macro should highlight the difference in yellow, as final output. 

Expected output – please see output sheet from the attachment. 

Sample attachment - https://app.box.com/s/3i1bpvbov5vr8h4v36hqy684elcwk8xw


Any help would be very much appreciated. Many thanks.

[toc] | [next] | [standalone]

#109341

Hi,

Am Mon, 26 Sep 2016 10:10:52 -0700 (PDT) schrieb Miss:

> I am writing to request macro (VBA function), which allows to me to see different data value (from column K and L from duplicate rows of data. 
> 
> For example ? please input sheet from the attachment. 
> 
> Process ? the macro, should look through lines of data which have duplicate name values (from column A), identify which rows from column K and L are different from the duplicate values. The macro should highlight the difference in yellow, as final output. 
> 
> Expected output ? please see output sheet from the attachment. 

have a look:
https://onedrive.live.com/redir?resid=9378aab6121822a3!326&authkey=!AApmk7UTBA7IuAM&ithint=folder%2cxlsm
for "sample file"
There is a formula solution. The helper column can be hidden.


Regards
Claus B.
-- 
Windows10
Office 2016

[toc] | [prev] | [next] | [standalone]

#109342

Miss;1625899 Wrote: 
> I am writing to request macro (VBA function), which allows to me to see
> different data value (from column K and L from duplicate rows of data.
> For example – please input sheet from the attachment. Process
> – the macro, should look through lines of data which have
> duplicate name values (from column A), identify which rows from column K
> and L are different from the duplicate values. The macro should
> highlight the difference in yellow, as final output. Expected output
> – please see output sheet from the attachment. Sample attachment -
> https://app.box.com/s/3i1bpvbov5vr8h4v36hqy684elcwk8xw Any help would be
> very much appreciated. Many thanks. Thanks a lot for sharing this with all people you actually know what
you are speaking approximately! Bookmarked. Please also visit my web
site =). We can have a link change contract among us




-- 
Tjlebyng648

[toc] | [prev] | [next] | [standalone]

#109345

Miss;1625899 Wrote: 
> I am writing to request macro (VBA function), which allows to me to see
> different data value (from column K and L from duplicate rows of data.
> For example – please input sheet from the attachment. Process
> – the macro, should look through lines of data which have
> duplicate name values (from column A), identify which rows from column K
> and L are different from the duplicate values. The macro should
> highlight the difference in yellow, as final output. Expected output
> – please see output sheet from the attachment. Sample attachment -
> https://app.box.com/s/3i1bpvbov5vr8h4v36hqy684elcwk8xw Any help would be
> very much appreciated. Many thanks. This article is genuinely a fastidious one it helps new net visitors,
who are wishing for blogging.




-- 
Tjlebyng648

[toc] | [prev] | [next] | [standalone]

#109352

Miss;1625899 Wrote: 
> I am writing to request macro (VBA function), which allows to me to see
> different data value (from column K and L from duplicate rows of data.
> For example – please input sheet from the attachment. Process
> – the macro, should look through lines of data which have
> duplicate name values (from column A), identify which rows from column K
> and L are different from the duplicate values. The macro should
> highlight the difference in yellow, as final output. Expected output
> – please see output sheet from the attachment. Sample attachment -
> https://app.box.com/s/3i1bpvbov5vr8h4v36hqy684elcwk8xw Any help would be
> very much appreciated. Many thanks. Good post however , I was wanting to know if you could write a litte
more on this subject? I'd be very thankful if you could elaborate a
little bit more. Thanks!




-- 
Txlebang106

[toc] | [prev] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web