LinkBack URL
About LinkBacks
Hi I have data in a row D5-S5 like a, b, , c, , d, etc so with blanks in it. I would like to make it into a, b, c, d with no blanks. I don't want to just use a filter to take the blanks out.
Any help would be appriciated
Dave
Hi I have data in a row D5-S5 like a, b, , c, , d, etc so with blanks in it. I would like to make it into a, b, c, d with no blanks. I don't want to just use a filter to take the blanks out.
Any help would be appriciated
Dave
Last edited by Throughstream; 04-23-2017 at 01:09 PM.
Do you want the results in a ROW or in a COLUMN?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
If in a column (in d8):
=IFERROR(INDEX(5:5,SMALL(IF($D$5:$S$5<>"",COLUMN($D$5:$S$5)),COLUMNS($D8:D8))),"")
array entered.
Array Formulae are a little different from ordinary formulae in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.
Don't type the curly brackets yourself - it won't work...
Apols zbor... Our posts crossed in cyberspace..
Misille had been fired before defense system was installed.
Teach me Excel VBA
Hi In a row please, so u5,v5 etcOriginally Posted by Glenn Kennedy
Many thanks
Last edited by Throughstream; 04-23-2017 at 01:10 PM.
So use this:
=IFERROR(INDEX(5:5,SMALL(IF($D$5:$S$5<>"",COLUMN($D$5:$S$5)),COLUMNS($U5:U5))),"")
array entered, as described above.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
Thank you.
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks