Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Values on the fly
I'm looking for a way to automatically assign an 'index value' to cells in
column "index". Starting with row one, I want to assign "A" based on the contents of the "item#" and "country" cells in the same row. And then, I want "A" assigned to every row containing the same values in those columns. And then, I want the next different value (in this case, the 2nd row) to be assigned "B"...again with every other row containing the same values in the "Item#" and "county" columns to be assigned the index value of "B"....and so on and so on. Is there a function that can be combined with a logic statement to automatically assign values to all cells in the "index" column? Index Order Item# country 1 8502 1 4215.00 4,215.00 TW 2 8943 1 1802.00 1,802.00 TW 3 2251 1 188.00 188.00 CN 4 2251 1 935.00 935.00 CN 5 2251 1 450.00 450.00 CN 6 2251 1 25.00 25.00 CN 7 2251 2 701.38 1,402.76 CN 8 2251 1 179.57 179.57 CN 9 2251 2 50.00 100.00 CN 10 2251 14 100.00 1,400.00 CN 11 2251 1 1800.00 1,800.00 TW 12 2251 1 100.00 100.00 TW 13 2251 1 25.00 25.00 TW 14 2251 1 56.45 56.45 TW 15 2251 1 435.00 435.00 TW 16 2251 1 235.20 235.20 TW 17 2251 1 538.00 538.00 TW 18 2251 3 174.45 523.35 TW 19 2251 1 1923.00 1,923.00 TW 20 2251 1 843.00 843.00 TW 21 2251 1 400.00 400.00 CN 22 2251 1 400.00 400.00 CN 23 2251 1 3434.00 3,434.00 CN 24 2251 1 942.89 942.89 CN 25 8925 1 225.00 225.00 CN 26 7234 2 1307.00 2,614.00 JP 27 8925 1 1395.00 1,395.00 TW 28 2251 1 632.70 632.70 TW 29 6102 1 8500.00 8,500.00 TW 30 7616 1 1822.00 1,822.00 TW |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 doesnt show Y-axis values when the values are small. | Charts and Charting in Excel | |||
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) |