FullMoonMadness
New Member
- Joined
- Apr 18, 2013
- Messages
- 5
Hello,
I am trying to extract some data and place it in another part of the workbook, and sort it. Example:
Column A has a title of "Cost" (A1), with the values being (A2:A6): $0, $0, $50.50, $0, $46
Column B has a title of "Unique Number" (B1), with values of (B2:B6): 1, 2, 3, 4, 5
Column C has a title of "Date" (C1), with the following values (C2:C6): 4/21, 5/11, 5/27, 6/4, 7/22
I want to extract data from all three cells into a new table, but only the cells where the cost is greater than zero. And I want to the new table to be sorted from lowest cost to greatest cost. The final table should look like:
Column L: $46, $50.50
Column M: 5, 3
Column N: 7/22, 5/27
The key is I don't want to use VBA. Can anyone help? Thanks in advance!
I am trying to extract some data and place it in another part of the workbook, and sort it. Example:
Column A has a title of "Cost" (A1), with the values being (A2:A6): $0, $0, $50.50, $0, $46
Column B has a title of "Unique Number" (B1), with values of (B2:B6): 1, 2, 3, 4, 5
Column C has a title of "Date" (C1), with the following values (C2:C6): 4/21, 5/11, 5/27, 6/4, 7/22
I want to extract data from all three cells into a new table, but only the cells where the cost is greater than zero. And I want to the new table to be sorted from lowest cost to greatest cost. The final table should look like:
Column L: $46, $50.50
Column M: 5, 3
Column N: 7/22, 5/27
The key is I don't want to use VBA. Can anyone help? Thanks in advance!