| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup function, but then a bit complicater
I am having the following set of data. 14000 rows.
A B 1010071 80425 1010071 80253 1010071 80425 1010071 80253 1010083 80451 1010083 80205 1010083 81853 1010083 80451 1010083 80205 1010083 81853 and so on... What I want to is this: Make a colum for C: Looking like this: 1010071 1010083 and so on.. = peace of cake and is done. But now is the problem. Behind this colum I want some colums holding the data for B. Looking like this 1010071 80425 80253 1010083 80451 80205 81853 80451 80205 81853 and so on.... I am having absolutely NO IDEA how to fix this one. any help would be welcome since doing this by hand is too much..I am pretty familiar with excel ( and a little with VBA) Thanks for any advice. Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Lookup function and Sum function | Excel Worksheet Functions | |||
| LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
![Robert[_33_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
