Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scattered Cell entries into one Column
What I have is scattered cells entries. Each row has an entry I want in a
specific new column. I am working with 'Excel 2003' and don't know squat about programing. I have tried filtering and do seem lost at this point to consolidate all this data in cells to a specific column. Can anyone advise me on how, step by step? -- LarryW |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scattered Cell entries into one Column
If there is only one numeric entry per row, select the first empty
column on the right and sum across all of the columns to the left. That will just sum to the lone row value in the new single column. Then copy the formula down all the data rows. You can copy-paste as values the new column if you want to decouple the values from the original data. SteveM On Nov 10, 10:50 am, LarryW wrote: What I have is scattered cells entries. Each row has an entry I want in a specific new column. I am working with 'Excel 2003' and don't know squat about programing. I have tried filtering and do seem lost at this point to consolidate all this data in cells to a specific column. Can anyone advise me on how, step by step? -- LarryW |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scattered Cell entries into one Column
Larry
This isn't progrmming help, but on the sheet, if your entries are scattered in cols B-D, put zzz in col E and =HLOOKUP("zz",B1:D1,1,TRUE) in col A D-C Dave LarryW wrote: What I have is scattered cells entries. Each row has an entry I want in a specific new column. I am working with 'Excel 2003' and don't know squat about programing. I have tried filtering and do seem lost at this point to consolidate all this data in cells to a specific column. Can anyone advise me on how, step by step? ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scattered Cell entries into one Column
[why put xxx in col E?]
Larry This isn't progrmming help, but on the sheet, if your entries are scattered in cols B-D, put =HLOOKUP("zz",B1:D1,1,TRUE) in col A D-C Dave LarryW wrote: What I have is scattered cells entries. Each row has an entry I want in a specific new column. I am working with 'Excel 2003' and don't know squat about programing. I have tried filtering and do seem lost at this point to consolidate all this data in cells to a specific column. Can anyone advise me on how, step by step? ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum variable range of column entries in offset cell | New Users to Excel | |||
Flagging cell entries in a column to add to a subtotal. | Excel Worksheet Functions | |||
Moving scattered cell data to new column? | Excel Worksheet Functions | |||
How do I sum scattered entries on an Excel worksheet? | Excel Worksheet Functions | |||
How do I sum scattered entries on an Excel worksheet? | Excel Programming |