Routine??

  • Thread starter Thread starter Zax
  • Start date Start date
Z

Zax

do possible is gather with a VBA routine of the similar data? If one like?



Example imagines of have the list of underlying values for column:


E F G H

6300 3600 1500 1200
6300 3600 1500 1200
6300 3600 1500 1200
6200 3600 1500 1100



I would want after the throwing of a VBA routine the result to be:

C E F G H
3 6300 3600 1500 1200
1 6200 3600 1500 1100




Where it in the C column comes me suitable the quantity from cells in
horizontal that they have the similar values.

NB.: The values in the columns could occupy 1 or more columns therefore
record a [macro] on a precise range]of columns it could not be
sufficient.


Thank you still.
You excuse for my English.
 
Select you data, then do Data=>Filter=>Advanced Filter, select the uniques
checkbox in the lower left corner of the resulting dialog, select copy and
designate a location on the sheet. You can leave the criteria empty.

Turn on the macro recorder while you do it if you need code. After you get
the code, you can modify it to copy the results to another sheet. (you can
manually work from another sheet, by starting on that sheet and ignoring the
error warning).
 
Tom Ogilvy said:
Select you data, then do Data=>Filter=>Advanced Filter, select the uniques
checkbox in the lower left corner of the resulting dialog, select copy and
designate a location on the sheet. You can leave the criteria empty.

Turn on the macro recorder while you do it if you need code. After you get
the code, you can modify it to copy the results to another sheet. (you can
manually work from another sheet, by starting on that sheet and ignoring the
error warning).
Click to expand...

Thank you for your suggestion.
but for count the values equal thing could I do?
 
=sumproduct((Sheet1!$E$2:$E$200=E2)*(Sheet1!$F$2:$F$200=F2)*(Sheet1!$G$2:$G$
200=G2)*(sheet1!$H$2:$H$200=H2))
drag fill down.
 
Back
Top