LinkBack URL
About LinkBacks
Hi,
I want to get the passed testcase's id to get stored in a single cell. Like wise the same functionality should be implemented when test case's fail.
Please refer the screenshot "Excel.png"
Thanks,
Hi,
I want to get the passed testcase's id to get stored in a single cell. Like wise the same functionality should be implemented when test case's fail.
Please refer the screenshot "Excel.png"
Thanks,
Instead of attaching a picture file, please attach an excel file so that it will be helpful for us to work with the file for providing solution for your query (Ensure that it's not containing any confidential data).
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Please find the attached excel sheet
In I6 Cell
Formula:
Please Login or Register to view this content.
Drag it down..
Hi,
Thanks for the reply, the formula works properly when the values are as such but when i change values in status column using the drop down (Worksheet: regression) then the formula doesnt map properly with the values which are altered.
Cheers,
Please show it in excel for better understanding
I have attached the Excel doument. Please find the attachement
Not seeing any difference in the attachments of Post # 3 & 7
Hi,
Hi,
I have attached the edited screenshot "Excel1.png" for your better understanding
Cheers
Oh my god! you are talking about the concatenation of data based on the matchYou have to go for VBA solution.
Yes i need to concatenate the data based on Pass/Fail/Not applicable status! If you know the code for it please share it with me
Refer Post #4 of the below thread
http://www.excelforum.com/excel-form...e-returns.html
Thank you very much.... itz working fine
Glad it helps you and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks