Hello. Please see attachment as I try and explain what I need. We have a report that once it is opened in Excel, it merges the employee number and only lists it once. We need it to list the number for each applicable line. There are over 1000 employees, so we don't want to CTL-D or manually copy the numbers down. Any suggestions?Excel Example.xlsx
Last edited by GMKoehler; 01-16-2015 at 06:24 PM.
Select col A, and format as General
Highlight all the cells that need attention. In this case, A1:A36. This includes all existing cells containing values.
Now, press F5.
Select Special
Select Blanks
Press OK
Press the press the = key
press and hold down the CTRL key
press the arrow up key (still holding down the CTRL key. . .don't let go. . .)
press enter.
copy and paste the entire column as values.
Pete
I know there is another way to do this, but cannot think of it right now
But If you are OK with a helper column, use this in row 3 (I used J3, but you can put it where you want), copied down...
=IF(ISNUMBER(--A3),IF(A3="",J2,A3),"")
If necessary, you can copy/paste values back over your original data
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you, FDibbins. That worked great!
A co-worker's husband also suggested:
=IF(ISBLANK(A3),J2,A3) This worked as well, even with text. Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks