| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to write a macro to selectively output certain data to a different table based on
Hi, I am trying to write a macro that does the following:
Original Name Risk Rank John A 1 John A 2 Mark C 3 Nancy A 2 Diane A 1 Diane B 1 Diane B 2 Diane C 2 Judy A 1 Judy A 2 Judy A 3 New Name Risk Rank John A 1 Mark C 3 Nancy A 2 Diane A 1 Diane B 1 Judy A 1 The table on the top is the original data and the one on the bottom is the output. Basically, I am trying to let the macro loop through the original table and only output to another table the rows with the lowest rank for the same person and risk. I am pretty new to the excel macro, thanks a lot!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum cells in same column selectively based on value of different . | Excel Programming | |||
| Open CSV file, format data and write output to a text file. | Excel Programming | |||
| output based on data in a graph | Excel Worksheet Functions | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| How do I write a macro that hides a row based on data in Excel? | Excel Programming | |||
Threaded Mode
