Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula help...
Hey guys, I posted a question relating to this same work task I was working on last week and got some great responses. I am having one other problem I thought you guys might be able to help me with... Here is a screenshot of what I am working with. (I altered the names and the last 6 digits of the account numbers, but the XXXX exist in the document I am working with as well) I have attached a sample of the original data as EXCELBEFORE.JPG. If you look at the other two attachments, excelafter1.jpg and excelafter2.jpg, these show what I want the data to look like. I want to replicate the name listed in collumn B automatically in collumn A until the new name is shown in collumn B. I had to break apart the last 2 pictures to make them smaller than the 100k limit. I achieved the results shown in the jpgs by hand, which was easy for only 3 or 4 names. However, I have to do this for over 2000, which is a very daunting task. A nice formula could help me out a lot, but I just can figure out how to get it to work... Thanks for the help. -Brendan +-------------------------------------------------------------------+ |Filename: excelafter2.JPG | |Download: http://www.excelforum.com/attachment.php?postid=5100 | +-------------------------------------------------------------------+ -- destrolennox ------------------------------------------------------------------------ destrolennox's Profile: http://www.excelforum.com/member.php...o&userid=36503 View this thread: http://www.excelforum.com/showthread...hreadid=564903 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |