unequal tables

Question

Hi there, my columns are unequal: see attached (yellow columns). How can I equalize them to column 1, to have proper data in rows?Thank you for any tips.

wassimn · Answer

Hello Eliza55 What do you mean by "unequal"? What do you mean by "equalize"? If you want the yellow ranges to have the same value of the corresponding cell in column A you can use a formula for example in cell B2 you can use =A2, in cell D2 use =A2, and in cell F2 use =A2 and then you can drag down the columns to make it all "equal"??? By the way, I see that in column A the values maybe stored as text (Left justified) vs numbers in the other columns (Right justified). That's OK but not standard practice. Let us know what you exactly mean so we can better help you.

eliza55 · Answer

WassimN&nbsp;I have commodity good code in column B, D, F, H, K for annual value of import (column C, F, H, J, L). All these goods codes should correspond to the code in the first column (all codes list). They do not. See pic.&nbsp;

wassimn · Answer

Hello Eliza55,Still Not clear. the data in Column B is not the same as Column D but that is not the important issue. I would suggest stating your question in a couple of examples such as:I want Cell C2 to be xxx because Cell A1 has 101, and then I want Cell C3 to be yyy because Cell A1 has 102. And many of these pointers so that we can figure what is best. You know your project inside-out, but we don't and we need to be able to make that mental image as to what the final outcome will look like to get you the best results. Right now, with my very limited understanding of what is needed, I am thinking you should look into the XLOOKUP function, but then again, very limited understanding.

eliza55 · Answer

OK, I want cells in column B equal to column A, but B should change together with column C values. So, cell B22 need to go down to the row 32, it should go together with a value in the cell C22.

wassimn · Answer

Hello Eliza55Looking at Row 22:A22 has 305, B22 has 403. Should B22 be 305? C22 has 334708.362 this should be on Row 28 (C28) because A28 is 403 and B22 is 403?Please let us know...

Forum Discussion

unequal tables

6 Replies

Resources