Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching multiple columns
Something tells me this is going to be easier to resolve than describing the
problem. I have a column of data and then another column showing the frequencies of the numbers within that column: C3:C85 looks like: 14 4 14 22 9 5 (and so forth; basically random with some duplicates) EA3:EA85 looks like (these are frequencies of column C): 8 5 8 2 7 7 (and so forth) What I'd like to do is have a separate sheet where I have a column (Sheet2!A) of the range of numbers in column C (i.e. 1,2,3,4...55, the end of the range), and then an adjacent column (Sheet2!B) that reports the corresponding frequency. So: Sheet2!A Sheet2!B 1 (whatever is in EA) 2 (whatever is in EA) 3 (whatever is in EA) 4 (whatever is in EA) 5 7 (and so forth) Although there are duplicate numbers in column C, the frequencies, of course, will always be the same for whatever number is duplicated (so, 5 in C will always have a freq of 7 as reported in EA). Any help would be greatly appreciated for the formula that should go into Sheet2!B that matches Sheet2!A to C and then to EA and then reports whatever is in EA. It has to be a formula, since the dataset is expanding; I need the new sheet to update accordingly. Thank you very, very much in advance. --Rothman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Justify text across multiple columns | Excel Discussion (Misc queries) | |||
splitting 1 column of data into multiple columns | Setting up and Configuration of Excel | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions |