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

Groups > microsoft.public.excel.programming > #109341

Re: find different value from duplicate data - macro help

Show all headers | View raw

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

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

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

csiph-web