Hi i need to fetch all rows matching a selected value . i cannot use row() , rows () in my application. Kindly help me with an excel formula.
i am reposting this as i need the solution immediately. Kindly help
Thanks & Regards,
Shruthi
Hi i need to fetch all rows matching a selected value . i cannot use row() , rows () in my application. Kindly help me with an excel formula.
i am reposting this as i need the solution immediately. Kindly help
Thanks & Regards,
Shruthi
This was in your spreadsheet:
This is what I have tried, I need a conactenated set of rows matching the dynamically selected value (a33). Kindly help
why can't you use =CONCATENATE(A36,B36,C36,D36,E36) in f36?
do u want to concat rows 36-60 or a36-e36?
Last edited by Blake 7; 02-11-2011 at 09:38 AM.
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Please be patient and wait for a reply to your original post. We are volunteers here and don't have time to be chasing your duplicates. If nobody replies in due time (days not hours/minutes) then bump the original thread...
Last edited by NBVC; 02-11-2011 at 11:12 AM.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks