Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Populating Columns - VBA macro or function? 1

Status
Not open for further replies.
yorrick

yorrick

Technical User
Jan 3, 2002
58
0
0
AU
Hi,

got a spreadsheet that looks like

Harry 23
34
33
45
Larry 23
12
45
12

What i want is Harry to be next to each of his scores. So it looks like

Harry 23
Harry 34
Harry 33
Harry 45
Larry 23
Larry 12
Larry 45
Larry 12

anyone any thoughts?
 
Sort by date Sort by votes
Select the names range, and do menu command Edit/Goto/Special/Blanks and then type "=" UpArrow Ctrl-Enter.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
 
Upvote 0 Downvote
Help!!

i used to get this post to work but now after I've selected the range and done
menu command Edit/Goto/Special/Blanks
press "="

and then uparrow

it selects Formulas in the Goto Special Menu! and therefore when I do ctrl-enter it simply says "no cells found" and does nothing!
 
Upvote 0 Downvote
ignore me -worked it out - talking jibberish!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GPnew
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
270
combo
combo
EFFEY
  • Locked
  • Question
I have three columns in excel named 1
Replies
5
Views
119
EFFEY
EFFEY
OCM
  • Locked
  • Question
Compare two columns
Replies
2
Views
387
OCM
OCM
Andrzejek
  • Locked
  • Question
Compare multiple columns in Excel 1
Replies
4
Views
476
combo
combo
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
529
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top