LinkBack URL
About LinkBacks
Hi all gurus,
I'm thinking Vlookup may help but wanted to check with you.
I want to search for letter a in a big table (as a indicates available) and then output the row and all cols for that a?
your support would be gratefully apprec,
Thank you
Hi all gurus,
I'm thinking Vlookup may help but wanted to check with you.
I want to search for letter a in a big table (as a indicates available) and then output the row and all cols for that a?
your support would be gratefully apprec,
Thank you
Post a file showing expected output so we can clearly understand what is required.
Just 1 letter in a cell? Or are there words/string in the cell and you need to find a specific letter inside there?I want to search for letter a in a big table
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
How do you want the results to appear?
As shown in A5:A7 or A9:C9?
Data Range
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
sorry had to drive home from work.
attached is the file....
Last edited by eeinkee; 07-19-2016 at 07:37 AM.
its a table like this but it will have numbers and I put in a when I know someone is available so then I only want to see whos available when......
listing all the details with that person. Hope this makes sense. Thank you
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
in attached as result, I dont want to filter....manually
if theres a formula that could it for me auto in another sheet...
Last edited by eeinkee; 07-19-2016 at 07:36 AM.
any ideas out there in the excel expert world?
I have a 20kb file download size limit.
Your files are way too big for me.
attached a more simplier view.....smaller file, with results tab of what I would like to see once I have Vlookup in place...
Last edited by eeinkee; 07-19-2016 at 07:54 AM.
What is the criteria for your selection? (it is probably there, I just cant see it)
Selection is any column (from L onwards) in a row containing an "a" (for available)
See
http://www.excelforum.com/showthread...t=#post4436543
Last edited by JohnTopley; 07-19-2016 at 11:27 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks