Hi guys,
Trying to figure out if there's a formula involved or just a column setting.
See the link - http://i.imgur.com/xmC5Tgz.jpg?1
Hi guys,
Trying to figure out if there's a formula involved or just a column setting.
See the link - http://i.imgur.com/xmC5Tgz.jpg?1
Hi,
Any chance of an actual workbook instead of just a picture?
Cheers
Hi and we3lcome to the forum
Please upload your sample workbook here. Not all members are able (company firewalls and stuff) or willing to download from file hosting sites
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
Maybe something like this...
Data Range
A B 1 Header1 Header2 2 5 5 3 63 5 4 0 15 5 15 15 6 0 15 7 0 25 8 0 53 9 61 61 10 70 63 11 70 12 5 81 13 25 85 14 15 85 16 53 17 0 18 81 19 15 20 15
This formula entered in B2:
=IFERROR(SMALL(A$2:A$20,COUNTIF(A$2:A$20,0)+ROWS(B$2:B2)),"")
Copy down until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Maybe this is what you want. The list just eliminates the 0 and blank values.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hi guys,
Sorry I wasn't able to post the workbook. The link didn't work.
I will try out your suggestions.
Thanks!
@ ellednarb666
Did you look at column A to see how the values were obtained? Those values were not manually inserted.
The problem is more than just VLOOKUP.
Hey Tony,
This worked perfectly. Thank you!
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks