| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging excel tables & more, countif, macro line insert etc
Hi
Hopefully someone can help me out there... I am really struggling with this on.. I have 2 sets of data 0300809 01 03 00006707 015 0300809 01 03 00008116 085 Last column is percentages I need to merge with this table 0300809 00012043 2 0300809 00012077 2 0300809 00012445 2 0300809 00012476 2 0300809 00015258 2 0300809 00018577 2 where last column is the number of % splits (I.E. 015 & 085) & this may vary What I need is to get this, I will have to insert lines based on the count of the % & then find some way of combining 0300809 00012043 01 03 00006707 015 0300809 00012043 01 03 00008116 085 0300809 00012077 01 03 00006707 015 0300809 00012077 01 03 00008116 085 0300809 00012445 01 03 00006707 015 0300809 00012445 01 03 00008116 085 0300809 00012476 01 03 00006707 015 0300809 00012476 01 03 00008116 085 0300809 00015258 01 03 00006707 015 0300809 00015258 01 03 00008116 085 0300809 00018577 01 03 00006707 015 0300809 00018577 01 03 00008116 085 As I said I am really struggling with this one.. I have a load of data that this needs to be done so manual method is not really feasible Here's hoping!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert a line via macro | Excel Discussion (Misc queries) | |||
| macro to insert blank line when lines sum to zero | Excel Discussion (Misc queries) | |||
| Insert blank line macro | Excel Worksheet Functions | |||
| Macro Line Insert | Excel Discussion (Misc queries) | |||
| Insert Line Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
