Hi,
I have a 2-column data, one is name another one is leader.
I wanted to populate the data into multiple columns ie the column header as each leader's name
I tried with index-macth combination, but it will duplicate the names.
Got stuck for hours.... appreciate any kind of assistance.
Thank yo very much.
HC
Last edited by Richard Buttrey; 12-20-2013 at 01:43 PM. Reason: additional Q
In D3 and copy down and acros, try this ARRAY formula.
Formula:
Please Login or Register to view this content.
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
You could do this without dummy columns if you use Arrayed formulas but they can slow your sheet down depending on it's size. Here's how to do it without array formulas.
In C (which you can later hide)
Formula:Please Login or Register to view this content.
Then in E3 copied across and down
Questions?Formula:Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Please see the file
Regards
Azumi
wow.. thank you very much to all of you!
thank you for the effort and prompt replies, i truly appreciate that.
God bless you all.
HC
Hi,
First of all I would want to apologise as I post this same question at another subforum asking for solution without VBA.
However, what I never noticed was, the drop down combo box (format control) were capturing the cells with the functions although it is blank.
Eg if my list have 7 names only, but the drop down list is showing blank rows (capturing rows with functions)
I already tried copying with values only but it doesnt work.
I have to use combo box, that is a requirement.
Appreciate any assistance.
Thank you.
Hi
Re post #5
Since this is essentially an extension to your original thread I've taken the decision to move it here so that everything is 'under one roof' . Strictly speaking it should be in the VBA forum but let's see if it gets resolved here first. If not we can move the whole thread later.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Re post #7
Hi,thank you very much!
Again, any assistance is very much appreciated.
Thank you!
HC
Last edited by hcyeap; 12-20-2013 at 11:44 PM.
Bump!
I was trying while waiting for anyone to help out... unfortunately I am too new to VBA
Appreciate any assistance.
Thank you!
Regards,
Hong Chen
Bump!
Really need this desperately....
Appreciate any assistance....
HC
Not sure why you are getting what you are getting because the sheet you uploaded doesn't have any sort of drop down or combo boxes or VBA. Makes it hard to troubleshoot.
If we are discussing a dynamic named range, replace COUNTA with something like
=SUMPRODUCT(--(LEN(G:G)>0))-1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks