Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I asked this question, but I would like to clarify. I have a range of data
as shown: a b 1 jan 5 2 feb 6 3 mar 7 4 jan 8 5 mar 10 6 jan 3 On a different sheet, I would like to extract all the data that is the same in 'a' and its corresponding value in 'b', and I would like them all together. No blanks in between. I would like on a different sheet to see all the 'jan' in the first three cells on the sheet with the values from 'b' beside them. Or, if it were 'feb' that I wanted, I would only see one cell, etc. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Subtotals in a list | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions |