shad0w4life
New Member
- Joined
- Nov 4, 2004
- Messages
- 48
this might sound all fine and dandy but...
ColumnA ColumnB
ABC 1A
ABC 1B
ABC 1C
DEF 1A
GHI 3
JKL 4C
ABC 2A
GHI 4
Now in this column what I need the results to show up as are
ABC 1C
ABC 2A
DEF 1A
GHI 3
GHI 4
JKL 4C
Basically I need to keep the "highest" ColumnB being that on a scale A is the lowest and Z would be the highest in the alpha scale so 1A < 1B AND Keep each seperate # eg. i the table I have the highest ColumnB for the 1's and the highest for the 2's
I ran this macro in excel but is access i'm completely new to VBA in it. Is it anything similar to Excel if so I'll post the code.
ColumnA ColumnB
ABC 1A
ABC 1B
ABC 1C
DEF 1A
GHI 3
JKL 4C
ABC 2A
GHI 4
Now in this column what I need the results to show up as are
ABC 1C
ABC 2A
DEF 1A
GHI 3
GHI 4
JKL 4C
Basically I need to keep the "highest" ColumnB being that on a scale A is the lowest and Z would be the highest in the alpha scale so 1A < 1B AND Keep each seperate # eg. i the table I have the highest ColumnB for the 1's and the highest for the 2's
I ran this macro in excel but is access i'm completely new to VBA in it. Is it anything similar to Excel if so I'll post the code.