Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My data table looks like this:
Date AA BAC DELL 20071203 4.83% 19.72% 7.50% 20071204 6.27% 10.49% 10.02% 20071205 10.61% 2.12% 5.32% 20071206 5.31% 20.33% 12.82% 20071207 8.64% 7.70% 2.97% I am looking for a formula for ColC of this table: Date Name Percent 20071203 AA 4.83% 20071203 BAC 19.72% 20071203 DELL 7.50% 20071204 AA 6.27% 20071204 BAC 10.49% 20071204 DELL 10.02% Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Partial match lookup question | Excel Worksheet Functions | |||
Match Lookup question | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
A question for Match and Lookup | Excel Discussion (Misc queries) | |||
LookUp/Match Question | Excel Worksheet Functions |